Microsoft Microsoft Certifications 98-364 Questions & Answers

• Question 11:

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

  ALTER TABLE removes all rows from a table without logging the individual row deletions.

  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. CREATE TABLE

  Correct Answer: C

• Question 12:

  You work at a coffee shop. They ask you to set up a website that stores charges on purchases.

  You need to recommend a data type in a database table to run financial functions against the charged amounts.

  Which data type should you recommend?

  A. Money

  B. Bit

  C. Varchar

  D. Binary

  Correct Answer: A

• Question 13:

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

  A row holds information for a single record in a table.

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

  C. Data type

  D. View

  Correct Answer: A

• Question 14:

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

  Ports 20 and 21 are the default ports to secure a SQL Server.

  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. 1433 and 1434

  C. 411 and 412

  D. 67 and 68

  Correct Answer: B

• Question 15:

  You ate creating a database object named Student to store the following data:

  

  Which syntax should you use to create the object?

  

  A. Option A

  B. Option B

  C. Option C

  D. Option D

  Correct Answer: A

• Question 16:

  You develop a database to store data about textbooks. The data must be stored to process at a later time. Which database object should you use to store the data?

  A. View

  B. Table

  C. Function

  D. Stored procedure

  Correct Answer: D

• Question 17:

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

  First normal form requires that a database excludes repeating groups.

  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. Composite keys

  C. Duplicate rows

  D. Foreign keys

  Correct Answer: A

• Question 18:

  You have the following SQL query

  SELECT * FROM dbo.ProAthlete WHERE Salary > 500000

  The query takes too much time to return data.

  You need to improve the performance of the query.

  Which item should you add to the Salary column?

  A. Non-null constraint

  B. Default constraint

  C. Index

  D. Foreign key

  Correct Answer: D

• Question 19:

  You work for a small auto trading company. You need to remove a car from the company database. Information about the car is stored in the following tables.

  

  All of the car's parts are custom made, so they each have a row in every table. Cascading deletes are not enabled but referential integrity is. From which table must you first make your deletion?

  A. Make

  B. Model

  C. Engine

  D. ModelEngine

  Correct Answer: A

• Question 20:

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

  You have a table that contains information about all students in your school.

  You use the INSERT SQL keyword to change a student's given name in the table.

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

  B. UPDATE

  C. SELECT

  D. No change needed

  Correct Answer: B