Database Fundamentals Free Practice Exam Questions

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

  1. Question 85: You have a table named Product. You create a view that includes all the products from the Product table that are in the Furniture category. You execute a state…
  2. Question 86: One reason to add an index is to:
  3. Question 87: You execute the following statement: SELECT EmployeeID, FirstName, DepartmentName FROM Employee, Department - This type of operation is called a/an:
  4. Question 88: This question requires that you evaluate the underlined text to determine if it is correct. Views are database objects that contain all of the data in a databa…
  5. Question 91: This question requires that you evaluate the underlined text to determine if it is correct. Create a query that returns a set of table data by using the UPDATE…
  6. Question 92: This question requires that you evaluate the underlined text to determine if it is correct. Truncate is a database term used to describe the process of applyin…
  7. Question 93: This question requires that you evaluate the underlined text to determine if it is correct. Use the ALLOW SELECT command to give a user permission to read the…
  8. Question 94: Data in a database is stored in:
  9. Question 95: This question requires that you evaluate the underlined text to determine if it is correct. ALTER TABLE removes all rows from a table without logging the indiv…
  10. Question 96: This question requires that you evaluate the underlined text to determine if it is correct. A row holds information for a single record in a table. Instruction…