Microsoft Microsoft Certifications 98-364 Questions & Answers

• Question 71:

  Which statement deletes the rows where the employee's phone number is not entered?

  

  A. Option A

  B. Option B

  C. Option C

  D. Option D

  Correct Answer: A

• Question 72:

  You need to insert two new products into the Product table. The first product is named Book and has an ID of 125. The second product is named Movie and has an ID of 126.

  Which statement should you use?

  

  A. Option A

  B. Option B

  C. Option C

  D. Option D

  Correct Answer: B

• Question 73:

  You have a table named Employee that includes four columns. You execute the following statement:

  SELECT * FROM Employee

  Which columns are returned?

  A. all columns

  B. only the last column

  C. only the first column

  D. only the first and last columns

  Correct Answer: A

• Question 74:

  Which two elements are required to define a column? (Choose two.)

  A. A name

  B. A key

  C. An index

  D. A data type

  Correct Answer: AD

• Question 75:

  What defines the amount of storage space that is allocated to a value in a column?

  A. format

  B. key

  C. data type

  D. validator

  Correct Answer: C

• Question 76:

  You are creating a table to store customer data. The AccountNumber column uses values that always consist of one letter and four digits. Which data type should you use for the AccountNumber column?

  A. CHAR

  B. BYTE

  C. DOUBLE

  D. SMALLINT

  Correct Answer: A

• Question 77:

  What is one difference between an update statement and a delete statement?

  A. An update statement can change only one row.

  B. A delete statement cannot use a where clause.

  C. An update statement does not remove rows from a table.

  D. A delete statement works only within a stored procedure.

  Correct Answer: C

• Question 78:

  You have a Department table and an Employee table in your database.

  You need to ensure that an employee can be assigned to only an existing department.

  What should you apply to the Employee table?

  A. A primary key

  B. An index

  C. A foreign key

  D. A unique constraint

  E. A data type

  Correct Answer: C

• Question 79:

  You need to store the first name, last name, and student ID for 100 students.

  This information will be stored in a table as:

  A. 100 items and three cells.

  B. 100 rows and three columns.

  C. three rows and 100 columns.

  D. three items and 100 cells.

  Correct Answer: B

• Question 80:

  What are three valid data manipulation language (DML) commands? (Choose three.)

  A. INSERT

  B. COMMIT

  C. DELETE

  D. OUTPUT

  E. UPDATE

  Correct Answer: ACE

  Data manipulation languages have their functional capability organized by the initial word in a statement, which is almost always a verb. In the case of SQL, these verbs are:

  SELECT ... FROM ... WHERE ...

  INSERT INTO ... VALUES ...

  UPDATE ... SET ... WHERE ...

  DELETE FROM ... WHERE ...

  References:

  http://en.wikipedia.org/wiki/Data_manipulation_language