Oracle 1Z0-083 Online Practice Questions and Exam Preparation

Oracle 1Z0-083 Online Questions & Answers

• Question 91:

  Your container database, CDB1, is in local undo mode.

  You successfully execute this command while connected to CDB1:

  CREATE PLUGGABLE DATABASE pdb1

  ADMIN USER pdb1_admin IDENTIFIED BY pdb123 ROLES=(CONNECT) CREATE_FILE_DEST='/u01/app/oracle/oradata/cdb1/pdb1';

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

  A. Service PDB1 is created for remote logins to PDB1.
  B. It is in mount state after creation.
  C. It has no local users.
  D. It has the same number of roles as CDB1.
  E. It has the same common users defined as does CDB1.
  F. It has only local roles.
  A. Service PDB1 is created for remote logins to PDB1.
  B. It is in mount state after creation.
  D. It has the same number of roles as CDB1.

  ---

  Explanation/Reference:

• Question 92:

  Which two are true about creating RMAN backups for an Oracle container database? (Choose two.)

  A. Online Redo Log backups can be created while connected to the root container.
  B. Control file backups can be created while connected to the root container.
  C. The BACKUP TABLESPACE command can back up a PDB tablespace even if RMAN is connected to CDB$ROOT.
  D. Archived Redo Log backups can be created while connected to an application root CDB.
  E. Control file backups can be created while connected to a nonroot container.
  B. Control file backups can be created while connected to the root container.
  E. Control file backups can be created while connected to a nonroot container.

  ---

  Explanation/Reference:

  E is correct

  tested: backup pluggable database "cdb$root". the quotes due to the $ symbol. it backups only the root container files (no pdb datafiles).

  tested CD: both incorrect Tested b: correct A is not correct due to the "must". you can connect to cdb and distinguish between tbs with same name in different pdbs with qualifying

  RMAN> BACKUP TABLESPACE pdb1:system, pdb1:sysaux, pdb1:users, pdb2:system;

  Reference: https://docs.oracle.com/en/database/oracle/oracle-database/19/bradv/backing-up-database.html#GUID-655DC5F5-FF8D-4A73-B67D-F5AAE20CA382

• Question 93:

  Which two are true about RMAN Multisection backups when a very large data file is divided into four sections? (Choose two.)

  A. Each of the file sections must be processed serially.
  B. The four sections can be created serially.
  C. The four sections must be image copies.
  D. The four sections can be created in parallel.
  E. The four sections must be contained in backup sets.
  B. The four sections can be created serially.
  D. The four sections can be created in parallel.

  ---

  Explanation/Reference:

  If you specify the SECTION SIZE parameter on the BACKUP command, then RMAN creates a backup set in which each backup piece contains the blocks from one file section. The option E mentions backup "sets" (more than one backup set), making the option wrong.

  Reference: https://docs.oracle.com/en/database/oracle/oracle-database/19/bradv/backing-up-database-advanced.html#GUID-F2D9FF2D-9E1C-4D38-AD8E-88B6B32F02B4

• Question 94:

  Which four are true about performance-related Oracle tools? Choose four

  A. The Automatic Database Diagnostic Monitor (ADDM) Compare Period report can compare two consecutive periods.
  B. SQL Performance Analyzer can suggest schema changes.
  C. SQL Performance Analyzer can identify regressed SQL statements.
  D. Database Replay always uses one replay client for all the original database sessions.
  E. Database Replay always uses one replay client for each original database session.
  F. The Automatic Database Diagnostic Monitor (ADDM) Compare Period report can compare two non -consecutive periods.
  G. The Active Session History (ASH) report is based on wait event samples.
  A. The Automatic Database Diagnostic Monitor (ADDM) Compare Period report can compare two consecutive periods.
  B. SQL Performance Analyzer can suggest schema changes.
  C. SQL Performance Analyzer can identify regressed SQL statements.
  F. The Automatic Database Diagnostic Monitor (ADDM) Compare Period report can compare two non -consecutive periods.

• Question 95:

  Which two statements are true when row archival management is enabled?

  A. The ORA_ARCHIVE_STATE column visibility is controlled by the ROW ARCHIVAL VISIBILITY session parameter.
  B. 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.
  C. The ROW ARCHIVAL VISIBILITY session parameter defaults to active rows only.
  D. The ORA_ARCHIVE_STATE column is visible if referenced in the select list of a query.
  E. The ORA_ARCHIVE_STATE column is updated automatically by the Oracle Server based on activity tracking columns, to Indicate that a row is no longer considered active. Correct
  C. The ROW ARCHIVAL VISIBILITY session parameter defaults to active rows only.
  D. The ORA_ARCHIVE_STATE column is visible if referenced in the select list of a query.

• Question 96:

  Which two statements are true about the Database Configuration Assistant (DBCA)?

  A. It can configure Automatic Storage Management (ASM) diskgroups.
  B. It can be used to copy an existing Oracle database to a new host and apply any patches necessary in the new host.
  C. It can be used to add a new tablespace.
  D. It can be used to create a database template from an existing database.
  E. It can generate SQL database creation scripts.
  D. It can be used to create a database template from an existing database.
  E. It can generate SQL database creation scripts.

• Question 97:

  SQL Performance Analyzer (SPA) has reported several regressed SQL statements for one of your databases.

  Which action could help in the performance management of these regressed SQL statements?

  A. Create SQL plan directives for each of the regressed statements.
  B. Use The SQL Tuning Advisor for each of the regressed statements.
  C. Create an adaptive execution plan for each of the regressed statements
  D. Use the SQL Access Advisor for each of the regressed statements.
  B. Use The SQL Tuning Advisor for each of the regressed statements.

• Question 98:

  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
  B. by using the RMAN duplicate command with nofilenamecheck to recover the database to the new host

• Question 99:

  You must transport the UNIVERSITY tablespace from one database to another.

  The UNIVERSITY tablespace is currently open read/write.

  The source and destination platforms have different endian formats.

  Examine this list of actions:

  1.

  Make the UNIVERSITY tablespace read-only on the source system.

  2.

  Export the UNIVERSITY tablespace metadata using EXPDP.

  3.

  Convert the UNIVERSITY tablespace data fies to the destination platform format using RMAN on the source system.

  4.

  Copy the UNIVERSITY tablespace data files to the destination system.

  5.

  Copy the Data Pump dump set to the destination system.

  6.

  Convert the UNIVERSITY tablespace data files to the destination platform format using RMAN on the destination system.

  7.

  Import the UNIVERSITY tablespace metadata using IMPDP.

  8.

  Make the UNIVERSITY tablespace read/write on the destination system.

  Which is the minimum number of actions required, in the correct order, to transport the UNIVERSITY tablespace?

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

  ---

  Explanation/Reference:

• Question 100:

  Which three are true about Oracle Restart? (Choose three).

  A. It can be configured to automatically attempt to restart various components after a hardware or software failure.
  B. While starting any components, it automatically attempts to start all dependencies first and in proper order.
  C. It runs from the Oracle Grid Infrastructure home.
  D. If you shut down a database instance with SQL*Plus, Oracle Restart interprets this as a database failure and attempts to restart the instance.
  E. The Server Control (SRVCTL) utility can be used to start and stop Oracle Restart.
  F. It runs periodic check operations to monitor the health of Oracle components.
  A. It can be configured to automatically attempt to restart various components after a hardware or software failure.
  B. While starting any components, it automatically attempts to start all dependencies first and in proper order.
  F. It runs periodic check operations to monitor the health of Oracle components.