单选题Your database instance is currently configured to support 1,500 connections. The Web applicationthat uses the database allows a large number of users to work with the database simultaneously. Someusers of the Web application do not interact with the se

题目
单选题
Your database instance is currently configured to support 1,500 connections. The Web applicationthat uses the database allows a large number of users to work with the database simultaneously. Someusers of the Web application do not interact with the server all the time.  You want to increase the scalability by configuring the database instance to handle more connections. Asa DBA,  which configuration would you set to support more than 1,500 connections at a time()
A

You would configure more listeners for the database.

B

You would configure the database in shared server mode to use the connection pooling feature.

C

You would increase the value of the PGA_AGGREGATE_TARGET initialization parameter that assigns more session memory to users.

D

You would decrease the value of the PRIVATE_SGA resource limit in the profiles used by the users to accommodate more session information.

如果没有搜索结果或未解决您的问题,请直接 联系老师 获取答案。
相似问题和答案

第1题:

Company.com has a database application and a Web server application running on the same p5-570 server in a single partition. Recently there have been a number of instances where the increased load on the database server has impacted the performance of the Web server. What can the technical specialist recommend to keep the database application from impacting the performance of the Web server?()

  • A、Create a VLAN between the web server and database server.
  • B、Purchase APV and install the VIOS.
  • C、Increase the priority of the Web server.
  • D、Create separate LPARs for Web and database workloads.

正确答案:D

第2题:

Your database instance is currently configured to support 1,500 connections. The Web applicationthat uses the database allows a large number of users to work with the database simultaneously. Someusers of the Web application do not interact with the server all the time.  You want to increase the scalability by configuring the database instance to handle more connections. Asa DBA,  which configuration would you set to support more than 1,500 connections at a time()

  • A、You would configure more listeners for the database.
  • B、You would configure the database in shared server mode to use the connection pooling feature.
  • C、You would increase the value of the PGA_AGGREGATE_TARGET initialization parameter that assigns more session memory to users.
  • D、You would decrease the value of the PRIVATE_SGA resource limit in the profiles used by the users to accommodate more session information.

正确答案:B

第3题:

A retail customer has a database application that is accessed by a large number of people through a web interface from multiple remote locations. Which questions will provide the information necessary to design the best performing storage solution of the following?()

  • A、How many web servers will be connected to the database?
  • B、How many concurrent applications will run against the database?
  • C、How many concurrent users will be accessing the database?
  • D、What are the types of transactions run against the database?

正确答案:D

第4题:

Your production database uses an Automatic Storage Management (ASM) instance to manage its files. You want to add a new disk group to the ASM instance to manage the increased data load. What action would you perform to include the new disk group in the ASM instance without causing any impact on the currently connected users?()

  • A、mount the new disk group in the ASM instance
  • B、restart the ASM instance and the production database instance
  • C、register the new disk groups in the production database instance
  • D、restart the ASM instance without restarting the production database instance
  • E、include the new disk group in the ASM_DISKSTRING parameter in the parameter file and restart the ASM instance

正确答案:A

第5题:

You work as a database administrator for Certkiller .com. In your production  database, the size of Database Buffer Cache needs to be increased immediately for the current as well as future instances of the database. The Oracle instance has been configured to accommodate any changes in the size of the memory structures. At this is production database, you want to accomplish this task with no impact on the user’s connections.  Which activity must you have completed before accomplishing this task?()

  • 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.

正确答案:C

第6题:

A customer has a database application that is accessed by a large number of people through a web interface from multiple remote locations.  Which of the following questions will provide the information necessary to design the best performing storage solution?()

  • A、How many web servers will be connected to the database?
  • B、Will the database be run on a Windows solution?
  • C、How many concurrent users will be accessing the database?
  • D、What are the types of transactions run against the database?

正确答案:D

第7题:

You work as a database administrator for Supportcenter.cn. You want to administer your database servers, which are running on different host machines, using the Web-enabled grid control interface. You have configured the agent on the host machines. You have started the Oracle Database 10g Grid Control utility on your machine. Which two additional components would you configure to achieve this objective?()

  • A、Application Server Control
  • B、Oracle Management Service
  • C、Oracle Enterprise Manager Repository
  • D、Oracle Enterprise Manager Database Control

正确答案:C,D

第8题:

You work as a database administrator at Certkiller .com. Your production database uses an Automatic Storage Management (ASM) instance to manage its files. You want to add a new disk group to the ASM instance to manage the increased data load. What action would you perform to include the new disk group in the ASM instance without causing any impact on the currently connected users?()

  • A、 mount the new disk group in the ASM instance
  • B、 restart the ASM instance and the production database instance
  • C、 register the new disk groups in the production database instance
  • D、 restart the ASM instance without restarting the production database instance
  • E、 include the new disk group in the ASM_DISKSTRING parameter in the parameter file and restart the ASM instance

正确答案:A

第9题:

A customer needs to ensure that the number of threads servicing an application does not exceed the number of database connections available to the application. What step must you take to address this situation?()

  • A、Configure a Max Threads Constraint and add your application to the list of applications for the  Constraint.
  • B、Configure a Work Manager with a Maximum Threads Constraint tied to the Connection Pool and  configuration your application to use the Work Manager.
  • C、Configure a Work Manager with a Minimum Threads Constraint tied to the Connection Pool and  configure your application to use the Work Manager.
  • D、Configure a global MaxThreads constraint and target it to the server or clusters where your  application is deployed.
  • E、Configure the startup parameter "-Dwls-maxThreads" to be the same as the number of  database connections configured.

正确答案:B

第10题:

You work as a database administrator for Supportcenter.cn. Your database is opened inNOARCHIVEKLOG mode. You decide to place the database in ARCHIVELOG mode. How would you do this?()

  • A、Execute the ALTER DATABASE ARCHIVELOG statement
  • B、Select ARCHIVELOG option in the database control and restart the database to apply the changes.
  • C、Shut down and start the instance, and in the NOMOUNT state execute the ALTER DATABASE ARCHIVELOG statement.
  • D、Shut down and start the instance, mount the database, then execute the ALTER DATABASE ARCHIVELOG statement.

正确答案:B,D

更多相关问题