1z0-050 Exam

��
��
Exam : Oracle 1Z0-050
Title : Oracle Database 11g: New Features for Administrators


1. Which two statements are true regarding the starting of the database instance using the following command? (Choose two.)
SQL>STARTUP UPGRADE
A.It enables all system triggers.
B.It allows only SYSDBA connections.
C.It ensures that all job queues remain active during the upgrade process.
D.It sets system initialization parameters to specific values that are required to enable database upgrade scripts to be run.
Answer: BD

2. Which dependent object will get invalidated even if it is not affected by the table redefinition?
A.views
B.triggers
C.packages
D.synonyms
Answer: B

3. Which two statements are true with respect to the maintenance window? (Choose two.)
A.A DBA can enable or disable an individual task in all maintenance windows.
B.A DBA cannot change the duration of the maintenance window after it is created.
C.In case of a long maintenance window, all Automated Maintenance Tasks are restarted every four hours.
D.A DBA can control the percentage of the resource allocated to the Automated Maintenance Tasks in each window.
Answer: AD

4. Your organization decided to upgrade the existing Oracle 10g database to Oracle 11g database in a multiprocessor environment. At the end of the upgrade, you observe that the DBA executes the following script:
SQL> @utlrp.sql
What is the significance of executing this script?
A.It performs parallel recompilation of only the stored PL/SQL code.
B.It performs sequential recompilation of only the stored PL/SQL code.
C.It performs parallel recompilation of any stored PL/SQL as well as Java code.
D.It performs sequential recompilation of any stored PL/SQL as well as Java code.
Answer: C

5. Which two are the prerequisites to enable Flashback Data Archive? (Choose two.)
A.Undo retention guarantee must be enabled.
B.Database must be running in archivelog mode.
C.Automatic undo management must be enabled.
D.The tablespace on which the Flashback Data Archive is created must be managed with Automatic Segment Space Management (ASSM).
Answer: CD

6. Examine the following PL/SQL block:
Which statement describes the effect of the execution of the above PL/SQL block?
A.The plan baselines are verified with the SQL profiles.
B.All fixed plan baselines are converted into nonfixed plan baselines.
C.All the nonaccepted SQL profiles are accepted into the plan baseline.
D.The nonaccepted plans in the SQL Management Base are verified with the existing plan baselines.
Answer: D

7. You installed Oracle Database 11g and are performing a manual upgrade of the Oracle9i database. As a part of the upgrade process, you execute the following script:
SQL>@utlu111i.sql
Which statement about the execution of this script is true?
A.It must be executed from the Oracle Database 11g environment.
B.It must be executed only after the SYSAUX tablespace has been created.
C.It must be executed from the environment of the database that is being upgraded.
D.It must be executed only after AUTOEXTEND is set to ON for all existing tablespaces.
E.It must be executed from both the Oracle Database 11g and Oracle Database 9i environments.
Answer: C

8. What are the recommendations for Oracle Database 11g installation to make it Optimal Flexible Architecture (OFA)-compliant? (Choose all that apply.)
A.ORACLE_BASE should be set explicitly.
B.An Oracle base should have only one Oracle home created in it.
C.Flash recovery area and data file location should be on separate disks.
D.Flash recovery area and data file location should be created under Oracle base in a non-Automatic Storage Management (ASM) setup.
Answer: ACD

9. You are managing an Oracle 11g database with ASM storage, for which the COMPATIBLE initialization parameter is set to 11.1.0. In the ASM instance, the COMPATIBLE.RDBMS attribute for the disk group is set to 10.2 and the COMPATIBLE.ASM attribute is set to 11.1.
Which two statements are true in this scenario for the features enabled for ASM? (Choose two.)
A.The ASM-preferred mirror read feature is enabled.
B.The ASM supports variable sizes for extents of 1, 8, and 64 allocation units.
C.The ASM disk is dropped immediately from a disk group when it becomes unavailable.
D.The RDBMS always reads the primary copy of a mirrored extent of the ASM disk group.
Answer: AB

