Which two statements are true about the DUAL table? (Choose two.)

• A.It can display multiple rows and columns
• B.It consists of a single row and single column of VARCHAR2 data type
• C.It can display multiple rows but only a single column
• D.It can be used to display only constants or pseudo columns
• E.It can be accessed by any user who has the SELECT privilege in any schema
• F.It can be accessed only by the SYS user

Comment: *

Name: *

Email: *

Verification: *

Which two statements are true about trace files produced by the Oracle Database server?
(Choose two.)

• A.They can be written by server processes
• B.Trace files are written to the Fast Recovery Area (FRA)
• C.They can be written by background processes
• D.All trace files contain error information that require contacting Oracle Support
• E.Trace file names are based on the database name concatenated with a sequential number

Comment: *

Name: *

Email: *

Verification: *

Which two are true about conventional path SQL load? (Choose two.)

• A.It cannot load data into clustered tables.
• B.It locks objects being processed.
• C.It does not generate UNDO.
• D.It enforces referential integrity constraints.
• E.It always generates redo.

Comment: *

Name: *

Email: *

Verification: *

Which three statements are true about inner and outer joins? (Choose three.)

• A.A full outer join returns matched and unmatched rows
• B.An inner join returns matched rows
• C.Outer joins can only be used between two tables per query
• D.A full outer join must use Oracle syntax
• E.Outer joins can be used when there are multiple join conditions on two tables
• F.A left or right outer join returns only unmatched rows

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 SYSDATE - TO_DATE('01-JANUARY-2019') FROM DUAL;
• B.SELECT ROUND(SYSDATE - TO_DATE('01/JANUARY/2019')) FROM DUAL;
• C.SELECT ROUND(SYSDATE - '01-JAN-2019') FROM DUAL;
• D.SELECT TO_CHAR(SYSDATE,'DD-MON-YYYY') - '01-JAN-2019' FROM DUAL;
• E.SELECT TO_DATE(SYSDATE, 'DD/MONTH/YYYY') - '01/JANUARY/2019' FROM DUAL;

Comment: *

Name: *

Email: *

Verification: *