It is impossible to pass Oracle 1Z0-052 exam without any help in the short term. Come to Pass4sure soon and find the most advanced, correct and guaranteed Oracle 1Z0-052 practice questions. You will get a surprising result by our Abreast of the times Oracle Database 11g: Administration I practice guides.

2016 Aug oracle 1z0-052:

Q91. You have two tables with referential integrity enforced between them. You need to insert data to the child table first because it is going to be a long transaction and data for the parent table will be available in a later stage, which can be inserted as part of the same transaction.

View the Exhibit to examine the commands used to create tables.

Which action would you take to delay the referential integrity checking until the end of the transaction?

Exhibit:


A. Set the constraint to deferred before starting the transaction

B. Alter the constraint to NOVALIDATE state before starting the transaction

C. Enable the resumable mode for the session before starting the transaction

D. Set the COMMIT_WAIT parameter to FORCE_WAIT for the session before starting the transaction

Answer: A


Q92. Which three operations require undo data? (Choose three.)

A. Committing a transaction

B. Flashing back a transaction

C. Recovering a failed transaction

D. Running a read-consistent query

E. Changing a tablespace status from READ ONLY to READ WRITE

Answer: BCD


Q93. Which two statements correctly describe the relation between a data file and the logical database structures? (Choose two)

A. An extent cannot spread across data files.

B. A segment cannot spread across data files.

C. A data file can belong to only one tablespace.

D. A data file can have only one segment created in it.

E. A data block can spread across multiple data files as it can consist of multiple operating system (OS) blocks.

Answer: AC


Q94. In your database, the current status of a PL/SQL procedure has become INVALID. Which action would fix the problem and make the PL/SQL procedure usable?

A. Recompile the PL/SQL procedure.

B. Modify the procedure to run with a definer's right.

C. Modify the procedure to run with an invoker's right.

D. Grant the EXECUTE privilege on the PL/SQL procedure to PUBLIC.

Answer: A


Q95. See the Exhibit:

Identify the component marked with a question mark:


A. Checkpoint (CKPT)

B. Process Monitor (PMON)

C. Archiver Processes (ARcn)

D. Recoverer Process (RECO)

E. Memory Manager Process (MMAN)

Answer: A


certifyforall.com

Down to date oracle database 11g administration i 1z0-052 pdf:

Q96. View the Exhibit to examine the output of the DBA_OUTSTANDING_ALERTS view.

After 30 minutes, you executed the following command:

SQL> SELECT reason,metric_value FROM dba_outstanding_alerts; 

REASON                        METRIC_VALUE 

------------------------------                ---------------------- 

Tablespace [TEST] is [28 perce nt] full     28.125 

What could be the reason for the elimination of the other rows in the output?

Exhibit:


A. An Automatic Workload Repository snapshot has been taken recently.

B. The non-threshold-based alerts are transferred to DBA_ALERT_HISTORY.

C. The threshold alerts conditions are cleared and the alerts are transferred to BA_ALERT_HISTORY.

D. The threshold alerts related to database metrics are permanently stored in DBA_ALERT_HISTORY but not the threshold alerts related to instance metrics.

Answer: C


Q97. User A executes the following command to drop a large table in your database:

SQL> DROP TABLE trans;

While the drop table operation is in progress; user B executes the following command on the same table;

SQL> DELETE FROM trans WHERE tr_type='SL'

Which statement is true regarding the DELETE command?

A. It fails to delete the records because the records are locked in the SHARE mode

B. It deletes the rows successfully because the table is locked in the SHARE mod

C. It fails to delete the records because the table is locked in EXCLUSIVE mode

D. It deletes the rows successfully because the table is locked in SHARE ROW EXCLUSIVE mode

Answer: C


Q98. A constraint in a table is defined with the INITIALLY IMMEDIATE clause. You executed the ALTER TABLE command with the ENABLE VALIDATE option to enable the constraint that was disabled.

What are the two effects of this command? (Choose two.)

A. It fails if any existing row violates the constraint.

B. It does not validate the existing data in the table.

C. It enables the constraint to be enforced at the end of each transaction.

D. It prevents insert, update, and delete operations on the table while the constraint is in the process of being enabled.

Answer: AD


Q99. You are in the middle of a transaction updating a very important table. The machine on which a database was running reboots because of power outage. This caused a database instance failure.

Which statement is true in this situation?

A. The online redo log files and archived redo log files are required to accomplish the recovery

B. The uncommitted transaction will be committed at the next startup of the database instance 

C. The uncommitted transaction is rolled back automatically at the next opening of the database

D. The DBA has to perform the recovery on the database to recover the uncommitted transaction

Answer: C


Q100. You set the following parameters in the parameter file and restarted the database:

MEMORY_MAX_TARGET=0

MEMORY_TARGET=500M

PGA_AGGREGATE_TARGET=90M

SGA_TARGET=270M

Which two statements are true about these parameters after the database instance is restarted?

(Choose two.)

A. The MEMORY_MAX_TARGET parameter is automatically set to 500 MB.

B. The PGA_AGGREGATE_TARGET and SGA_TARGET parameters are automatically set to zero.

C. The value of the MEMORY_MAX_TARGET parameter remains zero until it is changed manually.

D. The lower bounds of PGA_AGGREGATE_TARGET and SGA_TARGET parameters are set to 90 MB and 270 MB, respectively.

Answer: AD