1z0-082 Oracle Database Administration I Practice Questions

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

Oracle Managed Files (OMF)

Online table segment shrink

Online index segment shrink

Automatic data file extension (AUTOEXTEND)

Capacity planning growth reports based on historical data in the Automatic workload Repository (AWR)

analysis of all privileges used by all users including administrative users in the database

analysis of all privileges used by all users but excluding administrative users in the database

analysis of privileges that a user has on their own schema objects that they did not use

analysis of privileges that a user has on their own schema objects that they did use

analysis of privileges granted directly to a role that are then used by a user who has been granted that role

analysis of privileges granted indirectly to a role that are then used by a user who has been granted that role