单选题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？（）ASGABPGACShared PoolDStreams 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
SGA
B
PGA
C
Shared Pool
D
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？（）AThe location can be changed only if the flash recovery area is empty.BAfter executing the command， all new flash recovery area files will be created in the new location.CThe command will generate an error because you cannot change the flash recovery area while the database is open.DAll 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?（）AOSPF process IDBOSPF router IDCOSPF network typeDOSPF memory usageEOSPF CPU utilizationFOSPF 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 operationsALarge PoolBRedo Log BufferCDatabase Buffer CacheDProgram Global Area （PGA）
单选题Which describes the default behavior when you create a table? （）AThe table is accessible to all users.BTables are created in the public schema.CTables are created in your schema.DTables are created in the DBA schema.EYou 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？（）ASGABPGACShared PoolDStreams 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