Exact of 1Z0-053 brain dumps materials and dumps for Oracle certification for IT professionals, Real Success Guaranteed with Updated 1Z0-053 pdf dumps vce Materials. 100% PASS Oracle Database 11g: Administration II exam Today!
2021 May 1Z0-053 Study Guide Questions:
Q191. Which of the following Oracle features utilize the undo tablespace? (Choose all that apply)
A. Flashback Query
B. Flashback Drop
C. Flashback Table
D. Flashback Database
E. Transaction Processing
F. Recycle Bin
Answer: ACE
Q192. How would you grant the RVPC user access to specific RMAN database records in the RMAN virtual private catalog?
A. Issue the grant command from the SYS user (or equivalent) of the target database.
B. Issue the grant command from the SYS user (or equivalent) of the recovery-catalog database.
C. Issue the grant command from the recovery catalog-owning schema user account in the recovery catalog.
D. Issue the grant command from RMAN when connected to the recovery catalog-owning schema.
E. Issue the grant command from RMAN when connected to the target database.
Answer: D
Q193. Which three tasks can be performed using a duplicate database? (Choose three.)
A. Testing the backup and recovery procedures
B. Testing the upgrade of an Oracle database to a new release
C. Testing the effect of an application changes on database performance
D. Continuously updating archive log files from the target database to support failover
Answer: ABC
Down to date 1z0-053 exam dumps:
Q194. The user SYS creates a job by using the following command:
Which two statements are true about the job that was created by the preceding command? (Choose two.)
A. The job is enabled by default after creation
B. The job is automatically dropped after the end date
C. The job executes with the privileges of the user SYS
D. The globalization environment that exists at the time of the job creation prevails at the job runs
Answer: BC
Q195. You want to disable resumable space allocation for all sessions.
Which value should be assigned to the RESUMABLE_TIMEOUT parameter to disable resumable space allocation for all sessions?
A. 0
B. 10
C. 100
D. NULL
Answer: A
Q196. After executing the command alter diskgroup disk group2 drop disk dg2a; you issue the following command from the ASM instance:
Select group_number, count(*) from v$asm_operation;
What is the implication if the query against V$ASM_OPERATION returns zero rows?
A. The drop disk operation is still proceeding and you cannot yet run the undrop disks operation.
B. The drop disk operation is complete and you can run the undrop disks command if needed.
C. The drop disk operation is complete and you cannot run the undrop disk command.
D. The query will fail since there is not a V$ASM_OPERATION view available in an ASM instance.
E. None of the above is true.
Answer: C
Vivid 1z0-053 forum:
Q197. 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
Q198. Exhibit:
View the Exhibit to examine a portion of the output from the VALIDATE DATABASE command.
Which statement is true about the block corruption detected by the command?
A. No action is taken except the output in the Exhibit.
B. The ADVISE FAILURE command is automatically called to display the repair script.
C. The failure is logged into the Automatic Diagnostic Repository (ADR).
D. The corruption is repaired by the command implicitly.
Answer: C
Q199. You decided to use Direct NFS configuration in a non-RAC Oracle installation and created the oranfstab file in /etc. Which two statements are true regarding this oranfstab file? (Choose two.)
A. Its entries are specific to a single database.
B. It contains file systems that have been mounted by Direct NFS.
C. It is globally available to all Oracle 11g databases on the machine.
D. It contains file systems that have been mounted by the kernel NFS system.
Answer: CD
Q200. You are performing incomplete recovery using RMAN. You execute the following RUN block:
RUN
{
SET UNTIL SCN 1107600;
RESTORE DATABASE;
RECOVER DATABASE;
}
Which statement is true about the result?
A. RMAN restores all datafiles from the most recent backup available since the failure and applies the redo logs necessary to recover the database to SCN 1107600
B. RMAN restores all datafiles needed to restore the database through SCN 1107599 and applies the redo logs necessary to recover the database through SCN 1107599.
C. RMAN restores all datafiles and control files from the most recent backup
D. The RUN block fails because you did not specify an UNTIL clause in your RECOVER DATABASE command
Answer: B