Introduction to SQL Which command undo all the updates performed by the SQL in the transaction? ROLLBACK COMMIT TRUNCATE DELETE ROLLBACK COMMIT TRUNCATE DELETE ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Which SQL keyword is used to retrieve a maximum value? UPPER TOP MOST MAX UPPER TOP MOST MAX 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 9 0 5 10 9 0 5 ANSWER DOWNLOAD EXAMIANS APP
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 The SQL statement: SELECT Name, COUNT(*) FROM NAME_TABLE; counts the number of name rows and displays this total in a table with a single row and a single column. True False True False ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL SQL provides five built-in functions: COUNT, SUM, AVG, MAX, MIN. True False True False ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS