Database Redesign What SQL command can be used to delete columns from a table? MODIFY TABLE TableName DROP COLUMN ColumnName MODIFY TABLE TableName DROP ColumnName ALTER TABLE TableName DROP ColumnName ALTER TABLE TableName DROP COLUMN ColumnName MODIFY TABLE TableName DROP COLUMN ColumnName MODIFY TABLE TableName DROP ColumnName ALTER TABLE TableName DROP ColumnName ALTER TABLE TableName DROP COLUMN ColumnName ANSWER DOWNLOAD EXAMIANS APP
Database Redesign The NOT EXISTS keyword will be true if any row in the subquery meets the condition. True False True False ANSWER DOWNLOAD EXAMIANS APP
Database Redesign 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 EXISTS/NOT EXISTS expressions only Both of the above are helpful Correlated subqueries only None of these ANSWER DOWNLOAD EXAMIANS APP
Database Redesign How can you find rows that do not match some specified condition? None of these Double use of NOT EXISTS EXISTS NOT EXISTS None of these Double use of NOT EXISTS EXISTS NOT EXISTS ANSWER DOWNLOAD EXAMIANS APP
Database Redesign Dependency graphs are diagrams that consist of nodes and arcs that show the dependencies of a database. True False True False ANSWER DOWNLOAD EXAMIANS APP
Database Redesign Some organizations take the stand that no application should ever employ the true name of a table. True False True False ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS