Ideas to 1z0 052 pdf

Proper study guides for Improved Oracle Oracle Database 11g: Administration I certified begins with Oracle 1z0 052 pdf preparation products which designed to deliver the Exact oracle database 11g administration i 1z0 052 questions by making you pass the 1z0 052 pdf test at your first time. Try the free 1z0 052 pdf demo right now.

Q11. Which two statements are true regarding listeners? (Choose two.)

A. Listeners use only the TCP/IP protocol.

B. Multiple listener processes can run simultaneously on a host.

C. Multiple database instances can be registered with a single listener.

D. The listener-related errors can be traced only at the administrative level.

E. Only one database instance can be registered with a single listener at any time.

Answer: BC

Q12. Which three statements are correct about temporary tables? (Choose three.)

A. Indexes and views can be created on temporary tables.

B. Both the data and the structure of temporary tables can be exported.

C. Temporary tables are always created in a user's temporary tablespace.

D. The data inserted into a temporary table in a session is available to other sessions.

E. Data manipulation language (DML) locks are never acquired on the data of temporary tables.

Answer: ACE

Q13. Which statement is true about the UNDO_RETENTION parameter when retention guarantee is not enabled?

A. It is the time period after which the undo data becomes obsolete.

B. It is the time period after which the committed undo data would be transferred to a temporary tablespace.

C. It is the minimum time period up to which the committed undo data would be retained if free undo space is available.

D. It is the time period after which the undo data is transferred to the Flash Recovery Area to provide read consistency.

Answer: C

Q14. You execute a command to resize a data file, sales.dbf, of size 200 MB in your database:

ALTER DATABASE DATAFILE '/remorse/sales.dbf' RESIZE 150M;

Which statement is true about this command?

A. The command must be issued in MOUNT state.

B. The command succeeds only if the data file is offline.

C. The command must be issued when the database is in the archivelog mode.

D. The command succeeds if no extent in the tablespace is currently allocated above the 150 MB boundary of the file.

Answer: D

Q15. In which of the scenario will the DBA perform recovery? (Choose all that apply.)

A. The alert log file is corrupted

B. A tablespace is accidentally dropped

C. One of the redo log members is corrupted

D. A database user terminates the session abnormally

E. The hard disk on which the data files is stored is corrupted

Answer: BE

Q16. View the Exhibit.

You want to create a tablespace to contain objects with block size 16 KB. But while configuring the storage you find that the block size that you can provide is only 8 KB.

Which configuration could have enabled the block selection of 16 KB?

A. Choosing the extent allocation type to uniform

B. Choosing the Segment Space Management option to manual

C. Setting autoextension on for the data file mentioned for the tablespace

D. Setting the DB_16K_CACHE_SIZE parameter for the database instance to a nonzero value

Answer: D

Q17. Which two statements are true about Shared SQL Area and Private SQL Area? (Choose two.)

A. Shared SQL Area will be allocated in the shared pool

B. Shared SQL Area will be allocated when a session starts

C. Shared SQL Area will be allocated in the large pool always

D. The whole of Private SQL Area will be allocated in the Program Global Area (PGA) always

E. Shared SQL Area and Private SQL Area will be allocated in the PGA or large pool

F. The number of Private SQL Area allocations is dependent on the OPEN_CURSORS parameter

Answer: AF

Q18. The database instance is currently using SPFILE. View the Exhibit and examine the error that you received while running the DB Structure Integrity check. Given below are the steps to recover from the error in random order:

1. Shut down the instance, if not already done.

2. Copy one of the remaining control files to a new location.

3. Change the value of the CONTROL_FILES initialization parameter to correspond to the new location of the control files.

4. Start up the database instance to the NOMOUNT stage.

5. Recover the database to the point of failure of the control file.

6. Open the database.

Identify the correct sequence of steps?


A. 1, 2, 4, 3, 5, 6

B. 2, 4, 3, 5, 6; 1 not required

C. 4, 5, 6, 2, 3; 1 not required

D. 5, 2, 3, 4; 1 and 6 not required

Answer: A

Q19. Examine the values for the following initialization parameters:



Which two will be the implications of these values in your database? (Choose two.)

A. The SGA advisor will be disabled

B. The MTTR advisor will be disabled

C. Automatic checkpoint tuning will be disabled

D. Checkpoint information will not be written to the alert log file

Answer: BC

Q20. In your database instance, the STATISTICS_LEVEL initialization parameter is set to BASIC.

What is the impact of this setting?

A. Optimizer statistics are collected automatically.

B. Only timed operating system (OS) statistics and plan execution statistics are collected.

C. The snapshots for the Automatic Workload Repository (AWR) are not generated automatically.

D. Snapshots cannot be collected manually by using the DBMS_WORKLOAD_REPOSITORY package.

E. The Oracle server dynamically generates the necessary statistics on tables as part of query optimization.

Answer: C