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 dynam

题目

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.
相似考题

1.Whichstatementsregardingtheserverparameterfile(SPFILE)aretrue()A.AnSPFILEisabinaryfile.B.AnSPFILEcannotresideonaclient.C.AnSPFILEcannotcontainstaticparameters.D.AnSPFILEcanstorechangespersistentlyacrossinstancerestarts.E.AnSPFILEcanbereadbythedatabaseserver，butitisnotwrittentobytheserver.F.AnSPFILEmustbecreatedmanually，beforecreatingadatabase，evenifyouusetheDatabaseConfigurationAssistant（DBCA）tocreatethedatabase

2.Tomakeauditinformationmoreproductive，theDBAexecutesthefollowingcommandbeforestartinganauditoperation：SQL>ALTERSYSTEMSETAUDIT_TRAIL=DB，EXTENDEDSCOPE=SPFILE；WhichstatementistrueregardingtheauditrecordgeneratedwhenauditingstartsafterrestartingThedatabase（）A.ItcontainsonlytheplanfortheSQLstatementexecutedbytheuser.B.ItcontainstheSQLtextexecutedbytheuserandthebindvariablesusedwithit.C.ItcontainstheplanandstatisticsassociatedwiththeSQLstatementexecutedbytheuser.D.ItcontainstheplanfortheSQLstatementexecutedbytheuserandthebindvariablesusedwithit

3.WhichtwostatementsaboutAutomaticStorageManagement(ASM)aretrue?()A.ASMprovidesmirroringonfilebyfilebasis.B.ASMprovidesautomaticloadbalancingacrossallASMdisks.C.ASMsupportstheOracledatabaseandoperatingsystemfiles.D.ASMcanbeusedtostoretracefiles，alertlogfiles，andtheserverparameterfile（SPFILE）.

4.ViewtheExhibitandexaminetheoutputofthequery.Whatdoyouinferfromthis()A.TheSGA_TARGETisastaticparameter.B.Theinstanceisstarted，butthedatabaseisnotyetopen.C.Theserverparameterfile（SPFILE）wasusedtostarttheinstance.D.TheSGA_TARGETparameterdoesnothaveanyeffectonthedatabaseinstanceuntiltheSGA_MAX_SIZEparameterisspecified

