Oracle Database 12cR2 Administration: 1Z0-072

Which three statements are true about an spfile? (Choose three)

A. It contains only static initialization parameters.

B. It is the first file processed at instance startup.

C. It can be edited by SYS when the database instance is shut down.

D. It must exist for a database instance to start.

E. It can be used to create a pfile.

F. It contains initialization parameters whose values can be changed using the ALTER SYSTEM command.

Which statement is true about smallfile tablespaces?

A. Extent location metadata is stored in the data dictionary by default.

B. The number of data files is constrained only by the size of the storage array.

C. Maximum file size can be set to unlimited only if the logical volume manager supports striping.

D. Segments can span multiple tablespaces.

E. Segments can span multiple data files.

Which is true about roles?

A. A role can be granted to other roles.

B. Roles can be created only by SYS or SYSTEM.

C. Roles containing object privileges can be created only by the object owner.

D. All roles belong to the SYSTEM schema.

E. A role can be password-protected only if it has been granted system privileges.