It is impossible to pass Microsoft 98-364 exam without any help in the short term. Come to Ucertify soon and find the most advanced, correct and guaranteed Microsoft 98-364 practice questions. You will get a surprising result by our Improved Microsoft Database Fundamentals practice guides.

Q1. Which statement should you use to remove a foreign key? 

A. ALTER TABLE 

B. DELETE TABLE 

C. DELETE FOREIGN KEY 

D. ALTER FOREIGN KEY 

Answer:


Q2. You need to disable User1's access to view the data in the Customer table. Which statement should you use? 

A. Option A 

B. Option B 

C. Option C 

D. Option D 

Answer:


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

Answer: B


Q4. You have two tables. Each table has three rows. 

How many rows will be included in the Cartesian product of these two tables? 

A. 0 

B. 3 

C. 6 

D. 9 

Answer:


Q5. Which keyword can be used in a create table statement? 

A. ORDER BY 

B. DISTINCT 

C. GROUP BY 

D. UNIQUE 

Answer:


Q6. You have a table of products with fields for ProductID, Name, and Price. 

You need to write an UPDATE statement that sets the value in the InStock field to Yes for a specific ProductID. 

Which clause should you use in your update statement? 

A. THAT 

B. WHERE 

C. GROUP BY 

D. HAVING 

Answer:


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

Truncate is a database term used to describe the process of applying a backup to a damaged or corrupt 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 corrector. 

A. Change is needed 

B. Commit 

C. Attach 

D. Restore 

Answer:


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

Answer:


Q9. Which command should you use to give a user permission to read the data in a table? 

A. ALLOW SELECT 

B. LET READ 

C. PERMIT READ 

D. GRANT SELECT 

Answer:


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

You have two tables. Each table has three rows. 

Nine rows will be included in the Cartesian product of these two 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 corrector. 

A. No change is needed 

B. Zero 

C. Three 

D. Six 

Answer:


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

Answer:


Q12. You have a table named Employee that includes the following columns: 

EmployeeID 

Smp1oyeeName 

Which statement should you use to return the number of rows in the table? 

A. Option A 

B. Option B 

C. Option C 

D. Option D 

Answer:


Q13. DRAG DROP 

You need to set up a database to provide a view of North American mammals. 

Match the Structured Query Language (SQL) statements to the SQL query. 

Instructions: To answer, drag the appropriate SQL statement from the column on the left to its place in the SQL query on the right Each SQL statement may be used once, more than once, or not at all. Each correct match is worth one point. 

Answer: 


Q14. You have a table that contains the following data. 

You break the table into the following two tables. 

This process is referred to as: 

A. defragmentation 

B. normalization 

C. fragmentation 

D. denormalization 

Answer: B


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

Answer: