Microsoft MTA 98-364 Questions & Answers

• Question 1:

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

  A key defines the amount of storage space that is allocated to a value in a column.

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

  C. data type

  D. validator

  Correct Answer: C

• Question 2:

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

  A relational database management system employs the concept of an attribute to ensure that data entered into a field in a column is valid.

  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. a primary key

  C. a constraint

  D. an index

  Correct Answer: C

• Question 3:

  You have a database that contains 10 terabytes of data. You need to back up the database every two hours.

  Which type of backup should you use?

  A. archive

  B. incremental

  C. partial

  D. full

  Correct Answer: C

• Question 4:

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

  The UNION keyword combines the results of two queries and returns only rows that appear in both result sets.

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

  C. ALL

  D. JOIN

  Correct Answer: B

  UNION combines the results from both queries. INTERSECT returns rows that are common to both queries

• Question 5:

  You need to create a view to filter rows of data from an underling table.

  Which type of clause must be included in the CREATE VIEW statement?

  A. CONSTRAINT

  B. WHERE

  C. JOIN

  D. FILTER

  Correct Answer: B

• Question 6:

  You are developing a SQL query.

  Which two SQL constructs represent data manipulation language (DML) statements? Choose two.

  A. SELECT EmployeeName FROM Employee WHERE EmployeeName = 'Jack Smith';

  B. INSERT INTO Employee VALUES ('Jack Smith')

  C. ALTER TABLE Employee ADD EmployeeName Varchar;

  D. CREATE ROW IN Employee WHERE EmployeeName = 'Jack Smith';

  Correct Answer: AB

  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 ... (strictly speaking DQL)

  SELECT ... INTO ...

  INSERT INTO ... VALUES ...

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

  DELETE FROM ... WHERE ...

  References:

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

• Question 7:

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

  Use the ALLOW SELECT command to give a user permission to read the data 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. GRANT SELECT

  C. LET HEAD

  D. PERMIT READ

  Correct Answer: B

• Question 8:

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

  Views are database objects that contain all of the data 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. Queries

  C. Stored procedures

  D. Tables

  Correct Answer: D

• Question 9:

  You have two tables named Cars and Color as defined below. The two tables are related by ColorId.

  

  You run the following SQL statement: select:

  

  How many rows does the SQL statement return?

  A. 0

  B. 2

  C. 3

  D. 6

  Correct Answer: C

• Question 10:

  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.

  When volunteers ask to be removed from mailing lists, the table must be updated.

  You need to use a transaction to ensure that the database has data integrity and referential integrity.

  Which statement should you use?

  

  A. Option A

  B. Option B

  C. Option C

  D. Option D

  Correct Answer: A