SQL for Database Construction The SQL MAKE TABLE command is used to construct tables, define columns, define column constraints and create relationships. True False True False ANSWER DOWNLOAD EXAMIANS APP
SQL for Database Construction Which is NOT one of the most common types of SQL CHECK constraints? Comparing one column value to another within the same table Lists of values Range checks System date Comparing one column value to another within the same table Lists of values Range checks System date ANSWER DOWNLOAD EXAMIANS APP
SQL for Database Construction What SQL structure is used to limit column values of a table? The VALUE constraint The LIMIT constraint The CHECK constraint None of these The VALUE constraint The LIMIT constraint The CHECK constraint None of these ANSWER DOWNLOAD EXAMIANS APP
SQL for Database Construction What is an advantage of placing computations in SQL views? To save users from having to write an expression. To accomplish both of the above. None of these To ensure that the results are consistent. To save users from having to write an expression. To accomplish both of the above. None of these To ensure that the results are consistent. ANSWER DOWNLOAD EXAMIANS APP
SQL for Database Construction For what purposes are views used? To hide rows only To hide columns only All of these To hide complicated SQL statements only To hide rows only To hide columns only All of these To hide complicated SQL statements only ANSWER DOWNLOAD EXAMIANS APP
SQL for Database Construction A reason for using an SQL view to hide columns is: to accomplish both of the above. to simplify a result only. to prevent the display of sensitive data only. None of these to accomplish both of the above. to simplify a result only. to prevent the display of sensitive data only. None of these ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS