Which of the following statements is true regardinga 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, orinadvertent 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 stepsto 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 thedatabase. 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?

Which of the following statements are true regarding DML? Each correct answer represents a complete
solution. Choose all that apply.