SQL for Database Construction Common types of SQL CHECK constraints include range checks and limiting columns values. False True False True ANSWER DOWNLOAD EXAMIANS APP
SQL for Database Construction SQL statements can be embedded in triggers, stored procedures, and program code. True False True False ANSWER DOWNLOAD EXAMIANS APP
SQL for Database Construction What is an advantage of placing computations in SQL views? To ensure that the results are consistent. To accomplish both of the above. None of these To save users from having to write an expression. To ensure that the results are consistent. To accomplish both of the above. None of these To save users from having to write an expression. ANSWER DOWNLOAD EXAMIANS APP
SQL for Database Construction For what purposes are views used? To hide complicated SQL statements only All of these To hide columns only To hide rows only To hide complicated SQL statements only All of these To hide columns only To hide rows only ANSWER DOWNLOAD EXAMIANS APP
SQL for Database Construction The SQL command to create a table is: MAKE TABLE DEFINE TABLE CREATE TABLE ALTER TABLE MAKE TABLE DEFINE TABLE CREATE TABLE ALTER TABLE ANSWER DOWNLOAD EXAMIANS APP
SQL for Database Construction A benefit of using a stored procedure is that it can be distributed to client computers. True False True False ANSWER DOWNLOAD EXAMIANS APP