Your database is configured in shared server mode. However, 

题目
单选题
Your database is configured in shared server mode. However, your senior DBA asks you to modifythe value of the PRIVATE_SGA limit in the profile of the users.  What could be the reason for this()
A

to limit the User Global Area (UGA) memory allocated to a session from the SGA

B

to limit the amount of memory to be used for the dispatcher queue of a session in SGA

C

to limit the amount of memory to be used for the request pool in System Global Area (SGA)

D

to control the amount of memory allocated in SGA for the local variables for each shared server process

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

第1题:

Your Windows 2000 Professional computer has 10 shared folders that are available to other network users. A user reports that he cannot access a shared folder named ShareA.

You want to respond to the user's problem as quickly as possible by using an administrative tool.

However, you cannot remember the server location of ShareA. What should you do?

A.Use Windows Explorer to display the file paths of your shared folders.

B.Use Storage in Computer Management to view logical drive properties.

C.Use Event Viewer in Computer Management to search for shared folder error messages.

D.Use System Tools in Computer Management to display the file paths of your shared folders.


正确答案:D
解析:Explanation: The System Tools component of the Computer Management console can be used to locate shared folders. The Computer Management console can be accessed through the Administrative Tools applet in the Control Panel. In the Computer Management console, expand System Tools, expand Shared Folders and then open Shares to display all shared folders.

Incorrect Answers:
A: Windows Explorer does not show the location of shared folders in one place. To locate shared folders through Windows Explorer, you would need to check each directory and subdirectory for a shared folder icon.

B: Logical drives properties are used to display the capacity of the local logical drives on the local computer and the security permissions that have been granted on the logical drive. 'Storage' does not display the shared folders.

C: The Event viewer is used to view logs and error messages generated by Windows 2000. It cannot be used to show information on shares as it does not log any information concerning shared folders.

第2题:

You plan to use static database registration for a new listener when you create it.What could be the two reasons for this?()

  • A、More than one database is to be registered with the listener.
  • B、The users will connect the database by using the host naming method.
  • C、The Oracle Enterprise Manager is to be used to monitor an Oracle9i database.
  • D、The database that is to be registered with the listener is configured in shared server mode.
  • E、The listener is not configured on the default port of 1521 and the instance is not configured to register with a nondefault port.

正确答案:C,E

第3题:

You are the administrator of a Windows 2000 Server network that runs in mixed mode. You install a new Windows 2000 Server computer. You create and share a new HP LaserJet 4L printer.

Your Windows 2000 Professional client computer can print to the new printer successfully. However, when users try to connect to the printer from Windows NT Workstation 4.0 client computers, they receive the dialog box shown in the exhibit.

You want the printer driver to install automatically on the Windows NT Workstation computers. What should you do?

A.Copy the Windows NT 4.0 printer drivers to the Netlogon shared folders on all Windows NT Server 4.0 computers still configured as BDCs.

B.Copy the Windows NT 4.0 printer drivers to the Netlogon shared folders on the PDC emulator.

C.Change the sharing options on the printer to install additional drivers for Windows NT 4.0 or Windows 2000.

D.Copy the Windows NT 4.0 printer drivers to the Winnt\System32\printers\drivers folder on the Windows 2000 print Server.


正确答案:C
解析:Explanation:Windows2000printersautomaticallyallowWindows2000printerclientstodownloadthecorrectprinterdriver.However,down-levelclients,likeWindowsNT4.0,Windows95andWindows98wouldnotbeabletodownloadprinterdriversautomaticallyiftheWindows2000printserverdoesnothavethedown-levelprinterdrivers.Thesecanbeinstalledseparatelyontheprintserverthoughandthedown-levelclientswouldthenenjoythesameautomaticinstallationofprinterdrivers.Incorrectanswers:A\B\D:ThedriversshouldbeinstalledontheWindows2000printservernotcopied.

第4题:

Your company ahs an active direcotyr domain. The company also has a server named Server1 that runs Windows Server 2008. You install the file server role on Server1. you create a shared folder named AcctgShare on Server1 The permissions for the shared folder are configured as shown in the following table. ( missing again!) You need to ensure members of the Managers group can only view and open files in the shared folder.  What should you do()? 

  • A、Modify the share permissions for the Managers group to Reader
  • B、Modify the share permisisons for the Accounting Users group to Contributor
  • C、Modify the NTFS permisisons for the Managers group to Modify
  • D、Modify the NTFS permissions for the authenticated users group to modify and the share permissions to contributer.

正确答案:A

第5题:

You are working on a new Oracle Database 11g server, where only the software is installed and nodatabase is created. You plan to create a database on this server using the Database Configuration Assistant (DBCA).  Some of the requirements set for your database creation task are:  1:Configure the database to operate in shared server mode.  2:Disable automatic maintenance tasks such as optimizer statistics collection.  3:Configure a naming method to help the remote user connect to the database instance.  4:Use Automatic Storage Management (ASM) for storing the database files.  5:Configure daily database backup to flash recovery area.  6:Configure Enterprise Manager Database Control to manage the database.  Which of these requirements can be met while creating the database()

  • A、4 and 6
  • B、2,3,4,and 6
  • C、1,2,4,5,and 6
  • D、1,2,3,4,5,and 6

正确答案:C

第6题:

Your boss at Supportcenter.cn wants you to clarify Oracle 10g. Which condition in your database forces you to perform only consistent backups?()

  • A、The database is in mount state.
  • B、One of the tablespaces is offline.
  • C、One of the tablespaces is read only.
  • D、The database operates in ARCHIEVELOG mode. 
  • E、The database operates in NOARCHIEVELOG mode.

正确答案:E

第7题:

Your database is configured in shared server mode. However, your senior DBA asks you to modifythe value of the PRIVATE_SGA limit in the profile of the users.  What could be the reason for this()

  • A、to limit the User Global Area (UGA) memory allocated to a session from the SGA
  • B、to limit the amount of memory to be used for the dispatcher queue of a session in SGA
  • C、to limit the amount of memory to be used for the request pool in System Global Area (SGA)
  • D、to control the amount of memory allocated in SGA for the local variables for each shared server process

正确答案:A

第8题:

You configure your database Instance to support shared server connections.Which two memory areas that are part of PGA are stored in SGA instead, for shared server connection?()

A. User session data

B. Stack space

C. Private SQL area

D. Location of the runtime area for DML and DDL Statements

E. Location of a part of the runtime area for SELECT statements


参考答案:A, C

第9题:

Your database is configured in NOARCHIVELOG mode. All the control files have been lost due to a hard disk failure but the data files are not lost. You have the closed whole database backup available to you. Which two statements are true in this scenario?()

  • A、The instance aborts.
  • B、The database cannot be recovered.
  • C、The database can be recovered by restoring the control files from the backup.
  • D、The database remains opened and you have to shut it down with the ABORT option.
  • E、The database can be restored till the point of the last closed whole database backup.

正确答案:A,E

第10题:

多选题
You configure your database Instance to support shared server connections.Which two memory areas that are part of PGA are stored in SGA instead, for shared server connection?()
A

User session data

B

Stack space

C

Private SQL area

D

Location of the runtime area for DML and DDL Statements

E

Location of a part of the runtime area for SELECT statements


正确答案: B,D
解析: 暂无解析

更多相关问题