单选题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.

单选题
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.


参考解析

解析: 暂无解析

相关考题:

The user Alice wants to grant all users query privileges on her DEPT table. Which SQL statement accomplishes this? () A. GRANT select ON dept TO ALL_ USER;B. GRANT select ON dept TO ALL;C. GRANT QUERY ON dept TO ALL_USERSD. GRANT select ON dept TO PUBLIC;

The DBA issues this SQL command: CREATE USER scott IDENTIFIED by tiger; What privileges does the user Scott have at this point?() A. no privilegesB. only the SELECT privilegeC. only the CONNECT privilegeD. all the privileges of a default user

The user Sue issues this SQL statement:GRANT SELECT ON sue. EMP TO alice WITH GRANT OPTION; The user Alice issues this SQL statement:GRANT SELECT ON sue. EMP TO reena WITH GRANT OPTION; The user Reena issues this SQL statement:GRANT SELECT ON sue. EMP TO timber;The user Sue issues this SQL statement:REVOKE select on sue. EMP FROM alice;For which users does the revoke command revoke SELECT privileges on the SUE.EMP table?()A. Alice onlyB. Alice and ReenaC. Alice, Reena, and TimberD. Sue, Alice, Reena, and Timber

Scott issues the SQL statements:CREATE TABLE dept(deptno NUMBER(2),dname VARCHAR2(14),loc VARCHAR2(13)};GRANT SELECTON DEPTT0 SUE;If Sue needs to select from Scott‘s DEPT table, which command should she use?()A.SELECT*FROMDEPT;B.SELECT*FROMSCOTT.DEPT;C.SELECT*FROMDBASCOTTDEPT;D.SELECT*FROMALL_USERSWHEREUSER_NAME=‘;SCOTT‘;ANDTABLENAME=‘;DEPT‘;;

Which of the following describes the BEST course of action when a user continuously calls atechnician with computer issues instead of the helpdesk?() A. Put all other work orders on hold and assist the user with all their computer issues.B. Have another technician take over support calls for this user.C. Explain that the user needs to fill out a work order for the computer problems.D. Ask the user to call another technician for more in-depth assistance.

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.

Which of the following describes the BEST course of action when a user continuously calls atechnician with computer issues instead of the helpdesk?()A、Put all other work orders on hold and assist the user with all their computer issues.B、Have another technician take over support calls for this user.C、Explain that the user needs to fill out a work order for the computer problems.D、Ask the user to call another technician for more in-depth assistance.

The user Alice wants to grant all users query privileges on her DEPT table. Which SQL statement accomplishes this?()A、GRANT select ON dept TO ALL_ USER;B、GRANT select ON dept TO ALL;C、GRANT QUERY ON dept TO ALL_USERSD、GRANT select ON dept TO PUBLIC;

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 Sue issues this SQL statement: GRANT SELECT ON sue. EMP TO alice WITH GRANT OPTION; The user Alice issues this SQL statement: GRANT SELECT ON sue. EMP TO reena WITH GRANT OPTION; The user Reena issues this SQL statement: GRANT SELECT ON sue. EMP TO timber; The user Sue issues this SQL statement: REVOKE select on sue. EMP FROM alice; For which users does the revoke command revoke SELECT privileges on the SUE.EMP table?()A、Alice onlyB、Alice and ReenaC、Alice, Reena, and TimberD、Sue, Alice, Reena, and Timber

The DBA issues this SQL command:CREATE USER scott IDENTIFIED by tiger;What privileges does the user Scott have at this point?()A、no privilegesB、only the SELECT privilegeC、only the CONNECT privilegeD、all the privileges of a default user

You executed the following command to drop a user: DROP USER scott CASCADE; Which two statements regarding the above command are correct?()A、All the objects of scott are moved to the Recycle Bin.B、Any objects in the Recycle Bin belonging to scott are purged.C、All the objects owned by scott are permanently dropped from the database.D、All the objects of scott in the Recycle Bin must be purged before executing the DROP command.E、Any objects in the Recycle Bin belonging to scott will not be affected by the above DROP command.

You issue the following code:    EXEC DBMS_RESOURCE_MANAGER_PRIVS.GRANT_SWITCH_CONSUMER_GROUP        (’SCOTT’ ’GRP1’, TRUE);   What will be the result of executing the above code?()  A、 The switch privilege will be granted to the user, Scott, for changing the consumer group to GRP1.B、 The switch privilege will be granted to the user, Scott, for changing the consumer group from GRP1 to any other group.C、 The code will not execute successfully because there is no GRANT_SWITCH_CONSUMER_GROUP procedure in the DBMS_RESOURCE_MANAGER_PRIVS package.D、The code will execute successfully but no privilege will be granted to the user, Scott.

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.

Scott issues the SQL statements: CREATE TABLE dept (deptno NUMBER(2), dname VARCHAR2(14), loc VARCHAR2(13)}; GRANT SELECT ON DEPT T0 SUE; If Sue needs to select from Scott's DEPT table, which command should she use?()A、SELECT*FROMDEPT;B、SELECT*FROMSCOTT.DEPT;C、SELECT*FROMDBASCOTTDEPT;D、SELECT*FROMALL_USERSWHEREUSER_NAME=';SCOTT';ANDTABLENAME=';DEPT';;

