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 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 The SQL ALTER statement can be used to: change the table data. add rows to the table. delete rows from the table. change the table structure. change the table data. add rows to the table. delete rows from the table. change the table structure. ANSWER DOWNLOAD EXAMIANS APP
SQL for Database Construction To update an SQL view, the DBMS must be able to associate the column(s) to be updated with: None of these a particular row in a particular underlying table. a particular column in a particular underlying table. a particular column in a particular row. None of these a particular row in a particular underlying table. a particular column in a particular underlying table. a particular column in a particular row. ANSWER DOWNLOAD EXAMIANS APP
SQL for Database Construction The SQL statement to create a view is: SELECT VIEW MAKE VIEW INSERT VIEW CREATE VIEW SELECT VIEW MAKE VIEW INSERT VIEW CREATE VIEW ANSWER DOWNLOAD EXAMIANS APP
SQL for Database Construction What is not an advantage of stored procedures? Increased network traffic SQL can be optimized Code sharing Greater security Increased network traffic SQL can be optimized Code sharing Greater security ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS