SQL for Database Construction The SQL command to create a table is: MAKE TABLE DEFINE TABLE CREATE TABLE ALTER TABLE MAKE TABLE DEFINE TABLE CREATE TABLE ALTER TABLE ANSWER DOWNLOAD EXAMIANS APP
SQL for Database Construction What is not an advantage of stored procedures? SQL can be optimized Greater security Increased network traffic Code sharing SQL can be optimized Greater security Increased network traffic Code sharing ANSWER DOWNLOAD EXAMIANS APP
SQL for Database Construction Which is NOT one of the most common types of SQL CHECK constraints? Range checks Lists of values System date Comparing one column value to another within the same table Range checks Lists of values System date Comparing one column value to another within the same table ANSWER DOWNLOAD EXAMIANS APP
SQL for Database Construction The SQL MAKE TABLE command is used to construct tables, define columns, define column constraints and create relationships. True False True False ANSWER DOWNLOAD EXAMIANS APP
SQL for Database Construction The SQL statement to create a view is: CREATE VIEW INSERT VIEW SELECT VIEW MAKE VIEW CREATE VIEW INSERT VIEW SELECT VIEW MAKE VIEW ANSWER DOWNLOAD EXAMIANS APP
SQL for Database Construction Which of the following is NOT a type of SQL constraint? ALTERNATE KEY UNIQUE PRIMARY KEY FOREIGN KEY ALTERNATE KEY UNIQUE PRIMARY KEY FOREIGN KEY ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS