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 Jun 1Z0-053 Study Guide Questions:
Q61. You installed Oracle Database 11g afresh. Which statements are true regarding the default audit settings in this database? (Choose all that apply.)
A. The audit trail is stored in an operating system file.
B. Auditing is disabled for all privileges.
C. The audit trail is stored in the database.
D. Auditing is enabled for all privileges.
E. Auditing is enabled for certain privileges related to database security.
Q62. 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.
Q63. You are managing a 24*7 database. The backup strategy for the database is to perform user- managed backups. Identify two prerequisites to perform the backups. (Choose two.)
A. The database must be opened in restricted mode.
B. The database must be configured to run in ARCHIVELOG mode.
C. The tablespaces are required to be in backup mode before taking the backup.
D. The tablespaces are required to be in read-only mode before taking the backup
Improve 1z0-053 test questions:
Q64. You want to take a complete database backup using RMAN. The backup should consist only the used blocks from your database.
Which two statements are true about this backup operation? (Choose two.)
A. Backup compression should be enabled
B. Parallelism for the channel should be set to 2
C. All the files must be backed up as backup sets
D. The backup may be stored either on disk or on media with media manager
Q65. For which of the following can you use Segment Shrink? (Choose all that apply.)
A. Heap tables
B. Tables with function-based indexes
D. Partitions and subpartitions
E. None of the above
Q66. Which of the following are included in a transportable tablespace set? (Choose all that apply.)
A. The datafiles that make up a self-contained group of tablespaces required for copy
B. The system tablespace
C. An export of the tablespace metadata
D. The spfile
E. All of the above
Simulation 1z0-053 exam dumps:
Q67. What is the default value for the ENABLED attribute of a job or program when it is created?
C. There is no default. It must be defined at creation time.
Q68. Which components are needed for successful and most efficient recovery.
A. The backup RB3 and the current online redo log files
B. the backup RB2 and the archived redo log files after the log sequence number 15622
C. Backup R81 and the archived redo log hies after the log sequence number 12871
D. The backup RB3 and the archived redo log files after the log sequence number 16721
Q69. What two are the prerequisites for enabling Flashback Database? (Choose two)
A. The database must be in ARCHIVELOG mode
B. The database must be in MOUNT EXCLUSIVE mode
C. The database must be opened in RESTRICTED mode
D. The database instance must be started in the NOMOUNT state
E. The database instance must have the keep buffer pool defined
Q70. The ADMIN_EMP table has columns EMPNO, ENAME, DEPTNO, and SAL. It has a materialized view EMP_MV with a materialized log and an ENAME_IDX index on the ENAME column. You need to perform an online table redefinition on the ADMIN_EMP table to move it from the TBS1 tablespace to the TBS2 tablespace in the same schema. What action is required for the dependent objects when you perform online redefinition on the table?
A. The materialized view should have a complete refresh performed after the online table redefinition is completed.
B. The materialized view should have a fast refresh performed after the online table redefinition is completed.
C. The materialized view, materialized log, and the index should be dropped and re-created after the online table redefinition is complete.
D. The materialized view and materialized log should be dropped and all constraints disabled and re-created after the online table redefinition is complete.