SQL for Database Construction The SQL MAKE TABLE command is used to construct tables, define columns, define column constraints and create relationships. False True False True ANSWER DOWNLOAD EXAMIANS APP
SQL for Database Construction Common types of SQL CHECK constraints include range checks and limiting columns values. False True False True 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 pseudofile trigger None of these stored procedure pseudofile trigger None of these ANSWER DOWNLOAD EXAMIANS APP
SQL for Database Construction What is not an advantage of stored procedures? Greater security SQL can be optimized Code sharing Increased network traffic Greater security SQL can be optimized Code sharing Increased network traffic ANSWER DOWNLOAD EXAMIANS APP
SQL for Database Construction A ________ is a stored program that is attached to a table or a view. pseudofile None of these embedded SELECT statement trigger pseudofile None of these embedded SELECT statement trigger 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 CHECK constraint The LIMIT constraint None of these The VALUE constraint The CHECK constraint The LIMIT constraint ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS