Microsoft Microsoft Certifications 98-364 Questions & Answers

• Question 81:

  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

  Correct Answer: D

• Question 82:

  Data in a database is stored in:

  A. Tables

  B. Queries

  C. Data types

  D. Stored procedures

  Correct Answer: A

• Question 83:

  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.

  Correct Answer: A

• Question 84:

  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

  Correct Answer: D

• Question 85:

  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

  Correct Answer: B

• Question 86:

  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

  Correct Answer: C

• Question 87:

  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

  Correct Answer: D

• Question 88:

  You execute the following statement:

  

  This statement is an example of a/an:

  A. Subquery

  B. Union

  C. Outer join

  D. Cartesian product

  Correct Answer: A

• Question 89:

  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

  Correct Answer: A

• Question 90:

  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

  Correct Answer: D