Free Oracle 1z0-082 Practice Exam with Questions & Answers | Set: 2

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

Duplicates are eliminated automatically by the UNION ALL operator

The number of columns selected in each SELECT statement must be identical

The names of columns selected in each SELECT statement must be identical

The output is sorted by the UNION ALL operator

NULLS are not ignored during duplicate checking

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

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

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

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

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

It gives an error because the ALL keyword is not valid

It gives an error because the GROUP BY clause is not valid

It executes successfully but does not give the required result

It executes successfully and gives the required result

undo

index

stored procedures

sequences

tables

clusters

All roles granted to a user are set on by default when the user logs in,

Object privileges may not be granted to roles.

The SET ROLE statement can disable one or more roles for a session.

Roles must be password protected.

Roles may be granted to roles.

The SET ROLE statement can enable one or more roles for a session.

The control files are opened.

The consistency of the database is checked.

All required background processes are started.

SYS can access the database.

Memory is allocated for the SG1

You can no longer monitor it

You can reattach to it and monitor it

It is paused and can be resumed

It continues to run in the background

It terminates

COLUMN STORE COMPRESS FOR QUERY LOW

ROW STORE COMPRESS BASIC

COLUMN STORE COMPRESS FOR ARCHIVE LOW

COLUMN STORE COMPRESS FOR ARCHIVE HIGH

ROW STORE COMPRESS ADVANCED

Data block headers contain their own Data Block Address (DBA)

A table row piece can be chained across several database blocks

Multiple row pieces from the same row may be stored in different database blocks

Multiple row pieces from the same row may be stored in the same block

Data block free space is always contiguous in the middle of the block

Index block free space is always contiguous in the middle of the block