SQL for Database Construction Which of the following is NOT a type of SQL constraint? UNIQUE PRIMARY KEY FOREIGN KEY ALTERNATE KEY UNIQUE PRIMARY KEY FOREIGN KEY ALTERNATE KEY 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 What is not an advantage of stored procedures? Code sharing SQL can be optimized Increased network traffic Greater security Code sharing SQL can be optimized Increased network traffic Greater security ANSWER DOWNLOAD EXAMIANS APP
SQL for Database Construction Views can be used to show the results of computed columns. False True False True ANSWER DOWNLOAD EXAMIANS APP
SQL for Database Construction What is an SQL virtual table that is constructed from other tables? Query results Just another table A view A relation Query results Just another table A view A relation ANSWER DOWNLOAD EXAMIANS APP
SQL for Database Construction Views constructed from SQL SELECT statements that conform to the SQL-92 standard may not contain: ORDER BY WHERE FROM GROUP BY ORDER BY WHERE FROM GROUP BY ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS