This page was exported from All The Latest MCTS Exam Questions And Answers For Free Share [ https://www.mctsdump.com ] Export date:Thu Nov 21 10:34:33 2024 / +0000 GMT ___________________________________________________ Title: [New Exam Dumps] PassLeader Supply Free Real 1Z0-034 Exam Braindump Ensure 100 Percent Pass --------------------------------------------------- Free Download New 1Z0-034 Exam Dumps: PassLeader now supplying the new version of 1Z0-034 vce dumps, we ensure our 155q 1Z0-034 exam questions are the most complete and authoritative compared with others', which will ensure your 1Z0-034 exam 100% pass, and now we are offering the free new version VCE Player along with the VCE format 155q 1Z0-034 braindumps, also the PDF format 1Z0-034 practice test is available now, welcome to choose. keywords: 1Z0-034 exam,1Z0-034 exam dumps,155q 1Z0-034 exam questions,1Z0-034 pdf dumps,155q 1Z0-034 practice test,1Z0-034 vce file,Upgrade Oracle9i/10g OCA to Oracle Database 11g OCP QUESTION 1You 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.) A.    The database must be opened in restricted mode.B.    The database must be configured to run in ARCHIVELOG mode.C.    The tablespaces are required to be in backup mode before taking the backup.D.    The tablespaces are required to be in read-only mode before taking the backup Answer: BC QUESTION 2You 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. Answer: B QUESTION 3Which two statements are true regarding an Automatic Storage Management (ASM) instance? (Choose two.) A.    An ASM instance mounts an ASM control fileB.    An ASM instance uses the ASMB process for rebalancing of disks within a disk groupC.    Automatic Memory Management is enabled in an ASM instance even when the MEMORY_TARGET parameters not set explicitlyD.    An RDBMS instance gets connected to an ASM instance using ASMB as a foreground process when the database instance is started Answer: CD QUESTION 4You 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 Answer: BD QUESTION 5Which 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*'; Answer: AC QUESTION 6Before a Flashback Table operation, you execute the following command:ALTER TABLE employees ENABLE ROW MOVEMENT;Why would you need this to be executed? A.    Because row IDs may change during the flashback operationB.    Because the object number changes after the flashback operationC.    Because the rows are retrieved from the recycle bin during the flashback operationD.    Because the table is moved forward and back to a temporary during the flashback opertion Answer: A QUESTION 7Examine the following set of RMAN commands:RMAN> CONFIGURE CHANNELdelDEVICETYPEDISK FORMAT '/u02/backup/%U*;RKAN>RUN{ALLOCATECHANNELchlDEVICETYPEDISK;EXECUTESCRIPTfull_backup;}Which statement is true when the RMAN run block is executed? A.    The execution of the script fails because multiple channels cannot coexist.B.    The script is executed and both the channels are used for the script execution.C.    The new channel, CH1, is ignored because a channel has been configured already.D.    The persistent configuration parameter DC1 is overridden because a new channel is allocated in the RMAN run block. Answer: D QUESTION 8Your database is using a default temporary tablespace that contains the temp01.tmp temporary file. All the users on the database use the default temporary tablespace. A user issues a query on the orders table and receives the following error:ERROR at line I:ORA-0I565: error in identifying file '/u01/app/oracle/oradata/TEST/temp01.tmp'ORA-27037: unable to obtain file statusWhat would be the most efficient way to rectify this error? A.    Add a new tempfile to the user's temporary tablespace and drop the tempfile that produced the error.B.    Shut down the database instance, restore the temp01.tmp file from the backup, and then restart the database.C.    Allow the database to continue running, drop the temp01.tmp temporary file, and then re-create it with new tempfiles.D.    Take the temporary tablespace offline, recover the missing tempfile by applying redo logs, and then bring the temporary tablespace online. Answer: A QUESTION 9The instance abnormally terminates because of a power outage. Which statement is true about redo log files during instance recovery? A.    Inactive and current redo log files are required to accomplish recoveryB.    Online and archived redo files are required to accomplish instance recoveryC.    All redo log entries after the last checkpoint are applied from redo log files to data filesD.    All redo log entries recorded in the current log file until the checkpoint position are applied to data files Answer: C QUESTION 10What is the effect of increasing the value of the ASM_POWER_LIMIT parameter? A.    The number of DBWR processes increasesB.    The number of ASMB processes increasesC.    The number of DBWR_TO_SLAVES increasesD.    The rebalancing operation in an ASM instance completes more quickly, but can result in higher I/Ooverhead Answer: D QUESTION 11Your database initialization parameter file has the following entry:SEC_MAX_FAILZD_LOGIN_ATTEMPTS=3Which statement is true regarding this setting? A.    It drops the connection after the specified number of login attempts fail for any user.B.    It is enforced only if the password profile is enabled for the user.C.    It locks the user account after the specified number of attempts.D.    It drops the connection after the specified number of login attempts fail only for users who have the SYSDBAprivilege. Answer: A http://www.passleader.com/1z0-034.html --------------------------------------------------- Images: --------------------------------------------------- --------------------------------------------------- Post date: 2015-05-19 09:46:07 Post date GMT: 2015-05-19 09:46:07 Post modified date: 2015-05-19 09:46:07 Post modified date GMT: 2015-05-19 09:46:07 ____________________________________________________________________________________________ Export of Post and Page as text file has been powered by [ Universal Post Manager ] plugin from www.gconverters.com