AllExam Dumps

DUMPS, FREE DUMPS, VCP5 DUMPS| VMWARE DUMPS, VCP DUMPS, VCP4 DUMPS, VCAP DUMPS, VCDX DUMPS, CISCO DUMPS, CCNA, CCNA DUMPS, CCNP DUMPS, CCIE DUMPS, ITIL, EXIN DUMPS,


READ Free Dumps For Oracle- 1z0-060





Question ID 2139

Your are the DBA supporting an Oracle 11g Release 2 database and wish to move a table containing several DATE, CHAR, VARCHAR2, and NUMBER data types, and the table’s indexes, to another tablespace.
The table does not have a primary key and is used by an OLTP application.
Which technique will move the table and indexes while maintaining the highest level of availability to the application?
 

Option A

A.    Oracle Data Pump.
 

Option B

B.    An ALTER TABLE MOVE to move the table and ALTER INDEX REBUILD to move the indexes.
 

Option C

C.    An ALTER TABLE MOVE to move the table and ALTER INDEX REBUILD ONLINE to move the indexes.
 

Option D

D.    Online Table Redefinition.

 

Option E

E.    Edition-Based Table Redefinition.

Correct Answer D,E
Explanation


Question ID 2140

To implement Automatic Management (AMM), you set the following parameters:

When you try to start the database instance with these parameter settings, you receive the following error message:
 
SQL > startup
ORA-00824: cannot set SGA TARGET or MEMORY_TARGET due to existing internal settings, see alert log for more information.
Identify the reason the instance failed to start.
 

Option A

A.    The PGA_AGGREGATE_TARGET parameter is set to zero.
 

Option B

B.    The STATISTICS_LEVEL parameter is set to BASIC.
 

Option C

C.    Both the SGA_TARGET and MEMORY_TARGET parameters are set.

 

Option D

D.    The SGA_MAX_SIZE and SGA_TARGET parameter values are not equal

Correct Answer B
Explanation

Send email to admin@getfreedumps for new dumps request!!!