Database Fundamentals Free Practice Exam Questions

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

  1. Question 2: You accept an IT internship at a local charity. The charity wants you to help them with compliance and auditing requirements. You need to ensure that a column…
  2. Question 3: While attending college, you accept an IT internship at a local charity. The charity needs to report on data that is related and exists in two tables. You need…
  3. Question 4: You need to add rows to a database table. Which Structured Query Language (SQL) keyword should you use?
  4. Question 6: You work at a coffee shop. They ask you to set up a website that stores charges on purchases. You need to recommend a data type in a database table to run fina…
  5. Question 7: You have the following SQL query SELECT * FROM dbo.ProAthlete WHERE Salary > 500000 The query takes too much time to return data. You need to improve the perfo…
  6. Question 9: This question requires that you evaluate the underlined text to determine if it is correct. In a database table, each column represents a unique record. Instru…
  7. Question 10: You assign User1 a set of permissions that include the WITH GRANT OPTION. The WITH GRANT OPTION enables User1 to:
  8. Question 11: Which type of index changes the order in which the data is stored in a table?
  9. Question 12: You have two tables named Salesperson and Sales. You need to ensure that each record in the Sales table has a valid associated salesperson record in the Salesp…
  10. Question 15: You develop a database to store data about textbooks. The data must be stored to process at a later time. Which database object should you use to store the dat…