单项选择题
The database users are connecting to the PROD database from different applications, thereby degrading the database performance. The senior database administrator suspects the large number of concurrent connections to be the reason for low performance and asks you to restrict the number concurrent connections per database user to one. Which action would you take to achieve this objective? ()
A.set the SESSIONS to 1 in the parameter file
B.grant SINGLE SESSION privilege to all of the users
C.set the SESSIONS_PER_USER to 1 in the users’ profile
D.grant RESTRICTED SESSION privilege to all of the database users
E.create a role with SINGLE SESSION privilege and assign the role to the users
相关考题
-
多项选择题
WhichtwostatementsaretrueregardingaPL/SQLpackagebody?()
A.It cannot be created without a package specification.
B.It cannot invoke subprograms defined in other packages.
C.It can contain only the subprograms defined in the package specification.
D.It can be changed and recompiled without making the package specification invalid. -
单项选择题
Youworkinadatawarehouseenvironmentthatinvolvestheexecutionofcomplexqueries.ThecurrentcontentoftheSQLcacheholdstheidealworkloadforanalysis.Youwanttoanalyzeonlyfewmostresource-intensivestatements.Whatwouldbeyoursuggestiontoreceiverecommendationsontheefficientuseofindexesandmaterializedviewstoimprovequeryperformance?()
A.Run the SQL Access Advisor.
B.Run the SQL Tuning Advisor (STA).
C.Run the Automatic Workload Repository (AWR) report.
D.Run the Automatic Database Diagnostic Monitor (ADDM). -
多项选择题
WhichtwodatabaseoperationscanbeperformedattheMOUNTstageofdatabasestartup?()
A.renaming of data files
B.dropping the database user
C.renaming of control files
D.multiplexing of control files
E.configuring the database in ARCHIVELOG mode
