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 prototyping strategies? Each correct answer represents a
complete solution. Choose two.

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

How many records will be displayed if the following SQL 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?