Examine the commands executed in the following sequence：
1：SQL> CREATE ROLE mgrrole；
2：SQL> GRANT create user，select any table，connect，resource TO mgrrole；
3：SQL> GRANT select，update ON sh.sales TO mgrrole；
4：SQL> CREATE ROLE ceo IDENTIFIED BY boss；
5：SQL> GRANT mgrrole，drop any table，create any directory TO ceo；
6：SQL> GRANT ceo TO mgrrole；
Which statement is true about the above commands（）
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.
您可能感兴趣的试卷
你可能感兴趣的试题
Examine the following steps performed on a database instance：
1：The DBA grants the CREATE TABLE system privilege to the SKD user with ADMIN OPTION.
2：The SKD usercreates a table.
3：The SKD user grants theCREATETABLE system privilege to the HR user.
4：The HR user creates a table.
5：The DBA revokes the CREATE TABLE system privilege from SKD.
Which statement is true after step 5 is performed（）
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.
The user HR owns the EMP table. The user HR grants privileges to the user SCOTT by using this command：
SQL> GRANT SELECT，INSERT，UPDATE ON emp TO scott WITH GRANT OPTION； The user SCOTT executes this command to grant privileges to the user JIM： SQL> GRANT SELECT，INSERT，UPDATE ON hr.emp TO jim；
Now， the user HR decides to revoke privileges from JIM using this command： SQL> REVOKE SELECT，INSERT，UPDATE ON emp FROM jim； Which statement is true after HR issues the REVOKE command（）
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.
View the Exhibit and examine the privileges granted to the MGR_ROLE role.
The user SKD has been granted the CONNECT and RESOURCE roles only. The database administrator （DBA） grants MGR_ROLE to the user SKD by executing the command： SQL> GRANT MGR_ROLE TO SKDWITH ADMIN OPTION；
Which statement is true about the user SKD after he/she is granted this role（）
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.
The database instance has the following parameter setting： OS_AUTHENT_PREFIX = OPS$ OS_ROLES = FALSE
REMOTE_OS_AUTHENT = FALSE REMOTE_OS_ROLES = FALSE TIMED_OS_STATISTICS = 0
You have a local operating system user SKD. You create a database user OPS$SKD， and then
assignexternal authentication. The user OPS$SKD has the CREATE SESSION privilege.
What would youachieve by the above process（）
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.
View the Exhibit1， which shows the options that are selected to create the user SL_REP.
Which two statements are true regarding this user（）
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
The user HR receives the following error while inserting data into the TTK table： ERROR at line 1：
ORA-01653： unable to extend table HR.TTK by 128 in tablespace SMDUpon
investigation， you find that SMD is a small file tablespace.
Which three action would allow the user to insert data（）
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.
You executed the following command to create a tablespace called SALES_DATA：
> CREATE TABLESPACE sales_data DATAFILE SIZE 100M SEGMENT SPACE MANAGEMENT AUTO；
Which two statements are true about the SALES_DATA tablespace （）
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
Which statements are true regarding the USERS tablespace（）
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
You want to create a tablespace to contain objects with block size 16 KB. But while configuring thestorage you find that the block size that you can provide is only 8 KB.
Which configuration could have enabled the block selection of 16 KB（）
A.choosing the extent allocation type to uniform
B.choosing the Segment Space Management option to manual
C.setting autoextension on for the data file mentioned for the tablespace
D.setting the DB_16K_CACHE_SIZE parameter for the database instance to a nonzero value
最新试题
The database instance has the following parameter setting：OS_AUTHENT_PREFIX = OPS$ OS_ROLES = FALSE REMOTE_OS_AUTHENT = FALSEREMOTE_OS_ROLES = FALSE TIMED_OS_STATISTICS = 0 You have a local operating system user SKD.You create a database user OPS$SKD， and then assign external authentication. The user OPS$SKD has theCREATE SESSION privilege. What would you achieve by the above process（）
Which kinds of failures make the Data Recovery Advisor （DRA） generate a manual checklist？（）
You have two database servers SEMP and SACCT. The database in the SEMP server maintains the employeeinformation and the database in the SACCT server maintains the accounts payable information. The employeessubmit the expense reports to the accounts payable department. A user of the accounts payable databasewants to extract the employee information from the database in the SEMP server for cross-verification. Whichschema object enables the user to access the information from the remote database（）
Which statements are true regarding listeners（）
View the Exhibit to examine the output of the DBA_OUTSTANDING_ALERTS view. After 30 minutes, youexecuted the following command:SQL> SELECT reason,metric_value FROM dba_outstanding_alerts; REASON METRIC_VALUE------------------------------ ---------------------- Tablespace [TEST] is [28 perce 28.125 nt] fullWhat could be the reason for the elimination of the other rows in the output（）
Your database is functional with a peak load for the last one hour. You want to preserve the performancestatistics collected during this period to be used for comparison when you analyze the performance of thedatabase in the future. What action would you take to achieve this task（）
You want to configure and schedule offline database backups to run automatically. Which tool or utility wouldyou use to achieve this（）
View the Exhibit. You are creating an additional database by using the Database Configuration Assistant（DBCA）. You opted to create a General Purpose database and during the database creation realize that theBlock Size field is not enabled. What could be the reason for this（）
Which statements are correct about temporary tables（）
You set the following parameters in the parameter file and restarted the database：MEMORY_MAX_TARGET=0MEMORY_TARGET=500MPGA_AGGREGATE_TARGET=90MSGA_TARGET=270MWhich two statements are true about these parameters after the database instance is restarted（）