Oracle 1Z0-050 Online Practice Questions and Exam Preparation

Oracle 1Z0-050 Online Questions & Answers

• Question 101:

  Which two statements are true regarding the Automatic Diagnostic Repository (ADR) in Oracle Database 11g? (Choose two.)

  A. A single ADR can support multiple ADR homes for different database instances.
  B. The alert files are stored in XML file format in the TRACE directory of each ADR home.
  C. If the environmental variable ORACLE_BASE is set, then DIAGNOSTIC_DEST is set to $ORACLE_BASE.
  D. The BACKGROUND_DUMP_DEST initialization parameter overrides the DIAGNOSTIC_DEST initialization parameter for the location of the alert log file.
  A. A single ADR can support multiple ADR homes for different database instances.
  C. If the environmental variable ORACLE_BASE is set, then DIAGNOSTIC_DEST is set to $ORACLE_BASE.

• Question 102:

  You are working on the APPDB database as a DBA. The database has a default Flashback Data Archive DFLA1 created on it.

  You issued the following command to drop the Flashback Archive FLA1:

  DROP FLASHBACK ARCHIVE fla1;

  What is the effect of this command?

  A. The tablespace having Flashback Archive is dropped.
  B. The Flashback Archive FLA1 is dropped only if it is empty.
  C. The Flashback Data Archive and historical data are dropped.
  D. The Flashback Archive FLA1 is dropped after moving the existing data in it to the default Flashback Archive.
  D. The Flashback Archive FLA1 is dropped after moving the existing data in it to the default Flashback Archive.

• Question 103:

  You are managing an Oracle Database 11 g instance and an Oracle Database 10g instance on the same machine. Both instances use the ASM instance as storage. Which statements regarding the ASM disk group compatibility attributes are true in this scenario? (Choose all that apply.)

  A. ASM compatibility controls which features for the ASM will be enabled.
  B. RDBMS compatibility and the database version determines whether a database instance can mount the ASM disk group
  C. The RDBMS compatibility settings for a disk group control the format of data structures for ASM metadata on the disk.
  D. The database-compatibility version settings for each instance must be greater than or equal to the RDBMS compatibility of all ASM disk groups used by that database instances.
  A. ASM compatibility controls which features for the ASM will be enabled.
  B. RDBMS compatibility and the database version determines whether a database instance can mount the ASM disk group
  D. The database-compatibility version settings for each instance must be greater than or equal to the RDBMS compatibility of all ASM disk groups used by that database instances.

• Question 104:

  What are the advantages of variable extent size support for large ASM files? (Choose two.)

  A. It improves performance in the extended cluster configuration by reading from a local copy of an extent.
  B. It improves resync operations when the disk comes online after being taken offline for maintenance purposes.
  C. This feature enables faster file opens because of the reduction in the amount of memory that is required to store file extents.
  D. Fewer extent pointers are needed to describe the file and less memory is required to manage the extent maps in the shared pool.
  C. This feature enables faster file opens because of the reduction in the amount of memory that is required to store file extents.
  D. Fewer extent pointers are needed to describe the file and less memory is required to manage the extent maps in the shared pool.

• Question 105:

  You are working on a CATDB database that contains an Oracle Database version 11.1 catalog schema owned by the userRC011. The INST1 database contains an Oracle Database version 10.1 catalog schema owned by the user RCAT10.

  You want the RMAN to import metadata for database IDs 1423241 and 1423242, registered in RCAT10, into the recover catalog owned by RC011.

  You executed the following RMAN commands:

  RMAN> CONNECT CATALOG rco1 1/password@catdb

  RMAN> IMPORT CATALOG rcat1 0/oracle@inst1;

  What happens when you execute the above commands? (Choose all that apply.)

  A. They deregister all databases registered in the RCAT10 catalog.
  B. They import metadata for all registered databases in the RCAT10 database.
  C. They register all the RCATIO-catalog registered databases in the RC011 catalog.
  D. They overwrite all stored scripts in the RC011 catalog with the same name as that in the RCAT10 catalog.
  A. They deregister all databases registered in the RCAT10 catalog.
  B. They import metadata for all registered databases in the RCAT10 database.
  C. They register all the RCATIO-catalog registered databases in the RC011 catalog.

• Question 106:

  Which two statements about Oracle Direct Network File System (NFS) are true? (Choose two.)

  A. It bypasses the OS file system cache
  B. A separate NFS interface is required for use across Linux, UNIX, and Windows platforms.
  C. It uses the operating system kernel NFS layer for user tasks and network communication modules.
  D. File systems need not be mounted by the kernel NFS system when being served through Direct NFS.
  E. Oracle Disk Manager can manage NFS on its own, without using the operating system kernel NFS driver.
  A. It bypasses the OS file system cache
  D. File systems need not be mounted by the kernel NFS system when being served through Direct NFS.

• Question 107:

  Which statement describes the significance of the CHANGE FAILURE command in RMAN? (Choose all that apply.)

  A. It is used to explicitly close the open failures.
  B. It is used to execute the advised repair script.
  C. It is used to change failure priority only for the CRITICAL priority.
  D. It is used to change failure priority only for HIGH or LOW priorities.
  E. It is used to inform the database about the repair after the repair script executes.
  A. It is used to explicitly close the open failures.
  D. It is used to change failure priority only for HIGH or LOW priorities.

• Question 108:

  You plan to control the sessions performing a huge number of I/O operations. Your requirement is to kill the session when it exceeds a specified number of l/Os. Which statement describes a solution to the above?

  A. Set a threshold for the default system-defined moving window baseline.
  B. Add directives to the Automatic Database Diagnostic Monitor (ADDM).
  C. Modify the profile for the targeted users for which control needs to be imposed.
  D. Implement the database resource manager to add the SWITCH_IO_REQS and SWITCH_GROUP directives.
  D. Implement the database resource manager to add the SWITCH_IO_REQS and SWITCH_GROUP directives.

• Question 109:

  View the Exhibit exhibit1.

  

  In the CUSTOMERS_OBE table, when the value of CUST_STATE_PROVINCE is "CA", the value of COUNTRYJD is "US."

  View the Exhibit exhibit2 to examine the commands and query plans.

  The optimizer can sense 8 rows instead of 29 rows, which is the actual number of rows in the table. What can you do to make the optimizer detect the actual selectivity?

  A. Set the STATISTICS_LEVEL parameter to TYPICAL.
  B. Change the STALE_PERCENT value for the CUSTOMERS_OBE table.
  C. Set the OPTIMIZER_USE_PENDING_STATISTICS parameter to FALSE.
  D. Create extended statistics for the CUST_STATE_PROVINCE and CUSTOMERSJDBE columns.
  D. Create extended statistics for the CUST_STATE_PROVINCE and CUSTOMERSJDBE columns.

• Question 110:

  You are managing an Oracle Database 11g ASM instance with a disk group dg01 having three disks. One of the disks in the disk group becomes unavailable because of power failure. You issued the following command to change the

  DISK_REPAIR_TIME attribute from 3.6 hours to 5 hours:

  ALTER DISKGROUP dg01 SET ATTRIBUTE 'disk_repair_time' = '5h';

  To which disks in the disk group will the new value be applicable?

  A. all disks in the disk group
  B. all disks that are currently in OFFLINE mode
  C. all disks that are not currently in OFFLINE mode
  D. all disks in the disk group only if all of them are ONLINE
  C. all disks that are not currently in OFFLINE mode