Database Fundamentals Free Practice Exam Questions

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

Question 16: 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?
Question 17: This question requires that you evaluate the underlined text to determine if it is correct. Use the FROM keyword in a SELECT statement to return rows that meet…
Question 18: This question requires that you evaluate the underlined text to determine if it is correct. The CREATE TABLE command removes one or more table definitions and…
Question 19: 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: R…
Question 20: This question requires that you evaluate the underlined text to determine if it is correct. Use the ALTER statement to add a new table in a database. Instructi…
Question 21: This question requires that you evaluate the underlined text to determine if it is correct. Use indexing to create, remove, or change database objects. Instruc…
Question 22: This question requires that you evaluate the underlined text to determine if it is correct. The UNION keyword combines the results of two queries and returns o…
Question 25: You have a table named Student that contains 100 rows. Some of the rows have a NULL value in the FirstName column. You execute the following statement: DELETE…
Question 27: At 3:00 P.M. (1500 hours), you create a backup of your database. At 4:00 P.M. (1600 hours), you create a table named Customer and import data into the table. A…
Question 28: In which situation do you need to perform a restore on a database?