Oracle 1Z0-034 Online Practice Questions and Exam Preparation

Oracle 1Z0-034 Online Questions & Answers

• Question 101:

  Which three statements are true about windows?

  A. Only one window can be open at any given time
  B. Consumer groups are associated with windows
  C. Windows work with job classes to control resource allocation
  D. The database service name must be provided during windows creation
  E. Windows can automatically start job or change resource allocation among jobs for various time periods.
  A. Only one window can be open at any given time
  C. Windows work with job classes to control resource allocation
  E. Windows can automatically start job or change resource allocation among jobs for various time periods.

• Question 102:

  You are in the middle of a transaction updating a very important table. The machine on which a database was running reboots because of power outage. This caused a database instance failure. Which statement is true in this situation?

  A. The online redo log files and archived redo log files are required to accomplish the recovery
  B. The uncommitted transaction will be committed at the next startup of the database instance
  C. The uncommitted transaction is rolled back automatically at the next opening of the database
  D. The DBA has to perform the recovery on the database to recover the uncommitted transaction
  C. The uncommitted transaction is rolled back automatically at the next opening of the database

• Question 103:

  Which three elements can a job chain process involve? (Choose three)

  A. an event
  B. a schedule
  C. a program
  D. another chain
  E. a lightweight job
  B. a schedule
  D. another chain
  E. a lightweight job

• Question 104:

  Examine the following RMAN script:

  RMAN> run {

  debug on;

  allocate channel c1 type disk;

  backup datafile 5;

  }

  Which statement describes the purpose of the script?

  A. The data file is checked for physical corruption and backed up if found clean.
  B. The backup of data file 5 is performed and the interactive messages during the backup are suppressed.
  C. The existing backup for the data file is checked and the backup is performed if there are changes in the data file after the last backup.
  D. The backup of data file 5 is performed and all SQL statements that are executed during RMAN compilation and their results are displayed
  D. The backup of data file 5 is performed and all SQL statements that are executed during RMAN compilation and their results are displayed

• Question 105:

  You have enabled backup optimization for the RMAN environment. Identify two criteria on which RMAN will skip the file, if it has already been backed up.

  A. The data file backup is done with multiple channels
  B. The data files is in the read-write mode after being backed up in the read only mode
  C. The backup was taken after the data files was taken offline-normal or is in the read only mode
  D. The data file backup complies with the back retention policy and the backup duplexing feature
  C. The backup was taken after the data files was taken offline-normal or is in the read only mode
  D. The data file backup complies with the back retention policy and the backup duplexing feature

• 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.
  E. Oracle Disk Manager can manage NFS on its own, without using the operating system kernel NFS driver.

• Question 107:

  You configured the default backup device type as disk for RMAN backups. In your database, because of business requirements, you have to take a simultaneous duplicate backup of the data files when the RMAN BACKUP command is used. What must you set using the RMAN CONFIGURE command to achieve this?

  A. MAXSETSIZE TO 2;
  B. DEVICE TYPE DISK PARALLELISM 2;
  C. RETENTION POLICY TO REDUNDANCY 2;
  D. DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 2;
  D. DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 2;

• Question 108:

  Which two statements are true regarding an Automatic Storage Management (ASM) instance? (Choose two.)

  A. An ASM instance mounts an ASM control file
  B. An ASM instance uses the ASMB process for rebalancing of disks within a disk group
  C. Automatic Memory Management is enabled in an ASM instance even when the MEMORY_TARGET parameters not set explicitly
  D. An RDBMS instance gets connected to an ASM instance using ASMB as a foreground process when the database instance is started
  C. Automatic Memory Management is enabled in an ASM instance even when the MEMORY_TARGET parameters not set explicitly
  D. An RDBMS instance gets connected to an ASM instance using ASMB as a foreground process when the database instance is started

• Question 109:

  View the Exhibit and examine the steps that you executed to create a database resource plan. Subsequently, you execute the following procedure which results in an error: SQL> EXECUTE dbms_resources_manager.validate_pending_area ( );

  What could be the reason?

  

  A. The pending area is automatically submitted after the plan creation
  B. The procedure must be executed before creating the resources plan directive
  C. The SYS_GROUP resource consumer group is not included in the resource plan directive
  D. The OTHER_GROUPS resources consumer group is not included in the resource plan directive
  D. The OTHER_GROUPS resources consumer group is not included in the resource plan directive

• Question 110:

  For which two database objects can the VERSIONS clause of the Flashback Versions Query be used?

  A. fixed tables
  B. heap tables
  C. external tables
  D. temporary tables
  E. Index-Organized Tables (IOTs)
  F. views
  B. heap tables
  E. Index-Organized Tables (IOTs)