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
相关考题：
You specify a nonzero value for the MEMORY_TARGET initialization parameter, but do not set the PGA_AGGREGATE_TARGET or the SGA_TARGET parameters. You restart your database instance.Which statement about the result is true?（）A. The database instance starts, and Oracle sets the default value of SGA_TARGET to the same value as SGA_MAX_SIZEB. The database instance starts, and Oracle automatically tunes memory and allocates 60 percent to the SGA and 40 percent to the PGAC. The database instance starts, but Automatic Memory Management is disabledD. The database instance will not start because you did not specify the PGA_AGGREGATE_TARGET or SGA_TARGET parameter
To implement Automatic Management (AMM), you set the following parameters: When you try to start the database instance with these parameter settings, you receive the following error message:SQL startupORA-00824: cannot set SGA_TARGET or MEMORY_TARGET due to existing internal settings, see alert log for more information.Identify the reason the instance failed to start.（）A.The PGA_AGGREGATE_TARGET parameter is set to zero.B.The STATISTICS_LEVEL parameter is setto basic.C.Both the SGA_TARGETandMEMORY_TARGET paramete rsareset.D.The SGA_MAX_SIZEandSGA_TARGET parameter value sare note qual.
Which of the following should the technician do FIRST when removing a paper jam?() A. Open all the doors in the printer.B. Clear the print queue.C. Turn the printer off.D. Take the printer offline.
Which of the following should be done FIRST when troubleshooting a problem？（）A、Test the theory to determine the causeB、Perform a root cause analysisC、Establish a plan of actionD、Document outcomes
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
A customer states their computer was fine until yesterday when they heard a pop noise and thecomputer stopped working. Which of the following components should the technician test FIRST?（）A、Main system boardB、ProcessorC、Hard disk driveD、Power supply
Which of the following should the technician do FIRST when removing a paper jam?（）A、Open all the doors in the printer.B、Clear the print queue.C、Turn the printer off.D、Take the printer offline.
Which of the following are the FIRST actions to take when an administrator is troubleshooting aserver?（）A、Make one change at a time and test/confirm the change has resolved the problem.B、Verify full system functionality.C、Replicate the problem.D、Determine if a common element is causing multiple problems.E、Identify any changes to the server.
You specify a nonzero value for the MEMORY_TARGET initialization parameter，but do not set the PGA_AGGREGATE_TARGET or the SGA_TARGET parameters. You restart your database instance. Which statement about the result is true？（）A、 The database instance starts，and Oracle sets the default value of SGA_TARGET to the same value as SGA_MAX_SIZEB、 The database instance starts，and Oracle automatically tunes memory and allocates 60 percent to the SGA and 40 percent to the PGAC、 The database instance starts，but Automatic Memory Management is disabledD、 The database instance will not start because you did not specify the PGA_AGGREGATE_TARGET or SGA_TARGET parameter
Your database instance is started using the server parameter file （SPFILE）. You executed acommand to change the value of the LOG_BUFFER initialization parameter： ALTER SYSTEM SET LOG_BUFFER=32M SCOPE=BOTH； What would be the outcome of this command（）A、The command succeeds only if Automatic Memory Management is not enabled.B、The command succeeds， but you need to restart the database for changes to take effect.C、The command returns an error because the size of the redo log buffer cannot be changed dynamically.D、The parameter value is changed and it comes into effect as soon as space becomes available in the System Global Area （SGA）.
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
Which of the following Oracle features is enabled by setting a nonzero value for the MEMORY_TARGET initialization parameter？（） A、 Automatic PGA Memory ManagementB、 Automatic SGA Memory ManagementC、 Automatic Shared Memory ManagementD、 Automatic Memory ManagementE、 Manual SGA Memory ManagementF、 None of the above
Oracle Grid Infrastructure for a stand-alone server is installed on your production host before installing the Oracle Database server. The database and listener are configured by using Oracle Restart. Examine the following command and its output: $ crsctl config has CRS-4622: Oracle High Availability Services auto start is enabled. What does this imply?（）A、When you start an instance on a high with SQL *Plus dependent listeners and ASM disk groups are automatically started.B、When a database instance is started by using the SRVCTL utility and listener startup fails, the instance is still started.C、When a database is created by using SQL* Plus, it is automatically added to the Oracle Restart configuration.D、When you create a database service by modifying the SERVICE_NAMES initialization parameter, it is automatically added to the Oracle Restart configuration.
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
You are managing the Oracle database. Which of the following choices correctly identifies when Oracle reads the contents of the init.ora file?（）A、When the instance is started B、When the database is mounted C、When the database is opened D、When the database is closed
单选题Your database instance is started using the server parameter file （SPFILE）. You executed acommand to change the value of the LOG_BUFFER initialization parameter： ALTER SYSTEM SET LOG_BUFFER=32M SCOPE=BOTH； What would be the outcome of this command（）AThe command succeeds only if Automatic Memory Management is not enabled.BThe command succeeds， but you need to restart the database for changes to take effect.CThe command returns an error because the size of the redo log buffer cannot be changed dynamically.DThe parameter value is changed and it comes into effect as soon as space becomes available in the System Global Area （SGA）.
单选题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
单选题Which of the following changes to sentence 7 would best improve the coherence of the first paragraph?AChange you to their children.BChange use to also use.CBegin the sentence with Nevertheless.DBegin the sentence with For instance.EChange to behave to behaving.
多选题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
单选题To implement Automatic Management (AMM), you set the following parameters: When you try to start the database instance with these parameter settings, you receive the following error message: SQL startup ORA-00824: cannot set SGA_TARGET or MEMORY_TARGET due to existing internal settings, see alert log for more information. Identify the reason the instance failed to start.（）AThe PGA_AGGREGATE_TARGET parameter is set to zero.BThe STATISTICS_LEVEL parameter is setto basic.CBoth the SGA_TARGETandMEMORY_TARGET paramete rsareset.DThe SGA_MAX_SIZEandSGA_TARGET parameter value sare note qual.
多选题Which of the following are the FIRST actions to take when an administrator is troubleshooting a server？（）AMake one change at a time and test/confirm the change has resolved the problem.BVerify full system functionality.CReplicate the problem.DDetermine if a common element is causing multiple problems.EIdentify any changes to the server.
单选题You have performed the first step in placing your database into ARCHIVELOG mode. The second step is deciding whether the online redo log files are to be archived automatically or manually. Which action should you take to enable archiving at instance startup？（）A AB BC CD D
单选题Which of the following Oracle features is enabled by setting a nonzero value for the MEMORY_TARGET initialization parameter？（）A Automatic PGA Memory ManagementB Automatic SGA Memory ManagementC Automatic Shared Memory ManagementD Automatic Memory ManagementE Manual SGA Memory ManagementF None of the above
名词解释题首关消除（first-pass effect）