• Which of the following is a valid SQL statement?
• SELECT SYSDATE;
• SELECT UPPER(Hello) FROM dual;
• SELECT TO_CHAR(SYSDATE, 'Month DD, YYYY')
• FROM dual;
• all of the above
• none of the above

 

• Which of the following functions can be used to extract a portion of a character string?
• EXTRACT
• TRUNC
• SUBSTR
• INITCAP

 

• Which of the following determines how long ago orders that haven’t shipped were received?
• SELECT order#, shipdate-orderdate delay FROM orders;
• SELECT order#, SYSDATE – orderdate FROM orders WHERE shipdate IS NULL;
• SELECT order#, NVL(shipdate, 0) FROM orders WHERE orderdate is NULL;
• SELECT order#, NULL(shipdate) FROM orders;

 

• Which of the following SQL statements produces “Hello World” as the output?
• SELECT "Hello World" FROM dual;
• SELECT INITCAP('HELLO WORLD') FROM dual;
• SELECT LOWER('HELLO WORLD') FROM dual;
• both a and b
• none of the above

 

• Which of the following functions can be used to substitute a value for a NULL value?
• NVL
• TRUNC
• NVL2
• SUBSTR
• both a and d
• both a and c

 

• Which of the following is not a valid format argument for displaying the current time?
• 'HH:MM:SS'
• 'HH24:SS'
• 'HH12:MI:SS'
• All of the above are valid.

 

• Which of the following lists only the last four digits of the contact person’s phone number at American Publishing?
• SELECT EXTRACT(phone, -4, 1) FROM publisher WHERE name ¼ 'AMERICAN PUBLISHING';
• SELECT SUBSTR(phone, -4, 1) FROM publisher WHERE name = 'AMERICAN PUBLISHING';
• SELECT EXTRACT(phone, -1, 4) FROM publisher WHERE name = 'AMERICAN PUBLISHING';
• SELECT SUBSTR(phone, -4, 4) FROM publisher WHERE name = 'AMERICAN PUBLISHING';

 

• Which of the following functions can be used to determine how many months a book has been available?
• MONTH
• MON
• MONTH_BETWEEN
• none of the above

 

•  Which of the following displays the order date for order 1000 as 03/31?
• SELECT TO_CHAR(orderdate, 'MM/DD') FROM orders WHERE order# = 1000;
• SELECT TO_CHAR(orderdate, 'Mth/DD') FROM orders WHERE order# = 1000;
• SELECT TO_CHAR(orderdate, 'MONTH/YY') FROM orders WHERE order# = 1000;
• both a and b
• none of the above

 

 

•  Which of the following functions can produce different results, depending on the value of a specified column?
• NVL
• DECODE
• UPPER

SUBSTR