1z0-082 Practice Test

Your database instance is started with a PFILE.
Examine these parameters:

You want to increase the size of the buffer cache.
Free memory is available to increase the size of the buffer cache.
You execute the command:
SQL> ALTER SYSTEM SET DB_CACHE_SIZE=1024M;
What is the outcome?

A.

The value is changed only in the PFILE and takes effect at the next instance startup

B.

The value is changed for the current instance and in the PFILE

C.

It fails because the SCOPE clause is missing

D.

Change is applied to the current instance, but does not persist after instance restart

Which three statements are true about time zones, date data types, and timestamp data types in an Oracle database? (Choose three.)

A.

The CURRENT_TIMESTAMP function returns data without time zone information

B.

A TIMESTAMP WITH LOCAL TIMEZONE data type column is stored in the database using the time zone of the session that inserted the row

C.

A TIMESTAMP data type column contains information about year, month, and day

D.

The DBTIMEZONE function can return an offset from Universal Coordinated Time
(UTC)

E.

The SESSIONTIMEZONE function can return an offset from Universal Coordinated Time (UTC)

In the SALES database, DEFERRED_SEGMENT_CREATION is TRUE.
Examine this command:
SQL> CREATE TABLE T1(c1 INT PRIMARY KEY, c2 CLOB);
Which segment or segments, if any, are created as a result of executing the command?

A.

T1, an index segment for the primary key, a LOB segment, and a lobindex segment

B.

no segments are created

C.

T1 only

D.

T1 and an index segment created for the primary key only

E.

T1, an index segment for the primary key, and a LOB segment only

Which three statements are true about the Oracle Data Dictionary? (Choose three.)

A.

Data dictionary views are created by joins of dictionary base tables and DBA-defined
tables

B.

The data dictionary is created and maintained by the database administrator

C.

Views with the same name but different prefixes, such as CDB, DBA, ALL and USER, reference the same base tables from the data dictionary

D.

Base tables can be queried directly

E.

It is owned by the SYSTEM user

F.

Usernames of all users including database administrators are stored in the data
dictionary

Which two statements are true regarding Oracle database space management within blocks managed by Automatic Segment Space Management (ASSM)? (Choose two.)

A.

PCTFREE defaults to 10% for all blocks in all segments for all compression methods

B.

ASSM assigns blocks to one of four fullness categories based on what percentage of
the block is allocated for rows

C.

Update operations always attempt to find blocks with free space appropriate to the length of the row being updated

D.

Insert operations always attempt to find blocks with free space appropriate to the length of the row being inserted

E.

A block will always be eligible for inserts if the row is short enough to fit into the block