Free Oracle 1z0-497 Practice Exam with Questions & Answers | Set: 5

recompile it

rewrite its SQL queries

relink

rework the applications schema

nothing; it is transparent

It replaces the first four digits of the value from the SALARY column with the number 9.

It replaces the first digit of the value from the SALARY column with the number 4.

It replaces the first digit of the value from the COMMISSION_PCTcolumn with 9.

It replaces the first nine digits of the value from the COMMISSION_PCTcolumn with 1.

It uses the full data redaction method.

It uses the random redaction method.

A data file can span across tablespaces.

An extent contains one or more segments.

Tablespaces contain one or more data files.

Data objects are stored as segments in tablespaces.

Segments can span across data files within a tablespace.

Process Monitor Process (PMON)

Flashback Data Archive process (FBDA)

Space Management Coordinator process (SMCO)

Recoverer process (RECO)

Listener Registration process (LREG)

Checkpoint Process

The online redo log files and archived redo log files are required to accomplish a recovery.

The uncommitted transaction is committed at the next startup of the database instance.

The uncommitted transaction is rolled back automatically at the next opening of the database.

The DBA has to perform a recovery on the database to recover the uncommitted transaction.