Introduction to SQL In SQL, which of the following is not a data definition language commands? GRANT REVOKE UPDATE RENAME GRANT REVOKE UPDATE RENAME 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 TRUNCATE COMMIT DELETE ROLLBACK TRUNCATE COMMIT ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL The condition in a WHERE clause can refer to only one value. False True False True ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Which of the following SQL commands is used to retrieve data? SELECT INSERT JOIN DELETE SELECT INSERT JOIN DELETE ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Table Employee has 10 records. It has a non-NULL SALARY column which is also UNIQUE.The SQL statementSELECT COUNT(*) FROM Employee WHERE SALARY > ANY (SELECT SALARY FROM EMPLOYEE);prints 10 0 5 9 10 0 5 9 ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Count function in SQL returns the number of columns. distinct values. groups. values. columns. distinct values. groups. values. ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS