Exam Code: 1Z0-053 (Practice Exam Latest Test Questions VCE PDF)
Exam Name: Oracle Database 11g: Administration II
Certification Provider: Oracle
Free Today! Guaranteed Training- Pass 1Z0-053 Exam.
2021 May 1Z0-053 Study Guide Questions:
Q141. View the Exhibits: Exhibit 1 and Exhibit 2.
Both processes use an existing job template PROG_1. The time taken by the Jobs is recorded in the TEST_LOG table.
It was observed that the job creation process in Exhibit 1 takes less time than In Exhibit2.
What is the reason for this?
A. It creates less metadata for jobs.
B. It creates Jobs temporarily in memory only.
C. It writes the Job metadata to disk in compressed format.
D. It updates tables In the SYSTEM tablespace instead of creating new tables.
Answer: D
Q142. Which options must you configure while performing an automated Tablespace Point-in-Time Recovery (TSPITR) by using Recovery Manager (RMAN)?
A. New channels for restore and recovery tasks
B. New name for the data files of the tablespace
C. Auxiliary name for the data files of the tablespace
D. Auxiliary destinations for an auxiliary set of data files
Answer: D
Q143. You have created a script in the recovery catalog called backup_database. Which of the following commands would successfully execute that script?
A. run {
open script backup_database;
run script backup_database
}
B. run {
engage script backup_database;
}
C. run {
run script backup_database;
}
D. Run {
execute script backup_database;
}
E. The name backup_database is an invalid name for an RMAN script. Trying to run it from RMAN would result in an error.
Answer: D
Up to the immediate present oracle certified professional 1z0-053:
Q144. You are managing an Oracle Database 11g instance with ASM storage. You lost an ASM disk group DATA. You have RMAN backup of data as well as ASM metadata backup.
You want to re-create the missing disk group by using the ASMCMD md_restore command. Which of these methods would you use to achieve this? (Choose all that apply.)
A. Restore the disk group with the exact configuration as the backed-up disk group, using the same disk group name, same set of disks, failure group configurations, and data on the disk group.
B. Restore the disk group with the exact configuration as the backed-up disk group, using the same disk group name, same set of disks, and failure group configurations.
C. Restore the disk group with changed disk group specification, failure group specification, disk group name, and other disk attributes.
D. Restore metadata in an existing disk group by passing the existing disk group name as an input parameter.
Answer: BCD
Q145. You want the Automatic SQL Tuning process to stop accepting and implementing the recommended SQL profiles automatically. Which action would you perform to achieve this?
A. Edit the automatic maintenance window group configuration.
B. Set the CURSOR_SHARING parameter to EXACT for the database instance.
C. Use the DBMS_SQLTUNE.SET_TUNING_TASK_PARAMETERS procedure to set ACCEPT_SQL_PROFILES to FALSE.
D. Set the SQLTUNE_CATEGORY parameter to DEFAULT for the database instance.
Answer: C
Q146. You need to create a partitioned table to store historical data and you issued the following command:
CREATE TABLE purchase_interval
PARTITION BY RANGE (time_id)
INTERVAL (NUMTOYMINTERVAL(1,'month')) STORE IN (tbs1,tbs2,tbs3)
(
PARTITION p1 VALUES LESS THAN(TO_DATE('1-1-2005', 'dd-mm-yyyy')),
PARTITION p2 VALUES LESS THAN(TO_DATE('1-1-2007', 'dd-mm-yyyy')))
AS
SELECT *
FROM purchases
WHERE time_id < TO_DATE('1-1-2007','dd-mm-yyyy');
What is the outcome of the above command?
A. It returns an error because the range partitions P1 and P2 should be of the same range.
B. It creates two range partitions (P1, P2). Within each range partition, it creates monthwise subpartitions.
C. It creates two range partitions of varying range. For data beyond '1-1-2007,' it creates partitions with a width of one month each.
D. It returns an error because the number of tablespaces (TBS1,TBS2,TBS3)specified does not match the number of range partitions (P1,P2) specified.
Answer: C
Simulation oracle database 11g dba 2 1z0-053:
Q147. View the Exhibit exhibit1 to observe the maintenance window property. View the Exhibit exhibit2 to examine the output of the query.
Which two statements describe the conclusions? (Choose two.)
A. RESOURCE_PERCENTAGE should be increased.
B. The repeat time for the window should be decreased.
C. RESOURCE_PERCENTAGE should be decreased.
D. The window duration should be increased.
Answer: AD
Q148. What command would you use to set a persistent setting in RMAN so that backups are all written to a tape device?
A. CONFIGURE DEFAULT DEVICE TYPE TO TAPE MEDIA
B. CONFIGURE DEFAULT DEVICE TYPE TO TAPE
C. CONFIGURE DEFAULT DEVICE TYPE TO SBT
D. CONFIGURE DEFAULT DEVICE TYPE TO SBT_TAPE
Answer: C
Q149. Which command is used to begin a tablespace point-in-time recovery?
A. Restore tablespace
B. Recover tablespace
C. Tablespace recover
D. Recover to time
E. recover datafile
Answer: B
Q150. Which tasks are run automatically as part of the Automated Maintenance Task by default? (Choose all that apply.)
A. Segment Advisor
B. SQL Access Advisor
C. Optimizer statistics gathering
D. Automatic SQL Tuning Advisor
E. Automatic Database Diagnostics Monitor
Answer: ACD