Skip to content

Tag: 1Z0-031 exam

Passleader Latest Sample Questions for Oracle 1Z0-031 Test (121-130)

QUESTION 121:
You executed the following command to resize a data file, sales.dbf, of size 200MB in your database:
ALTER DATABASE DATAFILE /remorse/sales.dbf RESIZE 150M;
What would be the effect of this command?

A.The command succeeds and the data beyond 150 MB is lost.
B.The command succeeds if no extent in the tablespace is currently allocated above the 150 MB boundary of the file.
C.The command fails because it is not possible to reduce the size of the data file.
D.The command fails because it is possible to reduce only the size of the system data file.

Comments closed

Passleader Latest Sample Questions for Oracle 1Z0-031 Test (21-30)

QUESTION 21:
You specified extent management as local for a tablespace. How will this affect space management in the tablespace?

A.Bitmap will be used to record free and allocated extents.
B.Free extents will be managed by the data dictionary tables.
C.The tablespace can have extents containing blocks of different sizes.
D.The tablespace will be system managed and the users cannot specify the extent size.

Comments closed