SQL for Database Construction The SQL command to create a table is: DEFINE TABLE CREATE TABLE MAKE TABLE ALTER TABLE DEFINE TABLE CREATE TABLE MAKE TABLE ALTER TABLE ANSWER DOWNLOAD EXAMIANS APP
SQL for Database Construction A reason for using an SQL view to hide columns is: to simplify a result only. to prevent the display of sensitive data only. None of these to accomplish both of the above. to simplify a result only. to prevent the display of sensitive data only. None of these to accomplish both of the above. ANSWER DOWNLOAD EXAMIANS APP
SQL for Database Construction When a foreign key column is created without a corresponding foreign key constraint, we have created a "casual relationship" between the two tables. False True False True ANSWER DOWNLOAD EXAMIANS APP
SQL for Database Construction For what purposes are views used? All of these To hide complicated SQL statements only To hide rows only To hide columns only All of these To hide complicated SQL statements only To hide rows only To hide columns only ANSWER DOWNLOAD EXAMIANS APP
SQL for Database Construction The SQL DELETE statement is used to delete both the table structure and table data. True False True False ANSWER DOWNLOAD EXAMIANS APP
SQL for Database Construction Which of the following is NOT a type of SQL constraint? PRIMARY KEY FOREIGN KEY UNIQUE ALTERNATE KEY PRIMARY KEY FOREIGN KEY UNIQUE ALTERNATE KEY ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS