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?

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?

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.”

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?

You are a Database Administrator of MySQL database.Few days back, your server crashed. Now, it is up and
online. You need to check the integrity of various tables used in the database. You need to issue the CHECK
TABLE command. For which of the following tables will this command work? Each correct answer represents a
complete solution. Choose two.

Mark works as a Database Administrator for DataOneWorld Inc. Management instructs him to provide an
additional security layer to the database to prevent unauthorized viewing of data with the help of an algorithm
called cipher. Which of the following will help himto accomplish the task?