Which of the following is the process of collecting and analyzing information about the part of the
organization that is to be supported by the database application?

Which of the following statements is true regarding a composite key in a table?

Which of the following approaches begins with the identification of only a few important concepts
and, based on these, the design proceeds, spreading outward ‘radially’?

You have created a database for employee management. The database has a table named
Employees. The table has the following attributes:
Name
Address
Contact Number
Designation
You want to store the salary information for each employee. The database should also store salary
history. How will you design the database so that you can query the last increment given to a
particular employee?

Mark works as a Database Administrator for DataOneWorld Inc. The company has a SQL Server
database. Mark has to change the properties of an object inside the database. Which of the
following statements will he use to accomplish the task?

Mark works as the Database Administrator for DataWorld Inc. The company has a SQL server 2008
database. Mark wants to protect the database from unintended activities made by authorized
individuals or processes such as authenticated misuse, malicious attacks, or inadvertent mistakes.
Which of the following should he use to accomplish the task?

Rick works as a database administrator for a MySQL server. The server uses the InnoDB storage
engine. Rick finds that a table’s performance is inconsistent. He wants to bring the table to a
consistent state without shutting down the server. Choose the required steps to accomplish the task.

Examine the following table:

In the table, you deleted the record of Mark Smith. Which of the following will change as a result?

Which of the following files contain configuration information that must be restored after a MySQL
database server has crashed? Each correct answer represents a complete solution. Choose two.

John works as a Database Administrator in www.company.com Inc. The company has a SQL Server
database. John wants to create a table named employees in the database. The table will have the id,
firstname, lastname, and dateofbirth columns. John has to ensure that the lastname column does
not allow null values. Which of the following queries will he use to accomplish the task?