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?()
第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题:
A. No privileges.
B. Only the SELECT privilege.
C. Only the CONNECT privilege.
D. All the privileges of a default user.
第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)
第4题:
Which of the following describes the BEST course of action when a user continuously calls atechnician with computer issues instead of the helpdesk?()
第5题:
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.
第6题:
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.
第7题:
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‘;;
第8题:
A. no privileges
B. only the SELECT privilege
C. only the CONNECT privilege
D. all the privileges of a default user
第9题:
A user reports that they are unable to reach a particular website. The user had no issues reaching the site earlier in the day. Which of the following is the MOST likely cause of the lack of access?()
第10题:
In a TCP/IP network, which of the following protocols is involved when a user issues a ping command?()