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 a character 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 him to 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 relationship between regional center and study center?