we provide Certified Oracle 1z0 052 dumps simulations which are the best for clearing 1z0 052 pdf test, and to get certified by Oracle Oracle Database 11g: Administration I. The oracle database 11g administration i 1z0 052 Questions & Answers covers all the knowledge points of the real oracle database 11g administration i 1z0 052 exam. Crack your Oracle 1z0 052 dumps Exam with latest dumps, guaranteed!
♥♥ 2021 NEW RECOMMEND ♥♥
Free VCE & PDF File for Oracle 1Z0-052 Real Exam (Full Version!)
★ Pass on Your First TRY ★ 100% Money Back Guarantee ★ Realistic Practice Exam Questions
Q91. Which statement is true about a whole consistent database backup on a database running in ARCHIVELOG mode?
A. The backup will consist of used data blocks only.
B. The database must be shut down to accomplish the backup.
C. The backup can be accomplished without shutting down the database.
D. The backup will contain all database files that have never been backed up.
Q92. Automatic Shared Memory Management (ASMM) has been enabled for your database instance.
The initialization parameters for the components that are managed by ASMM are not set. After observing the effects of ASMM, you executed the following command:
SQL> ALTER SYSTEM SET DB_CACHE_SIZE = 100M;
Which statement is true in this scenario?
A. The minimum memory size for the database buffer cache is set to 100 MB.
B. The maximum memory size that can be obtained by the database buffer cache during ASMM is set to 100 MB.
C. The minimum memory size allocated for a server process in the database buffer cache in dedicated mode is set to 100 MB.
D. The maximum memory size from the database buffer cache that can be released for dynamic distribution during ASMM is set to 100 MB.
Q93. Which statements listed below describe the data dictionary views?
1. These are stored in the SYSTEM tablespace
2. These are the based on the virtual tables
3. These are owned by the SYS user
4. These can be queried by a normal user only if O7_DICTIONARY_ACCESSIBLILITY parameter is set to TRUE
5. The V$FIXED_TABLE view can be queried to list the names of these views
A. 1 and 3
B. 2,3 and 5
C. 1,2, and 5
D. 2,3,4 and 5
Q94. Your database instance is functional for the past one month. The Automatic Workload Repository (AWR) snapshot retention is set to 7 and the STATISTICS_LEVEL initialization parameter is set to TYPICAL. You receive a complaint about the poor performance of the database between 7 PM and 9 PM of the previous day. Choose two actions any of which can be referred to first to diagnose the problem. (Choose two.)
A. Use the Active Session History report.
B. Use the AWR Compare Periods report.
C. Use an ADDM analysis between 7 PM and 9 PM of the previous day.
D. Use the AWR Compare Period report between 7 PM and 9 PM of the previous day.
Q95. You are managing an Oracle Database 11g database. The database is open, and you plan to perform Recovery Manager (RMAN) backups.
Which three statements are true about these backups? (Choose three.)
A. The backups would be consistent.
B. The backups would be inconsistent.
C. The backups would be possible only if the database is running in ARCHIVELOG mode.
D. The backups would be possible only if the database is running in NOARCHIVELOG mode.
E. The backups need to be restored and the database has to be recovered in case of a media failure.
Q96. Which two activities are NOT supported by the Data Recovery Advisor (DRA)? (Choose two.)
A. Recover from failures in the RAC environment.
B. Diagnose and repair a data file corruption online.
C. Diagnose and repair a data file corruption offline.
D. Diagnose and repair failures on a standby database.
Q97. View the Exhibit. What would happen if Oracle Home is not empty?
A. The installation will not be continued until the location is empty.
B. The installation will proceed without overwriting the existing files.
C. The installation can be continued, but the existing files will be overwritten.
D. The installation terminates automatically after showing an error message.
Q98. Given below is a list of scenarios:
1. A user terminates his session abnormally.
2. The connection between the server and the client application terminates because of a network failure.
3. A schema is accidentally dropped.
4. The tablespace is accidentally dropped from the database.
5. The hard disk gets corrupted and the data files in the disk are lost.
6. The database instance abnormally shuts down because of power failure.
Which scenarios require DBA intervention to perform recovery?
A. 1, 3, and 6
B. 4, 5, and 6
C. 3, 4, and 5
D. 1, 2, and 6
Q99. In which situation may the UNDO_RETENTION parameter be ignored, even if it is set to a value?
A. When the data file of the undo tablespace is autoextensible
B. When there are more than one undo tablespace available in the database
C. When the undo tablespace is of a fixed size and retention guarantee is not enabled
D. When the undo tablespace is autoextensible and retention guarantee is not enabled
Q100. Examine the command that is used to create a table:
SQL> CREATE TABLE orders
( oid NUMBER(6) PRIMARY
KEY, odate DATE,
ccode NUMBER (6),
) TABLESPACE users;
Which two statements are true about the effect of the above command? (Choose two.)
A. A CHECK constraint is created on the OID column.
B. A NOT NULL constraint is created on the OID column.
C. The ORDERS table is the only object created in the USERS tablespace.
D. The ORDERS table and a unique index are created in the USERS tablespace.
E. The ORDERS table is created in the USERS tablespace and a unique index is created on the OID column in the SYSTEM tablespace.