You work as an Application Developer for Nero Inc. You want to instruct the DBMS to set the
transaction isolation level so that when a user updates a table in the database, other users cannot
read the value at the same time. Which of the following methods will you use to define the
transaction level?

You work as a Database Designer for Realtech Inc. You want to create two tables, Product and Order,
such that a row in the Order table does not exist without a corresponding row in the Product table.
The structure of the Product and Order tables with their respective columns is given below:
Product
ProductID
ProductNumber
Date_of_manufacturing
SupplierID
ProductPrice
ProductQty
Order
OrderID
OrderDate
OrderQuantity
OrderPrice
Based on this information, while maintaining the integrity of this rule, what will you do to
accomplish the task?

Which of the following are the correct statements of using the Flashback Query feature in Oracle?
Each correct answer represents a complete solution. Choose all that apply.

Which of the following are the steps of database planning life cycle? Each correct answer represents
a part of the solution. Choose three.

You manage a SQL Server 2008 server that hosts a database named Sales. Unauthorized odifications
to some tables within the Sales database have resulted in some views no longer working. You need
to implement a method that will ensure that all modifications to any objects with the Sales database
are logged. What should you do?

Which of the following are considered limitations of the legacy LOB implementation?

Which of the following properties of the database transaction has been defined in the given
statement: “Either all the changes or no changes have been made in the database.”

You work as a Database Designer for Allen Inc. You are designing the database of a company that has
several divisions (e.g. Spare Parts division). Each division has several departments (e.g. Quality
Control department), and every department has several employees. What will be the relationship
between the two entities, namely, division and employee, if you model the database?

Roger is the HR Manager of Neon Inc. He wants to generate a report of all the employees working in
Department ID 30 from the Emp table on the following attributes:
Fname
Lname
Salary
All the records should be sorted in ascending order of the Lname attribute. Which of the following
queries will he use to get the required output?

Merlyn works as a Database Administrator for DOW Inc. She is currently designing a database. She
wants to break down the preliminary specifications into smaller components so that each
component describes a basic fragment of the specifications. Which of the following approaches is
she using?