Introduction to SQL The SQL keyword(s) ________ is used with wildcards. IN and NOT IN LIKE only IN only NOT IN only IN and NOT IN LIKE only IN only NOT IN only 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 > ALL (SELECT SALARY FROM EMPLOYEE);prints 0 10 5 9 0 10 5 9 ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL SQL is: a data sublanguage. a DBMS. a programming language. an operating system. a data sublanguage. a DBMS. a programming language. an operating system. ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Which SQL keyword is used to sort the result-set? ORDER BY SORT SORT BY ORDER ORDER BY SORT SORT BY ORDER ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Which of the following command makes the updates performed by the transaction permanent in the database? COMMIT DELETE TRUNCATE ROLLBACK COMMIT DELETE TRUNCATE ROLLBACK ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL The SQL keyword BETWEEN is used: as a wildcard. for ranges. None of these to limit the columns displayed. as a wildcard. for ranges. None of these to limit the columns displayed. ANSWER DOWNLOAD EXAMIANS APP