Database Fundamentals Free Practice Exam Questions

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

1. Question 125: Which command should you use to remove a table from a database?
2. Question 126: You need to store the contact information for each student in your school database. You should store each student's information in a:
3. Question 127: Which keyword must be included in a create view statement?
4. Question 128: Which two elements are required to define a column? (Choose two.)
5. Question 129: What defines the amount of storage space that is allocated to a value in a column?
6. Question 130: You are creating a table to store customer data. The AccountNumber column uses values that always consist of one letter and four digits. Which data type should…
7. Question 131: What is one difference between an update statement and a delete statement?
8. Question 132: You have a Department table and an Employee table in your database. You need to ensure that an employee can be assigned to only an existing department. What sh…
9. Question 133: You need to store the first name, last name, and student ID for 100 students. This information will be stored in a table as:
10. Question 134: 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…