The PGA_AGGREGATE_TARGET parameter is set to zero.
The STATISTICS_LEVEL parameter is setto basic.
Both the SGA_TARGETandMEMORY_TARGET paramete rsareset.
The SGA_MAX_SIZEandSGA_TARGET parameter value sare note qual.
第1题:
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.
第2题:
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?()
第3题:
A. The MEMORY_MAX_TARGET parameter is automatically set to 500 MB
B. The value of the MEMORY_MAX_TARGET parameter remains zero till it is changed manually
C. The PGA_AGGREGATE_TARGET and SGA_TARGET parameters are automatically set to zero
D. The lower bounds of PGA_AGGREGATE_TARGET and SGA_TARGET parameters are set to 90 MB and 270 MB, respectively
第4题:
You are managing a single instance Oracle 10g database that utilizes the following parameters: Which of the following set of commands must you execute to enable Flashback Database?()
第5题:
You work as a database administrator for Certkiller .com. You want to create your database with the automatic undo management feature enable.Which two tasks must you perform to achieve this?()
第6题:
You create a Microsoft ASP.NET application by using the Microsoft .NET Framework version 3.5. When you access the application in a Web browser, you receive the following error message: "Service Unavailable". You need to access the application successfully. What should you do?()
第7题:
Which statement about Automatic Memory Management with Oracle 11g is true?()
第8题:
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_SIZE
B. The database instance starts, and Oracle automatically tunes memory and allocates 60 percent to the SGA and 40 percent to the PGA
C. The database instance starts, but Automatic Memory Management is disabled
D. The database instance will not start because you did not specify the PGA_AGGREGATE_TARGET or SGA_TARGET parameter
第9题:
The ORACLE_SID environment variable is set to +ASM. ASMLIB is not used in the configuration. You executed the following command to startup the Automatic Storage Management (ASM) instance. SQL> STARTUP; Which two activities are performed during a successful start up operation? ()(Choose two.)
第10题:
You execute the following command to start an Automatic Storage Management (ASM) instance: SQL>STARTUP; In which of the following modes will the ASM instance start?()