Database Fundamentals v1.0

Page:    1 / 10   
Exam contains 140 questions

You need to populate a table named EmployeeCopy with data from an existing table named Employee.
Which statement should you use?


  • A. Option A
  • B. Option B
  • C. Option C
  • D. Option D


Answer : D

You execute the following statement:


This statement is an example of a/an:

  • A. Subquery
  • B. Union
  • C. Outer join
  • D. Cartesian product


Answer : A

Which keyword would you use in a select statement to return rows that meet a specific condition?

  • A. WHERE
  • B. UNION
  • C. ORDER BY
  • D. FROM


Answer : A

You have a table named Employee that includes the following columns:

EmployeeID -

Smp1oyeeName -
Which statement should you use to return the number of rows in the table?


  • A. Option A
  • B. Option B
  • C. Option C
  • D. Option D


Answer : D

The Product table contains the following data.


You execute the following statement:
SELECT COUNT(*)
FROM Product WHERE Quantity > 18
What is the value returned by this statement?

  • A. 1
  • B. 2
  • C. 3
  • D. 4


Answer : C

Which command should you use to remove a table from a database?

  • A. REMOVE TABLE
  • B. UPDATE TABLE
  • C. DROP TABLE
  • D. DELETE TABLE


Answer : C

You need to store the contact information for each student in your school database.
You should store each student's information in a:

  • A. Stored procedure
  • B. Function
  • C. Row
  • D. Variable


Answer : C

Which category of SQL statements is used to add, remove, and modify database structures?

  • A. Data access language (DAL)
  • B. Data manipulation language (DML)
  • C. Data control language (DCL)
  • D. Data definition language (DDL)


Answer : D

You have a Customer table and an Order table. You join the Customer table with the Order table by using the CusromerID column.
The results include:

All customers and their orders -


-> Customers who have no orders
Which type of join do these results represent?

  • A. Complete join
  • B. Partial join
  • C. Inner join
  • D. Outer join


Answer : D

Data in a database is stored in:

  • A. Tables
  • B. Queries
  • C. Data types
  • D. Stored procedures


Answer : A

You have a table named Student that contains 100 rows. Some of the rows have a NULL value in the FirstName column.
You execute the following statement:

DELETE FROM Student -
What is the result?

  • A. All rows in the table will be deleted.
  • B. All rows containing a NULL value in the FirstName column will be deleted.
  • C. You will receive an error message.
  • D. All rows and the table definition will be deleted.


Answer : A

You need to establish a set of permissions that you can routinely assign to new users.
What should you create?

  • A. Resource
  • B. Group
  • C. List
  • D. Role


Answer : D

Which database term is used to describe the process of applying a backup to a damaged or corrupt database?

  • A. Recover
  • B. Restore
  • C. Commit
  • D. Attach


Answer : B

You need to disable User1's access to view the data in the Customer table.
Which statement should you use?


  • A. Option A
  • B. Option B
  • C. Option C
  • D. Option D


Answer : C

Denormalization is performed in order to:

  • A. Reduce redundancy.
  • B. Eliminate repeating groups.
  • C. Create smaller tables.
  • D. Improve query performance.


Answer : D

Page:    1 / 10   
Exam contains 140 questions

Talk to us!


Have any questions or issues ? Please dont hesitate to contact us