Database Fundamentals Free Practice Exam Questions

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

1. Question 59: Which category of SQL statements is used to add, remove, and modify database structures?
2. Question 61: You need to establish a set of permissions that you can routinely assign to new users. What should you create?
3. Question 62: Denormalization is performed in order to:
4. Question 63: Which two keys establish a relationship between two tables? (Choose two.)
5. Question 65: Which database term is used to describe the process of applying a backup to a damaged or corrupt database?
6. Question 66: You have a table named Product that contains one million rows. You need to search for product information in the Product table by using the product's unique ID…
7. Question 67: You need to remove a view named EmployeeView from your database. Which statement should you use?
8. Question 68: A named group of SQL statements that can be executed in a database is called a:
9. Question 69: You delete rows in a table named Order. The corresponding rows in the OrderItem table are automatically deleted. This process is an example of a/an:
10. Question 70: Which statement should you use to remove a foreign key?