Introduction to SQL Which SQL statement is used to delete data FROM a database? DELETE ALTER COLLAPSE REMOVE DELETE ALTER COLLAPSE REMOVE ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL The rows of the result relation produced by a SELECT statement can be sorted, but only by one column. False True False True ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Count function in SQL returns the number of distinct values. groups. values. columns. distinct values. groups. values. columns. ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL In SQL, which of the following is not a data definition language commands? RENAME REVOKE GRANT UPDATE RENAME REVOKE GRANT UPDATE ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Select the right statement to insert values to the student table. INSERT VALUES ( INSERT INTO student VALUES ( INSERT student VALUES ( INSERT VALUES INTO student ( INSERT VALUES ( INSERT INTO student VALUES ( INSERT student VALUES ( INSERT VALUES INTO student ( ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL The command to remove rows from a table 'CUSTOMER' is: DROP FROM CUSTOMER ... UPDATE FROM CUSTOMER ... REMOVE FROM CUSTOMER ... DELETE FROM CUSTOMER WHERE ... DROP FROM CUSTOMER ... UPDATE FROM CUSTOMER ... REMOVE FROM CUSTOMER ... DELETE FROM CUSTOMER WHERE ... ANSWER DOWNLOAD EXAMIANS APP