网友您好， 请在下方输入框内输入要搜索的题目：
题目内容
（请给出正确答案）
单选题
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 user creates a table. 3. The SKD user grants the CREATE TABLE 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 isperformed（）
A
The table created by SKD is not accessible and 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.
参考答案
参考解析
解析：
暂无解析
更多 “单选题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 user creates a table. 3. The SKD user grants the CREATE TABLE 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 isperformed（）A The table created by SKD is not accessible and 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 user needs to create a trigger that will update table T2 whenever a row is added to table T1. Assuming the user has all appropriate privileges for table T2, which privilege is required on table T1 to create the trigger?（）A.REFERENCESB.SELECTC.UPDATED.ALTER
考题
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 user needs to create a trigger that will update table T2 whenever a row is added to table T1. Assuming the user has all appropriate privileges for table T2, which privilege is required on table T1 to create the trigger?（）A、REFERENCESB、SELECTC、UPDATED、ALTER
考题
The HR user creates a stand-alone procedure as follows and grants the EXECUTE privilege on the procedureto many database users： CREATE OR REPLACE PROCEDURE create_dept （ v_deptno NUMBER， v_dname VARCHAR2， v_mgrNUMBER， v_loc NUMBER）BEGIN INSERT INTO hr.departments VALUES （v_deptno， v_dname， v_mgr， v_loc）； END； The users having permission to execute the procedure are able to insert records into the DEPARTMENTS tableeven though they do not have the INSERT privilege on the table. You want only those users who haveprivileges on the DEPARTMENTS table to be able to execute the procedure successfully. What would yousuggest to the PL/SQL developers to achieve this（）A、Create the procedure with definer’s right.B、Create the procedure with invoker’s right.C、Grant the EXECUTE privilege with GRANT OPTION on the procedure to selected users.D、Create the procedure as part of a PL/SQL package and grant the EXECUTE privilege on the package toselected users
考题
Examine the command： SQL ALTER USER skd ACCOUNT LOCK； Which two statements are true after the command is executed（）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
考题
The HR user creates a view with this command： SQL CREATE VIEW emp_v AS SELECT * FROM scott.emp； Now HR wants to grant the SELECT privilege on the EMP_V view to the JIM user. Which statement is true in this scenario？（）A、HR can grant the privilege to JIM but without GRANT OPTION.B、HR can grant the privilege to JIM because HR is the owner of the view.C、SCOTT has to grant the SELECT privilege on the EMP table to JIM before this operation.D、HR needs the SELECT privilege on the EMP table with GRANT OPTION from SCOTT for this operation.
考题
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 user creates a table. 3. The SKD user grants the CREATE TABLE 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 isperformed（）A、The table created by SKD is not accessible and 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.
考题
Examine the command： SQL ALTER USER skd ACCOUNT LOCK； Which two statements are true after the command is executed（）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.
考题
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 assign external authentication. The user OPS$SKD has theCREATE SESSION privilege. What would you achieve 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 theusername and password.D、The database user OPS$SKD has to login with the password of the local operating system user SKD toaccess the database instance.
考题
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.
考题
You execute the following set of commands to create a database user and to grant the system privileges in your production environment. SQL CREATE USER user01 IDENTIFIED BY oracle DEFAULT TABLESPACE tbs1 TEMPORARY TABLESPACE temp PROFILE default / SQL GRANT create session， create table TO user01； While executing the command to create a table， the user gets the following error message and the CREATE TABLE.. command fails. ERROR at line 1： ORA-01950： no privileges on tablespace What could be the possible reason for this error message？（）A、The tablespace TBS1 is full.B、The user is not the owner of the SYSTEM tablespace.C、The user does not have quota on the TBS1 tablespace.D、The user does not have sufficient system privileges to create table in the TBS1 tablespace.E、The user does not have sufficient privileges to create table on the default permanent tablespace.
考题
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.
考题
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.
考题
In your multitenant container database (CDB) containing pluggable database (PDBs), you granted theCREATE TABLE privilege to the common user C # # A_ADMIN in root and all PDBs. You execute thefollowing command from the root container:SQL REVOKE create table FROM C # # A_ADMIN;What is the result?（）A、It executes successfully and the CREATE TABLE privilege is revoked from C # # A_ADMIN in root only.B、It fails and reports an error because the CONTAINER=ALL clause is not used.C、It excludes successfully and the CREATE TABLE privilege is revoked from C # # A_ADMIN in root and all PDBs.D、It fails and reports an error because the CONTAINER=CURRENT clause is not used.E、It executes successfully and the CREATE TABLE privilege is revoked from C # # A_ADMIN in all PDBs.
考题
单选题In your multitenant container database (CDB) containing pluggable database (PDBs), you granted theCREATE TABLE privilege to the common user C # # A_ADMIN in root and all PDBs. You execute thefollowing command from the root container:SQL REVOKE create table FROM C # # A_ADMIN;What is the result?（）A
It executes successfully and the CREATE TABLE privilege is revoked from C # # A_ADMIN in root only.B
It fails and reports an error because the CONTAINER=ALL clause is not used.C
It excludes successfully and the CREATE TABLE privilege is revoked from C # # A_ADMIN in root and all PDBs.D
It fails and reports an error because the CONTAINER=CURRENT clause is not used.E
It executes successfully and the CREATE TABLE privilege is revoked from C # # A_ADMIN in all PDBs.
考题
单选题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.
考题
单选题View the Exhibit and examine the privileges granted to the MGR_ROLE role. The user SKD has been grantedthe CONNECT and RESOURCE roles only. The database administrator （DBA） grants MGR_ROLE to the userSKD by executing the command： SQL GRANT MGR_ROLE TO SKD WITH ADMIN OPTION； Which statement is true about the user SKD afterhe/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 privilegesfrom them
考题
单选题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 user creates a table. 3. The SKD user grants the CREATE TABLE 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 isperformed（）A
The table created by SKD is not accessible and 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 HR user creates a view with this command： SQL CREATE VIEW emp_v AS SELECT * FROM scott.emp； Now HR wants to grant the SELECT privilege on the EMP_V view to the JIM user. Which statement is true in this scenario？（）A
HR can grant the privilege to JIM but without GRANT OPTION.B
HR can grant the privilege to JIM because HR is the owner of the view.C
SCOTT has to grant the SELECT privilege on the EMP table to JIM before this operation.D
HR needs the SELECT privilege on the EMP table with GRANT OPTION from SCOTT for this operation.
考题
单选题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.
考题
单选题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 assign external authentication. The user OPS$SKD has theCREATE SESSION privilege. What would you achieve 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 theusername and password.D
The database user OPS$SKD has to login with the password of the local operating system user SKD toaccess the database instance.
考题
多选题Examine the command： SQL ALTER USER skd ACCOUNT LOCK； Which two statements are true after the command is executed（）AThe SKD user cannot log in to the database instance.BThe objects owned by the SKD user are not accessible to any user.CThe other users can access the objects owned by the SKD user， on which they have access.DThe password for the SKD user expires and the user is forced to change the password at the next log in.
考题
单选题The HR user creates a stand-alone procedure as follows and grants the EXECUTE privilege on the procedureto many database users： CREATE OR REPLACE PROCEDURE create_dept （ v_deptno NUMBER， v_dname VARCHAR2， v_mgrNUMBER， v_loc NUMBER）BEGIN INSERT INTO hr.departments VALUES （v_deptno， v_dname， v_mgr， v_loc）； END； The users having permission to execute the procedure are able to insert records into the DEPARTMENTS tableeven though they do not have the INSERT privilege on the table. You want only those users who haveprivileges on the DEPARTMENTS table to be able to execute the procedure successfully. What would yousuggest to the PL/SQL developers to achieve this（）A
Create the procedure with definer’s right.B
Create the procedure with invoker’s right.C
Grant the EXECUTE privilege with GRANT OPTION on the procedure to selected users.D
Create the procedure as part of a PL/SQL package and grant the EXECUTE privilege on the package toselected users
考题
单选题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.
考题
单选题The ORDERS table belongs to the user OE. OE has granted the SELECT privilege on the ORDERS table to the user HR.Which statement would create a synonym ORD so that HR can execute the following query successfully?（）A
CREATE SYNONYM ord FOR orders; This command is issued by OE B
CREATE PUBLIC SYNONYM ord FOR orders; This command is issued by OE C
CREATE SYNONYM ord FOR oe.orders; This command is issued by the database administrator D
CREATE PUBLIC SYNONYM ord FOR oe.orders; This command is issued by the database administrator
考题
单选题You execute the following set of commands to create a database user and to grant the system privileges in your production environment. SQL CREATE USER user01 IDENTIFIED BY oracle DEFAULT TABLESPACE tbs1 TEMPORARY TABLESPACE temp PROFILE default / SQL GRANT create session， create table TO user01； While executing the command to create a table， the user gets the following error message and the CREATE TABLE.. command fails. ERROR at line 1： ORA-01950： no privileges on tablespace What could be the possible reason for this error message？（）A
The tablespace TBS1 is full.B
The user is not the owner of the SYSTEM tablespace.C
The user does not have quota on the TBS1 tablespace.D
The user does not have sufficient system privileges to create table in the TBS1 tablespace.E
The user does not have sufficient privileges to create table on the default permanent tablespace.
考题
单选题A user needs to create a trigger that will update table T2 whenever a row is added to table T1. Assuming the user has all appropriate privileges for table T2, which privilege is required on table T1 to create the trigger?（）A
REFERENCESB
SELECTC
UPDATED
ALTER
热门标签
最新试卷