98-364 Exam
The Secret of 98-364 test question
Act now and download your Microsoft 98-364 test today! Do not waste time for the worthless Microsoft 98-364 tutorials. Download Up to the minute Microsoft Microsoft Database Fundamentals exam with real questions and answers and begin to learn Microsoft 98-364 with a classic professional.
Q1. Which type of index changes the order in which the data is stored in a table?
A. non-sequential
B. sequential
C. non-clustered
D. clustered
Answer: A
Q2. This question requires that you evaluate the underlined text to determine if it is correct.
You combine data from three tables into one table. The new table includes redundancy to optimize read performance.
The data in the new table has been denormalized.
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. Normalized
C. Truncated
D. Indexed
Answer: A
Q3. Which statement will result in the creation of an index?
A. Option A
B. Option B
C. Option C
D. Option D
Answer: A
Q4. What are three valid data manipulation language (DML) commands? (Choose three.)
A. INSERT
B. COMMIT
C. DELETE
D. OUTPUT
E. UPDATE
Answer: A,C,E
Explanation: http://en.wikipedia.org/wiki/Data_manipulation_language
Data manipulation languages have their functional capability organized by the initial word ina 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 ...
Q5. You are writing a select statement to find every product whose name contains a specific character.
Which keyword should you use in your where clause?
A. FIND
B. BETWEEN
C. INCLUDES
D. LIKE
Answer: D
Q6. You need to store the contact information for each student in your school database.
You should store each student's information in a:
A. Stored procedure
B. Function
C. Row
D. Variable
Answer: C
Q7. 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
Answer: D
Q8. 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
Answer: C
Q9. 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.
Answer: C
Q10. Which command should you use to add a column to an existing table?
A. MODIFY
B. ALTER
C. UPDATE
D. INSERT
E. CHANGE
Answer: B