可学答题网 > 问答 > 1Z0-042题库
目录: 标题| 题干| 答案| 搜索| 相关
问题

The database users are


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?()

  • Aset the SESSIONS to 1 in the parameter file
  • Bgrant SINGLE SESSION privilege to all of the users
  • Cset the SESSIONS_PER_USER to 1 in the users’ profile
  • Dgrant RESTRICTED SESSION privilege to all of the database users
  • Ecreate a role with SINGLE SESSION privilege and assign the role to the user
参考答案
参考解析:
分类:1Z0-042题库
相关推荐

1、Twenty database users 

Twenty database users are connected to your database. Five of the users are running long q...

2、You are a database&ens

You are a database administrator for your company. A user named Susan belongs to the Windo...

3、All the database users

All the database users are presently connected to the database instance and working. The HR&ens...

4、Users are performing a

Users are performing a large volume of inserts and deletes on the application tables in th...

5、You are a database&ens

You are a database administrator for your company. The company uses a vendor company’s ap...

6、You are a database&ens

You are a database administrator for your company. The company uses a SQL Server 2005 data...