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?

Two tables, namely, OrderItem and Item are depictedbelow in which all attributes mentioned therein
respectively, refer to column heading labels.

If the ItemName attribute is moved from the Item table to the OrderItem table, then will it violate any
normalization form? If yes, then which
of the following normalization forms will be violated?

You are the database administrator for a MySQL database. The database server is installed on a Unix system.
The time zone files for the system are located at /usr/share/zoneinfo. You need to ensure that the system and
MySQL time zones are based on the same information.Which of the following statements will you use to
accomplish the task?