AGRANT dba TO dbmgr;
BGRANT connect TO dbmgr;
CGRANT resource TO dbmgr;
DGRANT hs_admin_role TO dbmgr;
EGRANT manage scheduler TO dbmgr;
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()
单选题查看答案