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题

[] 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?（） 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、A.SELECT*FROMDEPT； B、B.SELECT*FROMSCOTT.DEPT； C、C.SELECT*FROMDBASCOTTDEPT； D、D.SELECT*FROMALL_USERSWHEREUSER_NAME='；SCOTT'；ANDTABLENAME='；DEPT'；；

点击查看答案

第3题

[单选题] A network technician is troubleshooting a network issue that has just been reported. Which of thefollowing troubleshooting steps should the technician take FIRST to help resolve this issue?（）

A、Record the solution in the appropriate logs for future use. B、Ask the user who reported the issue what past documentation they have. C、Ask the user who reported the issue to explain the symptoms in detail. D、Record what steps should be taken to resolve the issue.

点击查看答案

第4题

[] An administrator receives a call from a user who is unable to receive email. After troubleshooting the administrator is able to resolve the issue and verify that user is able to access email again. Which of the following is the NEXT step that the administrator should take?（） An administrator receives a call from a user who is unable to receive email. After troubleshooting the administrator is able to resolve the issue and verify that user is able to access email again. Which of the following is the NEXT step that the administrator should take?（）

A、A. Implement preventative measures. B、B. Close the issue. C、C. Document the outcome. D、D. Question other users to make sure they are not having the same issue

点击查看答案

第5题

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

点击查看答案

第6题

[单选题] Your database has experienced a loss of datafile users_01.dbf, which is associated with a ablespace called USERS. The database is still running. Which answer properly describes the rder of the steps that you would use to recover from this error?（） 1.Shut down the database. 2.Take the users_01.dbf datafile offline with the alter database command. 3.Restore the users_01.dbf datafile from backup media with the required archived redo logs. 4.Restore all users tablespace-related datafiles from backup media. 5.Issue the recover tablespace users command. 6.Issue the recover datafile users_01.dbf command. 7.Start up the database. 8.Bring the users_01.dbf datafile online with the alter database command.

A、1，3，6，7 B、2，3，6，8 C、1，2，3，6，7 D、1，2，3，6，，7，8 E、2，3，6，5，7

点击查看答案

第7题

[单选题] How would you grant the RVPC user access to specific RMAN database records in the RMAN virtual private catalog？（）

A、 Issue the grant command from the SYS user （or equivalent） of the target database. B、 Issue the grant command from the SYS user （or equivalent） of the recovery-catalog database. C、 Issue the grant command from the recovery catalog-owning schema user account in the recovery catalog. D、 Issue the grant command from RMAN when connected to the recovery catalog-owning schema. E、 Issue the grant command from RMAN when connected to the target database.

点击查看答案

第8题

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

点击查看答案

第9题

[单选题] 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

点击查看答案

请使用微信扫码支付