SQL for Database Construction SQL views can be used to hide: columns and rows only. complicated SQL syntax only. None of these both of the above can be hidden by an SQL view. columns and rows only. complicated SQL syntax only. None of these both of the above can be hidden by an SQL view. ANSWER DOWNLOAD EXAMIANS APP
SQL for Database Construction Which of the following is NOT a type of SQL constraint? PRIMARY KEY ALTERNATE KEY UNIQUE FOREIGN KEY PRIMARY KEY ALTERNATE KEY UNIQUE FOREIGN KEY ANSWER DOWNLOAD EXAMIANS APP
SQL for Database Construction SQL has a JOIN ON syntax that can be used to create inner joins and outer joins. True False True False ANSWER DOWNLOAD EXAMIANS APP
SQL for Database Construction The SQL statement used to create a view is CREATE VIEW. 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
SQL for Database Construction A ________ is a program that performs some common action on database data and that is stored in the database. stored procedure trigger pseudofile None of these stored procedure trigger pseudofile None of these ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS