SQL for Database Construction Which of the following is NOT a type of SQL constraint? FOREIGN KEY UNIQUE ALTERNATE KEY PRIMARY KEY FOREIGN KEY UNIQUE ALTERNATE KEY PRIMARY KEY ANSWER DOWNLOAD EXAMIANS APP
SQL for Database Construction A updatable view has its own data. False True False True ANSWER DOWNLOAD EXAMIANS APP
SQL for Database Construction What is not an advantage of stored procedures? SQL can be optimized Increased network traffic Greater security Code sharing SQL can be optimized Increased network traffic Greater security Code sharing ANSWER DOWNLOAD EXAMIANS APP
SQL for Database Construction A ________ is a stored program that is attached to a table or a view. None of these trigger embedded SELECT statement pseudofile None of these trigger embedded SELECT statement pseudofile ANSWER DOWNLOAD EXAMIANS APP
SQL for Database Construction A trigger is a stored program that is attached to a database. False True False True ANSWER DOWNLOAD EXAMIANS APP
SQL for Database Construction The SQL DELETE statement is used to delete both the table structure and table data. False True False True ANSWER DOWNLOAD EXAMIANS APP