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





Question ID 21876

Examine the command that is used to create a table:
SQL> CREATE TABLE orders (
oid NUMBER(6) PRIMARY KEY,
odate DATE,
ccode NUMBER (6),
oamt NUMBER(10,2)
) TABLESPACE users;
Which two statements are true about the effect of the above command? (Choose two.)

Option A

A CHECK constraint is created on the OID column.

Option B

A NOT NULL constraint is created on the OID column.

Option C

The ORDERS table is the only object created in the USERS tablespace.

Option D

The ORDERS table and a unique index are created in the USERS tablespace.

Option E

The ORDERS table is created in the USERS tablespace and a unique index is created on the OID column
in the SYSTEM tablespace.

Correct Answer B,D
Explanation


Question ID 21877

Which two statements are true about Shared SQL Area and Private SQL Area? (Choose two.)

Option A

Shared SQL Area will be allocated in the shared pool

Option B

Shared SQL Area will be allocated when a session starts

Option C

Shared SQL Area will be allocated in the large pool always

Option D

The whole of Private SQL Area will be allocated in the Program Global Area (PGA) always

Option E

Shared SQL Area and Private SQL Area will be allocated in the PGA or large pool

Option F

The number of Private SQL Area allocations is dependent on the OPEN_CURSORS parameter

Correct Answer A,F
Explanation

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