You work as a Database Designer for Hitech Inc. Youare designing a database named Project. The company
takes projects from outside and divides them into tasks (design, coding, etc.). Each task is assigned to only
one employee. You want to use a primary key constraint to uniquely define each row in a table named Task.
The tables are given below:

Which of the following attributes can be a primary key in the Task table?

Which of the following is the process of creating adesign for the database that will support the enterprise’s
operations and objectives for the required databasesystem?

You manage a database named Exams accessed via a website. The website is regularly accessed by users in
different countries. You are redesigning a table named History that records when users have purchased and
taken online exams. You need one of the columns in the History table to record what time of day that auser
has taken an exam. Additionally, you need this column to have time zone awareness. What data type should
you use?

Fill in the blank with the appropriate word.
The model for database management is a database model based on first-order predicate logic.

You are designing a database for a sports hostel. In the hostel, a player can be enrolled for multiplegames.
You are working on a relation shown in the image below:

Which of the following candidate keys would best serve as the primary key?

You are designing a database for a sports hostel. There are three types of buildings for which a fixedfee is
charged on per room basis. No player can take two accommodations. You design the following table:

Considering that the P_ID is the primary key, the table is in which normal form? Each correct answer
represents a complete solution. Choose all that apply.

You work as a Database Administrator for Dowtech Inc. A table named StudentInformation exists in a
database. The table has columns named student_names, student_marks, and student_courses. Some
students who have opted for various courses have got different marks in them. This implies that the table has
two many-to-many relationships. You have to ensure that these two relationships are not represented ina
single table and that the student_name column exists in both tables. Which of the following normal forms will
you use to represent these relationships in the tables?

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