Microsoft Microsoft Certifications 98-364 Questions & Answers

• Question 41:

  This question requires that you evaluate the underlined text to determine if it is correct.

  You have two tables. Each table has three rows. You create a SQL query that uses a cross join. The query does not include a WHERE clause.

  Nine rows will be included in the Cartesian product of these two tables.

  Instructions: Review the underlined text. If it makes the statement correct, select "No change is needed." If the statement is incorrect, select the answer choice that makes the statement corrector.

  A. No change is needed

  B. Zero

  C. Three

  D. Six

  Correct Answer: A

• Question 42:

  You have two tables named Salesperson and Sales.

  You need to ensure that each record in the Sales table has a valid associated salesperson record in the Salesperson table.

  Which database object should you add to the Sales table?

  A. Nonclustered index

  B. Primary key

  C. Foreign key

  D. Clustered index

  Correct Answer: B

• Question 43:

  This question requires that you evaluate the underlined text to determine if it is correct.

  Use the ALTER statement to add a new table in a database.

  Instructions: Review the underlined text. If it makes the statement correct, select "No change is needed." If the statement is incorrect, select the answer choice that makes the statement correct.

  A. No change is needed

  B. UPDATE

  C. INSERT

  D. CREATE

  Correct Answer: D

• Question 44:

  You need to rename a column in a database table.

  Which data definition language (DDL) statement should you use?

  A. ALTER

  B. INSERT

  C. CREATE

  D. UPDATE

  Correct Answer: A

• Question 45:

  This question requires that you evaluate the underlined text to determine if it is correct.

  Use indexing to create, remove, or change database objects.

  Instructions: Review the underlined text. If it makes the statement correct, select "No change is needed." If the statement is incorrect, select the answer choice that makes the statement correct.

  A. No change is needed.

  B. Data manipulation language (DML) statements

  C. Data definition language (DDL) statements

  D. A unique constraint

  Correct Answer: C

• Question 46:

  You have a database table named SongInformation as defined below:

  

  You need to create a Structured Query Language (SQL) query to retrieve only the names of songs that sold more than 1000 compact discs (CDs). Which query should you use?

  

  A. Option A

  B. Option B

  C. Option C

  D. Option D

  Correct Answer: A

• Question 47:

  You have the following table definition:

  CREATE TABLE Product (ProductID INTEGER, Name VARCHAR(20))

  You need to insert a new product. The product's name is Plate and the product's ID is 12345.

  Which statement should you use?

  

  A. Option A

  B. Option B

  C. Option C

  D. Option D

  Correct Answer: D

• Question 48:

  You have the database table named Cars as defined below:

  

  You have the following Structured Query Language (SQL) statement:

  

  How many rows are returned by the SQL statement?

  A. 4

  B. 5

  C. 6

  D. 7

  Correct Answer: A

• Question 49:

  On which database structure does an insert statement operate?

  A. Role

  B. Trigger

  C. User

  D. Stored procedure

  E. Table

  Correct Answer: E

• Question 50:

  You have a table of products with fields for ProductID, Name, and Price.

  You need to write an UPDATE statement that sets the value in the InStock field to Yes for a specific ProductID.

  Which clause should you use in your update statement?

  A. THAT

  B. WHERE

  C. GROUP BY

  D. HAVING

  Correct Answer: B