Oracle 1Z0-063 Online Practice Questions and Exam Preparation

Oracle 1Z0-063 Online Questions & Answers

• Question 141:

  Which three statements are true about compression of backup sets? (Choose three.)

  A. Compressed backups can only be written to media.
  B. Binary compression creates performance overhead during a backup operation.
  C. Unused blocks below the high-water mark are not backed up.
  D. Compressed backups cannot have section size defined during a backup operation
  E. It works only for locally managed tablespaces.
  B. Binary compression creates performance overhead during a backup operation.
  C. Unused blocks below the high-water mark are not backed up.
  E. It works only for locally managed tablespaces.

• Question 142:

  Examine the commands executed in the root container of your multitenant container database (CDB) that has multiple pluggable databases (PDBs):

  SQL> CREATE USER c##a_admin IDENTIFIED BY orcl123;

  SQL> CREATE ROLE c##role1 CONTAINER=ALL;

  SQL> GRANT CREATE VIEW TO C##roleI CONTAINER=ALL;

  SQL> GRANT c##role1 TO c##a_admin CONTAINER=ALL;

  SQL> REVOKE c##role1 FROM c##a_admin;

  What is the result of the revoke command?

  A. It executes successfully and the c##role1 role is revoked from the c##a_admin user only in the root container.
  B. It fails and reports an error because the container=all clause is not used.
  C. It executes successfully and the c##rocl1 role is revoked from the c##a_admin user in the root database and all the PDBs.
  D. It fails and reports an error because the container=current clause is not used.
  B. It fails and reports an error because the container=all clause is not used.

• Question 143:

  Which three RMAN persistent settings can be set for a database? (Choose three.)

  A. backup retention policy
  B. default backup device type
  C. default section size for backups
  D. default destinations for backups
  E. multiple backup device types for a single backup
  A. backup retention policy
  B. default backup device type
  D. default destinations for backups

• Question 144:

  Which two statements are true regarding the Oracle Data Pump export and import operations? (Choose two.)

  A. You cannot export data from a remote database.
  B. You can rename tables during import.
  C. You can overwrite existing dump files during export.
  D. You can compress data but not metadata during export.
  B. You can rename tables during import.
  C. You can overwrite existing dump files during export.

• Question 145:

  The CATDB12c database contains an Oracle Database version 12c catalog schema owned by the RC12C user.

  The RCAT11 database contains an Oracle Database version 11g catalog schema owned by the RC11 user in which several databases are registered. Both the databases are open.

  You execute the RMAN commands:

  

  Which two tasks are performed as part of the import? (Choose two.)

  A. All databases registered in the RC11 catalog are registered in the RC12C catalog.
  B. Databases from the RC12C catalog are implicitly unregistered if the RC11 catalog has registered databases with same name.
  C. Local and global stored scripts that have the same name as existing scripts in the RC12C catalog are automatically renamed.
  D. Imported databases are unregistered from the RC11 catalog.
  E. Recovery catalog is resynchronized with the control files of the registered databases.
  A. All databases registered in the RC11 catalog are registered in the RC12C catalog.
  D. Imported databases are unregistered from the RC11 catalog.

• Question 146:

  You execute the RMAN commands:

  RMAN> CONFIGURE DEFAULT DEVICE TYPE TO disk;

  RMAN> CONFIGURE DEVICE TYPE disk PARALLELISM 2;

  RMAN> CONFIGURE CHANNEL 1 DEVICE TYPE DISK FORMAT `/disk1/%U';

  RMAN> CONFIGURE CHANNEL 2 DEVICE TYPE DISK FORMAT `/disk2/%U';

  RMAN> BACKUP DATABASE;

  Which statement is true about the backup set created by the BACKUP command?

  A. The default channel is allocated and the backup set is created in only one destination.
  B. Two channels are allocated and a copy of the backup set is taken in the location specified by CHANNEL 2.
  C. Two channels are allocated and backup pieces for the backup set are created in both the specified destinations.
  D. Two channels are allocated and two copies of the backup set are taken in parallel in both locations.
  C. Two channels are allocated and backup pieces for the backup set are created in both the specified destinations.

• Question 147:

  Your database is running in archivelog mode and regular nightly backups are taken. Due to a media failure, the current online redo log group, which has one member, is lost and the instance is aborted. Examine the steps to recover the online redo log group and move it to a new location.

  1.

  Restore the corrupted redo log group.

  2.

  Restore the database from the most recent database backup.

  3.

  Perform an incomplete recovery.

  4.

  Relocate the member of the damaged online redo log group to a new location.

  5.

  Open the database with the resetlogs option.

  6.

  Issue a checkpoint and clear the log. Identify the required steps in the correct order.

  A. 1, 3, 4, 5
  B. 6, 3, 4, 5
  C. 2, 3, 4, 5
  D. 6, 4, 3, 5
  C. 2, 3, 4, 5

• Question 148:

  user_data is a non-encrypted tablespace containing tables with data.

  You must encrypt all data in this tablespace.

  Which three methods can do this? (Choose three.)

  A. Use Data Pump.
  B. Use ALTERTABLE. . .MOVE
  C. Use CREATE TABLE AS SELECT
  D. Use alter tablespace to encrypt the tablespace after enabling row movement on all its disk space
  E. Use altertablespace to encrypt the tablespace.
  A. Use Data Pump.
  B. Use ALTERTABLE. . .MOVE
  C. Use CREATE TABLE AS SELECT

• Question 149:

  Identify three benefits of unified auditing. (Choose three.)

  A. It helps to reduce disk space used to store an audit trail in a database.
  B. It guarantees zero-loss auditing.
  C. It reduces overhead on a database caused by auditing, by having a single audit trail.
  D. An audit trail cannot be modified because it is read-only.
  E. It automatically audits Recovery Manager (RMAN) events.
  C. It reduces overhead on a database caused by auditing, by having a single audit trail.
  D. An audit trail cannot be modified because it is read-only.
  E. It automatically audits Recovery Manager (RMAN) events.

• Question 150:

  After implementing full Oracle Data Redaction, you change the default value for the number data type as follows:

  SQL> SELECT NUMBER_VALUE FROM REDACTION_VALUES_FOR_TYPE_FULL; NUMBER_VALUE

  SQL> EXEC DBMS_REDACT.UPDATE_FULL_REDACTI0N_VALUES(-1)

  PL/SQL procedure successfully completed.

  SQL> select number_value from redaction_values_for_type_full;

  NUMBER VALUE

  After changing the value, you notice that FULL redaction continues to redact numeric data with a zero. What must you do to activate the new default value for numeric full redaction?

  A. Re-enable redaction policies that use FULL data redaction.
  B. Re-create redaction policies that use FULL data redaction.
  C. Re-connect the sessions that access objects with redaction policies defined on them.
  D. Flush the shared pool.
  E. Restart the database instance.
  E. Restart the database instance.