Database Fundamentals Free Practice Exam Questions

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

1. Question 49: You need to enable a new employee to authenticate to your database. Which command should you use?
2. Question 50: Which keyword can be used in a create table statement?
3. Question 51: You need to store product names that vary from three to 30 characters. You also need to minimize the amount of storage space that is used. Which data type shou…
4. Question 52: One reason to create a stored procedure is to:
5. Question 53: Which permission does a user need in order to run a stored procedure?
6. Question 54: You have two tables. Each table has three rows. How many rows will be included in the Cartesian product of these two tables?
7. Question 55: You are writing an SQL statement to retrieve rows from a table. Which data manipulation language (DML) command should you use?
8. Question 56: The component that holds information for a single entry in a table is called a:
9. Question 57: You are writing a select statement to find every product whose name contains a specific character. Which keyword should you use in your where clause?
10. Question 58: You have a table that contains information about all students in your school. Which SQL keyword should you use to change a student's first name in the table?