You are a Database Administrator of MySQL database.Few days back, your server crashed. Now, it is up and
online. You need to check the integrity of various tables used in the database. You need to issue the CHECK
TABLE command. For which of the following tables will this command work? Each correct answer represents a
complete solution. Choose two.

Which of the following can be used to populate a table? Each correct answer represents a complete solution.
Choose all that apply.

Which of the following statements about external tables is true?

You work as a Database Designer for SoftTech Inc. You have developed the conceptual design of the
database of an organization. Following is the ER-diagram, which you have designed. Now you have to convert
the following diagram to a logical model.

Which of the following steps will you take to accomplish the task? Each correct answer represents a part of the
solution. Choose all that apply.

Which of the following values cannot be stored in acharacter column defined as the primary key of a table?

Mark works as a Database Administrator for DataOneWorld Inc. Management instructs him to provide an
additional security layer to the database to prevent unauthorized viewing of data with the help of an algorithm
called cipher. Which of the following will help himto accomplish the task?

Which of the following is a design of the user interface and the application programs that use and process the
database?

Which of the following is used to give a default value to a column if the value for that column is unknown?

Suzanne works as a Database Designer for DataOneWorld Inc. She is assigned the task of ecomposing the
components of a database, but she has to ensure that all the components are decomposed to only some
extent. Which of the following approaches will she use to accomplish the task?

Consider the case of a distance education university. The university has many regional centers across the
country. Each regional center has a head known as regional manager. Each regional center has allotted more
than one study center in its region. Each regional center has a region code, which is unique and specifies a
region. Each study center also has a study center code, which is also unique. What is the relationshipbetween
regional center and study center?