Introduction to SQL The command to eliminate a table from a database is: REMOVE TABLE CUSTOMER; DROP TABLE CUSTOMER; UPDATE TABLE CUSTOMER; DELETE TABLE CUSTOMER; REMOVE TABLE CUSTOMER; DROP TABLE CUSTOMER; UPDATE TABLE CUSTOMER; DELETE TABLE CUSTOMER; ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL The SQL keyword(s) ________ is used with wildcards. LIKE only NOT IN only IN only IN and NOT IN LIKE only NOT IN only IN only IN and NOT IN ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL To remove duplicate rows from the results of an SQL SELECT statement, the ________ qualifier specified must be included. SINGLE UNIQUE DISTINCT ONLY SINGLE UNIQUE DISTINCT ONLY ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL In SQL, which of the following is not a data definition language commands? RENAME GRANT UPDATE REVOKE RENAME GRANT UPDATE REVOKE 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 groups rather than rows. 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 columns rather than groups. Acts like a WHERE clause but is used for groups rather than rows. Acts like a WHERE clause but is used for rows rather than columns. Acts EXACTLY like a WHERE clause. ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Select the right statement to insert values to the student table. INSERT VALUES INTO student ( INSERT student VALUES ( INSERT INTO student VALUES ( INSERT VALUES ( INSERT VALUES INTO student ( INSERT student VALUES ( INSERT INTO student VALUES ( INSERT VALUES ( ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS