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





Question ID 21723

Which two statements are true about extents?

Option A

Blocks belonging to an extent can be spread across multiple data files.

Option B

Data blocks in an extent are logically contiguous but can be non-contiguous on disk.

Option C

The blocks of a newly allocated extent, although free, may have been used before.

Option D

Data blocks in an extent are automatically reclaimed for use by other objects in a tablespaee when all the rows in a table are deleted.

Correct Answer B,C
Explanation


Question ID 21724

You execute the commands:
SQL>CREATE USER sidney
IDENTIFIED BY out_standing1
DEFAULT TABLESPACE users
QUOTA 10M ON users
TEMPORARY TABLESPACE temp
ACCOUNT UNLOCK;
SQL> GRANT CREATE SESSION TO Sidney;
Which two statements are true?

Option A

The create user command fails if any role with the name Sidney exists in the database.

Option B

The user sidney can connect to the database instance but cannot perform sort operations because no space quota is specified for the temp tablespace.

Option C

The user sidney is created but cannot connect to the database instance because no profile is default.

Option D

The user sidney can connect to the database instance but requires relevant privileges to create objects in the users tablespace.

Option E

The user sidney is created and authenticated by the operating system.

Correct Answer A,D
Explanation Reference: http://docs.oracle.com/cd/B28359_01/server.111/b28286/statements_8003.htm

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