单项选择题

You have been asked to create three users， PUB1， PUB2 and PUB3， for three newly hired employees and to allocate unlimited quota on their default tablespace PUBLISHER_TBS with no other privileges. After creating the users， which method can you use for granting the required privileges？（）

A.grant CONNECT role to all of the three users
B.grant RESOURCE role to all of the three users
C.grant both CONNECT and RESOURCE role to all of the three users
D.execute ALTER USER .. QUOTA UNLIMITED ON publisher_tbs command for all of the three users
E.create role with UNLIMITED TABLESPACE system privilege and assign the role to all of the three users

<上一题目录下一题>

热门试题

单项选择题Youwanttobenotifiedwhenthespaceusageofanexistingcriticaltablespacehasreached75%oftheallocatedspace.Whichoptionwouldyouusetoachievethis？（）

A.run a procedure to check the tablespace space usage
B.define the warning threshold for the tablespace at 75% in Database Control
C.create a trigger to be executed when tablespace space usage reaches 75%
D.submit a job by using DBMS_JOB package to check the free space in the tablespace at regular intervals
E.define the warning threshold to be 75% for the tablespace by ALTER TABLESPACE .. ADD THRESHOLD command

单项选择题YouobservethatinyourPRODdatabase，customerinformationisbeingmodifiedbysomeunauthorizedusers.YouwanttokeeptrackofallofthetransactionshappeningonthetableusingPL SQL.WhichtypeofPL SQLsubprogramorconstructwouldyouusetoaccomplishthistask？（）

A.functions
B.packages
C.procedures
D.database triggers
E.anonymous PL/SQL block

单项选择题Youwanttocreateanewoptimizeddatabaseforyourtransactionalproductionenvironmenttobeusedbyafinancialapplication.Whilecreatingthedatabase，youwanttheOraclesoftwaretotakecareofallbasicsettingstooptimizethedatabaseperformance.Whichmethodwouldyouusetoachievethisobjective？（）

A.Use the CREATE DATABASE .. command to create the database with Oracle-managed files.
B.Use the Database Configuration Assistant (DBCA) to create the database with Oracle-managed files.
C.Use Enterprise Manager to create a new database with the Online Transaction Processing (OLTP) option.
D.Use Database Configuration Assistant (DBCA) to create the database with Transaction Processing template.
E.Use the CREATE DATABASE .. command to create the database with Automatic Storage Management (ASM) file system.

多项选择题While setting up the database for your production environment， you want to create a user with following requirements. 1.The objects created by the user must be stored in a tablespace， TBS1， if the TABLESPACE option is not defined during the object creation. 2.The user should be able to use 10MB of space in the tablespace TBS1. 3.The user must change the password immediately after logging in for the first time. Which three options of the CREATE USER command would you use to achieve this objective？（）

A.profile
B.account lock
C.account unlock
D.password expire
E.quota 10MB on TBS1
F.password never expire
G.default tablespace TBS1
H.quota unlimited on TBS1
I.temporary tablespace TEMP
J.temporary tablespace SYSTEM

单项选择题In your database， the users SYS and SYSTEM have been assigned the profiles， ADMIN_PROF1 and ADMIN_PROF2， respectively. The rest of the database administrators are assigned the profile ADMIN_PROF3. You create a profile， USER_PROF， and assign it to the application user， Adams. After a week you realize that the profile is no longer required and you decide to drop it. What will Adam’s profile be after the USER_PROF profile has been dropped？（）

A.no profiles
B.the default profile
C.same as the profile of SYS user
D.same as the profile of SYSTEM user