违法和不良信息举报 联系客服
免费注册 登录

You set the following parameters in the parameter file and r

题目
多选题
You set the following parameters in the parameter file and restarted the database：MEMORY_MAX_TARGET=0MEMORY_TARGET=500M PGA_AGGREGATE_TARGET=90MSGA_TARGET=270M Which two statements are true about these parameters after the database instance is restarted（）
A

The MEMORY_MAX_TARGET parameter is automatically set to 500 mb.

B

The pga_AGGREGATE_TARGET and sga_TARGET parameters are automatically set to zero.

C

The value of the MEMORY_MAX_TARGET parameter remains zero until it is changed manually.

D

The lower bounds of pga_AGGREGATE_TARGET and sga_TARGET parameters are set to 90 nb and270 mb， respectively

如果没有搜索结果或未解决您的问题，请直接 联系老师 获取答案。
相似问题和答案

第1题：

Examine the exhibit to view the parameters set in your parameter file. (Click the Exhibit(s) button.)You restart the instance.To what value will the MEMORY_MAX_TARGET parameter be set by default?()

A.120M

B.320M

C.480M

D.600M


参考答案：D

第2题：

You want to upgrade 150 computers from Windows NT Workstation 4.0 to Windows 2000 Professional.

You create an Unattend.txt file by using Setup Manager. You copy the file to a floppy disk.

You then start the installation on a test computer by using the Windows 2000 Professional CD-ROM.

You insert the floppy disk after the computer starts.

Although you had set the user interaction level to full unattended mode, you are prompted for all the required parameters. You want to ensure that the unattended installation does not prompt you for input.

What should you do?

A．Add a [Data] section to Unattend.txt, and set the Unattendedinstall parameter to Yes.

B．Add an [Unattend] section to Unattend.txt, and set the OEMPreinstall parameter to yes.

C．Rename Unattend.txt on the floppy disk to Winnt.sif.

D．Create a \$Oem$\$1 folder on the hard disk of the test computer, and copy Unattend.txt to the folder.


正确答案：C
解析：Explanation: When booting the computer from the CD-ROM, and then using an answer file from a floppy disk, the answer file must be named Winnt.sif.

Incorrect answers:
A: A [data] section must be added to the unattend.txt file, and the unattendedinstall Parameter must be set to YES. However, the answer file must be named winnt.sif, as it is located on the diskette.

B: An [Unattend] section in the answer file has already been created by the Setup Manager.

D: The unattend.txt file must be located on a diskette, and it must be named winnt.sif. It should not be copied to a folder named $OEM$ on the hard drive.

第3题：

You set the following parameters in the parameter file and restarted the database:Which two statements are true regarding these parameters after the database instance is restarted?()

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


参考答案：A, D

第4题：

What is true regarding a shared， server-side parameter file for a Real Application Cluster database？ （）

  • A、It can contain parameters with distinct values for each distance.
  • B、It can contain only parameters with identical values for each instance.
  • C、It must contain an IFILE parameter for each instance’s individual parameter file.
  • D、It must be located in the default location for the primary instance’s parameter file.

正确答案:A

第5题：

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.（）

  • 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.

正确答案:B

第6题：

You database is running an ARCHIVELOG mode.The following parameter are set in your database instance:LOG_ARCHIVE_FORMAT = arch+%t_%r.arcLOG_ARCHIVE_DEST_1 = ‘LOCATION = /disk1/archive’DB_RECOVERY_FILE_DEST_SIZE = 50GDB_RECOVERY_FILE = ‘/u01/oradata’Which statement is true about the archived redo log files?（）

A. They are created only in the location specified by the LOG_ARCHIVE_DEST_1 parameter.

B. They are created only in the Fast Recovery Area.

C. They are created in the location specified by the LOG_ARCHIVE_DEST_1 parameter and in the default location $ORACLE_HOME/dbs/arch.

D. They are created in the location specified by the LOG_ARCHIVE_DEST_1 parameter and the location specified by the DB_RECOVERY_FILE_DEST parameter.


参考答案：B

第7题：

In your database， the RESULT_CACHE_MODE parameter has been set to MANUAL in the initialization parameter file. You issued the following command：   SQL>SELECT /*+ RESULT_CACHE */ sale_category， sum（sale_amt） FROM sales  GROUP BY sale_category；   Where would the result of this query be stored（）？  

  • A、 database buffer cache
  • B、 shared pool
  • C、 PGA
  • D、 large pool

正确答案:B

第8题：

Which statement about Automatic Memory Management with Oracle 11g is true?()

A. You cannot specify MEMORY_TARGET if you explicitly specify SGA_TARGET or PGA_AGGREGATE_TARGET values that are greater than zero in your parameter file.

B. Oracle can reallocate memory between the SGA and PGA automatically as needed.

C. To use Automatic Memory Management, you must explicitly set both the MEMORY_TARGET and MEMORY_MAX_TARGET parameters in your parameter file.

D. You can set the MEMORY_TARGET parameter to a maximum value of the current SGA size plus the current PGA size.


参考答案：B

第9题：

You work as a database administrator for Certkiller .com. Users complain that their query is taking a long time to complete. You suspect the database buffer cache size to be the reason， and you define an alert to be generated when the buffer cache hit metric goes below 85%. When you observe the dynamic performance views， you find that the buffer cache hit ratio is 81% but no alerts are being generated.  What could be the reason for this problem？（）

  • A、The advisory memory has been turned off.
  • B、The DB_CACHE_ADVICE parameter has been set to OFF in the parameter file.
  • C、The STATISTICS_LEVEL parameter has been set to BASIC in the parameter file.
  • D、The TIMED_STATISTICS parameter has been set to FALSE in the parameter file.
  • E、The STATISTICS_LEVEL parameter has been set to TYPICAL in the parameter file.

正确答案:C

第10题：

You have been recently hired as a database administrator. Your senior manager asks you to study the production database server and submit a report on the settings done by the previous DBA.  While observing the server settings， you find that the following parameter has been set in the parameter file of the database：  REMOTE_OS_AUTHENT = TRUE  What could have been the reason to set this parameter as TRUE？（）

  • A、to enable operating system authentication for a remote client
  • B、to restrict the scope of administration to identical operating systems
  • C、to allow the start up and shut down of the database from a remote client
  • D、to enable the administration of the operating system from a remote client
  • E、to disable the administration of the operating system from a remote client

正确答案:A

更多相关问题
相关内容