A.renaming the control filesB.re-creating the control f……

单项选择题View the Exhibit and examine the output of the query.  What do you infer from this（）

A.The SGA_TARGET is a static parameter.
B.The instance is started， but the database is not yet open.
C.The server parameter file （SPFILE） was used to start the instance.
D.The SGA_TARGET parameter does not have any effect onthe databaseinstance untiltheSGA_MAX_SIZE parameter is specified.

多项选择题Whichthreestatementsregardingtheserverparameterfile（SPFILE）aretrue（）

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.

多项选择题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.