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?

Which of the following provides reliable units of work that allow correct recovery from failures and keeps a
database consistent even in cases of system failure?

Which of the following DML SQL statements support usage of correlated sub-queries? Each correct answer
represents a complete solution. Choose all that apply.

Which of the following are the types of prototypingstrategies? Each correct answer represents a complete
solution. Choose two.

A table named Emp is given below that contains dataof an organization.

How many records will be displayed if the followingSQL query is executed? SELECT *
FROM Emp
WHERE Name BETWEEN ‘D’ AND ‘F’

Which of the following commands cannot be rolled back? Each correct answer represents a complete solution.
Choose two.

Mark works as a Database Designer for Reon Inc. He is assigned the task to create a database for the
company. He issues the following query to create the database.
CREATE DATABASE ‘24342’
What will be the output of the query?

What is the ideal time to back up dynamic log files?

You work as a MySQL Database Administrator. Your server crashed and it was recovered and made online
within half an hour. What will you do to ensure that the table structure and contents are in a proper state?

James works as an Administrator for Softech Inc. The company has a SQL Server 2005 computer named
SQL1. The company has six departments; Accounting, Sales, Marketing, Manufacturing, Production, and
Research. The user accounts of each department are located in a domain group named after the department.
James wants to create a separate database on SQL1 for each epartment which will store the department
related information. Users in each department must be able to read and update data in the database belonging
to their respective departments. No user must be able to access the database belonging to another
department. James wants to configure access to the database to meet these requirements. What should
James do to accomplish the task?