Microsoft Microsoft Certifications 98-364 Questions & Answers

• Question 31:

  You need to add rows to a database table.

  Which Structured Query Language (SQL) keyword should you use?

  A. JOIN

  B. INSERT

  C. CREATE

  D. UPDATE

  Correct Answer: A

• Question 32:

  You need to retrieve data from two related database tables based on a column that exists in both tables. Which command should you use in a query?

  A. INTERSECT

  B. UNION

  C. JOIN

  D. TRUNCATE

  Correct Answer: B

• Question 33:

  You accept an IT internship at a local charity. The charity asks you to keep a record of its volunteers by using a database table named Volunteer.

  The table has the following columns and rows:

  

  When volunteer information changes, you must update the table.

  You need to change Tia's name to Kimberly.

  Which statement should you choose?

  

  A. Option A

  B. Option B

  C. Option C

  D. Option D

  Correct Answer: A

• Question 34:

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

  Use the FROM keyword in a SELECT statement to return rows that meet a specific condition.

  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. ORDER BY

  C. UNION

  D. WHERE

  Correct Answer: D

• Question 35:

  You need to combine the results of two queries into a single result that contains all of the rows from both queries. Which Structured Query Language (SQL) statement should you use?

  A. TRUNCATE

  B. JOIN

  C. EXCEPT

  D. UNION

  Correct Answer: D

• Question 36:

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

  The CREATE TABLE command removes one or more table definitions and all data, indexes, triggers, constraints, and permission specifications for those 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 correct

  A. No change is needed

  B. DROP TABLE

  C. TRUNCATE TABLE

  D. ALTER TABLE

  Correct Answer: B

• Question 37:

  You accept an IT internship at a local charity. The charity wants you to help them with compliance and auditing requirements.

  You need to ensure that a column or combination of columns uniquely identifies each row of a table.

  Which constraint should you define?

  A. Primary key

  B. Secondary key

  C. Foreign key

  D. Default key

  Correct Answer: C

• Question 38:

  While attending college, you accept an IT internship at a local charity. The charity needs to report on data that is related and exists in two tables.

  You need to establish a relationship between the data that is in the two tables.

  Which constraint should you define?

  A. Foreign key

  B. Index key

  C. Link key

  D. Default key

  Correct Answer: B

• Question 39:

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

  A view can be used to ensure referential integrity.

  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. Save an extra copy of data stored in a separate table.

  C. Limit access to specific rows or columns of data in a table.

  D. Save historical data before deleting it from the base table.

  Correct Answer: C

• Question 40:

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

  In a database table, each column represents a unique record.

  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. Table

  C. Index

  D. Row

  Correct Answer: D