1Z0-052
多选题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
题目
An SPFILE is a binary file.
An SPFILE cannot reside on a client.
An SPFILE cannot contain static parameters.
An SPFILE can store changes persistently across instance restarts.
An SPFILE can be read by the database server， but it is not written to by the server.
An SPFILE must be created manually， before creating a database， even if you use the DatabaseConfiguration Assistant （DBCA） to create the database
相似问题和答案
第1题：
A. Alert log file
B. Archived redo log files
C. Control file autobackups
D. Server Parameter file (SPFILE)
E. Recovery Manager (RMAN) backup piece
第2题：
如何转换init.ora到spfile？解答：使用create spfile from pfile 命令。
第3题：
A. Alert log file
B. Archived redo log files
C. Control file autobackups
D. Server Parameter file (SPFILE)
E. Recovery Manager (RMAN) backup piece
第4题：
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 mode
- B、 Opening the database with the RESETLOGS option
- C、 Setting a new DBID for the newly restored database
- D、 Restoring the server parameter file （SPFILE） to the new host
正确答案:B
第5题：
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.
正确答案:A,B,D
第6题：
ViewtheExhibitandnotethefilesavailableinthe$ORACLE_HOME/dbsfolder.TheASMinstanceisalreadyrunning.Youusedthefollowingstepstostartthedatabaseinstanceandopenthedatabase：Whichfileisusedtostarttheinstanceinthiscase（）
A.init.ora
B.spfile.ora
C.initorcl.ora
D.spfile+ASM.ora
第7题：
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
第8题：
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
第9题：
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）.
正确答案:C
第10题：
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