10. You opened the encryption wallet and then issued the following command:
Then you closed the wallet. Later, you issued the following command to create the EMPLOYEES table in the SECURESPACE tablespace and you use the NO SALT option for the EMPID column.
What is the outcome?
A.It creates the table and encrypts the data in it.
B.It generates an error because the wallet is closed.
C.It creates the table but does not encrypt the data in it.
D.It generates an error because the NO SALT option cannot be used with the ENCRYPT option.
Answer: B

11. Which is the source used by Automatic SQL Tuning that runs as part of the AUTOTASK framework?
A.SQL statements that are part of the AWR baseline only
B.SQL statements based on the AWR top SQL identification
C.SQL statements that are part of the available SQL Tuning Set (STS) only
D.SQL statements that are available in the cursor cache and executed by a user other than SYS
Answer: B

12. Identify two situations in which you can use Data Recovery Advisor for recovery. (Choose two.)
A.The database files are corrupted when the database is open.
B.The archived log files are missing for which backup is not available.
C.The user has dropped an important table that needs to be recovered.
D.You are not able to start up the database instance because the required database files are missing.
Answer: AD

13. During the installation of Oracle Database 11g, you do not set ORACLE_BASE explicitly. You selected the option to create a database as part of the installation. How would this environment variable setting affect the installation?
A.The installation terminates with an error.
B.The installation proceeds with the default value without warnings and errors.
C.The installation proceeds with the default value but it would not be an OFA-compliant database.
D.The installation proceeds with the default value but a message would be generated in the alert log file.
Answer: D

14. You are managing the APPPROD database as a DBA. You plan to duplicate this database in the same system with the name DUPDB.
You issued the following RMAN commands to create a duplicate database:
Which three are the prerequisites for the successful execution of the above command? (Choose three.)
A.The source database should be open.
B.The target database should be in ARCHIVELOG mode if it is open.
C.RMAN should be connected to both the instances as SYSDBA.
D.The target database backups should be copied to the source database backup directories.
E.The password file must exist for the source database and have the same SYS user password as the target.
Answer: BCE


Click Online chat to talk with us , get more informations about Oracle Oracle 11i 1z0-050 practice exam study guides questions and answers

Quality and Value for the 1z0-050 Exam

Test4pass Practice Exams for Oracle 1z0-050 are written to the highest standards of technical accuracy, using only certified subject matter experts and published authors for development.

100% Guarantee to Pass Your 1z0-050 Exam

If you prepare for the exam using our Test4pass testing engine, we guarantee your success in the first attempt. If you do not pass the Oracle 11i 1z0-050 exam (ProCurve Secure WAN) on your first attempt we will give you a FULL REFUND of your purchasing fee AND send you another same value product for free.

Oracle 1z0-050 Downloadable, Printable Exams (in PDF format)

Our Exam 1z0-050 Preparation Material provides you everything you will need to take your 1z0-050 Exam. The 1z0-050 Exam details are researched and produced by Professional Certification Experts who are constantly using industry experience to produce precise, and logical. You may get questions from different web sites or books, but logic is the key. Our Product will help you not only pass in the first try, but also save your valuable time.

1z0-050 Downloadable, Interactive Testing engines

We are all well aware that a major problem in the IT industry is that there is a lack of quality study materials. Our Exam Preparation Material provides you everything you will need to take a certification examination. Like actual certification exams, our Practice Tests are in multiple-choice (MCQs) Our Oracle 1z0-050 Exam will provide you with free 1z0-050 dumps questions with verified answers that reflect the actual exam. These questions and answers provide you with the experience of taking the actual test. High quality and Value for the 1z0-050 Exam:100% Guarantee to Pass Your Oracle 11i exam and get your Oracle 11i Certification.

Test4pass 1z0-050 exam
Test4pass 1z0-050 pdf exam
Test4pass 1z0-050 braindumps
Test4pass 1z0-050 study guides
Test4pass 1z0-050 trainning materials
Test4pass 1z0-050 simulations
Test4pass 1z0-050 testing engine
Test4pass 1z0-050 vce
Test4pass 1z0-050 torrent
Test4pass 1z0-050 dumps
free download 1z0-050
Test4pass 1z0-050 practice exam
Test4pass 1z0-050 preparation files
Test4pass 1z0-050 questions
Test4pass 1z0-050 answers

https://test4pass.com/1z0-050-exam.html The safer.easier way to get Oracle 11i Certification .