Introduction to SQL SQL data definition commands make up a(n) ________ . DML HTML DDL XML DML HTML DDL XML ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Which operator performs pattern matching? EXISTS operator None of these LIKE operator BETWEEN operator EXISTS operator None of these LIKE operator BETWEEN operator ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Which of the following is illegal? SELECT SYSDATE - (SYSDATE - 2) FROM DUAL; SELECT SYSDATE - SYSDATE FROM DUAL; SELECT SYSDATE - (SYSDATE + 2) FROM DUAL; None of these SELECT SYSDATE - (SYSDATE - 2) FROM DUAL; SELECT SYSDATE - SYSDATE FROM DUAL; SELECT SYSDATE - (SYSDATE + 2) FROM DUAL; None of these ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL The SQL keyword BETWEEN is used: as a wildcard. to limit the columns displayed. None of these for ranges. as a wildcard. to limit the columns displayed. None of these for ranges. ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL A subquery in an SQL SELECT statement is enclosed in: brackets -- [...]. parenthesis -- (...) . CAPITAL LETTERS. braces -- {...}. brackets -- [...]. parenthesis -- (...) . CAPITAL LETTERS. braces -- {...}. 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