A regular subquery can be processed: from the top down. by nesting. None of these from the bottom up. TRUE ANSWER : ? YOUR ANSWER : ?
The EXISTS keyword will be true if: any row in the subquery meets the condition only. all rows in the subquery fail the condition only. both of these two conditions are met. neither of these two conditions is met. TRUE ANSWER : ? YOUR ANSWER : ?
The NOT EXISTS keyword will be true if any row in the subquery meets the condition. False True TRUE ANSWER : ? YOUR ANSWER : ?
The process of reading a database schema and producing a data model from that schema is known as: data modeling. reverse engineering. None of these database design. TRUE ANSWER : ? YOUR ANSWER : ?
Because of the need for extensive knowledge of SQL, many database developers choose to automate the redesign process. True False TRUE ANSWER : ? YOUR ANSWER : ?
Which of the following SQL statements are helpful in database redesign? EXISTS/NOT EXISTS expressions only Both of the above are helpful Correlated subqueries only None of these TRUE ANSWER : ? YOUR ANSWER : ?
Which is not true of a correlated subquery? They can be used to verify functional dependencies. EXISTS/NOT EXISTS is a form of a correlated subquery. The processing of the SELECT statements is nested. They are very similar to a regular subquery. TRUE ANSWER : ? YOUR ANSWER : ?
What SQL command can be used to add columns to a table? ALTER TABLE TableName ADD ColumnName ALTER TABLE TableName ADD COLUMN ColumnName MODIFY TABLE TableName ADD COLUMN ColumnName MODIFY TABLE TableName ADD ColumnName TRUE ANSWER : ? YOUR ANSWER : ?
Database redesign is not terribly difficult if the: database has no data. database is relatively small. database is structured. database is well-designed. TRUE ANSWER : ? YOUR ANSWER : ?