Database Fundamentals v1.0

Page:    1 / 16   
Exam contains 235 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 / 16   
Exam contains 235 questions

Talk to us!


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

Certlibrary.com is owned by MBS Tech Limited: Room 1905 Nam Wo Hong Building, 148 Wing Lok Street, Sheung Wan, Hong Kong. Company registration number: 2310926
Certlibrary doesn't offer Real Microsoft Exam Questions. Certlibrary Materials do not contain actual questions and answers from Cisco's Certification Exams.
CFA Institute does not endorse, promote or warrant the accuracy or quality of Certlibrary. CFA® and Chartered Financial Analyst® are registered trademarks owned by CFA Institute.
Terms & Conditions | Privacy Policy