Upgrade Oracle9i/10g OCA to Oracle Database 11g OCP
Question No: 11
You are managing a 24*7 database. The backup strategy for the database is to perform user-managedbackups.
Identify two prerequisites to perform the backups. (Choose two.)
The database must be opened in restricted mode.
The database must be configured to run in ARCHIVELOG mode.
The tablespaces are required to be in backup mode before taking the backup.
The tablespaces are required to be in read-only mode before taking the backup
Question No: 12
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?
It is a list of remote database links stored in the XML file that are available to the users of the database.
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.
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.
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.
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#39;s Guide.
Question No: 13
View the Exhibit and examine the RMAN commands.
Which statement describes the effect of a backup retention policy on the backup of a backup set?
Either all the copies of a backup set are obsolete or none of them are as per the retention policy.
The copies of the backup will be reported as obsolete under a redundancy-based backup retention policy.
The copies of the backup will be reported as obsolete under a recovery window-based backup retentionpolicy.
All the copies of the backup set are counted as one instance of a backup and will deleted in backup setexceeds the redundancy-based backup retention policy.
Question No: 14
Which four resources can directives be specified by using the Oracle Resource Manager?
degree of parallelism
number of open cursors
number of sorts performed
idle time for blocking sessions
number of I/Os requests
Question No: 15
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.
To store the backup information of multiple database
To restrict the amount of space that is used by the backups
To maintain a backup for a certain time is set by the CONTROL_FILE_RECORD_KEEP_TIME parameter.
To list the data files that were in a target database at a given time by using the AT option of REPORTSCHEMA command.
Question No: 16
View the Exhibit to observe the error.
You receive this error regularly and have to shutdown the database instance to overcome the error. AutomaticShared Memory Management is configured for the instance.
What can you do to reduce the chance of this error in the future?
Increase the value of SGA_MAX_SIZE
Enable automatic memory management
Set the PRE_PAGE_SGA parameter to true
Lock the System Global Area (SGA) in memory
Answer: B Explanation:
ORA-04031: unable to allocate string bytes of shared memory (quot;stringquot;,quot;stringquot;,quot;stringquot;,quot;stringquot;)
Cause: More shared memory is needed than was allocated in the shared pool or Streams pool.
Action: If the shared pool is out of memory, either use the DBMS_SHARED_POOL package to pin largepackages, reduce your use of shared memory, or increase the amount of available shared memory byincreasing the value of the initialization parametersSHARED_POOL_RESERVED_SIZE andSHARED_POOL_SIZE. If the large pool is out of memory, increase the initialization parameterLARGE_POOL_SIZE. If the error is issued from an Oracle Streams or XStream process, increase theinitialization parameter STREAMS_POOL_SIZE or increase the capture or apply parameter MAX_SGA_SIZE.
Question No: 17
Which are the two prerequisites before setting up Flashback Data Archive? (Choose two.)
Flash recovery area must be defined
Undo retention guarantee must be enabled.
Database must be running in archivelog mode.
Automatic undo management must be enabled.
The tablespace in which the Flashback Data Archive is created must have automatic segment spaceManagement (ASSM).
Question No: 18
Given below are RMAN commands to enable backup optimization and set the retention policy:
RMANgt; CONFIGURE DEFAULT DEVICE TYPE TO sbt; RMANgt; CONFIGURE BACKUP OPTIMIZATION ON;
RMANgt; CONFIGURE RETENTION POLICY TO REDUNDANCY 2;
The USERS tablespace has never been backed up. You take the USERS tablespace offline on Monday. Viewthe Exhibit to examine the operations performed by using RMAN.
Which two statements are true about the backup of the USERS tablespace? (Choose two.)
It will be backed up as a part of database backup on Friday.
It will be backed up as a part of database backup on Tuesday.
It will not be backed up as a part of database backup on Wednesday.
The command on Sunday deletes the backup of the USERS tablespace taken on Tuesday.
Answer: B,D Explanation: Refer to here.
Backup Optimization for SBT Backups with Redundancy Retention Policy
Question No: 19
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?
Question No: 20
Which option must you configure while performing an automated Tablespace Point-in-Time Recovery (TSPITR) by using Recovery Manager (RMAN)?
New channels for restore and recovery tasks
New name for the data files of the tablespace
Auxiliary name for the data files of the tablespace
Auxiliary destinations for an auxiliary set of data files
100% Free Download!
–Download Free Demo:1z0-034 Demo PDF
100% Pass Guaranteed!
–Download 2018 Latesttests 1z0-034 Full Exam PDF and VCE
|Lowest Price Guarantee||Yes||No||No|
|Free VCE Simulator||Yes||No||No|