网友您好， 请在下方输入框内输入要搜索的题目：
题目内容
（请给出正确答案）
What is true about the WITH GRANT OPTION clause?（）
- A、It allows a grantee DBA privileges.
- B、It is required syntax for object privileges.
- C、It allows privileges on specified columns of tables.
- D、It is used to grant an object privilege on a foreign key column.
- E、It allows the grantee to grant object privileges to other users and roles.
参考答案
更多 “What is true about the WITH GRANT OPTION clause?（）A、It allows a grantee DBA privileges.B、It is required syntax for object privileges.C、It allows privileges on specified columns of tables.D、It is used to grant an object privilege on a foreign key column.E、It allows the grantee to grant object privileges to other users and roles.” 相关考题
考题
The DBA issues this SQL command:What privileges does the user Scott have at this point?()
A. No privileges.B. Only the SELECT privilege.C. Only the CONNECT privilege.D. All the privileges of a default user.
考题
Examine the statement:GRANT select, insert, updateON student_gradesTO managerWITH GRANT OPTION;Which two are true?()
A. MANAGER must be a role.B. It allows the MANAGER to pass the specified privileges on to other users.C. It allows the MANAGER to create tables that refer to the STUDENT_GRADES table.D. It allows the MANAGER to apply all DML statements on the STUDENT_GRADES table.E. It allows the MANAGER the ability to select from, insert into, and update the STUDENT_GRADES table.F. It allows the MANAGER the ability to select from, delete from, and update the STUDENT_GRADES table.
考题
Which three statements are true about the working of system privileges in a multitenant control database(CDB) that has pluggable databases (PDBs)?()
A. System privileges apply only to the PDB in which they are used.B. Local users cannot use local system privileges on the schema of a common user.C. The granter of system privileges must possess the set container privilege.D. Common users connected to a PDB can exercise privileges across other PDBs.E. System privileges with the with grant option container all clause must be granted to a common user before the common user can grant privileges to other users.
考题
What stage can the following grammar activity be used at?
The teacher asked students to arrange the words of sentences into different columns marked subject, predicate, object, object complement, adverbial and so on．A.Presentation．
B.Practice．
C.Production．
D.Preparation．
考题
What is true about the grant?A. It is for more than $1 million.
B. It is an extension of an existing grant.
C. It is awarded by the Bridgeport Revitalization Committee.
D. It is the largest the BRC has ever received.
考题
The user SCOTT who is the owner of ORDERS and ORDERJTEMS tables issues the following GRANT command： GRANT ALL ON orders， order_items TO PUBLIC； What correction needs to be done to the above statement？ （）A、 PUBLIC should be replaced with specific usernames.B、 ALL should be replaced with a list of specific privileges.C、 WITH GRANT OPTION should be added to the statement.D、 Separate GRANT statements are required for ORDERS and ORDERJTEMS tables.
考题
What allows the programmer to destroy an object x？（） A、 x.delete（）B、 x.finalize（）C、 Runtime.getRuntime（）.gc（）D、 Explicitly setting the object’s reference to null.E、 Ensuring there are no references to the object.F、 Only the garbage collection system can destroy an object.
考题
In your Certkiller .com production database， you find that the database users are able to create and read files with unstructured data， available in any location on the host machine from an application. You want to restrict the database users to access files in a specific location on the host machine. What could do to achieve this？（）A、Modify the value for the UTL_FILE_DIR parameter in the parameter fileB、Grant read and write privilege on the operating system path to the database usersC、Modify the value for the LDAP_DIRECTORY_ACCESS parameter in the parameter fileD、Modify the value for the PLSQL_NATIVE_LIBRARY_DIR parameter in the parameter fileE、Create a directory object referring to the operating system path， and grant read and write privilege on the directory object to the database users
考题
You are the DBA for an academic database. You need to create a role that allows a group of users to modify existing rows in the STUDENT_GRADES table.Which set of statements accomplishes this?（）A、CREATE ROLL registrar; GRANT MODIFY ON student_grant TO registrar; GRANT registrar to user 1, user2, user3B、CREATE NEW ROLE registrar; GRANT ALL ON student_grant TO registrar; GRANT registrar to user 1, user2, user3C、CREATE ROLL registrar; GRANT UPDATE ON student_grant TO registrar; GRANT ROLE to user1, user2, user3D、CREATE ROLL registrar; GRANT UPDATE ON student_grant TO registrar; GRANT registrar to user 1, user2, user3;E、CREATE registrar; GRANT CHANGE ON student_grant TO registrar; GRANT registrar;
考题
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 DBA issues this SQL command: CREATE USER scott IDENTIFIES by tiger; What privileges does the user Scott have at this point?（）A、No privileges.B、Only the SELECT privilege.C、Only the CONNECT privilege.D、All the privileges of a default user.
考题
You need to give the MANAGER role the ability to select from, insert into, and modify existing rows in the STUDENT_GRADES table. Anyone given this MANAGER role should be able to pass those privileges on to others. Which statement accomplishes this? （）A、GRANT select, insert, update ON student_grades TO managerB、GRANT select, insert, update ON student_grades TO ROLE managerC、GRANT select, insert, modify ON student_grades TO manager WITH GRANT OPTION;D、GRANT select, insert, update ON student_grades TO manager WITH GRANT OPTION;E、GRANT select, insert, update ON student_grades TO ROLE manager WITH GRANT OPTION;F、GRANT select, insert, modify ON student_grades TO ROLE manager WITH GRANT OPTION;
考题
In your multitenant container database (CDB) containing pluggable database (PDBs), the HR user executes the following commands to create and grant privileges on a procedure: CREATE OR REPLACE PROCEDURE create_test_v (v_emp_id NUMBER, v_ename VARCHAR2,v_SALARY NUMBER, v_dept_id NUMBER) BEGIN INSERT INTO hr.test VALUES (V_emp_id, V_ename, V_salary, V_dept_id); END; / GRANT EXECUTE ON CREATE_TEST TO john, jim, smith, king; How can you prevent users having the EXECUTE privilege on the CREATE_TEST procedure from inserting values into tables on which they do not have any privileges?（）A、Create the CREATE_TEST procedure with definer’s rights.B、Grant the EXECUTE privilege to users with GRANT OPTION on the CREATE_TEST procedure.C、Create the CREATE_TEST procedure with invoker’s rights.D、Create the CREATE_TEST procedure as part of a package and grant users the EXECUTE privilege the package.
考题
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.
考题
While creating a scheduler window using the DBMS_SCHEDULER package， a user logged in as DBMGR gets the error message insufficient privileges？ Which two commands would you use to resolve this error？（）A、 GRANT dba TO dbmgr；B、 GRANT connect TO dbmgr；C、 GRANT resource TO dbmgr；D、 GRANT hs_admin_role TO dmbgr；E、 GRANT manage scheduler TO dbmgr；
考题
You have been asked to create three users， PUB1， PUB2 and PUB3， for three newly hired employees and to allocate unlimited quota on their default tablespace PUBLISHER_TBS with no other privileges. After creating the users， which method can you use for granting the required privileges？（）A、grant CONNECT role to all of the three usersB、grant RESOURCE role to all of the three usersC、grant both CONNECT and RESOURCE role to all of the three usersD、execute ALTER USER .. QUOTA UNLIMITED ON publisher_tbs command for all of the three usersE、create role with UNLIMITED TABLESPACE system privilege and assign the role to all of the three users
考题
Which three statements are true about the working of system privileges in a multitenant control database(CDB) that has pluggable databases (PDBs)?（）A、System privileges apply only to the PDB in which they are used.B、Local users cannot use local system privileges on the schema of a common user.C、The granter of system privileges must possess the set container privilege.D、Common users connected to a PDB can exercise privileges across other PDBs.E、System privileges with the with grant option container all clause must be granted to a common user before the common user can grant privileges 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.
考题
Examine these statements: CREATE ROLE registrar GRANT UPDATE ON dtudent_grades TO registrar; GRANT registrar to user1, user2, user3; What does this set of SQL statements do?（）A、The set of statements contains an error and does not work.B、It creates a role called REGISTRAR, adds the MODIFY privilege on the STUDENT_GRADES object to the role, and gives the REGISTRAR role to three users.C、It creates a role called REGISTRAR, adds the UPDATE privilege on the STUDENT_GRADES object to the role, and gives the REGISTRAR role to three users.D、It creates a role called REGISTRAR, adds the UPDATE privilege on the STUDENT_GRADES object to the role, and creates three users with the role.E、It creates a role called REGISTRAR, adds the UPDATE privilege on three users, and gives the REGISTRAR role to the STUDENT_GRADES object.F、It creates a role called STUDENT_GRADES, adds the UPDATE privilege on three users, and gives the UPDATE role to the registrar.
考题
单选题What allows the programmer to destroy an object x？（）A
x.delete（）B
x.finalize（）C
Runtime.getRuntime（）.gc（）D
Explicitly setting the object’s reference to null.E
Ensuring there are no references to the object.F
Only the garbage collection system can destroy an object.
考题
单选题The user SCOTT who is the owner of ORDERS and ORDERJTEMS tables issues the following GRANT command： GRANT ALL ON orders， order_items TO PUBLIC； What correction needs to be done to the above statement？ （）A
PUBLIC should be replaced with specific usernames.B
ALL should be replaced with a list of specific privileges.C
WITH GRANT OPTION should be added to the statement.D
Separate GRANT statements are required for ORDERS and ORDERJTEMS tables.
考题
单选题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
考题
单选题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.
考题
单选题Examine these statements: CREATE ROLE registrar GRANT UPDATE ON dtudent_grades TO registrar; GRANT registrar to user1, user2, user3; What does this set of SQL statements do? （）A
The set of statements contains an error and does not work.B
It creates a role called REGISTRAR, adds the MODIFY privilege on the STUDENT_GRADES object to the role, and gives the REGISTRAR role to three users.C
It creates a role called REGISTRAR, adds the UPDATE privilege on the STUDENT_GRADES object to the role, and gives the REGISTRAR role to three users.D
It creates a role called REGISTRAR, adds the UPDATE privilege on the STUDENT_GRADES object to the role, and creates three users with the role.E
It creates a role called REGISTRAR, adds the UPDATE privilege on three users, and gives the REGISTRAR role to the STUDENT_GRADES object.F
It creates a role called STUDENT_GRADES, adds the UPDATE privilege on three users, and gives the UPDATE role to the registrar.
考题
多选题Examine the statement: GRANT select, insert, update ON student_grades TO manager WITH GRANT OPTION; Which two are true?（）AMANAGER must be a role.BIt allows the MANAGER to pass the specified privileges on to other users.CIt allows the MANAGER to create tables that refer to the STUDENT_GRADES table.DIt allows the MANAGER to apply all DML statements on the STUDENT_GRADES table.EIt allows the MANAGER the ability to select from, insert into, and update the STUDENT_GRADES table.FIt allows the MANAGER the ability to select from, delete from, and update the STUDENT_GRADES table.
考题
单选题What is true about the WITH GRANT OPTION clause?（）A
It allows a grantee DBA privileges.B
It is required syntax for object privileges.C
It allows privileges on specified columns of tables.D
It is used to grant an object privilege on a foreign key column.E
It allows the grantee to grant object privileges to other users and roles.
考题
单选题What stage can the following grammar activity be used at? The teacher askes students to arrange the words of sentences into different columns marked subject, predicate, object, object complement, adverbial and so on. _____A
PresentationB
PracticeC
ProductionD
Preparation
热门标签
最新试卷