A.Create the role with global authentication.
B.Create the role with external authentication.
C.Create the role as a secure application role.
D.Create the role as a password-protected role.
E.Create a role and use Fine-Grained Access Control （FGAC） to secure the role.

A.The commands execute successfully.
B.Command 6 produces an error because of circular role grant.
C.Command 5 produces an error because a role cannot be granted to another role.
D.Command 3 produces an error because the MGRROLE role already contains system privileges.
E.The table created by HR remains and HR still has the CREATE TABLE system privilege.
F.The table created by HR remains and HR can grant the CREATE TABLE system privilege to other users.

A.The table created by SKD isnot accessibleand SKD cannot create new tables.
B.The tables created by SKD and HR remain， but both cannot create new tables.
C.The table created by HR remains and HR still has the CREATE TABLE system privilege.
D.The table created by HR remains and HR can grant the CREATE TABLE system privilege to other users.

A.The command fails because SCOTT still has privileges.
B.The command succeeds and privileges are revoked from JIM.
C.The command fails because HR cannot revoke the privileges from JIM.
D.The command succeeds and only HR has the privilege to perform the SELECT， INSERT， and UPDATEoperations on the EMP table.

A.The user SKD can grant only the MGR_ROLE role to other users， but not the privileges in it. 
B.The user SKD can revoke the MGR_ROLE only from the users for whom he/she is the grantor.
C.The user SKD can grant the privileges in the MGR_ROLE role to other users， but not with ADMIN OPTION.
D.The user SKD can grant the privileges in the MGR_ROLE role to other users， but cannot revoke privileges from them.

A.The database user OPS$SKD will be able to administer the database.
B.The authentication detail for the database user OPS$SKD is recorded in the password file.
C.The local operating system user SKD will be able to access the database instance without specifying the username and password.
D.The database user OPS$SKD has to login with the password of the local operating system user SKD to access the database instance.

A.The SKD user cannot log in to the database instance.
B.The objects owned by the SKD user are not accessible to any user.
C.The other users can access the objects owned by the SKD user， on which they have access.
D.The password for the SKD user expires and the user is forced to change the password at the next log in.

A.The user is authenticated by the operating system.
B.The objects created by the user are placed in the USERS tablespace.
C.The user does not require quota on the TEMP tablespace to perform sort operations.
D.The user is forced to change the password at the first login to the database instance.
E.The objects created by the user in future are unlocked to be accessed by all the users in the database by defa

A.Add a data file to the SMD tablespace.
B.Add a data file to the temporary tablespace associated with the user HR.
C.Resize the data file associated with the SMD tablespace to make it larger.
D.Alter the data file associated with the SMD tablespace to grow automatically.
E.Change the segment space management for the SMD tablespace to automatic. n segments is managed through free lists.

A.The database automatically determines the extent-sizing policy for the tablespace.
B.The segments are automatically shrunk when the contents are removed from them.
C.The allocation of extents within the tablespace is managed through the dictionary tables.
D.The space utilization description of the data blocks in segments is recorded inbitmapblocks.
E.The space utilization description of the data blocks in segments is managed through free lists.MANUAL

A.A bitmap is used to record free extents.
B.Free extents information is managed within the tablespace.
C.Free extents information is managed in the SYSAUX tablespace.
D.The data dictionary tables are updated when extents are allocated or deallocated