Free Oracle 1z0-083 Exam Questions (page: 9)

Which two are true about OS groups and users for Oracle Grid Infrastructure and the Oracle Relational Database Management System (RDBMS)? (Choose two.)

  1. By default, members of the OSASM group can access Automatic Storage Management and RDBMS instances.
  2. The primary group for the Oracle Grid Infrastructure and Oracle Database owners must be the Oracle Inventory group.
  3. The Oracle Grid Infrastructure installation must be owned by the grid user.
  4. The Oracle Grid Infrastructure owner owns Oracle Restart and Oracle Automatic Storage Management binaries.
  5. The Oracle Grid Infrastructure owner must have OSOPER, OSBACKUPDBA, and OSKMDBA as secondary groups.
  6. The same OSDBA group must be used for Automatic Storage Management and the Oracle Database.

Answer(s): B,D



Which four are true about duplicating a database using Recovery Manager (RMAN)? (Choose four.)

  1. Duplication can be done by having the auxiliary database instance pull backup sets from the target database instance.
  2. A connection to an auxiliary instance is always required.
  3. A subset of the target database can be duplicated.
  4. A new DBID is always created for the duplicated database.
  5. A connection to the recovery catalog instance is always required.
  6. A backup of the target database is always required.
  7. Duplication can be done by having the target database instance push copies to the auxiliary database instance.
  8. A connection to the target database instance is always required.

Answer(s): A,B,C,G



Examine these RMAN commands:

RMAN> CONNECT TARGET "sbu@prod AS SYSBACKUP"; RMAN> CONNECT AUXILIARY "sbu@dup_db AS SYSBACKUP"; RMAN> DUPLICATE TARGET DATABASE TO dup_db FROM ACTIVE DATABASE PASSWORD FILE SECTION SIZE 400M;

Which two statements are true about the DUPLICATE command?

  1. It succeeds.
  2. It fails because no parallel channels are allocated for the auxiliary database.
  3. It fails because connection to the AUXILIARY instance must be as SYSDBA.
  4. Itsucceeds only if the target database is greater than 400M.
  5. No catalogued backup of the TARGET is used to duplicate the database.

Answer(s): A,E



Examine these RMAN commands:

RMAN> CONNECT TARGET "sbu@prod AS SYSBACKUP"; RMAN> CONNECT AUXILIARY "sbu@dup_db AS SYSBACKUP"; RMAN> DUPLICATE TARGET DATABASE TO dup_db FROM ACTIVE DATABASE PASSWORD FILE SECTION SIZE 400M;

Which two statements are true about the DUPLICATE command?

  1. It succeed
  2. It fails because no parallel channels are allocated for the auxiliary databa
  3. It fails because connection to the AUXILIARY instance must be as SYSD
  4. Itsucceeds only if the target database is greater than 40
  5. No catalogued backup of the TARGET is used to duplicate the databa

Answer(s): A,E






Post your Comments and Discuss Oracle 1z0-083 exam prep with other Community members:

1z0-083 Exam Discussions & Posts