单选题When manually configuring the SGA,which of the following parameter changes requires an instance restart to take effect?()   "First Test, First Pass" - www.lead2pass.com 97 Oracle 1Z0-053 ExamA DB_CACHE_SIZEB SHARED_POOL_SIZEC LARGE_POOL_SIZED JAVA_POOL_SIZEE SGA_MAX_SIZEF SORT_AREA_SIZE

单选题
When manually configuring the SGA,which of the following parameter changes requires an instance restart to take effect?()   "First Test, First Pass" - www.lead2pass.com 97 Oracle 1Z0-053 Exam
A

 DB_CACHE_SIZE

B

 SHARED_POOL_SIZE

C

 LARGE_POOL_SIZE

D

 JAVA_POOL_SIZE

E

 SGA_MAX_SIZE

F

 SORT_AREA_SIZE


参考解析

解析: 暂无解析

相关考题:

When configuring a POS system, which of the following peripheral devices would MOST likelyneed to be installed?() A. Optical mouseB. Handheld digitizerC. Barcode readerD. TouchscreenE. Document scannerF. KeyboardG. External USB drive

When configuring a DHCP server, which of the following can the administrator define for DHCP users?() A. Database serverB. NTP serverC. DHCP serverD. SQLServerE. DNS serverF. Domain name

When configuring Cisco IOS login enhancements for virtual connections, what is the "quiet period"?()A、The period of time in which virtual login attempts are blocked, following repeated failed login attemptsB、The period of time in which virtual logins are blocked as security services fully initializeC、A period of time when no one is attempting tolog inD、The period of time between successive login attempts

When configuring a scheduler map, which two are referenced?()A、Forwarding ClassB、SchedulerC、Rewrite RulesD、Priority

Using Oracle Enterprise Manager to set SGA pool values manually, for which of the following pools does Oracle EM offer advice to set the value appropriately?() A、 DB_CACHE_SIZEB、 SHARED_POOL_SIZEC、 LARGE_POOL_SIZED、 JAVA_POOL_SIZEE、 SGA_MAX_SIZEF、 SORT_AREA_SIZE

In which two conditions are resumable statements suspended?()A、 when a user exceeds the space quotaB、 when a user session is terminatedC、 when a table that is being accessed by the current transaction is not foundD、 when a user manually suspends the statementE、 when the maximum extents of a segment is reached

Which three of the following steps are mandatory when configuring MPLS on Cisco IOS? ()(Choose three.)A、start LDPB、enable CEF switchingC、configure the MPLS IDD、disable IP TTL propagationE、configure conditional label advertisingF、enable label switching on frame mode interfaces

When configuring QoS on a wireless controller, the per-user, real-time bandwidth contract isenforced for which of the following protocols?()A、IPXB、IPC、UDPD、TCP

When configuring a DHCP server, which of the following can the administrator define for DHCPusers?()A、 Database serverB、 NTP serverC、 DHCP serverD、 SQL serverE、 DNS serverF、 Domain name

When configuring an interface using SMIT and Further Configuration with an IP address and netmask, which of the following outcomes indicates how the routing tables will be affected?()A、A subnet route is automatically addedB、A default route is automatically addedC、All other routes are automatically addedD、The routing table is not affected

When configuring the messaging system, which of the following are valid parameters for the file transport? ()A、File NameB、Operating SystemC、LocationD、HostE、Mode

To manually configure the SGA components using Oracle Enterprise Manager Memory Advisor, you can set values for which of the following initialization parameters?()A、 DB_CACHE_SIZEB、 SHARED_POOL_SIZEC、 LARGE_POOL_SIZED、 JAVA_POOL_SIZEE、 SGA_MAX_SIZEF、 SORT_AREA_SIZE

In Oracle 11g,by default which one of the following conditions implicitly enables Automatic PGA Memory Management?()  A、 Setting a nonzero value for SGA_TARGETB、 Configuring Automatic Shared Memory ManagementC、 Configuring Automatic Memory ManagementD、 Setting a nonzero value for SGA_MAX_SIZE and PGA_AGGREGATE_TARGETE、 None of the above

The DBA has chosen to manage SGA and PGA memory separately in an OLTP database because of his unique knowledge of the application. Which of these are good starting points to use when configuring the maximum values for SGA and PGA,based on the amount of memory available on the system?()A、 20% SGA 80% PGAB、 25% SGA 75% PGAC、 50% SGA 50% PGAD、 75% SGA 25% PGAE、 80% SGA 20% PGA

When configuring Shared Ethernet Adapter (SEA) failover between two VIO servers,  which of the following attributes must have a different value on both VIO servers?()A、 HA ModeB、 Trunk priorityC、 Control ChannelD、 Default VLAN ID

单选题When configuring an interface using SMIT and Further Configuration with an IP address and netmask, which of the following outcomes indicates how the routing tables will be affected?()AA subnet route is automatically addedBA default route is automatically addedCAll other routes are automatically addedDThe routing table is not affected

单选题When an UNDO segment is created manually by you, its availability status is set to which of the following automatically by Oracle?()AOnline BPending online COffline DStale

多选题Which two statements are true regarding the SGA_TARGET initialization parameter()AIt can be increased up to the value of the SGA_MAX_SIZE parameter.BIncreasing the value of the SGA_TARGET parameter distributes the increased memory among all the Autotuned components.CReducing the value of the SGA_TARGET parameter deallocates memory from both autotuned and Manually sized components.DIncreasing the value of SGA_TARGET up to the value of SGA_MAX_SIZE disables the automatic shared Memory management feature.

单选题In Oracle 11g,by default which one of the following conditions implicitly enables Automatic PGA Memory Management?()A Setting a nonzero value for SGA_TARGETB Configuring Automatic Shared Memory ManagementC Configuring Automatic Memory ManagementD Setting a nonzero value for SGA_MAX_SIZE and PGA_AGGREGATE_TARGETE None of the above

多选题When configuring a DHCP server, which of the following can the administrator define for DHCPusers?()ADatabase serverBNTP serverCDHCP serverDSQL serverEDNS serverFDomain name

多选题To manually configure the SGA components using Oracle Enterprise Manager Memory Advisor, you can set values for which of the following initialization parameters?()ADB_CACHE_SIZEBSHARED_POOL_SIZECLARGE_POOL_SIZEDJAVA_POOL_SIZEESGA_MAX_SIZEFSORT_AREA_SIZE

单选题When configuring Cisco IOS login enhancements for virtual connections, what is the "quiet period"?()AThe period of time in which virtual login attempts are blocked, following repeated failed login attemptsBThe period of time in which virtual logins are blocked as security services fully initializeCA period of time when no one is attempting tolog inDThe period of time between successive login attempts

多选题Using Oracle Enterprise Manager to set SGA pool values manually, for which of the following pools does Oracle EM offer advice to set the value appropriately?()ADB_CACHE_SIZEBSHARED_POOL_SIZECLARGE_POOL_SIZEDJAVA_POOL_SIZEESGA_MAX_SIZEFSORT_AREA_SIZE

多选题When configuring the messaging system, which of the following are parameters of the e-mail transport? ()ALocationBProtocolCModeDWeb AddressEHost

单选题When configuring a multipoint GRE (mGRE) tunnel interface, which one of the following is NOT a valid configuration option:()A tunnel sourceB tunnel destinationC tunnel keyD ip addressE tunnelvrf

单选题When configuring Shared Ethernet Adapter (SEA) failover between two VIO servers,  which of the following attributes must have a different value on both VIO servers?()A HA ModeB Trunk priorityC Control ChannelD Default VLAN ID

单选题The DBA has chosen to manage SGA and PGA memory separately in an OLTP database because of his unique knowledge of the application. Which of these are good starting points to use when configuring the maximum values for SGA and PGA,based on the amount of memory available on the system?()A 20% SGA 80% PGAB 25% SGA 75% PGAC 50% SGA 50% PGAD 75% SGA 25% PGAE 80% SGA 20% PGA