Introduction to SQL In SQL, which of the following is not a data definition language commands? REVOKE GRANT UPDATE RENAME REVOKE GRANT UPDATE RENAME ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL The result of a SQL SELECT statement is a ________ . file table report form file table report form ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL The HAVING clause does which of the following? Acts like a WHERE clause but is used for columns rather than groups. Acts like a WHERE clause but is used for rows rather than columns. Acts EXACTLY like a WHERE clause. Acts like a WHERE clause but is used for groups rather than rows. Acts like a WHERE clause but is used for columns rather than groups. Acts like a WHERE clause but is used for rows rather than columns. Acts EXACTLY like a WHERE clause. Acts like a WHERE clause but is used for groups rather than rows. ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Which of the following is valid SQL for an Index? CREATE INDEX ID; REMOVE INDEX ID; ADD INDEX ID; CHANGE INDEX ID; CREATE INDEX ID; REMOVE INDEX ID; ADD INDEX ID; CHANGE INDEX ID; ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Which of the following command makes the updates performed by the transaction permanent in the database? COMMIT TRUNCATE ROLLBACK DELETE COMMIT TRUNCATE ROLLBACK DELETE ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Which of the following SQL commands can be used to add data to a database table? UPDATE APPEND INSERT ADD UPDATE APPEND INSERT ADD ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS