SQL for Database Construction A updatable view has its own data. False True False True ANSWER DOWNLOAD EXAMIANS APP
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 reason for using an SQL view to hide columns is: to prevent the display of sensitive data only. to simplify a result only. to accomplish both of the above. None of these to prevent the display of sensitive data only. to simplify a result only. to accomplish both of the above. None of these ANSWER DOWNLOAD EXAMIANS APP
SQL for Database Construction If any required (NOT NULL) columns are missing from the view, the view cannot be used for inserting new data. False True False True ANSWER DOWNLOAD EXAMIANS APP
SQL for Database Construction A benefit of using a stored procedure is that it can be distributed to client computers. False True False True 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