Introduction to SQL SELECT DISTINCT is used if a user wishes to see duplicate columns in a query. True False True False ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Which of the following command makes the updates performed by the transaction permanent in the database? DELETE ROLLBACK COMMIT TRUNCATE DELETE ROLLBACK COMMIT TRUNCATE ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Find the temperature in increasing order of all cities SELECT city, temperature FROM weather ORDER BY temperature; SELECT city, temperature FROM weather; SELECT city, temperature FROM weather ORDER BY city; SELECT city FROM weather ORDER BY temperature; SELECT city, temperature FROM weather ORDER BY temperature; SELECT city, temperature FROM weather; SELECT city, temperature FROM weather ORDER BY city; SELECT city FROM weather ORDER BY temperature; ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Which of the following is a valid SQL type? All of these NUMERIC FLOAT CHARACTER All of these NUMERIC FLOAT CHARACTER ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL In SQL, which of the following is not a data definition language commands? UPDATE RENAME GRANT REVOKE UPDATE RENAME GRANT REVOKE 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 VALUES INTO student ( INSERT student VALUES ( INSERT VALUES ( INSERT INTO student VALUES ( INSERT VALUES INTO student ( INSERT student VALUES ( ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS