Tag Archives: Exam

Which three statements are true about time zones, date data types, and timestamp data types in an Oracle

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.)

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.)

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 »