Examine the following table:

What is the degree of this table?

A company named Rel Inc. has many authorized dealers across the country who sell their products.
The Sales Manager of the company wants to see the details of the authorized dealers, including the
name, region, and total sales in ascending order of sales. Which of the following queries should be
issued to get the desired output?

You work as the Database Administrator for a MySQL database server. In an hour or so, you are able
to bring a corrupted server online. You execute the CHECK TABLE command and find that some of
the InnoDB tables need to be repaired. You restart the server and discover that auto-recover has
failed. Which of the following steps will you take to recover the corrupted InnoDB tables?

Mark works as a Database Administrator for DataOneWorld Inc. The company has a SQL Server
database. Management instructs him to verify the identity of a user or software that is connecting to
the database. Which of the following will help him to accomplish the task?

Which of the following are the characteristics of application design? Each correct answer represents
a complete solution. Choose three.

Consider the conceptual database design, depicting the relationship between two entities. The
relationship among Author, Title, and Order is represented by the ER-diagram given below:

What is the relationship between Author and Title?

John works as a database designer in ABC Tech. He wants to produce a description of a database
implemented on secondary storage media. Which of the following designs will he implement to
accomplish the task?

You have developed a stored procedure named usp_GetEmp that accepts an employee number as a
parameter and retrieves the details about the employee from the CurrentEmp table of a database
named Employees. You have tested it, and it works exactly as you expected. Later, another
employee tries to use the stored procedure and receives the following error: “The SELECT
permission was denied on the object ‘CurrentEmp’, database ‘Employees.schema ‘dbo’ “.
What should you do to resolve the problem?

Peter works as a Database Administrator for DataOneWorld Inc. The company has a SQL Server
database. Peter has to construct an Entity-Relationship schema design for the data he will use in the
database. Which of the following database designs will he use to accomplish the task?

You are taking back up of your MySQL database server. You need to take a back up of the file that
has been created by the replication slave server and contains information needed for connecting to
the master server. Which of the following files will you copy?