Database Redesign - Database MCQ Questions and answers- Technical Aptitude

Home / Database / Database Redesign

31.
The SQL-92 command to change a table name is RENAME TABLE.

A. True

B. False

Answer & Solution Discuss in Board Save for Later

32.
Reverse engineering is the process of reading a database schema and producing a data model from that schema.

A. True

B. False

Answer & Solution Discuss in Board Save for Later

33.
The data model produced from the reverse engineering process is a true logical model.

A. True

B. False

Answer & Solution Discuss in Board Save for Later

34.
It is not easy to build a database correctly the first time.

A. True

B. False

Answer & Solution Discuss in Board Save for Later

35.
Typically, there should be at least two different copies of the database schema used in the redesign process.

A. True

B. False

Answer & Solution Discuss in Board Save for Later

36.
Information systems and organizations do not just influence each other; they create each other.

A. True

B. False

Answer & Solution Discuss in Board Save for Later

37.
Adding null columns to a table is straightforward.

A. True

B. False

Answer & Solution Discuss in Board Save for Later

38.
The NOT EXISTS keyword will be true if any row in the subquery meets the condition.

A. True

B. False

Answer & Solution Discuss in Board Save for Later

39.
Dependency graphs are diagrams that consist of nodes and arcs that show the dependencies of a database.

A. True

B. False

Answer & Solution Discuss in Board Save for Later

40.
The EXISTS keyword will be true if any row in the subquery meets the condition.

A. True

B. False

Answer & Solution Discuss in Board Save for Later

1 2 3 4