1Z0-053 | All About 100% Guarantee 1Z0-053 exam dumps
Q361. View the Exhibits: Exhibit 1 and Exhibit 2
Both processes use an existing job template PROG_1. The time taken by the jobs are recorded in the TEST_LOG table. It was observed that the job creation process in exhibit 1 takes less time than in exhibit 2.
What is the reason for this?
Exhibit:
A. It creates less metadata for jobs
B. It creates jobs temporarily in memory only
C. It writes the jobs metadata to disk in compressed format
D. It updates tables in SYSTEM tablespace instead of creating new tables
Answer: A
Q362. Which of the following are prerequisite steps to transport a database? (Choose all that apply.)
A. Query the V$TRANSPORTABLE_PLATFORMS view in the source database to determine if the intended destination is listed.
B. Verify that there are no restrictions or limitations that the source or destination database may encounter.
C. Verify that the source and destination have the same Oracle version, critical updates, patch-set version, and patch-set exceptions.
D. Determine if you will perform the conversion on the source or destination platform.
E. None of the above.
Answer: ABD
Q363. Which statements are true regarding the system-defined moving window baseline in Oracle Database 11g? (Choose all that apply.)
A. It does not allow you to change the moving window size.
B. Adaptive threshold functionalities use it by default to compute statistics.
C. It is created by default with the window size being equal to the AWR retention time.
D. It is created when the first snapshot is collected by the Automatic Workload Repository (AWR).
Answer: BC
Q364. What is the impact of the following backup if it exceeds the duration allowance? (Choose all that apply.)Backup as compressed backupset duration 2:00 partial minimize load database ;
A. The entire backup will fail. It will not be usable for recovery.
B. The entire backup will fail, but any datafile successfully backed up will be usable for recovery.
C. If this backup fails, subsequent backups will prioritize datafiles not backed up.
D. If this backup fails, an error will be raised and any other commands will not be executed.
E. If this backup fails, no error will be raised and any other commands will be executed.
Answer: B
Q365. What is the purpose of the RMAN recovery catalog? (Choose all that apply.)
A. Make backups faster
B. Store RMAN metadata
C. Store RMAN scripts
D. Provide the ability to do centralized backup reporting.
E. Make recovery faster
Answer: BCD
Q366. Your archive-log destination directory runs out of space. What is the impact of this on the database?
A. None. The database will switch over to the stand-by archive-log destination directory.
B. A warning message will be written to the alert log of the database, but no adverse impacts to the database will be experienced.
C. The database will shut down, and will not restart until you correct the out-of-space situation.
D. The database will continue to try to write to the archive-log destination directory for one hour.
After one hour, the database will shut down normally.
E. Once Oracle has cycled through all online redo logs, it will stop processing any DML or DDL until the out-of-space condition is corrected.
Answer: E
Q367. Which two statements regarding the Flashback Table feature are correct? (Choose two.)
A. Flashback Table can be performed on system tables.
B. Flashback Table operation does not shrink the segments.
C. Flashback Table uses log mining to extract SQL_REDO and SQL_UNDO statements.
D. Flashback Table operation acquires exclusive data manipulation language (DML) locks.
Answer: BD
Q368. Which is the correct command to back up the database, back up the archived redo logs, and then remove the backed-up archived redo logs?
A. backup database
B. backup database and archivelogs
C. backup database plus archivelogs
D. backup database plus archivelog delete input
E. backup database and archivelog delete input
Answer: D
Q369. Which of the following does the recover command not do?
A. Restore archived redo logs.
B. Apply archived redo logs.
C. Restore incremental backups.
D. Apply incremental backups.
E. Restore datafile images.
Answer: A
Q370. 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