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 10 5 0 9 10 5 0 9 ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Which SQL keyword is used to retrieve a maximum value? TOP MAX UPPER MOST TOP MAX UPPER MOST ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL The keyword LIKE can be used in a WHERE clause to refer to a range of values. True False True False ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Which is the subset of SQL commands used to manipulate Oracle Database structures, including tables? Data Manipulation Language(DML) Both of above None Data Definition Language(DDL) Data Manipulation Language(DML) Both of above None Data Definition Language(DDL) ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Which SQL keyword is used to retrieve only unique values? DIFFERENT UNIQUE DISTINCT DISTINCTIVE DIFFERENT UNIQUE DISTINCT DISTINCTIVE ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL The SQL keyword BETWEEN is used: to limit the columns displayed. as a wildcard. None of these for ranges. to limit the columns displayed. as a wildcard. None of these for ranges. ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS