Database Redesign What SQL command can be used to delete columns from a table? ALTER TABLE TableName DROP COLUMN ColumnName MODIFY TABLE TableName DROP ColumnName ALTER TABLE TableName DROP ColumnName MODIFY TABLE TableName DROP COLUMN ColumnName ALTER TABLE TableName DROP COLUMN ColumnName MODIFY TABLE TableName DROP ColumnName ALTER TABLE TableName DROP ColumnName MODIFY TABLE TableName DROP COLUMN ColumnName ANSWER DOWNLOAD EXAMIANS APP
Database Redesign How can you find rows that do not match some specified condition? Double use of NOT EXISTS NOT EXISTS EXISTS None of these Double use of NOT EXISTS NOT EXISTS EXISTS None of these ANSWER DOWNLOAD EXAMIANS APP
Database Redesign The data model that is produced from reverse engineering is: None of these an internal model. a conceptual model. a logical model. None of these an internal model. a conceptual model. a logical model. ANSWER DOWNLOAD EXAMIANS APP
Database Redesign Which is not true of a correlated subquery? EXISTS/NOT EXISTS is a form of a correlated subquery. They can be used to verify functional dependencies. The processing of the SELECT statements is nested. They are very similar to a regular subquery. EXISTS/NOT EXISTS is a form of a correlated subquery. They can be used to verify functional dependencies. The processing of the SELECT statements is nested. They are very similar to a regular subquery. ANSWER DOWNLOAD EXAMIANS APP
Database Redesign Reverse engineering is the process of reading a database schema and producing a data model from that schema. False True False True ANSWER DOWNLOAD EXAMIANS APP
Database Redesign Adding null columns to a table is straightforward. True False True False ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS