Latest Certified Success Dumps Download

CISCO, MICROSOFT, COMPTIA, HP, IBM, ORACLE, VMWARE
1z0-052 DUMPS

Latest Oracle 1Z0-052 Real Exam Download 61-70

August 21, 2013

Ensurepass

QUESTION 61

Automatic Shared Memory Management is disabled for your database instance. You realize that there are cases of SQL statements performing poorly because of repeated parsing activity, resulting in degradation of performance. What would be your next step to improve performance?

 

A.      Run the SQL Access Advisor.

B.      Run the memory Advisor for the SGA.

C.      Run the memory Advisor for the PGA.

D.      Run the memory advisor for the shared pool.

E.       Run the memory advisor for the buffer cache.

 

Answer: D

 

 

QUESTION 62

View the Exhibit and examine the parameters. User A executes the following command to update the TRANS table:

 

SQL> UPDATE B.trans SET tr_amt=tr_amt+500 WHERE c_code=’C005′;

 

Before user A issues a COMMIT or ROLLBACK command, user B executes the following command on the TRANS table:

 

SQL> ALTER TABLE trans MODIFY (tr_type VARCHAR2(3));

 

What would happen in this scenario?

 

clip_image002

 

A.      The ALTER TABLE command modifies the column successfully.

B.      The DDL operation gets higher priority and transaction for user A is rolled back.

C.      The ALETER TABLE command waits indefinitely until user A ends the transaction.

D.      The ALTER TABLE command fails after waiting for 60 seconds due to the resource being busy.

 

Answer: D

 

 

QUESTION 63

Which two files in the database can be configured for automatic backups by using the autobackup feature in Recovery Manager (RMAN)? (Choose two.)

 

A.      Data Files

B.      Control Files

C.      Parameter Files

D.      Online Redo Log Files

E.       Server Parameter File

 

Answer: BE

 

 

QUESTION 64

Which two statements are true regarding the usage of the SQL*LOADER utility? (Choose two.)

 

A.      You can load data into multiple tables during the same load session.

B.      You can load data from multiple files to a table during the same load session.

C.      You cannot perform selective data loading based on the values available in the records.

D.      You can use an export file generated by the EXPDP utility as an input data file to load the data.

E.       You can load data only if the input file is available on the disk and tape but not a named pipes.

 

Answer: AB

 

 

QUESTION 65

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

 

 

 

QUESTION 66

Note the following structures in your database server:

 

1.       Extents

2.       OS Blocks

3.       Tablespace

4.       Segments

5.       Oracle Data Block

 

Which option has the correct arrangement of these structures from the smallest to the largest?

 

A.      2, 5, 1, 4, 3

B.      1, 2, 3, 4, 5

C.      5, 2, 1, 3, 4

D.      2, 1, 5, 4, 3

 

Answer: A

 

 

QUESTION 67

You want to access employee details contained in flat files as part of the EMPLOYEE table. You plan to add a new column to the EMPLOYEE table to achieve this. Which data types would you use for the new column?

 

A.      CLOB

B.      BLOB

C.      BFILE

D.      LONG RAW

 

Answer: C

 

 

QUESTION 68

You are managing an Oracle Database 11g database with the following backup strategy:

 

1.       On Sunday, an incremental level 0 tape backup is performed.

2.       Monday through Saturday, a cumulative incremental level 1 tape backup is performed.

 

Which two statements are true regarding the backups performed? (Choose two.)

 

A.      The backup performed in step 1 backs up all blocks that have ever been in use in the database.

B.      The backup performed in step 2 copies all the blocks changed since the most recent level 0 backup.

C.      The backup performed in step 1 backs up all the blocks changed since the most recent level 1 backup.

D.      The backup performed in step 2 backs up all blocks that have changed since the most recent incremental backup at level 1.

 

Answer: AB

 

 

QUESTION 69

View the Exhibit and examine the attributes of an undo tablespace. In an OLTP system, the user SCOTT has started a query on a large table in the peak transactional hour that performs bulk inserts. The query runs for more than 15 minutes and then SCOTT receives the following error:

 

ORA-01555: snapshot too old

 

What could be the reason for this error?

 

clip_image004

 

A.      The query is unable to get a read-consistent image.

B.      There is not enough space in Flash Recovery Area.

C.      There is not enough free space in the flashback archive.

D.      The query is unable to place data blocks in undo tablespace.

 

Answer: A

 

 

QUESTION 70

Which two operations can be performed on an external table? (Choose two.)

 

A.      Create a view on the table

B.      Create an index on the table

C.      Create a synonym on the table

D.      Add a virtual column to the table

E.       Update the table using the UPDATE statement

F.       Delete rows in the table using the DELETE command

 

Answer: AC

 




Download Latest Oracle 1Z0-052 Real Free Tests , help you to pass exam 100%.