Oracle Oracle Certifications 1Z0-083 Questions & Answers

• Question 141:

  Unified auditing is enabled in your database. The HR_ADMIN and OE_ADMIN roles exist and are granted system privileges.

  You execute the command:

  SQL>CREATE AUDIT POLICY tab1e_aud PRIVILEGES CREATE ANY TABLE, DROP ANY TABLE ROLES hr_admin, oe_admin;

  Which statement is true?

  A. It succeeds and needs to be enabled to capture all SQL statements that require either the specified privileges or any privilege granted to the HR_ADMIN or OE_ADMIN role.

  B. It fails because the command does notspecify when the unified audit policy should be enforced.

  C. It succeeds and starts capturing only successful SQL statements for all users who have either the specified privileges or roles granted to them.

  D. It fails because system privileges cannot be granted with roles in the same audit policy.

  Correct Answer: A

  After you create the policy, you must enable it by using the AUDIT statement.

  AUDIT POLICY { policy_auditing } [WHENEVER [NOT] SUCCESSFUL];

• Question 142:

  Which two are true about backup encryption? (Choose two).

  A. The Transparent Data Encryption (TDE) keystore is backed up using RMAN.

  B. Vendor-specific media management software can be used for making encrypted RMAN backups to media.

  C. The BACKUP BACKUPSET command can encrypt and decrypt backup sets.

  D. Image copies can be encrypted.

  E. Keystore-based encryption is the default mode for RMAN backup encryption.

  F. Backup encryption can be enabled selectively for specific tablespaces.

  Correct Answer: CE

• Question 143:

  Which three are true about OPatch ? (Choose three).

  A. It requires installation of Oracle Universal Installer.

  B. A. It performs a shutdown and then a restart of all processes in both Oracle Grid Infrastructure and Oracle Database home during the patching process.

  C. It must be invoked as the user that owns the software being patched.

  D. It is a Java-based utility for applying patchsets.

  E. It is platform independent.

  F. It can be used to apply interim patches to the Grid Infrastructure and Database Home combination.

  Correct Answer: BCF

• Question 144:

  Which three RMAN persistent settings can be set explicitly? (Choose three)

  A. SPFILE backup duplexing

  B. control file auto backup formats

  C. archive log deletion policy

  D. image copy duplexing

  E. redo log backup duplexing

  F. archive log backup duplexing

  Correct Answer: BCF

• Question 145:

  Your production database is running in archivelog mode. You use RMAN with a recovery catalog to back up your database to media and the database is uniquely identified in the recovery catalog. You want to create a test database from the production database and allow the production database to remain open during the duplicate process. You restore the database backups to a new host with the same directory structure as the production database and want to use the recovery catalog for future backups after the database is successfully restored to the new host.

  How would you achieve this?

  A. by using the RMAN switch command to set the new location for the data files

  B. by using the RMAN duplicate command with nofilenamecheck to recover the database to the new host

  C. by using the RMAN duplicate command with dbid and set new name for tablespace to recover the database to the new host

  D. by creating a new database in the new host, and then using the RMAN recover command

  Correct Answer: B

• Question 146:

  Which three are true in Oracle 19c and later releases? (Choose three).

  A. If the password file location changes, then the new location is used automatically by the Oracle Server.

  B. Schema Only accounts can be granted administrator privileges.

  C. All the Oracle-supplied accounts are Schema Only accounts.

  D. Privilege Analysis is included in Oracle Enterprise Edition and no longer requires Database Vault.

  E. Unified Auditing can be configured to audit only events that are issued indirectly by an audited user.

  F. Unified Auditing can be configured to audit only events that are issued directly by an audited user.

  Correct Answer: BDF

  Reference: https://mandysandhu.com/2018/04/30/oracle-database-18c-schema-only-accounts/

• Question 147:

  You accidentally drop the CUSTOMERS table, and then recover it by using the FLASHBACK TABLE command. Which two statements are true about the dependent objects of the CUSTOMERS table?

  A. All the triggers associated with the table are flashed back but are disabled.

  B. Materialized views that use the CUSTOMERS table are flashed back.

  C. LOB segments associated with the CUSTOMERS table are flashed back.

  D. All the constraints defined on the table, except the referential integrity constraints, are flashed back.

  E. Only the primary key constraint created for the table is flashed back, whereas all other indexes must be retrieved separately.

  Correct Answer: CD

• Question 148:

  Which two statements are true about Resource Manager plans for individual pluggable databases (PDB plans) in a multitenant container database (CDB)?

  A. If no PDB plan is enabled for a pluggable database, then all sessions for that PDB are treated to an equal degree of the resource share of that PDB.

  B. In a PDB plan, subplans may be used with up to eight consumer groups.

  C. If a PDB plan is enabled for a pluggable database, then resources are allocated to consumer groups across all PDBs in the CDB.

  D. If no PDB plan is enabled for a pluggable database, then the PDB share in the CDB plan is dynamically calculated.

  E. If a PDB plan is enabled for a pluggable database, then resources are allocated to consumer groups based on the shares provided to the PDB in the CDB plan and the shares provided to the consumer groups in the PDB plan.

  Correct Answer: AE

• Question 149:

  You upgraded your database from pre-12c to a multitenant container database (CDB) containing pluggable databases (PDBs). Examine the query and its output:

  

  Which two tasks must you perform to add users with SYSBACKUP, SYSDG, and SYSKM privilege to the password file? (Choose two.)

  A. Assign the appropriate operating system groups to SYSBACKUP, SYSDG, SYSKM.

  B. Grant SYSBACKUP, SYSDG, and SYSKM privileges to the intended users.

  C. Re-create the password file with SYSBACKUP, SYSDG, and SYSKM privilege and the FORCE argument set to No.

  D. Re-create the password file with SYSBACKUP, SYSDG, and SYSKM privilege, and FORCE arguments set to Yes.

  E. Re-createthepasswordfileintheOracleDatabase12cformat. Correct

  Correct Answer: BD

  * orapwd

  / You can create a database password file using the password file creation utility, ORAPWD.

  The syntax of the ORAPWD command is as follows:

  orapwd FILE=filename [ENTRIES=numusers] [FORCE={y|n}] [ASM={y|n}]

  [DBUNIQUENAME=dbname] [FORMAT={12|legacy}] [SYSBACKUP={y|n}] [SYSDG={y|n}]

  [SYSKM={y|n}] [DELETE={y|n}] [INPUT_FILE=input-fname]

  force - whether to overwrite existing file (optional),

  * v$PWFILE_users

  / 12c: V$PWFILE_USERS lists all users in the password file, and indicates whether the user has been granted the SYSDBA, SYSOPER, SYSASM, SYSBACKUP, SYSDG, and SYSKM privileges.

  / 10c: sts users who have been granted SYSDBA and SYSOPER privileges as derived from the password file.

  ColumnDatatypeDescription USERNAMEVARCHAR2(30)The name of the user that is contained in the password file SYSDBAVARCHAR2(5)If TRUE, the user can connect with SYSDBA privileges SYSOPERVARCHAR2(5)If TRUE, the user can connect with SYSOPER privileges Incorrect: not E: The format of the v$PWFILE_users file is already in 12c format.

• Question 150:

  RMAN is connected to a target database instance and an auxilary instance. You execute 3625the command:

  

  RMAN> DUPLICATE TARGET DATABASE TO dupdb FROM ACTIVE DATABASE SECTION SIZE 1G; What is the outcome?

  A. RMAN uses the pull method to restore files using image copies

  B. RMAN uses the push method to transfer image copies

  C. RMAN uses the push method to transfer backup sets

  D. RMAN uses the pull method to restore files using backup sets

  Correct Answer: D

  When RMAN performs active database duplication using backup sets, a connection is established with the source database and the auxiliary database. The auxiliary database then connects to the source database through Oracle Net Services and retrieves the required database files from the source database. This method of active database duplication is also to as the pull-based method.

  Example: DUPLICATE TARGET DATABASE TO dupdb FROM ACTIVE DATABASE PASSWORD FILE SPFILE NOFILENAMECHECK; Incorrect Answers: A, B, C: When active database duplication is performed using image copies, after RMAN establishes a connection with the source database, the source database transfers the required database files to the auxiliary database. Using image copies may require additional resources on the source database. This method is referred to as the push-based method of active database duplication.

  References: https://docs.oracle.com/database/121/BRADV/rcmdupdb.htm