The commands execute successfully.
Command 6 produces an error because of circular role grant.
Command 5 produces an error because a role cannot be granted to another role.
Command 3 produces an error because the MGRROLE role already contains system privileges.
The table created by HR remains and HR still has the CREATE TABLE system privilege.
The table created by HR remains and HR can grant the CREATE TABLE system privilege to other users.
第1题:
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 only
B. Alice and Reena
C. Alice, Reena, and Timber
D. Sue, Alice, Reena, and Timber
第2题:
“把查询sc表和更新sc表的grade列的权限授予用户user1”的正确SQL语句是( )。
A.GRANT SELECT,UPDATE(grade)ON TABLE sc TO user1
B.GRANT SELECT sc,UPDATE sc.grade TO user1
C.GRANT SELECT,UPDATE ON TABLE sc.grade TO used
D.GRANT SELECT ON TABLE sc,UPDATE ON TABLE sc(grade) TO user1
第3题:
下面哪些SQL命令向名为ACCTSUPER的用户授予系统权限()
第4题:
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?()
第5题:
You need to perform these tasks: 1. Create and assign a MANAGER role to Blake and Clark 2. Grant CREATE TABLE and CREATE VIEW privileges to Blake and Clark Which set of SQL statements achieves the desired results? ()
第6题:
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?()
第7题:
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?()
第8题:
CREATE ROLE manager; GRANT create table, create view TO manager; GRANT manager TO BLACK, CLARK;
CREATE ROLE manager; GRANT create table, create voew TO manager; GRANT manager ROLE TO BLACK, CLARK;
GRANT manager ROLE TO BLACK, CLARK; GRANT create table, create voew TO BLACK CLARK; ***MISSING***
第9题:
Alice only
Alice and Reena
Alice, Reena, and Timber
Sue, Alice, Reena, and Timber
第10题:
GRANT SELECT ANY TRANSACTION TO ARREN
GRANT SELECT ON FLASHBACK_TRANSACTION_QUERY TO ARREN
GRANT SELECT_ANY_TRANSACTION TO ARREN
GRANT FLASHBACK TO ARREN
GRANT SELECT ANY VIEW TO ARREN
第11题:
The command fails because SCOTT still has privileges.
The command succeeds and privileges are revoked from JIM.
The command fails because HR cannot revoke the privileges from JIM.
The command succeeds and only HR has the privilege to perform the SELECT, INSERT, and UPDATEoperations on the EMP table.
第12题:
The tablespace TBS1 is full.
The user is not the owner of the SYSTEM tablespace.
The user does not have quota on the TBS1 tablespace.
The user does not have sufficient system privileges to create table in the TBS1 tablespace.
The user does not have sufficient privileges to create table on the default permanent tablespace.
第13题:
SQL的DML包括的语句有______。
A.ROLLBACK, COMMIT
B.CREATE, DROP, ALTER
C.GRANT, REVOKE
D.SELECT, INSERT, DELETE, UPDATE
第14题:
“把查询sc表和更新sc表的grade列的权限受予用户user1”的正确SQL语句是()。
第15题:
SQL的DML包括的语句有()。
第16题:
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?()
第17题:
Examine the following commands executed in your database: SQL> ALTER SESSION RECYCLEBIN=ON; Session altered SQL> CREATE TABLE emp TABLESPACE tbsfd AS SELECT * FROM hr.employees; Table created. Further, you executed the following command to drop the table: SQL> DROP TABLE emp; Table dropped. What happens in this scenario? ()
第18题:
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()
第19题:
The DBA issues this SQL command:CREATE USER scott IDENTIFIED by tiger;What privileges does the user Scott have at this point?()
第20题:
The table is moved to the SYSAUX tablespace.
The table is moved to the SYSTEM tablespace.
The table is removed from the database permanently.
The table is renamed and remains in the TBSFD tablespace.
第21题:
The commands execute successfully.
Command 6 produces an error because of circular role grant.
Command 5 produces an error because a role cannot be granted to another role.
Command 3 produces an error because the MGRROLE role already contains system privileges.
The table created by HR remains and HR still has the CREATE TABLE system privilege.
The table created by HR remains and HR can grant the CREATE TABLE system privilege to other users.
第22题:
HR can grant the privilege to JIM but without GRANT OPTION.
HR can grant the privilege to JIM because HR is the owner of the view.
SCOTT has to grant the SELECT privilege on the EMP table to JIM before this operation.
HR needs the SELECT privilege on the EMP table with GRANT OPTION from SCOTT for this operation.
第23题:
CREATE ROLE manager; GRANT create table, create view TO manager; GRANT manager TO BLACK, CLARK;
CREATE ROLE manager; GRANT create table, create voew TO manager; GRANT manager ROLE TO BLACK, CLARK;
GRANT manager ROLE TO BLACK, CLARK; GRANT create table, create voew TO BLACK CLARK; ***MISSING***
第24题:
no privileges
only the SELECT privilege
only the CONNECT privilege
all the privileges of a default user