单选题Which of the following describes the BEST course of action when a user continuously calls atechnician with computer issues instead of the helpdesk?()APut all other work orders on hold and assist the user with all their computer issues.BHave another technician take over support calls for this user.CExplain that the user needs to fill out a work order for the computer problems.DAsk the user to call another technician for more in-depth assistance.

单选题The user Alice wants to grant all users query privileges on her DEPT table. Which SQL statement accomplishes this?()AGRANT select ON dept TO ALL_ USER;BGRANT select ON dept TO ALL;CGRANT QUERY ON dept TO ALL_USERSDGRANT select ON dept TO PUBLIC;

单选题The user Sue issues this SQL statement: GRANT SELECT ON sue. EMP TO alice WITH GRANT OPTION; The user Alice issues this SQL statement: GRANT SELECT ON sue. EMP TO reena WITH GRANT OPTION; The user Reena issues this SQL statement: GRANT SELECT ON sue. EMP TO timber; The user Sue issues this SQL statement: REVOKE select on sue. EMP FROM alice; For which users does the revoke command revoke SELECT privileges on the SUE.EMP table?()AAlice onlyBAlice and ReenaCAlice, Reena, and TimberDSue, Alice, Reena, and Timber

单选题View the Exhibit and examine the data in ORDERS_MASTER and MONTHLYjDRDERS tables. What would be the outcome of the above statement?()A  The ORDERS_MASTER table would contain the ORDERJDs 1 and 2.B  The ORDERS_MASTER table would contain the ORDERJDs 1, 2 and 3.C  The ORDERS_MASTER table would contain the ORDERJDs 1, 2 and 4.D  The ORDERS MASTER table would contain the ORDER IDs 1, 2, 3 and 4.

单选题View the Exhibit and examine the structure of the ORDERS and ORDERJTEMS tables.  Evaluate the following SQL statement:   SELECT oi.order_id, product_jd, order_date   FROM order_items oi JOIN orders o   USING (order_id);   Which statement is true regarding the execution of this SQL statement?()A  The statement would not execute because table aliases are not allowed in the JOIN clause.B  The statement would not execute because the table alias prefix is not used in the USING clause.C  The statement would not execute because all the columns in the SELECT clause are not prefixed with table aliases.D  The statement would not execute because the column part of the USING clause cannot have a qualifier in the SELECT list.

单选题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?()AHR can grant the privilege to JIM but without GRANT OPTION.BHR can grant the privilege to JIM because HR is the owner of the view.CSCOTT has to grant the SELECT privilege on the EMP table to JIM before this operation.DHR 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()AThe command fails because SCOTT still has privileges.BThe command succeeds and privileges are revoked from JIM.CThe command fails because HR cannot revoke the privileges from JIM.DThe command succeeds and only HR has the privilege to perform the SELECT, INSERT, and UPDATEoperations on the EMP table.

单选题You issue the following code:    EXEC DBMS_RESOURCE_MANAGER_PRIVS.GRANT_SWITCH_CONSUMER_GROUP        (’SCOTT’ ’GRP1’, TRUE);   What will be the result of executing the above code?()A The switch privilege will be granted to the user, Scott, for changing the consumer group to GRP1.B The switch privilege will be granted to the user, Scott, for changing the consumer group from GRP1 to any other group.C The code will not execute successfully because there is no GRANT_SWITCH_CONSUMER_GROUP procedure in the DBMS_RESOURCE_MANAGER_PRIVS package.DThe code will execute successfully but no privilege will be granted to the user, Scott.

单选题Scott issues the SQL statements: CREATE TABLE dept (deptno NUMBER(2), dname VARCHAR2(14), loc VARCHAR2(13)}; GRANT SELECT ON DEPT T0 SUE; If Sue needs to select from Scott's DEPT table, which command should she use?()ASELECT*FROMDEPT;BSELECT*FROMSCOTT.DEPT;CSELECT*FROMDBASCOTTDEPT;DSELECT*FROMALL_USERSWHEREUSER_NAME=';SCOTT';ANDTABLENAME=';DEPT';;

单选题You execute the following command to audit the database activities:  SQL AUDIT DROP ANY TABLE BY scott BY SESSION WHENEVER SUCCESSFUL;  What is the effect of this command?()AOne audit record is created for the whole session if user SCOTT successfully drops one or more tables in his session.BOne audit record is created for every session when any user successfully drops a table owned by SCOTT.COne audit record is created for each successful DROP TABLE command executed by any user to drop tables owned by SCOTT.DOne audit record is generated for the session when SCOTT grants the DROP ANY TABLE privilege to other users in his session.EOne audit record is created for each successful DROP TABLE command executed in the session of SCOTT.

单选题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?()ACREATE SYNONYM ord FOR orders; This command is issued by OE BCREATE PUBLIC SYNONYM ord FOR orders; This command is issued by OE CCREATE SYNONYM ord FOR oe.orders; This command is issued by the database administrator DCREATE PUBLIC SYNONYM ord FOR oe.orders; This command is issued by the database administrator

单选题The DBA issues this SQL command:CREATE USER scott IDENTIFIED by tiger;What privileges does the user Scott have at this point?()Ano privilegesBonly the SELECT privilegeConly the CONNECT privilegeDall the privileges of a default user