Database Fundamentals Free Practice Exam Questions

128 real Database Fundamentals exam questions with answers and AI explanations. Microsoft certification prep — page 3 of 13.

1. Question 29: You need to rename a column in a database table. Which data definition language (DDL) statement should you use?
2. Question 31: You have a table that contains product IDs and product names. You need to write an UPDATE statement to change the name of a specific product to glass. What sho…
3. Question 32: The terms "bitmap," "b-tree," and "hash" refer to which type of database structure?
4. Question 33: You need to store product quantities, and you want to minimize the amount of storage space that is used. Which data type should you use?
5. Question 35: Which command should you use to add a column to an existing table?
6. Question 36: One difference between a function and a stored procedure is that a function:
7. Question 38: 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) stat…
8. Question 43: 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 in…
9. Question 45: You need to delete a database table. Which data definition language (DDL) keyword should you use?
10. Question 48: Which key uniquely identifies a row in a table?