Download Upgrade Oracle9i-10g OCA to Oracle Database 11g OCP.Prepaway.1z0-034.2018-11-28.1e.87q.vcex

Download Dump

File Info

Exam Upgrade Oracle9i/10g OCA to Oracle Database 11g OCP
Number 1z0-034
File Name Upgrade Oracle9i-10g OCA to Oracle Database 11g OCP.Prepaway.1z0-034.2018-11-28.1e.87q.vcex
Size 2.08 Mb
Posted November 28, 2018
Downloads 24



How to open VCEX & EXAM Files?

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

Purchase
Coupon: EXAMFILESCOM

Coupon: EXAMFILESCOM
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? 


  • A: It is a list of remote database links stored in the XML file that are available to the users of the database.
  • B: 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.
  • 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 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.



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

  • A: CPU usage 
  • B: degree of parallelism
  • C: number of open cursors
  • D: number of sorts performed
  • E: idle time for blocking sessions
  • F: number of I/Os requests



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.

  • A: To store the backup information of multiple database
  • B: To restrict the amount of space that is used by the backups
  • C: To maintain a backup for a certain time is set by the CONTROL_FILE_RECORD_KEEP_TIME parameter.
  • D: To list the data files that were in a target database at a given time by using the AT option of REPORTSCHEMA command.



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?

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



Question 5
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.



Question 6
Note the following statements that use flashback technology: 
FLASHBACK TABLE <table> TO SCN <scn>; 
SELECT * FROM <table> AS OF SCN 123456; 
FLASHBACK TABLE <table> TO BEFORE DROP; 
FLASHBACK DATABASE TO TIMESTAMP <timestamp>; 
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?

  • A: 1, 2, and 5
  • B: 1, 3, and 4
  • C: 2, 3, 4, and 5
  • D: 1, 2, 3, 4, and 5



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:

  

  • A: Because the PGA_AGGREGATE_TARGET parameter is not set
  • B: Because the STATISTICS_LEVEL parameter is set to BASIC
  • C: Because MEMORY_TARGET and MEMORY_MAX_TARGET cannot be equal
  • D: Because both the SGA_TARGET and MEMORY_TARGET parameters are set. 



Question 8
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



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]

  • A: Change the RMAN archived log deletion policy.
  • B: Use the RMAN CROSSCHECK command to reclaim the archived log space. 
  • C: Change the RMAN retention policy to retain backups for a shorter period of time.
  • D: Use OS command to move files from the flash recovery area to some other location



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

  • A: ALTER DISKGROUP misc MOUNT;
  • B: ALTER DISKGROUP misc DROP DISK misc2;
  • C: ALTER DISKGROUP misc CHECK ALL NOREPAIR;
  • D: ALTER DISKGROUP misc RESIZE ALL SIZE 1023m;
  • E: ALTER DISKGROUP dgroupA ADD DISK '/devices/A*';









CONNECT US


ProfExam
PROFEXAM WITH A 20% DISCOUNT

You can buy ProfExam with a 20% discount..

Get Now!


HOW TO OPEN VCEX AND EXAM FILES

Use ProfExam Simulator to open VCEX and EXAM files
ProfExam Screen



HOW TO OPEN VCE FILES

Use VCE Exam Simulator to open VCE files
Avanaset