QUESTION: 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?

in the undo tablespace
in the SYSAUX tablespace
in the SGA
in the PGA
in the temporary tablespace

Answer(s): A

Reference:

https://docs.oracle.com/database/121/ADMIN/undo.htm#ADMIN11478 (16.7)

Show Answer Next Question

You have been tasked to create a table for a banking application.

One of the columns must meet three requirements:
1. Be stored in a format supporting date arithmetic without using conversion functions
2. Store a loan period of up to 10 years
3. Be used for calculating interest for the number of days the loan remains unpaid

Which data type should you use?

INTERVAL YEAR TO MONTH
INTERVAL DAY TO SECOND
TIMESTAMP WITH LOCAL TIMEZONE
TIMESTAMP
TIMESTAMP WITH TIMEZONE

Answer(s): B

Show Answer Next Question

QUESTION: 7

In the spfile of a single instance database, LOCAL_LISTENER is set to LISTENER_1.
The TNSNAMES.ORA file in $ORACLE_HOME/network/admin in the database home contains:

Which statement is true?

Dynamic service registration cannot be used for this database instance
The LREG process registers services dynamically with the LISTENER_1 listener
LISTENER_1 must also be defined in the LISTENER.ORA file to enable dynamic service registration
There are two listeners named LISTENER and LISTENER_1 running simultaneously using port 1521 on the same host as the database instances
The definition for LISTENER_1 requires a CONNECT_DATA section to enable dynamic service registration

Answer(s): C

Reference:

https://docs.oracle.com/database/121/NETAG/listenercfg.htm#NETAG292

Show Answer Next Question

QUESTION: 8

Which three statements are true concerning logical and physical database structures? (Choose three.)

All tablespaces may have one or more data files
The extents of a segment must always reside in the same datafile
A smallfile tablespace might be bigger than a bigfile tablespace
A segment can span multiple data files in some tablespaces
A segment’s blocks can be of different sizes
A segment might have only one extent
Segments can span multiple tablespaces

Answer(s): C,F,G

Show Answer Next Question

Free Oracle 1Z0-082 Exam Questions (page: 3)

QUESTION: 5

Reference:

QUESTION: 6

QUESTION: 7

Reference:

QUESTION: 8

1Z0-082 Exam Discussions & Posts