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? Eachcorrect
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 apart 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. Whatshould
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 thedatabase.”

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 orderof 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 wantsto
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?

John works as a Database Administrator for DataOneW orld Inc. The company has a SQL Server database.
John wants to insert records in a table where the database is structured in a fixed format. Which of the
following data models will he use to accomplish thetask?