SQL for Database Construction The SQL MAKE TABLE command is used to construct tables, define columns, define column constraints and create relationships. False True False True ANSWER DOWNLOAD EXAMIANS APP
SQL for Database Construction A view that contains a computed column can be easily updated. True False True False ANSWER DOWNLOAD EXAMIANS APP
SQL for Database Construction Which of the following is NOT a type of SQL constraint? ALTERNATE KEY UNIQUE FOREIGN KEY PRIMARY KEY ALTERNATE KEY UNIQUE FOREIGN KEY PRIMARY KEY ANSWER DOWNLOAD EXAMIANS APP
SQL for Database Construction What is not an advantage of stored procedures? Code sharing Greater security Increased network traffic SQL can be optimized Code sharing Greater security Increased network traffic SQL can be optimized ANSWER DOWNLOAD EXAMIANS APP
SQL for Database Construction The SQL DELETE statement is used to delete both the table structure and table data. True False True False ANSWER DOWNLOAD EXAMIANS APP
SQL for Database Construction SQL statements can be embedded in triggers, stored procedures, and program code. False True False True ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS