1Z0-007

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

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

如果没有搜索结果，请直接 联系老师 获取答案。
如果没有搜索结果，请直接 联系老师 获取答案。
相似问题和答案

第1题：

The DBA issues this SQL command: CREATE USER scott IDENTIFIED 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


参考答案：A

第2题：

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.


参考答案：C

第3题：

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)


参考答案：B

第4题：

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)

正确答案:B

第5题：

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


参考答案：B

第6题：

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


参考答案：C

第7题：

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.


参考答案：A

第8题：

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.


参考答案：B, C

第9题：

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.

正确答案:D

第10题：

The DBA issues this SQL command:CREATE USER scott IDENTIFIED 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

正确答案:A

更多相关问题
相关内容