Introduction to SQL The wildcard asterisk (*) is the SQL-92 standard for indicating "any sequence of characters." True False True False ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Which SQL keyword is used to sort the result-set? ORDER BY SORT BY SORT ORDER ORDER BY SORT BY SORT ORDER 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 5 9 10 0 5 9 10 ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL The SQL statementSELECT SUBSTR('123456789', INSTR('abcabcabc', 'b'), 4) FROM DUAL; 456789 1234 2345 6789 456789 1234 2345 6789 ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL The result of a SQL SELECT statement is a(n) ________ . report table form file report table form file ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Which is the subset of SQL commands used to manipulate Oracle Database structures, including tables? Data Definition Language(DDL) Data Manipulation Language(DML) Both of above None Data Definition Language(DDL) Data Manipulation Language(DML) Both of above None ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS