多选题

While creating a scheduler window using the DBMS_SCHEDULER package, a user logged in as DBMGR gets the error message insufficient privileges.  Which two commands would you use to resolve this error?()

AGRANT dba TO dbmgr;

BGRANT connect TO dbmgr;

CGRANT resource TO dbmgr;

DGRANT hs_admin_role TO dbmgr;

EGRANT manage scheduler TO dbmgr;

正确答案

来源:www.examk.com

答案解析

相似试题
  • You work as a database administrator for Certkiller .com. You enabled tracing while creating a listener to your database.  What additional information is available to you when you enable tracing?()

    单选题查看答案

  • You work as a database administrator for Supportcenter.cn. While setting up the database for your production environment, you want to create a user according to the requirements in the exhibit. Which three options of the CREATE USER command would you use to achieve this objective?()

    多选题查看答案

  • Which statement is true while creating subplans using Resource Manager?()

    单选题查看答案

  • You work as a database administrator for Certkiller .com. While setting up the database for your production environment, you want to create a user according to the requirements in the exhibit.  Which three options of the CREATE USER command would you use to achieve this objective?()

    多选题查看答案

  • 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?()

    单选题查看答案

  • A developer is creating a class Book, that needs to access class Paper. The Paper class is deployed in a JAR named myLib.jar.  Which three, taken independently, will allow the developer to use the Paper class while compiling the Bookclass?()

    多选题查看答案

  • Exhibit You work as a database administrator for Supportcenter.cn. While creating a new user or changing the password for existing users, the password must adhere to the restrictions specified in the exhibit. Which option would you use to achieve this objective?()

    单选题查看答案

  • You want to create a tablespace to contain objects with block size 16 KB. But while configuring thestorage you find that the block size that you can provide is only 8 KB.  Which configuration could have enabled the block selection of 16 KB()

    单选题查看答案

  • Which naming method uses the tnsnames.ora file to store the connect descriptor used by the client  while connecting to the database instance from a remote machine()

    单选题查看答案