多选题Which statements regarding the server parameter file （SPFILE） are true（）AAn SPFILE is a binary file.BAn SPFILE cannot reside on a client.CAn SPFILE cannot contain static parameters.DAn SPFILE can store changes persistently across instance restarts.EAn SPFILE can be read by the database server， but it is not written to by the server.FAn SPFILE must be created manually， before creating a database， even if you use the DatabaseConfiguration Assistant （DBCA） to create the database
多选题
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
参考解析
解析：
暂无解析
相关考题：
Which three types of files can be automatically placed in the flash recovery area (fast recovery area in 11g Release 2)?() A. Alert log fileB. Archived redo log filesC. Control file autobackupsD. Server Parameter file (SPFILE)E. Recovery Manager (RMAN) backup piece
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 filesB. only the current SPFILE and data files if autobackup is disabledC. only the data files and the archived redo logsD. the control file, current SPFILE file, data files, and archived redo logs
Which three types of files can be automatically placed in the flash recovery area (fast recovery area in 11g Release 2)?() (Choose three.) A. Alert log fileB. Archived redo log filesC. Control file autobackupsD. Server Parameter file (SPFILE)E. Recovery Manager (RMAN) backup piece
ViewtheExhibitandnotethefilesavailableinthe$ORACLE_HOME/dbsfolder.TheASMinstanceisalreadyrunning.Youusedthefollowingstepstostartthedatabaseinstanceandopenthedatabase：Whichfileisusedtostarttheinstanceinthiscase（）A.init.oraB.spfile.oraC.initorcl.oraD.spfile+ASM.ora
数据库参数文件的执行优先级由高到低是:() A. SpfileSID.ora ->initSID.ora ->spfile.ora - init.oraB. InitSID.ora ->spifleSID.ora ->init.ora ->spfile.oraC. SpfileSID.ora->spfile.ora->initSID.ora ->init.ora
Which three 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.
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）.
After you have restored and recovered a database to a new host by using a previously performed Recovery Manager （RMAN） backup， which is the best option you would consider for the new database？（） A、 Opening the database in RESTRICTED modeB、 Opening the database with the RESETLOGS optionC、 Setting a new DBID for the newly restored databaseD、 Restoring the server parameter file （SPFILE） to the new host
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、DatafilesB、 Current control fileC、 Server parameter file （spfile）D、 Password file
Which two statements about Automatic Storage Management （ASM） are true？（）A、ASM provides mirroring on file by file basis.B、ASM provides automatic load balancing across all ASM disks.C、ASM supports the Oracle database and operating system files.D、ASM can be used to store trace files， alert log files， and the server parameter file （SPFILE）.
Your database is running in ARCHIVELOG mode, and the database is open. You execute an RMAN backupand specify the KEEP clause.Which components are backed up when this option is specified?（）A、only the control file, the current SPFILE, and data filesB、only the current SPFILE and data files if autobackup is disabledC、only the data files and the archived redo logsD、the control file, current SPFILE file, data files, and archived redo logs
Which three types of files can be automatically placed in the flash recovery area (fast recovery area in 11g Release 2)?（） (Choose three.)A、Alert log fileB、Archived redo log filesC、Control file autobackupsD、Server Parameter file (SPFILE)E、Recovery Manager (RMAN) backup piece
What components are present in an ASM instance？（）A、 SGAB、 Database processesC、 Database datafilesD、 Control filesE、 Database parameter file or spfile
Which three types of files can be automatically placed in the flash recovery area fast recovery area in 11g Release 2？（）A、 Alert log fileB、 Archived redo log filesC、 Control file autobackupsD、 Server Parameter file （SPFILE）E、 Recovery Manager （RMAN） backup piece
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.
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.
Your database is started by using the server parameter file （SPFILE）. You issued this command to change the value of the LOG_BUFFER initialization parameter： ALTER SYSTEM SET LOG_BUFFER=24M SCOPE=BOTH； What would be the outcome of this command？ （）A、The command would return an error because LOG_BUFFER is a static parameter.B、The parameter value would be changed and it would come into effect immediately.C、You need to restart the database so that parameter changes can come into effect.D、The command would succeed only if initialization parameter LOG_ARCHIVE_MAX_PROCESS is set to value 2.
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.
多选题Which statements regarding the server parameter file （SPFILE） are true（）AAn SPFILE is a binary file.BAn SPFILE cannot reside on a client.CAn SPFILE cannot contain static parameters.DAn SPFILE can store changes persistently across instance restarts.EAn SPFILE can be read by the database server， but it is not written to by the server.FAn SPFILE must be created manually， before creating a database， even if you use the DatabaseConfiguration Assistant （DBCA） to create the database
单选题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（）AThe command succeeds only if Automatic Memory Management is not enabled.BThe command succeeds， but you need to restart the database for changes to take effect.CThe command returns an error because the size of the redo log buffer cannot be changed dynamically.DThe parameter value is changed and it comes into effect as soon as space becomes available in the System Global Area （SGA）.
多选题Which two statements about Automatic Storage Management （ASM） are true？（）AASM provides mirroring on file by file basis.BASM provides automatic load balancing across all ASM disks.CASM supports the Oracle database and operating system files.DASM can be used to store trace files， alert log files， and the server parameter file （SPFILE）.
多选题Which three types of files can be automatically placed in the flash recovery area (fast recovery area in 11g Release 2)?（） (Choose three.)AAlert log fileBArchived redo log filesCControl file autobackupsDServer Parameter file (SPFILE)ERecovery Manager (RMAN) backup piece
单选题How can you make a shared server-side initialization parameter file available to all instances of a Real Application Clusters database？（）AInclude an SPFILE parameter in each instance-specified initialization file.BCreate an SPFILE copy on each client from which the instance will be started.CStore the SPFILE in a raw partition with a vendor-specifies location and name.DUse a single client to start the instances and create the SPFILE on this client.
多选题What components are present in an ASM instance？（）ASGABDatabase processesCDatabase datafilesDControl filesEDatabase parameter file or spfile
单选题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？（）ADatafilesB Current control fileC Server parameter file （spfile）D Password file
多选题Which three types of files can be automatically placed in the flash recovery area (fast recovery area in 11g Release 2)?（）AAlert log fileBArchived redo log filesCControl file autobackupsDServer Parameter file (SPFILE)ERecovery Manager (RMAN) backup piece
单选题Your database is running in ARCHIVELOG mode, and the database is open. You execute an RMAN backupand specify the KEEP clause.Which components are backed up when this option is specified?（）Aonly the control file, the current SPFILE, and data filesBonly the current SPFILE and data files if autobackup is disabledConly the data files and the archived redo logsDthe control file, current SPFILE file, data files, and archived redo logs