General Questions

Question 1 :

Which of the following SQL statements are helpful in database redesign?


A). Correlated subqueries only
B). EXISTS/NOT EXISTS expressions only
C). Both of the above are helpful
D). None of the above are helpful.
Answer : Option C

Question 2 :

What SQL command can be used to delete columns from a table?


A). MODIFY TABLE TableName DROP COLUMN ColumnName
B). MODIFY TABLE TableName DROP ColumnName
C). ALTER TABLE TableName DROP COLUMN ColumnName
D). ALTER TABLE TableName DROP ColumnName
Answer : Option C

Question 3 :

Database redesign is not terribly difficult if the:


A). database is structured.
B). database is well-designed.
C). database has no data.
D). database is relatively small.
Answer : Option C

Question 4 :

Which SQL-92 standard SQL command can be used to change a table name?


A). RENAME TABLE
B). CHANGE TABLE
C). ALTER TABLE
D). None of the above is correct.
Answer : Option D

Question 5 :

The process of reading a database schema and producing a data model from that schema is known as:


A). data modeling.
B). database design.
C). reverse engineering.
D). None of the above is correct.
Answer : Option C