Database Redesign The process of reading a database schema and producing a data model from that schema is known as: data modeling. None of these reverse engineering. database design. data modeling. None of these reverse engineering. database design. ANSWER DOWNLOAD EXAMIANS APP
Database Redesign What SQL command can be used to add columns to a table? MODIFY TABLE TableName ADD ColumnName ALTER TABLE TableName ADD ColumnName ALTER TABLE TableName ADD COLUMN ColumnName MODIFY TABLE TableName ADD COLUMN ColumnName MODIFY TABLE TableName ADD ColumnName ALTER TABLE TableName ADD ColumnName ALTER TABLE TableName ADD COLUMN ColumnName MODIFY TABLE TableName ADD COLUMN ColumnName 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 How can you find rows that do not match some specified condition? NOT EXISTS Double use of NOT EXISTS None of these EXISTS NOT EXISTS Double use of NOT EXISTS None of these EXISTS ANSWER DOWNLOAD EXAMIANS APP
Database Redesign The data model that is produced from reverse engineering is: None of these a logical model. a conceptual model. an internal model. None of these a logical model. a conceptual model. an internal model. ANSWER DOWNLOAD EXAMIANS APP
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 MODIFY TABLE TableName DROP COLUMN ColumnName ALTER TABLE TableName DROP ColumnName ALTER TABLE TableName DROP COLUMN ColumnName MODIFY TABLE TableName DROP ColumnName MODIFY TABLE TableName DROP COLUMN ColumnName ALTER TABLE TableName DROP ColumnName ANSWER DOWNLOAD EXAMIANS APP