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 trigger is a stored program that is attached to a database. True False True False ANSWER DOWNLOAD EXAMIANS APP
SQL for Database Construction Which of the following is NOT a type of SQL constraint? ALTERNATE KEY PRIMARY KEY UNIQUE FOREIGN KEY ALTERNATE KEY PRIMARY KEY UNIQUE FOREIGN KEY ANSWER DOWNLOAD EXAMIANS APP
SQL for Database Construction Views constructed from SQL SELECT statements that conform to the SQL-92 standard may not contain: FROM ORDER BY GROUP BY WHERE FROM ORDER BY GROUP BY WHERE ANSWER DOWNLOAD EXAMIANS APP
SQL for Database Construction What SQL structure is used to limit column values of a table? None of these The VALUE constraint The LIMIT constraint The CHECK constraint None of these The VALUE constraint The LIMIT constraint The CHECK constraint ANSWER DOWNLOAD EXAMIANS APP
SQL for Database Construction What is not an advantage of stored procedures? Code sharing Increased network traffic Greater security SQL can be optimized Code sharing Increased network traffic Greater security SQL can be optimized ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS