SQL for Database Construction The SQL ALTER statement can be used to: change the table data. delete rows from the table. add rows to the table. change the table structure. change the table data. delete rows from the table. add rows to the table. change the table structure. ANSWER DOWNLOAD EXAMIANS APP
SQL for Database Construction The SQL CHECK constraint is fully defined by the SQL-92 standard, and is consistently implemented by all DBMS vendors. True False True False ANSWER DOWNLOAD EXAMIANS APP
SQL for Database Construction The SQL command to create a table is: CREATE TABLE DEFINE TABLE MAKE TABLE ALTER TABLE CREATE TABLE DEFINE TABLE MAKE TABLE ALTER TABLE ANSWER DOWNLOAD EXAMIANS APP
SQL for Database Construction A benefit of using a stored procedure is that it can be distributed to client computers. False True False True 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 Which of the following is NOT a type of SQL constraint? FOREIGN KEY ALTERNATE KEY UNIQUE PRIMARY KEY FOREIGN KEY ALTERNATE KEY UNIQUE PRIMARY KEY ANSWER DOWNLOAD EXAMIANS APP