Your SPFILE contains the following parameter settings：   SGA_TARGET = 8G   DB_CACHE_SIZE = 4G   SHARED_POOL_SIZE = 2G   LARGE_POOL_SIZE = 512M   JAVA_POOL_SIZE = 512M   LOG_BUFFER = 100M   SGA_MAX_SIZE = 10G   You query the V$SGA_DYNAMIC_COMPONENTS dynamic performance view and discover that the large pool component is currently sized at 1G. You want the value of the SGA_TARGET initialization parameter to 10G， but instead of specifying a value of 10G for the SGA_TARGET initialization parameter， you erroneously execute the following statement：   SQL>ALTER SYSTEM SET SGA_TARGET = 0 SCOPE = BOTH；   What is the result of this statement？（）  

A、 The database crashes.

B、 The large pool releases 512M of memory.

C、 The large pool retains 1G of allocated memory.

D、 The large pool increases to 1，512M of memory.

相关问题推荐

• You have joined a new organization as a Database Administrator. The Security Administrator in your organization has kept human errors， such as erroneously dropping users， tables， and important data， to a minimum by carefully granting only the necessary privileges to each user. As a result of several ongoing transactions within your database， you discover that the flashback logs are rapidly increasing in the flash recovery area. To avoid out-of-space errors， you decide to delete the flashback logs from the flash recovery area. How can you delete the flashback logs from the database if your database is up and running？（）

  A、 Shut down the database using the SHUTDOWN command. Mount the database using the STARTUP MOUNT EXCLUSIVE command and disable Flashback Database using the ALTER DATABASE FLASHBACK OFF statement.

  B、 Change the parameter setting in the SPFILE for the DB_RECOVERY_FILE_DEST parameter using the ALTER SYSTEM SET DB_RECOVERY_FILE_DEST=’’ SCOPE=BOTH statement while the database is up and running.

  C、 Shut down the database using the SHUTDOWN command. Mount the database using the STARTUP MOUNT EXCLUSIVE command. Change the parameter setting in the SPFILE for the DB_RECOVERY_FILE_DEST parameter using the ALTER SYSTEM SET DB_RECOVERY_FILE_DEST=’’ SCOPE=BOTH statement. Disable Flashback Database using the ALTER DATABASE FLASHBACK OFF statement.

  D、 Change the parameter setting in the SPFILE for the DB_RECOVERY_FILE_DEST parameter using the ALTER SYSTEM SET DB_RECOVERY_FILE_DEST=’’ SCOPE=BOTH statement. Shut down the database using the SHUTDOWN command. Mount the database using the STARTUP MOUNT EXCLUSIVE command and disable Flashback Database using the ALTER DATABASE FLASHBACK OFF statement.

  查看答案

• You are maintaining the SALES database of a company. You have never backed up the USERS tablespace that is currently offline. On Sunday， you issued the following commands：   CONFIGURE DEFAULT DEVICE TYPE TO sbt；   CONFIGURE BACKUP OPTIMIZATION ON；   CONFIGURE RETENTION POLICY TO REDUNDANCY 3；   From Monday to Saturday， you performed the following actions：   Day                         Action  Monday                BACKUP DATABASE  Tuesday                BACKUP DATABASE  Wednesday              BACKUP DATABASE  Thursday               BACKUP DATABASE  Friday                 BACKUP DATABASE  Saturday               BACKUP DATABASE  How many times will the backup of the USERS tablespace be performed？（）

  A、 The backup will not be performed at all.

  B、 three times

  C、 four times

  D、 six times

  查看答案

• Users are performing a large volume of inserts and deletes on the application tables in the APPS tablespace. You observe that there are several warning alerts being generated for the APPS tablespace space usage metrics. Currently， the warning threshold for the tablespace space usage metrics is set to 70%.  To make the generated alerts more useful as a problem identification tool， you want to reduce the frequency of alert generation for the tablespace space usage metrics for the APPS tablespace. What should you do？（）

  A、disable SQL tracing for theAPPS tablespace

  B、disable logging attribute for the APPS tablespace

  C、modify the tablespace to be a dictionary­managed tablespace

  D、increase the critical threshold value for the tablespace space usage metrics for the APPS tablespace

  E、increase the warning threshold value for the tablespace space usage metrics for the APPS tablespace

  查看答案

• public class Yippee {  public static void main（String [] args） {  for（int x = 1； x 

  A、 No output is produced. 123

  B、 No output is produced. 234

  C、 No output is produced. 1234

  D、 An exception is thrown at runtime. 123

  E、 An exception is thrown at runtime. 234

  F、 An exception is thrown at rijntime. 1234

  查看答案

• Flashback Database is enabled in your Oracle 10g database. One of your database users erroneously purged an important table residing in his schema. The table was purged sometime between 10：00 P.M. and 10：30 P.M. The next day， you decide to flash back the database. Before you flash back the database， you want to ensure that you have all the necessary flashback data. Which dynamic performance view must you use to determine whether you have the required flashback data to recover the purged table？（）

  A、 V$DATABASE

  B、 V$UNDOSTAT

  C、 V$FLASHBACK_DATABASE_LOG

  D、 V$FLASHBACK_DATABASE_STAT

  查看答案