Database Fundamentals Free Practice Exam Questions

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

Question 136: JDBC API 2.0 defines five levels of transaction isolation for database concurrency control. Which of the following is the lowest level of transaction isolation?
Question 137: You are the database administrator of a MySQL server that runs on a Windows server. All clients are local clients. For security, you want to disable connection…
Question 138: Which of the following commands can be used to change the authorization type in DB2 9? Each correct answer represents a complete solution. (Choose all that app…
Question 139: You are a database developer for a database named Customers hosted on a SQL Server 2008 server. Recently, several customers were deleted from the Customers dat…
Question 140: You work as a Database Designer for DataOneWorld Inc. The company has a SQL Server database. You are assigned the task of creating a data model of an enterpris…
Question 141: John works as a Database Administrator for DataOneWorld Inc. The company has a SQL Server database. John wants to insert records in a table where the database…
Question 142: Which of the following scripts is used to convert Unix-type zone files into SQL statements, and loads the time zone tables in a mysql database?
Question 143: You are the database administrator for a MySQL database server. The network contains new and old (pre-4.1) clients. You configure another database server on th…
Question 144: Which of the following DML SQL statements support usage of correlated sub-queries? Each correct answer represents a complete solution. (Choose all that apply.)
Question 145: What is the ideal time to back up dynamic log files?