多项选择题
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?()
A.Profile
B.Account lock
C.Account unlock
D.Password expire
E.Quota 10MB on SupportCenter TBS1
F.Password never expire
G.Defaulttablespace SupportCenter TBS1
H.Quota unlimited on SupportCenter TBS1
I.TemporarytablespaceTEMP
J.TemporarytablespaceSYSTEM
相关考题
-
多项选择题
YouworkasadatabaseadministratorforSupportcenter.cn.YouareworkingonOracleDatabase10g.Toforwardclientconnectionstoaninstance,thelistenermustknowinformationsuchasthenameoftheinstanceandwheretheinstance’sORACLE_HOMEislocated.Howdoesthelistenergetthisinformation?()
A.It gets it from the parameter file.
B.The listener prompts for details on startup.
C.The listener gathers information from the control file.
D.The instance automatically registers with the default listener.
E.The listener gets this information through thelistener.orafile. -
单项选择题
YouworkasadatabaseadministratorforSupportcenter.cn.Whilegrantingarole,SELECT_CATALOG_ROLE,toauser,SupportCenter,usingOracleEnterpriseManager10gDatabaseControl,youhaveclearedtheDEFAULTcheckbox.Whatwillbetheresult?()
A.The user cannot use the role at all.
B.The role would not be granted to the user.
C.The user needs to enable the role explicitly.
D.The user can start using the role immediately.
E.The user would have the admin option for the role. -
单项选择题
Exhibit, error You work as a database administrator for Supportcenter.cn. When you try to connect to the database, you get an error (See exhibit). What could be the possible reason for getting such an error?()
A.Database is not open
B.Listener is not running
C.Service name is not correct
D.Wrong port number used in URL
E.Usersysdoes have themediaprivilege
