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 accomplishthe
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 exactlyas 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?

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

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’?