The Oracle 1Z0-053 Sample Question Set is designed to help you prepare for the Oracle Database 11g - Administration II (1Z0-053) certification exam. To become familiar with actual Oracle Certification exam environment, we suggest you to try Sample Oracle 1Z0-053 Certification Practice Exam.
This sample Oracle 1Z0-053 certification practice exam is designed for evaluation purposes only. If you really want to test your knowledge to identify your weak areas and familiarize with actual exam format, we suggest you to practice with Premium Oracle 1Z0-053 Certification Practice Exam for Oracle Database 11g - Administration II (1Z0-053) certification. Our team of Oracle Database experts have designed Questions-Answers for this premium practice exam by collecting inputs from recently certified candidates. Hence, We strongly recommend you to use Premium Oracle 1Z0-053 Certification Practice Exam to clear your actual Oracle 1Z0-053 Certification Exam with great score.
1. Which option speeds up the disk rebalancing in an Automatic Storage Management (ASM) disk group by increasing the degree of parallelism?
a) Increasing ASM_POWER_LIMIT
b) Increasing the number of DBWR processes
c) Increasing the number of ASMB processes
d) Increasing the number of DBWR_IO_SLAVES
2. The database is in the ARCHIVELOG mode and is configured for remote administration. You execute the following command when the database is in the MOUNT state:
$ nid TARGET=sys/oracle DBNAME=orcl_dup SETNAME=YES
Which two actions would you perform after the command executes successfully?
(Choose two)
a) Open the database with the RESETLOGS option
b) Create a new password file and restart the database instance
c) Change the DB_NAME parameter in the parameter file and restart the database instance
d) Perform a backup of the database because the archive logs cannot be used for the current database incarnation
3. Examine the following PL/SQL block used to create a schedule by the SYS user:
BEGIN
DBMS_SCHEDULER.CREATE_SCHEDULE (
schedule_name => 'my_stats_schedule',
start_date => SYSTIMESTAMP,
end_date => SYSTIMESTAMP + INTERVAL '30' day,
repeat_interval => 'FREQ=HOURLY; INTERVAL=4',
comments => 'The statistics schedule');
END;
Which two statements are true about the schedule created?
(Choose two)
a) The schedule is created with access to public
b) A job defined with the schedule runs in every four hours for 30 days
c) The schedule can be attached with the jobs created only by the SYS user
d) A job defined with the schedule runs for four hours every day for the next 30 days
4. Identify two results that you get using the BACKUP VALIDATE Recovery Manager (RMAN) command.
(Choose two)
a) It checks for the obsolete backups in the recovery catalog
b) It confirms that all database files exist and are in the correct locations
c) It checks for the availability of backup sets and image copies in the recovery catalog
d) It identifies whether tape streaming or disk input/output (I/O) is the bottleneck in a backup job
5. Identify two permanent items in the Flash Recovery Area.
(Choose two)
a) Flashback logs
b) Archived redo logs
c) Control file autobackups
d) Multiplexed copies of online redo logs
e) Multiplexed copies of the current control file
6. What is determined by Recovery Manager (RMAN) multiplexing?
a) The number of files per backup set during the backup
b) The number of sections to which a file is divided during backup
c) The number of channels opened automatically during the back up of the database
d) The number of files in a backup that are read simultaneously and then written to the same backup piece
7. Which two operations can you perform using the ALTER FLASHBACK ARCHIVE command?
(Choose two)
a) Purge some data from the Flashback Data Archive
b) Add new tablespace to the Flashback Data Archive
c) Change the retention time of a Flashback Data Archive
d) Remove all tablespaces from the Flashback Data Archive
8. Which two statements are true about the Recovery Manager (RMAN) multisection backup?
(Choose two)
a) Multisection backup produces multipiece backup set
b) Multisection backups can be performed as backup sets and image copies
c) The backup optimization feature must be enabled to perform multisection backup
d) RMAN can break up large files into sections and back up and restore these sections independently
9. Which three criteria will not allow the shrink operation in a table?
(Choose three)
a) The table is part of a cluster
b) The table is managed by free lists
c) ROW MOVEMENT is enabled for the table
d) The table has blocks with migrated and chained rows
e) The table is in the automatic segment space-managed tablespace and has a function based index
10. Examine the following command:
SQL> CREATE RESTORE POINT before_upgrade GUARANTEE FLASHBACK DATABASE;
Which two statements are true about the restore point created by the above command?
(Choose two)
a) The restore point is never edged out of the control file until it is dropped explicitly
b) The NOLOGGING operation such as direct loads cannot be reversed using the restore point
c) The database can be flashed back up to the SCN at the command, even if flashback logging is not enabled
d) Shrinking of data files or dropping a tablespace do not prevent flashing back the affected data files to the restore point
QUESTION: 01
Answer: a
QUESTION: 02
Answer: b, c
QUESTION: 03
Answer: a, b
QUESTION: 04
Answer: b, d
QUESTION: 05
Answer: d, e
QUESTION: 06
Answer: d
QUESTION: 07
Answer: a, c
QUESTION: 08
Answer: a, d
QUESTION: 09
Answer: a, b, e
QUESTION: 10
Answer: a, c
Posted by: gerrigerridugmoree0271811.blogspot.com
Source: https://www.dbexam.com/sample-questions/oracle-1z0-053-certification-sample-questions-and-answers
