Oracle 1Z0-083 Online Practice Questions and Exam Preparation

Oracle 1Z0-083 Online Questions & Answers

• Question 211:

  Oracle Managed Files (OMF) is enabled in a CDB and this command is successfully executed:

  

  Which three are true? (Choose three.)

  A. Application PDBs that are subsequently created in the APP1 application container will be cloned from APP1$SEED.
  B. An application seed PDB is created for APP1.
  C. An application root PDB is created for APP1.
  D. A default service is created for the application root APP1.
  E. Application PDBs that are subsequently created in the APP1 application container will be cloned from PDB$SEED.
  F. APP1 can never be unplugged.
  C. An application root PDB is created for APP1.
  D. A default service is created for the application root APP1.
  E. Application PDBs that are subsequently created in the APP1 application container will be cloned from PDB$SEED.

  ---

  Explanation/Reference:

  AB not APP1$SEED created because not uses AS SEED

  F is incorrect -> If not have any PDBs plug to the APP container, you can unplug an APP container.

• Question 212:

  Which two are true about the Automatic Database Diagnostic Monitor? (ADDM)? (Choose two.)

  A. When ADDM reports multiple findings, summing all their impacts can yield to more than 100% of DB time.
  B. It runs automatically after each AWR snapshot.
  C. By default it analyzes a period of time corresponding to the last 4 hours of activity.
  D. Results are written to the alert log.
  E. By default it analyzes a period of time corresponding to the last 24 hours of activity.
  A. When ADDM reports multiple findings, summing all their impacts can yield to more than 100% of DB time.
  B. It runs automatically after each AWR snapshot.

  ---

  Explanation/Reference:

• Question 213:

  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.
  B. Schema Only accounts can be granted administrator privileges.
  D. Privilege Analysis is included in Oracle Enterprise Edition and no longer requires Database Vault.
  F. Unified Auditing can be configured to audit only events that are issued directly by an audited user.

  ---

  Explanation/Reference:

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

• Question 214:

  Which two are true about the character sets used in an Oracle database? (Choose two.)

  A. Single-byte character sets provide better performance than multibyte character sets.
  B. Unicode enables information from any language to be stored using a single character set.
  C. Unicode is the only supported character set for Oracle databases created using Database Configuration Assistant (DBCA).
  D. Single-byte character sets always use 7-bit encoding schemes.
  E. Multibyte character sets allow more efficient space utilization than single byte character sets.
  F. Single-byte character sets always use 8-bit encoding schemes.
  A. Single-byte character sets provide better performance than multibyte character sets.
  B. Unicode enables information from any language to be stored using a single character set.

  ---

  Explanation/Reference:

  A > Single-byte character sets result in better performance than multibyte character sets, and they also are the most efficient in terms of space requirements.

  B> Unicode is a universal encoded character set that enables information from any language to be stored using a single character set.

  Reference:

  https://docs.oracle.com/database/121/NLSPG/ch2charset.htm#NLSPG166

  https://docs.oracle.com/cd/B19306_01/server.102/b14225/ch6unicode.htm#:~:text=Unicode%20is%20a%20universal%20encoded%20character%20set%20that,been%20adopted%20by%20many%20software%20and%20hardware%

  20vendors.

• Question 215:

  Which two are true about RMAN duplexed backup sets? (Choose two.)

  A. They can be written only to disk.
  B. They must be written to media.
  C. They can be created by using the RMAN CONFIGURE command to specify duplexing before taking a backup.
  D. They can be created only by using the COPIES option of a BACKUP command.
  E. They can be written to media.
  C. They can be created by using the RMAN CONFIGURE command to specify duplexing before taking a backup.
  E. They can be written to media.

  ---

  Explanation/Reference:

  CE - Correct

  A. They can be written only to disk. - not only

  B. They must be written to media. - not must

  C. They can be created by using the RMAN CONFIGURE command to specify duplexing before taking a backup. - true

  D. They can be created only by using the COPIES option of a BACKUP command. - not only

  E. They can be written to media. - true

• Question 216:

  You take regular backups of one of your production databases by using RMAN with a recovery catalog. You have added two new tablespaces to this database which must be included in future backups. Which process occurs which allows the new backups to contain the new datafiles?

  A. The target database control file is synchronized from the recovery catalog with a partial resync at the next backup.
  B. The recovery catalog is synchronized from the target database control file with a full resync at the next backup.
  C. The target database control file is synchronized from the recovery catalog with a full resync at the next backup.
  D. The recovery catalog is synchronized from the target database control file with a partial resync at the next backup.
  B. The recovery catalog is synchronized from the target database control file with a full resync at the next backup.

  ---

  Explanation/Reference:

  Target database control file is always up-to-date. RMAN stores the information of the backup in the target database control file, and then it is pushed into the catalog once it is in place. Adding a tablespace or adding a new datafile to a tablespace. For any action like this, the --full resynchronization-- is initiated by RMAN.

