The orders table has a column ORDER_DATE of data type date.
The default display format for a date Is DD-MON-RR.
Which two where conditions demonstrate the correct usage of conversion functions?

• A.WHERE order_date > TO_DATE<ADD_MONTHS(SYSDATE, c) , 'MON DD YYYY')
• B.WHERE order date > TO DATE('JUL 10 2018', *MON DD YYYY')
• C.WHERE TO_CHAR(order_date, 'MON DD YYYY') = 'JAN 20 2019'
• D.WHERE order_date > TO_CHAR(ADD_MONTHS(SYSDATE, 6), 'MON DD YYYY')
• E.WHERE order_date IN (TO_DATE ('Oct 21 2018', 'Mon DD YYYY'), TC_CHAR('Nov 21 2018', 'Mon DD YYYY'))

Comment: *

Name: *

Email: *

Verification: *

Examine these commands:

Which two statements are true about the sqiidr execution?

• A.It overwrites the data for Alan and adds data for Curl and Bob
• B.It generates a log that contains control file entries, which can be used with normal SQL'Loader operations.
• C.It overwrites all data in emp with data from emp.dat.
• D.It generates a sqi script that it uses to load data from EMP.DAT TO EMP.
• E.It appends data from EMP.DAT TO EMP.

Comment: *

Name: *

Email: *

Verification: *

What is true about non-equijoin statement performance? (Choose two.)

• A.The BETWEEN condition always performs less well than using the >= and <= conditions
• B.The BETWEEN condition always performs better than using the >= and <= conditions
• C.The join syntax used makes no difference to performance
• D.Table aliases can improve performance
• E.The Oracle join syntax performs better than the SQL:1999 compliant ANSI join syntax

Comment: *

Name: *

Email: *

Verification: *

You need to calculate the number of days from 1st January 2019 until today.
Dates are stored in the default format of DD-MON-RR.
Which two queries give the required output? (Choose two.)

• A.SELECT ROUND(SYSDATE - '01-JAN-2019') FROM DUAL;
• B.SELECT ROUND(SYSDATE - TO_DATE('01/JANUARY/2019')) FROM DUAL;
• C.SELECT TO_CHAR(SYSDATE,'DD-MON-YYYY') - '01-JAN-2019' FROM DUAL;
• D.SELECT SYSDATE - TO_DATE('01-JANUARY-2019') FROM DUAL;
• E.SELECT TO_DATE(SYSDATE, 'DD/MONTH/YYYY') - '01/JANUARY/2019' FROM DUAL;

Comment: *

Name: *

Email: *

Verification: *

Which two statements are true about the PMON background process? (Choose two.)

• A.It registers database services with all local and remote listeners known to the database instance
• B.It frees resources held by abnormally terminated processes
• C.It records checkpoint information in the control file
• D.It frees unused temporary segments
• E.It kills sessions that exceed idle time

Comment: *

Name: *

Email: *

Verification: *