SQL for Database Construction A reason for using an SQL view to hide columns is: to prevent the display of sensitive data only. to simplify a result only. None of these to accomplish both of the above. to prevent the display of sensitive data only. to simplify a result only. None of these to accomplish both of the above. 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. True False True False 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: a particular column in a particular underlying table. None of these a particular row in a particular underlying table. a particular column in a particular row. a particular column in a particular underlying table. None of these a particular row in a particular underlying table. a particular column in a particular row. ANSWER DOWNLOAD EXAMIANS APP
SQL for Database Construction SQL Server does not support the BEFORE trigger. True False True False ANSWER DOWNLOAD EXAMIANS APP
SQL for Database Construction The SQL CHECK constraint is fully defined by the SQL-92 standard, and is consistently implemented by all DBMS vendors. False True False True ANSWER DOWNLOAD EXAMIANS APP
SQL for Database Construction What is not an advantage of stored procedures? Code sharing Greater security SQL can be optimized Increased network traffic Code sharing Greater security SQL can be optimized Increased network traffic ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS