SQL for Database Construction The SQL statement used to create a view is CREATE VIEW. False True False True ANSWER DOWNLOAD EXAMIANS APP
SQL for Database Construction A trigger is a stored program that is attached to a database. 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 SQL views can be used to hide: None of these columns and rows only. both of the above can be hidden by an SQL view. complicated SQL syntax only. None of these columns and rows only. both of the above can be hidden by an SQL view. complicated SQL syntax only. ANSWER DOWNLOAD EXAMIANS APP
SQL for Database Construction When a foreign key column is created without a corresponding foreign key constraint, we have created a "casual relationship" between the two tables. False True False True ANSWER DOWNLOAD EXAMIANS APP
SQL for Database Construction What is not an advantage of stored procedures? Increased network traffic Greater security SQL can be optimized Code sharing Increased network traffic Greater security SQL can be optimized Code sharing ANSWER DOWNLOAD EXAMIANS APP