更多“Your SPFILE contains&”相关问题

  • 第1题：

    ViewtheExhibitandnotethefilesavailableinthe$ORACLE_HOME/dbsfolder.TheASMinstanceisalreadyrunning.Youusedthefollowingstepstostartthedatabaseinstanceandopenthedatabase：Whichfileisusedtostarttheinstanceinthiscase（）

    A.init.ora

    B.spfile.ora

    C.initorcl.ora

    D.spfile+ASM.ora


    参考答案：B

  • 第2题：

    WhataretheprerequisitesforenablingFlashbackDatabase?()

    A.ThedatabasemustbestartedintheMOUNTEXCLUSIVEstate.

    B.Thedatabasemusthavemultiplexedcontrolfiles.

    C.Thedatabasemustbeopenedbyusingatext-basedparameterfileinsteadofaserverparameterfile（SPFILE）.

    D.ThedatabasemustbeinARCHIVELOGmode.

    E.ThedatabasemustbeintheNOMOUNTstate.

    F.ThedatabasemustbeopenedinRESTRICTEDmode.


    参考答案：A, D

  • 第3题：

    数据库参数文件的执行优先级由高到低是:()

    A. SpfileSID.ora ->initSID.ora ->spfile.ora - init.ora

    B. InitSID.ora ->spifleSID.ora ->init.ora ->spfile.ora

    C. SpfileSID.ora->spfile.ora->initSID.ora ->init.ora


    参考答案C

  • 第4题：

    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.

    正确答案:A

  • 第5题：

    Which  statements regarding the server parameter file （SPFILE） are true（）

    • A、An SPFILE is a binary file.
    • B、An SPFILE cannot reside on a client.
    • C、An SPFILE cannot contain static parameters.
    • D、An SPFILE can store changes persistently across instance restarts.
    • E、An SPFILE can be read by the database server， but it is not written to by the server.
    • F、An SPFILE must be created manually， before creating a database， even if you use the DatabaseConfiguration Assistant （DBCA） to create the database

    正确答案:A,B,D

  • 第6题：

    有关Oracle9i中Spfile和Pfile的描述，不正确的是（）。

    • A、都是数据库及例程的参数配置文件
    • B、存储的格式不同
    • C、Pfile的优先级比SPfile的高
    • D、参数生效的灵活性不同

    正确答案:C

  • 第7题：

    单选题
    Given a complete loss of your database， in what order would you need to perform the following RMAN operations to restore it？（）   a. restore controlfile  b. restore database  c. restore spfile  d. recover database  e. alter database open  f. alter database open resetlogs
    A

     b， a， c， d， e

    B

     a， c， b， d， f

    C

     c， a， b， d， e

    D

     c， a， b， d， f

    E

     e， a， b， d， c


    正确答案： C
    解析： 暂无解析

  • 第8题：

    单选题
    The database was started up using a text parameter file. What will be the default scope of changes made by using the SET clause of the ALTER SYSTEM statement？（）
    A

    Only MEMORY is updated.

    B

    Only SPFILE values are updated.

    C

    Only init.ora parameters are updated.

    D

    Both init.ora parameters and SPFILE values are updated.


    正确答案： C
    解析： 暂无解析

  • 第9题：

    单选题
    The SPFILE for your database contains the following parameter settings：   SGA_TARGET = 1000M   DB_CACHE_SIZE = 512M   SHARED_POOL_SIZE = 128M   LOG_BUFFER = 10M   DB_8K_CACHE_SIZE = 50M   What is the total memory that can be distributed across the auto-tuned memory components？（）
    A

     940M

    B

     990M

    C

     690M

    D

     1000M


    正确答案： C
    解析： 暂无解析

  • 第10题：

    多选题
    What components are present in an ASM instance？（）
    A

    SGA

    B

    Database processes

    C

    Database datafiles

    D

    Control files

    E

    Database parameter file or spfile


    正确答案： B,A
    解析： 暂无解析

  • 第11题：

    单选题
    Your database is running in ARCHIVELOG mode， and the database is open. You execute an RMAN backup and specify the KEEP clause.  Which components are backed up when this option is specified？（）
    A

     only the control file， the current SPFILE， and data files

    B

     only the current SPFILE and data files if autobackup is disabled

    C

     only the data files and the archived redo logs

    D

     the control file，current SPFILE file，data files，and archived redo logs


    正确答案： B
    解析： 暂无解析

  • 第12题：

    单选题
    How can you make a shared server-side initialization parameter file available to all instances of a Real Application Clusters database？（）
    A

    Include an SPFILE parameter in each instance-specified initialization file.

    B

    Create an SPFILE copy on each client from which the instance will be started.

    C

    Store the SPFILE in a raw partition with a vendor-specifies location and name.

    D

    Use a single client to start the instances and create the SPFILE on this client.


    正确答案： A
    解析： 暂无解析

  • 第13题：

    Whichthreestatementsregardingtheserverparameterfile(SPFILE)aretrue()

    A.AnSPFILEisabinaryfile.

    B.AnSPFILEcannotresideonaclient.

    C.AnSPFILEcannotcontainstaticparameters.

    D.AnSPFILEcanstorechangespersistentlyacrossinstancerestarts.

    E.AnSPFILEcanbereadbythedatabaseserver，butitisnotwrittentobytheserver.

    F.AnSPFILEmustbecreatedmanually，beforecreatingadatabase，evenifyouusetheDatabaseConfigurationAssistant（DBCA）tocreatethedatabase.


    参考答案：A, B, D

  • 第14题：

    如何转换init.ora到spfile？解答：使用create spfile from pfile 命令。


    正确答案：
             

  • 第15题：

    You work as a database administrator for Supportcenter.cn. In your Oracle database 10g installation you have set ORACLE_BASE to /u01/app/oracle. Which objective will be achieved by this setting？（）

    • A、The Oracle kernel will be placed in this location.
    • B、The Oracle software will be placed in this location.
    • C、The server parameter file （SPFILE） will be placed in this location.
    • D、The database files will be placed in this location， if not specified explicitly.
    • E、The location will be considered for the base of Oracle Managed Files （OMF）.
    • F、The location will be considered for the base of Optimal Flexible Architecture （OFA）.

    正确答案:F

  • 第16题：

    You are maintaining your database in Oracle10g. You are performing the backup by using the BACKUP AS BACKUPSET command at the RMAN prompt. Which file cannot be backed up by using the BACKUP AS BACKUPSET command？（）

    • A、Datafiles
    • B、 Current control file
    • C、 Server parameter file （spfile）
    • D、 Password file

    正确答案:D

  • 第17题：

    Your database is running in ARCHIVELOG mode,and the database is open. You execute an RMAN backup and specify the KEEP clause.Which components are backed up when this option is specified?（）

    • A、only the control file, the current SPFILE, and data files
    • B、only the current SPFILE and data files if autobackup is disabled
    • C、only the data files and the archived redo logs
    • D、the control file, current SPFILE file, data files, and archived redo logs

    正确答案:D

  • 第18题：

    Given a complete loss of your database， in what order would you need to perform the following RMAN operations to restore it？（）   a. restore controlfile  b. restore database  c. restore spfile  d. recover database  e. alter database open  f. alter database open resetlogs

    • A、 b， a， c， d， e
    • B、 a， c， b， d， f
    • C、 c， a， b， d， e
    • D、 c， a， b， d， f
    • E、 e， a， b， d， c

    正确答案:D

  • 第19题：

    单选题
    Your database is running in ARCHIVELOG mode,and the database is open. You execute an RMAN backup and specify the KEEP clause.Which components are backed up when this option is specified?（）
    A

    only the control file, the current SPFILE, and data files

    B

    only the current SPFILE and data files if autobackup is disabled

    C

    only the data files and the archived redo logs

    D

    the control file, current SPFILE file, data files, and archived redo logs


    正确答案： D
    解析： 暂无解析

  • 第20题：

    单选题
    You are using RMAN to backup your ARCHIVELOG mode database. You have enabled control-file autobackups. Which files are not backed up during the RMAN backup?（）
    A

    Database Datafiles 

    B

    Database Control Files 

    C

    Online redo logs

    D

    Archived redo logs 

    E

    The database SPFILE 

    F

    None of the above, all these files are backed up. 


    正确答案： D
    解析： 暂无解析

  • 第21题：

    单选题
    You have control-file autobackups enabled. When starting your database from SQL*Plus， you receive the following error message：   SQL> startup ORA-01078： failure in processing system parameters LRM-00109：  could not open parameter file ，  C:///ORACLE/PRODUCT/11.1.0/DB_1/DATABASE/INITORCL.ORA Using RMAN，   how would you respond to this error？（）
    A

     Issue the startup nomount command and then issue the restore parameter file command from the RMAN prompt.

    B

     Issue the startup nomount command and then issue the restore spfile command from the RMAN prompt.

    C

     Issue the startup nomount command and then issue the restore spfile from autobackup command from the RMAN prompt.

    D

     Issue the startup nomount command and then issue the restore spfile from backup command from the RMAN prompt.

    E

     Issue the restore spfile from autobackup command from the RMAN prompt.


    正确答案： A
    解析： 暂无解析

  • 第22题：

    单选题
    You are maintaining your database in Oracle10g. You are performing the backup by using the BACKUP AS BACKUPSET command at the RMAN prompt. Which file cannot be backed up by using the BACKUP AS BACKUPSET command？（）
    A

    Datafiles

    B

     Current control file

    C

     Server parameter file （spfile）

    D

     Password file


    正确答案： D
    解析： 暂无解析

  • 第23题：

    单选题
    If you lost your entire database，including the database spfile，control files，online redo logs，and database datafiles，what kind of recovery would be required with RMAN？（）
    A

     Complete database recovery.

    B

     Incomplete database recovery.

    C

     Approximate database recovery.

    D

     Archived database recovery.

    E

     The database could not be recovered with RMAN.


    正确答案： D
    解析： 暂无解析

  • 第24题：

    多选题
    Which  statements regarding the server parameter file （SPFILE） are true（）
    A

    An SPFILE is a binary file.

    B

    An SPFILE cannot reside on a client.

    C

    An SPFILE cannot contain static parameters.

    D

    An SPFILE can store changes persistently across instance restarts.

    E

    An SPFILE can be read by the database server， but it is not written to by the server.

    F

    An SPFILE must be created manually， before creating a database， even if you use the DatabaseConfiguration Assistant （DBCA） to create the database


    正确答案： E,B
    解析： 暂无解析

相关内容