Oracle Certification Exam Question: Download Oracle Certification PDF

You need to calculate the number of days from 1st Jan 2007 till date:
Dates are stored in the default format of dd-mm-rr.
Which two SQL statements would give the required output? (Choose two.)
A. SELECT SYSDATE - 01-JAN-2007 FROM DUAL
B. SELECT SYSDATE - TO_DATE(01/JANUARY/2007) FROM DUAL;
C. SELECT SYSDATE - TO_DATE(01-JANUARY-2007) FROM DUAL;
D. SELECT TO_CHAR(SYSDATE,DD-MON-YYYY)-01-JAN-2007 FROM DUAL;
E. SELECT TO_DATE(SYSDATE,DD/MONTH/YYYY)-01/JANUARY/2007 FROM DUAL;

Answer:

B. SELECT SYSDATE - TO_DATE('01/JANUARY/2007') FROM DUAL;
C. SELECT SYSDATE - TO_DATE('01-JANUARY-2007) FROM DUAL;

Download Oracle Certification PDF Read All 25 Oracle Certification Questions

Previous Question

Next Question

Suppose you need to generate a list of all customer last names with their credit limits from the
CUSTOMERS table. Those customers who do not have a credit limit should appear last in the list.
Which two queries would achieve the required result? (Choose two.)
A. SELECT cust_last_name,cust_credit_limit
FROM customers
ORDER BY cust_credit_limit DESC;
B. SELECT cust_last_name,cust_credit_limit
FROM customers
ORDER BY cust_credit_limit;
C. SELECT cust_last_name,cust_credit_limit
FROM customers
ORDER BY cust_credit_limit NULLS LAST;
D. SELECT cust_last_name,cust_credit_limit
FROM customers
ORDER BY cust_last_name,cust_credit_limit NULLS LAST;

Which three statements are true regarding subqueries? (Choose three.)
A. Subqueries can contain GROUP BY and ORDER BY clauses
B. Main query and subquery can get data from different tables
C. Main query and subquery must get data from the same tables
D. Subqueries can contain ORDER BY but not the GROUP BY clause
E. Only one column or expression can be compared between the main query and subqeury
F. Multiple columns or expressions can be compared between the main query and subquery