1z0-082 Oracle Database Administration I Practice Questions

They can be written by server processes

Trace files are written to the Fast Recovery Area (FRA)

They can be written by background processes

All trace files contain error information that require contacting Oracle Support

Trace file names are based on the database name concatenated with a sequential number

Add a data file to DATA

Drop other U1 objects in DATA

Increase UTs quota sufficiently in DATA

Set DEFERRED_SEGMENT_CREATION to TRUE

Grant UNLIMITED TABLESPACE to U1

Set AUTOEXTEND ON for data files in DATA

A TRUNCATE command issued in a session causes all rows in a GLOBAL TEMPORARY TABLE for the issuing session to be deleted.

GLOBAL TEMPORARY TABLE rows inserted by a session are available to a ny other session whose user has been granted select on the table.

GLOBAL TEMPORARY TABLE space allC. tion occurs at session start.

Any GLOBAL TEMPORARY TABLE rows existing at session termination will be deleted.

A GLOBAL TEMPORARY TABLE’S definition is available to multiple sessions.

A DELETE command on a GLOBAL TEMPORARY TABLE cannot be rolled back.

a full outer join returns matched and unmatched rows

An inner join returns matched rows

Outer joins can only be used between two tables per query

A full outer join must use Oracle syntax

Outer joins can be used when there are multiple join conditions on two tables

A left or right outer join returns only unmatched rows

Views can be updated without the need to re-grant privileges on the view

Tables in the defining query of a view must always exist in order to create the view

The WITH CHECK clause prevents certain rows from being displayed when querying the view

Data Manipulation Language (DML) can always be used on views

Inserting one or more rows using a view whose defining query contains a GROUP BY clause will cause an error

Deleting one or more rows using a view whose defining query contains a GROUP BY clause will cause an error

The WITH CHECK clause prevents certain rows from being updated or inserted

It must be smaller than the smallest BIGFILE tablespace

Free space is managed using freelists

Any data files added to the tablespace must have a size of 5 gigabytes

It uses the database default blocksize

It is a locally managed tablespace

Component: Database Buffer Cache. Cause: Insufficiently sized buffer cache leading to excessive physical I/O.

Component: Redo Log Buffer. Cause: The LGWR process is unable to write to redo logs quickly enough.

Component: Shared Pool. Cause: The application uses non-shareable SQL due to literals instead of bind variables, causing excessive hard parsing.

Component: Data Dictionary Cache. Cause: Frequent DDL operations are invalidating cached dictionary objects.

It is not possible to shrink either indexes or Index Organized Tables (IOTs)

It always eleminates all migrated ows if any exist in the table

To shrink a table it must have a PRIMARY KEY constraint

To shrink a table it must have a UNIQUE KEY constraint

To shrink a table it must have row movement enabled.

It must be in a tablespace that uses Automatic Segment Space Management (ASSM)

a primary key column referenced by another column as a foreign key can be dropped if using the CASCADE option.

An UNUSED column’s space is reclaimed automatically when the block containing that column is next queried.

An UNUSED column’s space is reclaimed automatically when the row containing that column is next queried.

Partition key columns cannot be dropped.

A DROP COLUMN command can be rolled back

a column that is set to UNUSED still counts towards the limit of 1000 columns per table

Revoke the CREATE SESSION privilege from other users

Revoke the CREATE SESSION privilege from user HR

Log in to the database instance

Grant the CREATE SESSION privilege with ADMIN OPTION to other users

Execute DDL statements in the HR schema

Execute DML statements in the HR schema