• Question 217:

  How do you configure a CDB for local undo mode?

  A. Open the CDB instance in upgrade mode. In CDB$ROOT, execute ALTER DATABASE LOCAL UNDO ON, and then restart the CDB instance.
  B. Open the CDB instance in restricted mode. In CDB$ROOT, execute ALTER DATABASE LOCAL UNDO ON, and create an UNDO tablespace in each PDB, then restart the CDB instance.
  C. Open the CDB instance in restricted mode. In CDB$ROOT, drop the UNDO tablespace. Execute ALTER DATABASE LOCAL UNDO ONin each PDB, and then restart the CDB instance.
  D. Open the CDB instance in read-only mode. In CDB$ROOT, execute ALTER DATABASE LOCAL UNDO ON, and then change the CDB to read/write mode.
  E. Open the CDB instance in upgrade mode. In each PDB, execute ALTER DATABASE LOCAL UNDO ON, create an UNDO tablespace, and then restart the CDB instance.
  A. Open the CDB instance in upgrade mode. In CDB$ROOT, execute ALTER DATABASE LOCAL UNDO ON, and then restart the CDB instance.

  ---

  Explanation/Reference:

  Tested couple of minutes ago in practice. It was not possible to change undo mode on the PDB level:

  SQL> alter database local undo OFF; alter database local undo OFF * ERROR at line 1: ORA-65040: operation not allowed from within a pluggable database

  Reference: https://docs.oracle.com/en/database/oracle/oracle-database/12.2/admin/administering-a-cdb-with-sql-plus.html#GUID-1AAB032F-D13A-4E06-A062-59E0487C2FC5

• Question 218:

  Which two are true about duplicating pluggable databases (PDBs) with RMAN? (Choose two.)

  A. Two or more PDBs can be duplicated with the same RMAN DUPLICATE command.
  B. All tablespaces belonging to a PDB must be duplicated when duplicating the PDB.
  C. The auxiliary instance is automatically created with ENABLE_PLUGGABLE_DATABASE = TRUE.
  D. A user with SYSDBA or SYSBACKUP must be logged in with RMAN to the PDB to duplicate it.
  E. CDB$ROOT and PDB$SEED are automatically duplicated.
  A. Two or more PDBs can be duplicated with the same RMAN DUPLICATE command.
  E. CDB$ROOT and PDB$SEED are automatically duplicated.

  ---

  Explanation/Reference:

  You can duplicate a single PDB, a set of PDBs, or a set of tablespaces within a PDB by using the DUPLICATE command.

  To duplicate PDBs, you must log in to the root of the CDB as a user with the SYSDBA or SYSBACKUP privilege. When duplicating a PDB to a new CDB, you must create the auxiliary instance as a CDB. To do so, start the auxiliary instance

  with the declaration enable_pluggable_database=TRUE in the initialization parameter file.

  When you duplicate one or more PDBs, RMAN also duplicates the root (CDB$ROOT) and the CDB seed (PDB$SEED). The resulting duplicate database is a fully functional CDB that contains the root, the CDB seed, and the duplicated PDBs.

  Reference: https://docs.oracle.com/database/121/BRADV/rcmdupdb.htm#BRADV430

• Question 219:

  Examine this configuration:

  1.

  CDB1 is an Oracle Database 12c Release 2 database containing pluggable databases PDB$SEED, PDB1, and PDB2.

  2.

  PDB$SEED is open READ ONLY

  3.

  PDB1 is open READ WRITE

  4.

  PDB2 is MOUNTED.

  5.

  ORACLE_HOME is /u01/app/oracle/product/18.1.0/dbhome_1.

  You execute these commands before upgrading the database to the current release:

  

  For which databases will fixup scripts be created?

  A. CDB1, PDB$SEED, PDB1, and PDB2
  B. PDB$SEED, PDB1, and PDB2 only
  C. CDB1 and PDB$SEED only
  D. CDB1, PDB1, and PDB2 only
  E. CDB1, PDB$SEED, and PDB1 only
  E. CDB1, PDB$SEED, and PDB1 only

  ---

  Explanation/Reference:

  For multitenant architecture (CDB and PDB) upgrades, open up all the PDBs that you want the tool to analyze before you run the tool.

• Question 220:

  You create a table with the PERIOD FOR clause to enable the use of the Temporal Validity feature of Oracle Database 12c. Examine the table definition:

  

  Which three statements are true concerning the use of the Valid Time Temporal feature for the EMPLOYEES table?

  A. The valid time columns employee_time_start and employee_time_end are automatically created.
  B. The same statement may filter on both transaction time and valid temp or altime by using the AS OF TIMESTAMP and PERIOD FOR clauses.
  C. The valid time columns are not populated by the Oracle Server automatically.
  D. The valid time columns are visible by default when the table is described.
  E. Setting the session valid time using DBMS_FLASHBACK_ARCHIVE.ENABLE_AT_VALID_TIME sets the visibility for data manipulation language (DML), data definition language (DDL), and queries performed by the session.
  A. The valid time columns employee_time_start and employee_time_end are automatically created.
  B. The same statement may filter on both transaction time and valid temp or altime by using the AS OF TIMESTAMP and PERIOD FOR clauses.
  E. Setting the session valid time using DBMS_FLASHBACK_ARCHIVE.ENABLE_AT_VALID_TIME sets the visibility for data manipulation language (DML), data definition language (DDL), and queries performed by the session.

  ---

  Explanation/Reference:

  A: To implement Temporal Validity(TV), 12c offers the option to have two date columns in that table which is having TV enabled using the new clause Period For in the Create Table for the newly created tables or in the Alter Table for the

  existing ones. The columns that are

  used can be defined while creating the table itself and will be used in the Period For clause or you can skip having them in the table's definition in the case of which, the Period For clause would be creating them internally.

  E: ENABLE_AT_VALID_TIME Procedure

  This procedure enables session level valid time flashback.