The Only Tip You Need: oracle database 11g administration i 1z0 052

Cause all that matters here is passing the Oracle oracle database 11g administration i 1z0 052 exam. Cause all that you need is a high score of oracle database 11g administration i 1z0 052 Oracle Database 11g: Administration I exam. The only one thing you need to do is downloading Exambible oracle database 11g administration i 1z0 052 exam study guides now. We will not let you down with our money-back guarantee.

2017 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

Free Instant Download NEW 1Z0-052 Exam Dumps (PDF & VCE):
Available on:
http://www.certleader.com/1Z0-052-dumps.html

Q1. 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

Q2. In a system, large online transaction processing (OLTP) jobs run during the daytime that require a large database buffer cache. In the night, the system supports batch jobs that require a higher value to be set for the large pool. You must simultaneously configure the memory components to accommodate the peak requirement.

What would you do to automate this configuration for the memory components with change in mode of working?

A. Set the SGA_TARGET initialization parameter to zero.

B. Set the PRE_PAGE_SGA initialization parameter to TRUE.

C. Set the MEMORY_MAX_TARGET initialization parameter to zero.

D. Set the SGA_TARGET initialization parameter to a nonzero value.

Answer: D

Q3. You plan to move data from a flat file to a table in your database. You decide to use SQL*Loader direct path load method to perform this task. The table in which you plan to load data in an important table having various integrity constraint defined on it.

Which constraints will remain enabled by default during this operation? (Choose all that apply.)

A. CHECK

B. UNIQUE

C. NOT NULL

D. PRIMARY KEY

E. FOREIGN KEY

Answer: BCD

Q4. The job to gather optimizer statistics for objects runs as part of the automatic maintenance window in your database instance. At a certain point of time, the maintenance window closes before the statistics are gathered for all objects.

Which statement is true in this scenario?

A. The statistics collection continues until all objects are processed.

B. The job is terminated and the statistics collected are restored to a time before the job started.

C. This produces an error and the statistics collected are locked until the next time that the maintenance window is opened.

D. The job is terminated and the statistics for the remaining objects are collected the next time that the maintenance window is opened.

Answer: D

Q5. 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

Answer: C

Q6. The instance abnormally terminates because of a power outage.

Which statement is true about redo log files during instance recovery?

A. Inactive and current redo log files are required to accomplish recovery

B. Online and archived redo files are required to accomplish instance recovery

C. All redo log entries after the last checkpoint are applied from redo log files to data files

D. All redo log entries recorded in the current log file until the checkpoint position are applied to data files

Answer: C

Q7. You perform differential incremental level 1 backups of your database on each working day and level 0 backup on Sunday to tape:

Which two statements are true about differential incremental backups? (Choose two.)

A. The backup performed on Sundays contains all the blocks that have ever been used in the database

B. The backup performed on Sundays contains all the blocks that have changed since the last level 1 backup

C. The backup performed on each working day contains all the blocks that have changed since the last level 0 backup

D. The backup performed on Monday contains all the blocks that have changed since the level 0 backup and every other working day contains all the blocks that have changed since the level 1 backup

Answer: AD

Q8. Identify the two situations in which you use the alert log file in your database to check the details. (Choose two.)

A. Running a query on a table returns "ORA-600: Internal Error."

B. Inserting a value in a table returns "ORA-01722: invalid number."

C. Creating a table returns "ORA-00955: name is already used by an existing object."

D. Inserting a value in a table returns "ORA-00001: unique constraint (SYS.PK_TECHP) violated."

E. Inserting a row in a table returns "ORA-00060: deadlock detected while waiting for resource."

Answer: AE

Q9. You want to enable archiving on your database. Presently, the database is running in NOARCHIVELOG mode.

Given below are the steps to accomplish the task in random order:

1. Shut down the instance.

2. Execute the ALTER DATABASE ARCHIVELOG command.

3. Start up the instance and mount the database.

4. Set the DB_RECOVERY_FILE_DEST initialization parameter to $ORACLE_HOME/dest_1.

5. Open the database.

Which is the correct sequence of steps for accomplishing the task?

A. 4, 1, 3, 2, 5

B. 1, 3, 4, 5, 2

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

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

E. 1, 3, 4, 5; 2 not required

Answer: C

Q10. Examine the command:

SQL>DBMS_STATS.SET_TABLE_PREFS('SH','CUSTOMERS','PUBLISH','false');

Which statement describes the effect of the above command?

A. Automatic statistics collection is stopped for the CUSTOMERS table

B. Statistics for the CUSTOMERS table are locked and cannot be overwritten

C. Existing statistics for the CUSTOMERS table become unusable for the query optimizer

D. Subsequently, statistics gathered on the CUSTOMERS table are stored as pending statistics

Answer: D

Certleader Dumps
Certleader is a company specialized on providing high quality IT exam materials and fully committed to assist our respected clients crack any IT certification tests on their 1st efforts.