Database Fundamentals Free Practice Exam Questions

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

1. Question 71: First normal form requires that a database excludes:
2. Question 72: On which database structure does an insert statement operate?
3. Question 76: 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?
4. Question 77: 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 a…
5. Question 79: You execute a statement inside a transaction to delete 100 rows from a table. The transaction fails after only 40 rows are deleted. What is the result in the d…
6. Question 80: You are developing a SQL query. Which two SQL constructs represent data manipulation language (DML) statements? Choose two.
7. Question 81: 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?
8. Question 82: This question requires that you evaluate the underlined text to determine if it is correct. Ports 20 and 21 are the default ports to secure a SQL Server. Instr…
9. Question 83: This question requires that you evaluate the underlined text to determine if it is correct. You have a table that contains information about all students in yo…
10. Question 84: Your class project requires that you help a charity to create a website that registers volunteers. The website must store the following data about the voluntee…