1z0-050 exam questions

Free 1z0-050 Demo Download

Just4braindumps.info offers free demo for Oracle 11i 1z0-050 exam (Oracle Database 11g: New Features for Administrators). You can check out the interface, question quality and usability of our practice exams before you decide to buy it. We are the only one site can offer demo for almost all products.

1z0-050 exam questions

1z0-050 Exam Description

It is well known that latest 1z0-050 exam test is the hot exam of Oracle certification. Just4braindumps.info offer you all the Q&A of the 1z0-050 real test . It is the examination of the perfect combination and it will help you pass 1z0-050 exam at the first time!

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


1. 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

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

4. 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

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

6. 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