网友您好, 请在下方输入框内输入要搜索的题目:

题目内容 (请给出正确答案)
单选题
Which is the memory area that is created when a dedicated server process is started, and contains data and control information for that server process?()
A

SGA

B

PGA

C

Shared Pool

D

Streams Pool


参考答案

参考解析
解析: 暂无解析
更多 “单选题Which is the memory area that is created when a dedicated server process is started, and contains data and control information for that server process?()A SGAB PGAC Shared PoolD Streams Pool” 相关考题
考题 Which three are true about the large pool for an Oracle database instance that supports shared serverconnections?() A. Allocates memory for RMAN backup and restore operationsB. Allocates memory for shared and private SQL areasC. Contains a cursor area for storing runtime information about cursorsD. Contains stack spaceE. Contains a hash area performing hash joins of tables

考题 Which of the following technologies when implemented allows for the GREATEST fault tolerance for memory?() A. RAIDB. Registered memoryC. ECCD. Memory pairing

考题 When verifying OSPF virtual link problems, which is an important item to check on the two transit OSPF routers?() A. OSPF process IDB. OSPF router IDC. OSPF network typeD. OSPF memory usageE. OSPF CPU utilizationF. OSPF stub area configurations

考题 When an OSPF design is planned, which implementation can help a router not have memory resource issues?() A. Have a backbone area (area 0) with 40 routers and use default routes to reach external destinationsB. Have a backbo ne area (area 0) with 4 routers and 30,000 external routes injected into OSPFC. Have less OSPF areas to reduce the need for interarea route summarizationsD. Have multiple OSPF processes on each OSPF router. Example, router ospf 1, router ospf 2

考题 When an OSPF design is planned, which implementation can help a router not have memory resource issues?()A、Have a backbone area (area 0) with 40 routers and use default routes to reach external destinationsB、Have a backbo ne area (area 0) with 4 routers and 30,000 external routes injected into OSPFC、Have less OSPF areas to reduce the need for interarea route summarizationsD、Have multiple OSPF processes on each OSPF router. Example, router ospf 1, router ospf 2

考题 When verifying OSPF virtual link problems, which is an important item to check on the two transit OSPF routers?()A、OSPF process IDB、OSPF router IDC、OSPF network typeD、OSPF memory usageE、OSPF CPU utilizationF、OSPF stub area configurations

考题 You are working in a dedicated server environment. Your database is running in the automatic Program Global Area (PGA) memory management mode. Which two statements are correct in this scenario? ()A、 The WORK_AREASIZE_POLICY initialization parameter cannot be set to AUTO.B、 The Oracle database automatically controls the amount of PGA memory allotted to SQL work areas.C、 Setting the value of the SGA_TARGET initialization parameter to 0 will disable the automatic PGA memory management.D、 The SORT_AREA_SIZE parameter is ignored by all the sessions running in the automatic PGA memory management mode.

考题 Automatic PGA Memory Management eliminates the need to manually configure which of the following initialization parameters?() A、 SORT_AREA_SIZEB、 HASH_AREA_SIZEC、 BITMAP_MERGE_AREA_SIZED、 CREATE_BITMAP_AREA_SIZEE、 PGA_AGGREGATE_TARGET

考题 Which of the following answers are correct characteristics of microsegmentation, in the context of a Local Area Network (LAN)?()A、Dedicated paths between sending and receiving hosts are established.B、Multiple subnetwork broadcast addresses are created.C、Multiple ARP tables are needed.D、The decrease in the number of collision domains.E、Broadcast domains are enhanced.F、Additional bandwidth is used to connect hosts.

考题 Which of the following technologies when implemented allows for the GREATEST fault tolerance for memory?()A、 RAIDB、 Registered memoryC、 ECCD、 Memory pairing

考题 Which of the following should be considered when upgrading memory? ()A、speed of memoryB、memory slot colorC、type of memoryD、CPU speedE、BIOS version

考题 While adding the forced varyon volume group option, it is decided to create a disk heartbeat  Network over the disk paths. Which HACMP function is used to create disk heartbeat devices?()A、 The Disk hearbeat facility is initialized when creating enhanced concurrent mode volume groups through HACMP.B、 HACMP does not create the disk heartbeat area directly; RSCT facility creates the area used for the disk heartbeat when the device is started by Group Services.C、 The ’Chdev -v-C " command creates an enhanced Volume Group from an ordinarilyVolume Group. This creates the heartbeat region on the vfirst disk in the chain.D、 The disk heartbeat area on the disk is created and initialized when the device is created inHACMP "Extended Configuration - Extended Topology - Disk heartbeat facility" smit path.

考题 Which of the following is a correct statement about Workload Partitions (WPARs)?()A、WPARs use dedicated cores and shared memory.B、WPARs are restricted to using dedicated resources.C、WPARs share the resources of a single AIX instance.D、WPARs use shared cores, memory, and dedicated network adapters.

考题 Which three are true about the large pool for an Oracle database instance that supports shared serverconnections?()A、Allocates memory for RMAN backup and restore operationsB、Allocates memory for shared and private SQL areasC、Contains a cursor area for storing runtime information about cursorsD、Contains stack spaceE、Contains a hash area performing hash joins of tables

考题 You recently created a database and configured the SPFILE with the following parameter settings to ensure that Oracle automatically adjusts the memory for the Program Global Area (PGA):   SORT_AREA_SIZE = 150M   HASH_AREA_SIZE = 150M   BITMAP_MERGE_AREA_SIZE = 150M   CREATE_BITMAP_AREA_SIZE = 150M   WORKAREA_SIZE_POLICY = AUTO   You have not included the PGA_AGGREGATE_TARGET initialization parameter in the SPFILE and the System Global Area (SGA) is currently sized at 4G.   What is the total PGA memory allocated across all database server processes?()  A、 10MB、 400MC、 600MD、 800M

考题 Which two statements are true about record groups?()A、They are stored in the database. B、They are stored in local Forms memory. C、The type is specified explicitly at design time. D、The type is implied by when and how it is created.

考题 单选题You decided to change the location of the flash recovery area. You executed the following command: Which statement is true?()A The location can be changed only if the flash recovery area is empty.B After executing the command, all new flash recovery area files will be created in the new location.C The command will generate an error because you cannot change the flash recovery area while the database is open.D All the existing files in the flash recovery area will be moved to the new location, and all new Flash Recovery Area files will be created in the new location.

考题 单选题When verifying OSPF virtual link problems, which is an important item to check on the two transit OSPF routers?()A OSPF process IDB OSPF router IDC OSPF network typeD OSPF memory usageE OSPF CPU utilizationF OSPF stub area configurations

考题 多选题Automatic PGA Memory Management eliminates the need to manually configure which of the following initialization parameters?()ASORT_AREA_SIZEBHASH_AREA_SIZECBITMAP_MERGE_AREA_SIZEDCREATE_BITMAP_AREA_SIZEEPGA_AGGREGATE_TARGET

考题 单选题You have included the following parameter setting in your server parameter file:       PGA_AGGREGATE_TARGET = 800M        SORT_AREA_SIZE = 100M        HASH_AREA_SIZE = 100M        BITMAP_MERGE_AREA_SIZE = 100M        CREATE_BITMAP_AREA_SIZE = 100M   Which statement is true?()A  All the *_AREA_SIZE parameters are ignored.B  The Automatic PGA Memory Management feature cannot be disabled.C  The total Program Global Area (PGA) memory cannot be manually increased above 800M.D  The total memory for the PGA can automatically exceed 800M using the Automatic PGA Memory Management feature.

考题 单选题Identify the memory component from which memory may be allocated for: () 1: Session memory for the shared server  2: Buffers for I/O slaves  3: Oracle Database Recovery Manager (RMAN) backup and restore operationsA Large PoolB Redo Log BufferC Database Buffer CacheD Program Global Area (PGA)

考题 单选题Which describes the default behavior when you create a table? ()A The table is accessible to all users.B Tables are created in the public schema.C Tables are created in your schema.D Tables are created in the DBA schema.E You must specify the schema when the table is created.

考题 多选题Which two statements are true about record groups?()AThey are stored in the database.BThey are stored in local Forms memory.CThe type is specified explicitly at design time.DThe type is implied by when and how it is created.

考题 单选题Which of the following technologies when implemented allows for the GREATEST fault tolerance for memory?()A  RAIDB  Registered memoryC  ECCD  Memory pairing

考题 单选题While adding the forced varyon volume group option, it is decided to create a disk heartbeat  Network over the disk paths. Which HACMP function is used to create disk heartbeat devices?()A  The Disk hearbeat facility is initialized when creating enhanced concurrent mode volume groups through HACMP.B  HACMP does not create the disk heartbeat area directly; RSCT facility creates the area used for the disk heartbeat when the device is started by Group Services.C  The ’Chdev -v-C  command creates an enhanced Volume Group from an ordinarilyVolume Group. This creates the heartbeat region on the vfirst disk in the chain.D  The disk heartbeat area on the disk is created and initialized when the device is created inHACMP Extended Configuration - Extended Topology - Disk heartbeat facility smit path.

考题 单选题Which is the memory area that is created when a dedicated server process is started, and contains data and control information for that server process?()A SGAB PGAC Shared PoolD Streams Pool

考题 多选题You are working in a dedicated server environment. Your database is running in the automatic Program Global Area (PGA) memory management mode.   Which two statements are correct in this scenario?()AThe WORK_AREASIZE_POLICY initialization parameter cannot be set to AUTO.BThe Oracle database automatically controls the amount of PGA memory allotted to SQL work areas.CSetting the value of the SGA_TARGET initialization parameter to 0 will disable the automatic PGA  memory management.DThe SORT_AREA_SIZE parameter is ignored by all the sessions running in the automatic PGA  memory management mode.

考题 多选题Which three are true about the large pool for an Oracle database instance that supports shared serverconnections?()AAllocates memory for RMAN backup and restore operationsBAllocates memory for shared and private SQL areasCContains a cursor area for storing runtime information about cursorsDContains stack spaceEContains a hash area performing hash joins of tables