Download Oracle.1z0-034.PrepAway.2018-11-28.87q.vcex

Download Exam

File Info

Exam Upgrade Oracle9i/10g OCA to Oracle Database 11g OCP
Number 1z0-034
File Name Oracle.1z0-034.PrepAway.2018-11-28.87q.vcex
Size 2 MB
Posted Nov 28, 2018
Download Oracle.1z0-034.PrepAway.2018-11-28.87q.vcex

How to open VCEX & EXAM Files?

Files with VCEX & EXAM extensions can be opened by ProfExam Simulator.

Download
ProfExam Simulator

Purchase

Coupon: MASTEREXAM
With discount: 20%





Demo Questions

Question 1

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? 


  1. It is a list of remote database links stored in the XML file that are available to the users of the database.
  2. 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.
  3. 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.
  4. 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.
Correct answer: B
Explanation:
The DBMS_NETWORK_ACL_ADMIN package provides the interface to administer the network Access ControlList (ACL). Refer to here for About Fin-Grained Access to External Network ServicesConfiguring fine-grained access control for users and roles that need to access external network services fromthe database. This way, specific groups of users can connect to one or more host computers, based onprivileges that you grant them. Typically, you use this feature to control access to applications that run onspecific host addresses. To configure fine-grained access control to external network services, you create an access control list (ACL),which is stored in Oracle XML DB. You can create the access control list by using Oracle XML DB itself, orby using the DBMS_NETWORK_ACL_ADMIN and DBMS_NETWORK_ACL_UTILITY PL/SQL packages. This guideexplains how to use these packages to create and manage the access control list. To create an access controllist by using Oracle XML DB and for general conceptual information about access control lists, see Oracle XMLDB Developer's Guide.
The DBMS_NETWORK_ACL_ADMIN package provides the interface to administer the network Access ControlList (ACL). 
Refer to here for About Fin-Grained Access to External Network ServicesConfiguring fine-grained access control for users and roles that need to access external network services fromthe database. This way, specific groups of users can connect to one or more host computers, based onprivileges that you grant them. 
Typically, you use this feature to control access to applications that run onspecific host addresses. 
To configure fine-grained access control to external network services, you create an access control list (ACL),which is stored in Oracle XML DB. You can create the access control list by using Oracle XML DB itself, orby using the DBMS_NETWORK_ACL_ADMIN and DBMS_NETWORK_ACL_UTILITY PL/SQL packages. This guideexplains how to use these packages to create and manage the access control list. To create an access controllist by using Oracle XML DB and for general conceptual information about access control lists, see Oracle XMLDB Developer's Guide.



Question 2

Which four resources can directives be specified by using the Oracle Resource Manager?


  1. CPU usage 
  2. degree of parallelism
  3. number of open cursors
  4. number of sorts performed
  5. idle time for blocking sessions
  6. number of I/Os requests
Correct answer: ABEF



Question 3

You are using the control file to maintain information about the database backups that are being performed by Recovery Manager (RMAN). 
Identify two scenarios in which you must have a recovery catalog.


  1. To store the backup information of multiple database
  2. To restrict the amount of space that is used by the backups
  3. To maintain a backup for a certain time is set by the CONTROL_FILE_RECORD_KEEP_TIME parameter.
  4. To list the data files that were in a target database at a given time by using the AT option of REPORTSCHEMA command.
Correct answer: AD



Question 4

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?


  1. TYPE
  2. LOCATION
  3. PARALLEL
  4. DEFAULT DIRECTORY
  5. ORGANIZATION EXTERNAL
Correct answer: C



Question 5

Which three statements are true about windows?


  1. Only one window can be open at any given time 
  2. Consumer groups are associated with windows
  3. Windows work with job classes to control resource allocation
  4. The database service name must be provided during windows creation
  5. Windows can automatically start job or change resource allocation among jobs for various time periods.
Correct answer: ACE



Question 6

Note the following statements that use flashback technology: 
  1. FLASHBACK TABLE <table> TO SCN <scn>; 
  2. SELECT * FROM <table> AS OF SCN 123456; 
  3. FLASHBACK TABLE <table> TO BEFORE DROP; 
  4. FLASHBACK DATABASE TO TIMESTAMP <timestamp>; 
  5. SELECT * FROM <table> VERSIONS AS OF SCN 123456 AND 123999; 
Which of these statements will be dependent on the availability of relevant undo data in the undo segment?


  1. 1, 2, and 5
  2. 1, 3, and 4
  3. 2, 3, 4, and 5
  4. 1, 2, 3, 4, and 5
Correct answer: A
Explanation:
The BEFORE DROP clause uses Recycle Bin; The FLASHBACK DATABASE uses flashback logs at FRA area.
The BEFORE DROP clause uses Recycle Bin; 
The FLASHBACK DATABASE uses flashback logs at FRA area.



Question 7

View the Exhibit and examine the parameter settings in your server-side parameter file (SPFILE). When you tried to start the database instance, you received the 
following error:
SQL> startup 
ORA-00824: cannot set SGA_TARGET or MEMORY_TARGET due to existing internal settings, see alert log for more information Why did the instance fail to start? 
Exhibit:
  


  1. Because the PGA_AGGREGATE_TARGET parameter is not set
  2. Because the STATISTICS_LEVEL parameter is set to BASIC
  3. Because MEMORY_TARGET and MEMORY_MAX_TARGET cannot be equal
  4. Because both the SGA_TARGET and MEMORY_TARGET parameters are set. 
Correct answer: B
Explanation:
Setting SGA Target Size You enable the automatic shared memory management feature by setting the SGA_TARGET parameter to an on zero value. This parameter sets the total size of the SGA. It replaces the parameters that control the memory allocated for a specific set of individual components, which are now automatically and dynamically resized (tuned) as needed. Note:The STATISTICS_LEVEL initialization parameter must be set to TYPICAL (the default) or ALL for automatic shared memory management to function.
Setting SGA Target Size 
You enable the automatic shared memory management feature by setting the SGA_TARGET parameter to an on zero value. This parameter sets the total size of the SGA. It replaces the parameters that control the memory allocated for a specific set of individual components, which are now automatically and dynamically resized (tuned) as needed. 
Note:
The STATISTICS_LEVEL initialization parameter must be set to TYPICAL (the default) or ALL for automatic shared memory management to function.



Question 8

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


  1. An ASM instance mounts an ASM control file
  2. An ASM instance uses the ASMB process for rebalancing of disks within a disk group
  3. Automatic Memory Management is enabled in an ASM instance even when the MEMORY_TARGET parameters not set explicitly
  4. An RDBMS instance gets connected to an ASM instance using ASMB as a foreground process when the database instance is started
Correct answer: CD



Question 9

You are using the flash recovery area (fast recovery area in 11g Release 2) to store backup related files in your database. After regular monitoring of space usage in the Mash recovery area. You realize that the flash recovery area is (jetting filled up very fast and it is running out of space. Your database flash recovery area is low on specie and you have no more room on disk. Proactively, which two options could you use to make more space available in the flash recovery [Choose two]


  1. Change the RMAN archived log deletion policy.
  2. Use the RMAN CROSSCHECK command to reclaim the archived log space. 
  3. Change the RMAN retention policy to retain backups for a shorter period of time.
  4. Use OS command to move files from the flash recovery area to some other location
Correct answer: BD



Question 10

Which two commands never trigger an implicit rebalancing within the disk group?. (Choose two.)


  1. ALTER DISKGROUP misc MOUNT;
  2. ALTER DISKGROUP misc DROP DISK misc2;
  3. ALTER DISKGROUP misc CHECK ALL NOREPAIR;
  4. ALTER DISKGROUP misc RESIZE ALL SIZE 1023m;
  5. ALTER DISKGROUP dgroupA ADD DISK '/devices/A*';
Correct answer: AC
Explanation:
Altering Disk Groups You can use the ALTER DISKGROUP SQL statement to alter a disk group configuration. You can add, resize, or drop disks while the database remains online. Whenever possible, multiple operations in a single ALTERDISKGROUP statement are recommended. Grouping operations in a single ALTER DISKGROUP statement can reduce rebalancing operations. Oracle ASM automatically rebalances when the configuration of a disk group changes. By default, the ALTER DISKGROUP statement does not wait until the operation is complete before returning. Query theV$ASM_OPERATION view to monitor the status of this operation. add_disk_clause Use this clause to add one or more disks to the disk group and specify attributes for the newly added disk. Oracle ASM automatically rebalances the disk group as part of this operation. drop_disk_clause Use this clause to drop one or more disks from the disk group. DROP DISK The DROP DISK clause lets you drop one or more disks from the disk group and automatically rebalance the disk group. When you drop a disk, Oracle ASM relocates all the data from the disk and clears the disk header so that it no longer is part of the disk group. The disk header is not cleared if you specify the FORCE keyword.
Altering Disk Groups 
You can use the ALTER DISKGROUP SQL statement to alter a disk group configuration. You can add, resize, or drop disks while the database remains online. 
Whenever possible, multiple operations in a single ALTERDISKGROUP statement are recommended. Grouping operations in a single ALTER DISKGROUP statement can reduce rebalancing operations. 
Oracle ASM automatically rebalances when the configuration of a disk group changes. By default, the ALTER DISKGROUP statement does not wait until the operation is complete before returning. Query theV$ASM_OPERATION view to monitor the status of this operation. 
add_disk_clause 
Use this clause to add one or more disks to the disk group and specify attributes for the newly added disk. Oracle ASM automatically rebalances the disk group as part of this operation. 
drop_disk_clause 
Use this clause to drop one or more disks from the disk group. 
DROP DISK 
The DROP DISK clause lets you drop one or more disks from the disk group and automatically rebalance the disk group. When you drop a disk, Oracle ASM relocates all the data from the disk and clears the disk header so that it no longer is part of the disk group. The disk header is not cleared if you specify the FORCE keyword.









CONNECT US

Facebook

Twitter

PROFEXAM WITH A 20% DISCOUNT

You can buy ProfExam with a 20% discount!

Get Now!


HOW TO OPEN VCEX FILES

Use ProfExam Simulator to open VCEX files