Question No. 1

You execute this command:

Sufficient storage is available in filesystem /u01.

Which two statements are true about the BIG_TBS tablespace? (Choose two.)

AAUTOEXTEND is possible for the datafile

BIt must be bigger than the largest SMALLFILE tablespace

CAdditional data files may not be added

DIt will be a dictionary-managed tablespace by default

EIt will always have a 32K blocksize

Show Answer

Correct Answer: A, C

Question No. 2

Which statement is true about the INTERSECT operator used in compound queries?

AMultiple INTERSECT operators are not possible in the same SQL statement

BIt processes NULLs in the selected columns

CINTERSECT is of lower precedence than UNION or UNION ALL

DIt ignores NULLs

Show Answer

Correct Answer: B

Question No. 3

Which three statements are true about advanced connection options supported by Oracle Net for connection to Oracle Database instances? (Choose three.)

AConnect Time Failover requires the use of Transparent Application Failover (TAF)

BSource Routing requires the use of a name server

CSource Routing enables the use of Connection Manager (CMAN) which enables network traffic to be routed through a firewall

DLoad Balancing can balance the number of connections to dispatchers when using a Shared Server configuration

ELoad Balancing requires the use of a name server

FConnect Time Failover requires the connect string to have two or more listener addresses configured

Show Answer

Correct Answer: C, D, F

https://docs.oracle.com/en/database/oracle/oracle-database/12.2/rilin/shared-server-configuration-for-an-oracle-rac-database.html#GUID-2EFBA08D-FEEE-407F-BC42-E548DA946DF9

Question No. 4

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

ACURRENT_TIMESTAMP returns the same date and time as SYSDATE with additional details of fractional seconds

BSYSDATE can be queried only from the DUAL table

CCURRENT_DATE returns the current date and time as per the session time zone

DSYSDATE can be used in expressions only if the default date format is DD-MON-RR

ESYSDATE and CURRENT_DATE return the current date and time set for the operating system of the database server

FCURRENT_TIMESTAMP returns the same date as CURRENT_DATE

Show Answer

Correct Answer: C, F

https://www.w3resource.com/oracle/datetime-functions/oracle-current_timestamp-function.php

Question No. 5

A database is configured to use automatic undo management with temporary undo enabled.

An UPDATE is executed on a temporary table.

Where is the UNDO stored?

Ain the undo tablespace

Bin the SYSAUX tablespace

Cin the SGA

Din the PGA

Ein the temporary tablespace

Show Answer

Correct Answer: E

http://www.dba-oracle.com/t_temp_undo_enabled.htm

Free Oracle 1Z0-082 Exam Actual Questions

The questions for 1Z0-082 were last updated On Apr 30, 2024