1Z0-053 | Simulation Oracle 1Z0-053 vce
Q111. A database is running In ARCHIVBXXMS mode. It has two online redo log groups and each group has one member. A LGWR Input/output (I/O) fells due to permanent media failure that has resulted In the loss of redo log file and the LWGR terminates causing the instance to crash.
The steps to recover from the loss of a current redo log group member in the random order are as follow.
1) Restore the corrupted redo log group.
2) Restore from a whole database backup.
3) Perform incomplete recovery.
4) Relocate by renaming the member of the damaged online redo log group to a new location.
5) Open the database with the RESETLOGS option.
6) Restart the database instance.
7) Issue a checkpoint and clear the log.
Identify the option with the correct sequential steps to accomplish the task efficiently.
A. 1, 3, 4, and 5
B. 7, 3, 4. and 5
C. 2, 3, 4, and 5
D. 7, 4, 3. and 5
E. Only 6 is required
Answer: B
Q112. Which of these formats represents the correct hierarchy for the ADR?
A. <diagnostic_dest>/rdbms/diag/<dbname>/<instname>
B. <diagnostic_dest>/diag/rdbms/<instname>/<dbname>
C. <diagnostic_dest>/diag/rdbms/<dbname>/<instname>
D. None of the above
Answer: C
Q113. What is the proper command to shut down the database in a consistent manner?
A. Shutdown abort
B. Shutdown kill
C. Shutdown nowait
D. shutdown immediate
E. shutdown halt
Answer: D
Q114. When performing an online backup, what is the proper order of the following steps?
a. Issue the alter database end backup command.
b. Back up the archived redo logs.
c. Issue the alter database begin backup command.
d. Back up the database files.
e. Determine the beginning log sequence number.
f. Determine the ending log sequence number.
g. Force a log switch with the alter system switch logfile command.
A. a, b, c, d, e, f, g
B. c, d, a, b, e, g, f
C. f, d, b, g, a, c, e
D. e, c, d, a, g, f, b
E. a, f, b, g, e, c, d
Answer: D
Q115. 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
Q116. Which three statements are true regarding the functioning of the Autotask Background Process (ABP)? (Choose three.)
A. It creates jobs without considering the priorities associated with them.
B. It translates tasks into jobs for execution by the scheduler.
C. It determines the list of jobs that must be created for each maintenance window.
D. It is spawned by the MMON background process at the start of the maintenance window.
E. It maintains a repository in the SYSTEM tablespace to store the history of the execution of all tasks.
Answer: BCD
Q117. You are managing an Oracle Database 11g database with the ASM storage. The database is having big file tablespaces. You want files to open faster and less memory to be used in the shared pool to manage the extent maps. What configuration would you effect to achieve your objective? (Choose all that apply.)
A. Set the ASM compatibility attribute for the ASM disk group to 11.1.0.
B. Set the RDBMS compatibility attribute for the ASM disk group to 11.1.0.
C. Set the COMPATIBLE initialization parameter for the ASM instance to 11.1.0.
D. Set the COMPATIBLE initialization parameter for the database instance to 11.1.0.
Answer: AD
Q118. Your company wants to upgrade the current production database to the RAC environment. To perform testing before migrating to the RAC environment, you performed the workload capture on the production database to record the peak workload. You set up the test RAC database and want to replay the recorded workload on the testmachine. Note the following steps that you may require to replay the database workload:
1) Preprocess the captured workload.
2) Restart the database in RESTRICTED mode.
3) Set up the Replay Clients.
4) Restore the test database to the point when the capture started.
5) Remap connections.
Arrange the steps required in the correct sequence to accomplish this task on the test machine.
A. 1, 4, 5, 3 (2 is not required.)
B. 1, 4, 3, 5 (2 is not required.)
C. 1, 2, 4, 5 (3 is not required.)
D. 2, 1, 5, 3, 4
E. 1, 2, 4, 5, 3
Answer: A
Q119. David managed to accidentally delete the datafiles for database called DSL. He called Heber and Heber tried to help but he managed to delete the control files of the database. Heber called Bill and Bill saved the day. They are using a recovery catalog for this database. What steps did Bill perform to recover the database and in what order?
a. Restored the control file with the RMAN restore controlfile command.
b. Mounted the DSL instance with the alter database mount command.
c. Restored the datafiles for the DSL database with the RMAN restore command.
d. Opened the DSL database with the alter database open resetlogs command.
e. Recovered the datafiles for the DSL database with the RMAN recover command.
f. Started the DSL instance.
g. Connected to the recovery catalog with RMAN.
A. a, b, c, d, e, f, g
B. b, c, d, g, f, e, a
C. g, f, a, b, c, e, d
D. c, a, d, b, f, e, g
E. g, f, a, b, e, c, d
Answer: C
Q120. Which NLS parameter can be used to change the default Oracle sort method from binary to linguistic for the SQL SELECT statement?
A. NLS_LANG
B. NLS_COMP
C. NLS_SORT
D. None of the above
Answer: D