单项选择题
You work as a database administrator for Supportcenter.cn. You find that users with DBA role are using more CPU resources than what is allocated in their profiles. Which action would you take to ensure that resources limits are imposed on these users？（）
A.Assign the DEFAULT profile to the users
B.Set the RESOURCE_LIMIT parameter to TRUE in the parameter file
C.Create a new profile with CPU restrictions and assign it to the users
D.Specify the users as members of the DEFAULT_CONSUMER_GROUP
E.Revoke the DBA role and grant CONNECT and RESOURCE role to the users
相关考题
-
单项选择题
YourSupportcenter.cndatabaseisinARCHIVELOGmode.ThedatafilethatbelongstotheSYSTEMtablespacehasbecomecorrupted.Uptowhatpointcanyourecoverthedatabase？（）
A.Until last commit
B.Until the time you perform recovery
C.Until the time the date file got corrupted
D.Until the point where the last transaction begun
E.You cannot recover the SYSTEMtablespaceand must re-create the database. -
单项选择题
YouworkasadatabaseadministratorforSupportcenter.cn.Inyourproductiondatabase，thesizeofDatabaseBufferCacheneedstobeincreasedimmediatelyforthecurrentaswellasfutureinstancesofthedatabase.TheOracleinstancehasbeenconfiguredtoaccommodateanychangesinthesizeofthememorystructures.Atthisisproductiondatabase，youwanttoaccomplishthistaskwithnoimpactontheuser’sconnections.Whichactivitymustyouhavecompletedbeforeaccomplishingthistask？（）
A.You must have started the database instance in restricted mode.
B.You must have started the database instance inNORMALmode.
C.You must have started the database instance with server parameter file.
D.You must have started the database instance but must not have mounted.
E.You must have started the database instance but must not have opened. -
多项选择题
You work as a database administrator for Supportcenter.cn. You decided to manage client and server connections using Local Naming method in Supportcenter.cn. When you try to connect to the database you get the following error： ERROR： ORA-12154：TNS：couldnot resolve service name Which network configuration files would you look into to resolve this error？（）
A.snmp.ora
B.names.ora
C.spfile.ora
D.sqlnet.ora
E.listener.ora
F.tnsnames.ora
