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-050





Question ID 1879

You issued the following command:
CREATE GLOBAL TEMPORARY TABLE admin
_    work area

(startdate DATE,
enddate DATE,
class CHAR(20))
ON COMMIT DELETE ROWS
TABLESPACE tbs_t1;
An index is then created on the ADMIN_WORK_AREA temporary table.
Which two statements are true regarding the TBS_T1 tablespace in the above command? (Choose two.)
 

Option A

A.    It stores only the temporary table but not its indexes.

 

Option B

B.    It stores both the temporary table as well as its indexes.
 

Option C

C.    It must be a nondefault temporary tablespace for the database.
 

Option D

D.    It can be a default or nondefault temporary tablespace for the database.
 

Option E

E.    It must be the default temporary tablespace of the user who issues the command.

Correct Answer B,D
Explanation


Question ID 1880

Identify the activities performed as part of the Automatic SQL Tuning process in the maintenance window? (Choose al that apply.)

Option A

A.    generating the SQL profile
 

Option B

B.    testing and accepting the SQL profile
 

Option C

C.    generating a list of candidate SQLs fortuning
 

Option D

D.    adding tuned SQL plans into the SQL plan baseline
 

Option E

E.    tuning each SQL statement in the order of importance F- generating baselines that include candidate SQLs fortuning
 

Correct Answer A,B,C,E
Explanation

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