Oracle 1Z0-083 Online Practice Questions and Exam Preparation

Oracle 1Z0-083 Online Questions & Answers

• Question 191:

  You are administering a multitenant container database (COB) that contains two pluggable databases (PDBs), pdb1 and pdb2.

  You are connected to pdb2 as a common user with DBA privileges.

  The statistics_level parameter is PDB modifiable. As the user sys, execute the following command on pdb2:

  SQL> ALTER SYSTEM SET STATISTICS_LEVEL=ALL SID='*' SCOPE=SPFILE;

  Which statement is true about the result of this command?

  A. The statistics_level parameter is set to all when any of the PDBs is reopened.
  B. The statistics_level parameter is set to all only for PDB2 when it is reopened.
  C. The statistics_level parameter is set to all when the root database is restarted.
  D. The statement is ignored because there is no SPFILE for a PDB.
  B. The statistics_level parameter is set to all only for PDB2 when it is reopened.

  ---

  Explanation/Reference:

• Question 192:

  Which two are true about Oracle Grid Infrastructure for a Standalone Server? (Choose two.)

  A. It supports volume management, file system, and automatic restart capabilities.
  B. It must be installed before the Oracle database software is installed.
  C. The CSS daemon runs from the Grid Infrastructure home.
  D. It can manage database resources on the server where it is installed or on a different server.
  E. It requires Oracle Automatic Storage Management (ASM) components to be installed separately.
  A. It supports volume management, file system, and automatic restart capabilities.
  C. The CSS daemon runs from the Grid Infrastructure home.
  E. It requires Oracle Automatic Storage Management (ASM) components to be installed separately.

  ---

  If you install Oracle Grid Infrastructure for a standalone server and then create your database, then the database is automatically added to the Oracle Restart configuration. Oracle Restart automatically restarts the database when required.

  If you install Oracle Grid Infrastructure for a standalone server on a host computer on which a database already exists, then you must manually add the database, the listener, the Oracle ASM instance, and other components to the Oracle

  Restart configuration before you are able to configure automatic database restarts.

• Question 193:

  Which three statements are true about Automatic Workload Repository (AWR)?

  A. All AWR tables belong to the SYSTEM schema.
  B. The AWR data is stored in memory and in the database.
  C. The snapshots collected by AWR are used by the self-tuning components in the database
  D. AWR computes time model statistics based on time usage for activities, which are displayed in the v$SYS time model and V$SESS_TIME_MODEL views.
  E. AWR contains system wide tracing and logging information.
  B. The AWR data is stored in memory and in the database.
  C. The snapshots collected by AWR are used by the self-tuning components in the database
  D. AWR computes time model statistics based on time usage for activities, which are displayed in the v$SYS time model and V$SESS_TIME_MODEL views.

  ---

  Explanation/Reference:

• Question 194:

  You take your database backups by using the RMAN media management interface (MMI). Which two are true about the use of the RMAN MMI? (Choose two.)

  A. You can use it to create image copies for entire file systems.
  B. You can use it to create image copies for database files.
  C. You can use it to create backup sets for database files.
  D. You can use it to create proxy copies for database files.
  E. You can use it to create proxy copies for entire file systems.
  B. You can use it to create image copies for database files.
  C. You can use it to create backup sets for database files.

  ---

  Explanation/Reference:

• Question 195:

  Which three are true about thresholds, metrics, and server-generated alerts? (Choose three.)

  A. All metrics are instance related.
  B. Cleared stateful alerts are displayed by querying DBA_ALERT_HISTORY.
  C. A space usage management alert is automatically cleared after the underlying problem is resolved.
  D. They are generated by SMON when a tablespace is 97% full.
  E. Metrics are statistical counts for a specific unit.
  F. STATISTICS_LEVEL must be set to ALL to generate alerts.
  B. Cleared stateful alerts are displayed by querying DBA_ALERT_HISTORY.
  C. A space usage management alert is automatically cleared after the underlying problem is resolved.
  E. Metrics are statistical counts for a specific unit.

  ---

  Explanation/Reference:

  A. False. Tablespace Space Usage metris is database related

  B. True. Stateful alerts appear in DBA_OUTSTANDING_ALERTS and, when cleared, go to DBA_ALERT_HISTORY

  C. True. Most alerts (such as "Out of space") are clared automatically when the cause of the problem disappears.

  D. False. They're generated by MMON

  E. True

  F. False. This parameter is not required to generate alerts

  Reference: Oracle Database 12c: Administration Wrokshop https://docs.oracle.com/cd/E11882_01/server.112/e41573/autostat.htm#PFGRF027 https://blogs.oracle.com/oem/how-to-clear-an-alert-v2

• Question 196:

  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.
  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.
  F. It can be used to apply interim patches to the Grid Infrastructure and Database Home combination.

• Question 197:

  In which two situations can you use threshold server-generated alerts to help diagnose and fix problems? (Choose two).

  A. when free space in a locally managed tablespace falls below a specified percentage
  B. when the number of logons per second exceeds a specific value
  C. when a database instance has been running for a period greater than a threshold value
  D. when the total number of locked user account exceeds a specific value
  E. when a database instance has been running for a period greater than a threshold value
  A. when free space in a locally managed tablespace falls below a specified percentage
  B. when the number of logons per second exceeds a specific value

• Question 198:

  Which two statements are true about RMAN duplexed backups?

  A. It is not supported for image copies.
  B. It is only supported for backups to tape via the media management interface.
  C. Duplex backups can be performed on either disk or media, but cannot be performed on media and disk simultaneously.
  D. Duplex backups can contain only data files and control files.
  E. For performing duplexed backups, the parallelism for the device must be set equal to the number copies.
  A. It is not supported for image copies.
  C. Duplex backups can be performed on either disk or media, but cannot be performed on media and disk simultaneously.

• Question 199:

  Which three are true about recovery operations done without using Recovery Manager (RMAN)? (Choose three.)

  A. A lost SPFILE can be recovered from memory using SQL*PLUS.
  B. A lost password file can be re-created with SQL*PLUS.
  C. A lost TEMPFILE must always be re-created manually.
  D. A lost password file can be manually re-created with the orapwd utility.
  E. A lost PFILE can be re-created alert.log using SQL*PLUS.
  F. A lost index tablespace can be re-created without performing any recovery.
  A. A lost SPFILE can be recovered from memory using SQL*PLUS.
  D. A lost password file can be manually re-created with the orapwd utility.
  F. A lost index tablespace can be re-created without performing any recovery.

  ---

  Explanation/Reference:

• Question 200:

  Which three methods can be used for heap table data migration after upgrading a database? (Choose three.)

  A. using Database Replay
  B. using SQL Developer
  C. using Oracle Data Pump
  D. using operating system file copy utilities
  E. using Database Upgrade Assistant
  F. using the CREATE TABLE AS SELECT SQL statement
  B. using SQL Developer
  C. using Oracle Data Pump
  F. using the CREATE TABLE AS SELECT SQL statement

  ---

  Explanation/Reference: