Exambible offers free demo for 1Z0-053 exam. "Oracle Database 11g: Administration II", also known as 1Z0-053 exam, is a Oracle Certification. This set of posts, Passing the Oracle 1Z0-053 exam, will help you answer those questions. The 1Z0-053 Questions & Answers covers all the knowledge points of the real exam. 100% real Oracle 1Z0-053 exams and revised by experts!
♥♥ 2018 NEW RECOMMEND ♥♥
Free VCE & PDF File for Oracle 1Z0-053 Real Exam (Full Version!)
★ Pass on Your First TRY ★ 100% Money Back Guarantee ★ Realistic Practice Exam Questions
Q111. 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
Q112. The Automatic Database Diagnostic Monitor (ADDM) analysis runs every 60 minutes on your database. Your database is facing a series of interrelated problems over a period of two hours. You need to ensure that the ADDM analysis is run over a time span of two hours in future. What would you do?
A. Create two custom ADDM tasks.
B. Modify the AWR snapshot time interval to two hours.
C. Create a new scheduler window for a time period of two hours.
D. Modify the Automatic Workload Repository (AWR) snapshot retention period to two hours.
Q113. In your production database, users report that they are unable to generate reports on an important table because it does not contain any data. While investigating the reason, you realize that another user executed the TRUNCATE TABLE command, which accidentally caused the data to be lost. Now you want to recover the lost data of the table without affecting objects in other schemas.
Which method must you use to recover the lost data?
A. Complete Recovery with online redo log
B. Complete Recovery with archived redo log
C. Tablespace Point-in-Time Recovery (TSPITR)
D. Incomplete Recovery with system change number (SCN)
Q114. Note the output of the following query;
SQL> SELECT flashback_archieve_name, status FROM dba_flashback_archieve;
You executed the following command to enable Flashback Data Archive on the EXCHANGB_PATE table:
ALTER TABLE exchange_rate FLASHBACK ARCHIEVE;
What is the outcome of this command?
A. The table uses the default Flashback Data Archive.
B. The Flashback Data Archive Is created In the SYSAUX tablespace.
C. The Flashback Data Archive is created in the same tablespace where the tables are stored.
D. The command generates an error because no flashback Data Archive name is specified and there is no default Flashback Data Achieve.
Q115. Which background process coordinates the rebalance activity for disk groups?
Q116. Which commands are used for RMAN database recovery? (Choose all that apply.)
Q117. 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
Q118. Every Sunday the Unix system administrator has a job that executes a full backup of the entire Unix system your database is on. Is this backup usable for backup and recovery of your database?
A. Yes, if the database is in ARCHIVELOG mode.
B. Yes, if the database is in NOARCHIVELOG mode.
C. No, the backup is not usable in any way.
D. Only if the ENABLE_ONLINE_BACKUP parameter is set to TRUE.
Q119. To set the history retention period for either window logging or job logging individually, which parameters of the SET_SCHEDULER_ATTRIBUTE procedure need to be used? (Choose all that apply.)
Q120. ENCRYPT_TS is an encrypted tablespace that contains tables with data. Which statement is true regarding the effect of queries and data manipulation language (DML) statements on the encrypted data in the tables?
A. The data is decrypted during SORT and JOIN operations.
B. The data remains encrypted when it is read into memory.
C. The data remains encrypted when it is stored in the redo logs.
D. The data remains encrypted in the UNDO tablespace provided that the UNDO tablespace was created with the encryption option enabled.