Oracle Upgrade to Oracle Database 12c - 1Z0-060 Free Exam Questions

A. The ORA_ARCHIVE_STATE column is visible if referenced in the select list of a query.

B. The ROW ARCHIVAL VISIBILITY session parameter defaults to active rows only.

C. The ORA_ARCHIVE_STATEcolumn is updated automatically by the Oracle Server based on activity tracking columns, to Indicate that a row is no longer considered active.

D. The ORA_ARCHIVE_STATE column is updated manually or by a program that could reference activity tracking columns, to indicate that a row is no longer considered active.

E. The ORA_ARCHIVE_STATE column visibility is controlled by the ROW ARCHIVAL VISIBILITY session parameter.

A. Only the ORD_CUSTOMER_IX2 index is created.

B. The optimizer evaluates index access from both the indexes before deciding on which index to use for a query execution plan.

C. Only the ORD_CUSTOMER_IX1 index is created.

D. Both the indexes are created: however, only ORD_CUSTOMER_IX2 index is visible.

E. Both the indexes are updated when a new row is inserted, updated, or deleted in the ORDERS table.

A. All users except sys and SCOTT

B. All users except sys, system, and SCOTT

C. All users except SYS

D. All users except SCOTT

A. 1, 3, 2, 5, 6, 4

B. 1, 3, 5, 2, 6, 4

C. 1, 3, 5, 6, 2, 4

D. 1, 3, 6, 2, 5, 4

E. 1, 3, 2, 5, 6, 4

A. ALTER DATABASE OPEN issued from that PDB

B. ALTER PLUGGABLE DATABASE PDB OPEN issued from another PDB

C. ALTER PLUGGABLE DATABASE OPEN ALL ISSUED from a PDB

D. ALTER PLUGGABLE DATABASE OPEN issued from that PDB

E. ALTER DATABASE PDB OPEN issued from the root

F. ALTER PLUGGABLE DATABASE PDB OPEN issued from the seed

G. ALTER PLUGGABLE DATABASE OPEN ALL ISSUED from the root

A. You must copy the VPD policies manually from the original table to the new table during online redefinition.

B. All the triggers for the table are disabled without changing any of the column names or column types in the table.

C. The primary key constraint on the EMPLOYEES table is disabled during redefinition.

D. VPD policies are copied from the original table to the new table during online redefinition.

A. Flashback logs are written sequentially, and are archived.

B. Flashback logs are used to restore to the blocks' before images, and then the redo data may be used to roll forward to the desired flashback time.

C. Flashback Database uses a restored control file to recover a database.

D. The Oracle database automatically creates, deletes, and resides flashback logs in the Fast Recovery Area.

E. Flashback Database can recover a database to the state that it was in before a reset logs operation.

F. Flashback Database can recover a data file that was dropped during the span of time of the flashback.

A. 1-d, 2-b, 3-a, and 4-c

B. 1-c, 2-d, 3-a, and 4-b

C. 1-c, 2-a, 3-b, and 4-d

D. 1-a, 2-b, 3-c, and 4-d

A. Compressed backups can be written to media only if using proxy copies.

B. File system compression should be enabled if compressed backups are being written to disk.

C. Media manager compression should not be enabled if compressed backups are being written to tape.

D. Compression creates some performance overhead during backups to tape.

E. Compression creates some performance overhead during backups to disk.

A. The export dump file must be created before starting the import on the target database.

B. The import operation must be performed by a user on the target database with the DATAPUMP_IMP_FULL_DATABASE role, and the database link must connect to a user on the source database with the DATAPUMP_EXD_FULL_DATABASE role.

C. The source and target database must be running on the same platform with the same endianness.

D. The impdp operation must be performed by the same user that performed the expdp operation.

E. All the user-defined tablespaces must be in read-only mode on the source database.

F. The path of data files on the target database must be the same as that on the source database.

A. No more data files can be added to the tablespace.

B. The MRKT tablespace is created as a small file tablespace, because the file size is less than the minimum required for big file files.

C. The relative file number of the tablespace is not stored in rowids for the table rows that are stored in the MRKT tablespace.

D. Users who were using the old default tablespace will have their default tablespaces changed to the MRKT tablespace.

E. The MRKT tablespace may be dropped if it has no contents.

A. Data pump import requires an import file to be in a directory owned by the oracle owner.

B. You can detach from a data pump import job and reattach later.

C. You can detach from a Data Pump export job and reattach later.

D. Data Pump uses parallel execution server processes to implement parallel import.

E. Data Pump always automatically uses the direct path method for loading and unloading all types of data.

A. Rebuilding an index using ALTER INDEX . . . REBUILD fails with an ORA-01578: ORACLE data block corrupted (file # 14, block # 50) error.

B. Creating a table returns ORA-00955: name us already in used by an existing objects.

C. Inserting a value into a table returns ORA-00001: unique constraint (SYS.OK_TECHP) violated.

D. Inserting a value into a table returns ORA-01722: invalid number.

E. Running a query on a table returns ORA-600: Internal Error.