首页计算机考试Oracle认证
(多选题)

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

    答案解析

快考试在线搜题