2016 June Oracle Official – 1Z0-053: Oracle Database 11g: Administration II Exam Questions New Updated Today in Braindump2go.com. 100% 1Z0-053 Exam Pass Guaranteed!
NEW QUESTION 11 – NEW QUESTION 20:
QUESTION 11
Which three statements are true regarding persistent lightweight jobs? (Choose three.)
A. Persistent lightweight jobs modify several tables in the data dictionary to generate a lot of redo.
B. The user cannot set privileges on persistent lightweight jobs.
C. Persistent lightweight jobs are useful when users need to create a large number of jobs in a short time.
D. Persistent lightweight jobs are useful when users need to create a small number of jobs that run infrequently.
E. The use of a template is mandatory to create persistent lightweight jobs.
Answer: BCE
Explanation:
http://blog.csdn.net/rlhua/article/details/19174365
QUESTION 12
Your database initialization parameter file has the following entry:
SEC_MAX_FAILED_LOGIN_ATTEMPTS=3
Which 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
SYSDBA privilege.
Answer: A
QUESTION 13
Which statement is true regarding virtual private catalogs?
A. A virtual private catalog owner can create a local stored script, and have read/write access to a global
stored script.
B. The virtual private catalog owner cannot create and modify the stored scripts.
C. The set of views and synonyms that make up the virtual private catalog is stored in the schema of the
RMAN recovery catalog owner.
D. To perform most of the RMAN operations, the virtual catalog owner must have the SYSDBA or
SYSOPER privilege on the target database.
Answer: D
QUESTION 14
Which tasks can be accomplished using the Enterprise Manager Support Workbench in Oracle Database 11g? (Choose all that apply.)
A. Generate reports on data failure such as data file failures.
B. You can track the Service Request (SR) and implement repairs.
C. You can package and upload diagnostic data to Oracle Support.
D. You can manually run health checks to gather diagnostic data for a problem.
Answer: BCD
QUESTION 15
What are the advantages of variable extent size support for large ASM files? (Choose two.)
A. It improves resync operations when the disk comes online after being taken offline for maintenance
purposes.
B. It improves performance in the extended cluster configuration by reading from a local copy of
an extent.
C. Fewer extent pointers are needed to describe the file and less memory is required to manage the
extent maps in the shared pool.
D. This feature enables faster file opens because of the reduction in the amount of memory that is
required to store file extents.
Answer: CD
QUESTION 16
Which two are the uses of the ASM metadata backup and restore (AMBR) feature? (Choose two.)
A. It can be used to back up all data on ASM disks.
B. It can be used to recover the damaged ASM disk group along with the data.
C. It can be used to gather information about a preexisting ASM disk group with disk paths, disk name,
failure groups, attributes, templates, and alias directory structure.
D. It can be used to re-create the ASM disk group with its attributes.
Answer: CD
QUESTION 17
Which two changes and their effect on the system can be tested by using the Database Replay feature? (Choose two.)
A. multiplexing of the control file
B. adding the redo log member to the database
C. database and operating system upgrades
D. changing the database storage to ASM-managed storage
Answer: CD
QUESTION 18
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
QUESTION 19
While performing the backup of the flash recovery area, you notice that one of the archived redo log files is missing. You have multiple destinations for archived redo log files. What implications does it have on the backup of the flash recovery area?
A. The backup fails because one of the archived redo log files is missing.
B. The backup succeeds but it would be without the missing archived log.
C. During backup, you are prompted for the alternative destination for the missing archived redo log file.
D. The backup succeeds because it fails over to one of the alternative archived redo log destinations.
Answer: D
QUESTION 20
You are managing an Oracle Database 11g instance and an Oracle Database 10g instance on the same machine. Both instances use the ASM instance as storage. Which statement regarding the ASM disk group compatibility attributes are true in this scenario? (Choose all that apply.)
A. The database-compatibility version settings for each instance must be greater than or equal to
the RDBMS compatibility of all ASM disk groups used by that database instances.
B. RDBMS compatibility and the database version determines whether a database instance can
mount the ASM disk group.
C. The RDBMS compatibility settings for a disk group control the format of data structures for ASM
metadata on the disk.
D. ASM compatibility controls which features for the ASM will be enabled.
Answer: ABD
2016 Valid Oracle 1Z0-053 Study Materials:
1.| Latest 1Z0-053 Exam PDF and VCE Dumps 676q from Braindump2go: http://www.braindump2go.com/1z0-053.html [100% Exam Pass Guaranteed!]
2.| New 1Z0-053 Exam Questions and Answers – Google Drive: https://drive.google.com/folderview?id=0B75b5xYLjSSNOGJaLVVucEZfS28&usp=sharing
MORE Practice is the Most Important IF You want to PASS Oracle 1Z0-053 Exam 100%!
————— Braindump2go.com
————— Pass All IT Exams at the first Try!