Free Oracle 1z0-034 Exam Dumps Questions & Answers

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

You need to configure fine-grained access control to external network resources from within your database. You create an access control list (ACL) using the DBMS_NETWORK_ACL_ADMIN package.
Which statement is true regarding the ACL created?

• A.  It is the list of the host names or the IP addresses stored in the data dictionary that can connect to yourdatabase through PL/SQL network utility packages such as UTL_TCP.
• B.  It is a list of remote database links stored in the XML file that are available to the users of the database.
• C.  It is a list of users and network privileges stored in the data dictionary according to which a group of userscan connect to one or more hosts.
• D.  It is a list of users and network privileges stored in the XML file according to which a group of users canconnect to one or more hosts.

View the Exhibit.

You must unload data from the ORDERS, ORDER_ITEMS, and products database tables to four files using the External Table Population method.
You execute the command shown on the exhibit, but only two files have been created.
Which parameter must be changed so that four files are created?

• A.  TYPE
• B.  ORGANIZATION EXTERNAL
• C.  PARALLEL
• D.  LOCATION
• E.  DEFAULT DIRECTORY

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 RDBMS instance gets connected to an ASM instance using ASMB as a foreground process when the database instance is started
• C.  An ASM instance uses the ASMB process for rebalancing of disks within a disk group
• D.  Automatic Memory Management is enabled in an ASM instance even when the MEMORY_TARGET parameters not set explicitly

In one of your online transaction processing (OLTP) applications, table keys are frequently updated and queries performed using many different operators.
In addition, reports are generated using complex joins with non-equality operators.
What table organization is the best for this workload?

• A.  global temporary table
• B.  object table
• C.  sorted hash clustered table
• D.  heap table
• E.  external table
• F.  hash clustered table