View the Exhibit and examine the initialization parameter settings. Which three initialization parameters are to be set manually as they are not automatically tuned()
A.LOG_BUFFER B.SORT_AREA_SIZE C.JAVA_POOL_SIZE D.STREAMS_POOL_SIZE E.DB_16K_CACHE_SIZE F.DB_KEEP_CACHE_SIZE
单项选择题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).
单项选择题View the Exhibit. You are creating an additional database by using the Database Configuration Assistant (DBCA). Youopted to create a General Purpose database and during the database creation realize that the Block Sizefield is not enabled. What could be the reason for this()
A.You have chosen the File System option as the storage option. B.You have chosen the Automatic Storage Management (ASM) as the storage option. C.The data block size can be increased only when DBCA is invoked from Oracle Universal Installer (OUI). D.You are using General Purpose template and not the Custom Database template to create the database.
单项选择题You are working on a new Oracle Database 11g server, where only the software is installed and nodatabase is created. You plan to create a database on this server using the Database Configuration Assistant (DBCA). Some of the requirements set for your database creation task are: 1:Configure the database to operate in shared server mode. 2:Disable automatic maintenance tasks such as optimizer statistics collection. 3:Configure a naming method to help the remote user connect to the database instance. 4:Use Automatic Storage Management (ASM) for storing the database files. 5:Configure daily database backup to flash recovery area. 6:Configure Enterprise Manager Database Control to manage the database. Which of these requirements can be met while creating the database()
A.4 and 6 B.2,3,4,and 6 C.1,2,4,5,and 6 D.1,2,3,4,5,and 6
单项选择题View the Exhibit. What would happen if Oracle Home is not empty()
A.The installation will not be continued until the location is empty. B.The installation will proceed without overwriting the existing files. C.The installation can be continued, but the existing files will be overwritten. D.The installation terminates automatically after showing an error message
单项选择题You are installing Oracle Database 11g on a machine. When you run the installer, the OracleUniversal Installer (OUI) shows the message that says one of the product-specific prerequisite checkshas failed: Checking available swap space requirements ... Expected result: 1512MB Actual Result: 1018MB Check complete. The overall result of this check is: Failed <<<< Problem: The system does not have the required swap space. What happens to the installation in this situation()
A.It can be continued. B.It resizes the swap space automatically when you proceed further. C.It can be continued, but the instance cannot be started without increasing the swap space. D.It shows a message saying one or more prerequisite checks have failed and the installation cannotproceed.