Which two statements are true about date/time functions in a session where NLS_DATE_FORMAT is set to DD-MON-YYYY HH24:MI:SS? (Choose two.) A. CURRENT_TIMESTAMP returns the same date and time as SYSDATE with additional details of fractional seconds B. SYSDATE can be queried only from the DUAL table C. CURRENT_DATE returns the current date and time as per the session… Read More »
Which two statements are true about UNDO and REDO? (Choose two.) A. DML modifies Oracle database objects and only generates REDO B. The generation of REDO generates UNDO C. The generation of UNDO generates REDO D. DML modifies Oracle database objects and only generates UNDO Correct Answer: B,C
Which three statements are true about time zones, date data types, and timestamp data types in an Oracle database? (Choose three.) A. The DBTIMEZONE function can return an offset from Universal Coordinated Time (UTC) B. The SESSIONTIMEZONE function can return an offset from Universal Coordinated Time (UTC) C. A TIMESTAMP data type column contains information about year, month,… Read More »
Which two are true about a SQL statement using SET operators such as UNION? (Choose two.) A. The number, but not names, of columns must be identical for all SELECT statements in the query. B. The data type of each column returned by the second query must exactly match the data type of the corresponding column returned by… Read More »
Which three statements are true about external tables in Oracle 18c and later releases? (Choose three.) A. They cannot be partitioned B. The ORACLE_DATAPUMP access driver can be used to unload data from a database into an external table C. The ORACLE_DATAPUMP access driver can be used to load data into a database from an external table D.… Read More »
Which three statements are true about external tables in Oracle 18c and later releases? (Choose three.) A. External table files can be used for other external tables in a different database B. The ORACLE_LOADER access driver can be used to unload data from a database into an external table C. The ORACLE_DATAPUMP access driver can be used to… Read More »
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… Read More »
Given:Which statement is true? A. Only s is accessible by obj. B. p, r, and s are accessible by obj. C. Both p and s are accessible by obj. D. Both r and s are accessible by obj. Correct Answer: D
Which three statements are true about the Oracle join and ANSI join syntax? (Choose three.) A. The Oracle join syntax supports creation of a Cartesian product of two tables B. The Oracle join syntax performs better than the SQL:1999 compliant ANSI join syntax C. The SQL:1999 compliant ANSI join syntax supports natural joins D. The SQL:1999 compliant ANSI… Read More »
Which two statements are true about the ORDER BY clause when used with a SQL statement containing a SET operator such as UNION? (Choose two.) A. The first column in the first SELECT of the compound query with the UNION operator is used by default to sort output in the absence of an ORDER BY clause B. Only… Read More »