The DBA issues this SQL command:CREATE USER scott IDENTIFIED

A. no privileges

B. only the SELECT privilege

C. only the CONNECT privilege

D. all the privileges of a default user

A. CREATIVE USER susan;

B. CREATIVE OR REPLACE USER susan;

C. CREATE NEW USER susan DEFAULT

D. CREATE USER susan IDENTIFIED BY blue;

E. CREATE NEW USER susan IDENTIFIED BY blue;

F. CREATE OR REPLACE USER susan IDENTIFIED BY blue;

Your database interface is running. A user SCOTT starts a SQL *Plus session, and issues the following query:SQL> SELECT * FROM sales;Which process would retrieve the result from the database and return it to the client program?（）

A. User process

B. Server process

C. System Monitor (SMON)

D. Process Monitor (PMON)

E. Checkpoint process (CKPT)

在Oracle中，用ALTER将scott的口令改为hello，下列哪个是正确的？（ ）

A.ALTER USER scott IDENTIFIED BY hello

B.ALTER scott USER IDENTIFIED BY hello

C.ALTER USER scott IDENTIFIED AS hello

D.ALTER USER hello IDENTIFIED BY scott

A. No privileges.

B. Only the SELECT privilege.

C. Only the CONNECT privilege.

D. 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 only

B. Alice and Reena

C. Alice, Reena, and Timber

D. Sue, Alice, Reena, and Timber

View the Exhibit for some of the current parameter settings. A user logs in to the HR schema and issues the following commands:SQL> CREATE TABLE emp(empno NUMBER(3),ename VARCHAR2(20),sal NUMBER(8,2));SQL> INSERT INTO emp(empno,ename) VALUES(1,‘JAMES‘);At this moment, a second user also logs in to the HR schema and issues the following command:SQL> ALTER TABLE emp MODIFY sal NUMBER(10,2);What happens in the above scenario?（）

A. The second user‘s session immediately produces the resource busy error.

B. The second user‘s command executes successfully.

C. The second user‘s session waits for a time period before producing the resource busy error.

D. A deadlock is created.

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.

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‘；；