多选题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
You set the following parameters in the parameter file and restarted the database:Which two statements are true regarding these parameters after the database instance is restarted?() A. The MEMORY_MAX_TARGET parameter is automatically set to 500 MBB. The value of the MEMORY_MAX_TARGET parameter remains zero till it is changed manuallyC. The PGA_AGGREGATE_TARGET and SGA_TARGET parameters are automatically set to zeroD. The lower bounds of PGA_AGGREGATE_TARGET and SGA_TARGET parameters are set to 90 MB and 270 MB, respectively
Which tow statements are most correct regarding opt-in models?（）A、A based opt-in model uses virtualized identifiersB、A based opt-in model uses hardware values as identifiersC、A logical server opt-in model uses virtualized identifiersD、A logical server opt-in model uses hardware values as identifiers
Which two statements are true regarding trace options on Junos devices?（）A、You can see the contents of the log file by entering the show log filename commandB、Trace options will send information to your screen automaticallyC、Trace options are limited to one protocol at a timeD、The file name and set of flags may be specified when enabling trace options
Your boss at Certkiller .com wants you to clarify Oracle 10g. Which statement regarding the contents of the V$PARAMETER view is true？（）A、Displays only the list of default valuesB、Displays only the list of all basic parametersC、Displays the currently in effect parameter valuesD、Displays only the list of all advanced parametersE、Displays the list of all the parameter files of a databaseF、Displays the current contents of the server parameter file.
You are connected to Recovery Manager （RMAN） without a recovery catalog. There is no copy of the control file available. You want to restore the control file from an autobackup. To retrieve the autobackup， you need the database ID （DBID）. In which two sources would you find the DBID？ （）A、 the alert log fileB、 the server parameter fileC、 the formatted name of a control file autobackupD、 an RMAN session log fileE、 the trace file
The database is running in ARCHIVELOG mode. Examine the initialization parameters and theirvalues set to enable archiving on your database server： LOG_ARCHIVE_FORMAT = arch_%t_%s_%r.arc LOG_ARCHIVE_DEST_1 = ’LOCATION = /disk1/archive’ DB_RECOVERY_FILE_DEST = ’/u01/oradata’ DB_RECOVERY_FILE_DEST_SIZE = 20G Which statement is true regarding the archived redo log files（）A、It will be created on the local file system.B、It will be created only in the Flash Recovery Area.C、It will be created in the location specified by the LOG_ARCHIVE_DEST_1 parameter and the defaultlocation $ORACLE_HOME/dbs.D、It will be created in the location specified by the LOG_ARCHIVE_DEST_1 parameter and locationspecified by the DB_RECOVERY_FILE_DEST parameter.
What is true regarding a shared， server-side parameter file for a Real Application Cluster database？ （）A、It can contain parameters with distinct values for each distance.B、It can contain only parameters with identical values for each instance.C、It must contain an IFILE parameter for each instance’s individual parameter file.D、It must be located in the default location for the primary instance’s parameter file.
You performed the RMAN database backup with the KEEP option. Which two statements are true regarding this backup？（）A、 The backup contains data files， the server parameter file，and the control file even if the control file autobackup is disabled.B、 The KEEP option overrides the configured retention policy.C、 The backup contains only data files and archived redo log files.D、 The KEEP option is an attribute of an individual backup piece.
You performed the RMAN database backup with the KEEP option.Which two statements are true about this backup?（） (Choose two)A、The KEEP option overrides the configured retention policyB、The KEEP option is an attribute of an individual backup pieceC、The backup contains only data files and archived redo log filesD、The backup contains data files, the server parameter file and the control file even if the control file auto backup is disabled
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 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 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）.
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
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
Which two statements regarding the control file and Recover Manager are true？ （）A、The control file can grow in size.B、The control file can store RMAN scripts.C、CONTROL_FILE_RECORD_KEEP_TIME determines retention time for RMAN records.D、The RMAN catalog can exist solely in the control file of the target database.
Which two files in the database can be configured for automatic backups by using the autobackupfeature in Recovery Manager （RMAN）（）A、data filesB、control filesC、parameter fileD、online redo log filesE、server parameter file
Which two files in the database can be configured for automatic backups by using the autobackup feature inRecovery Manager （RMAN）（）A、Data filesB、Control filesC、Parameter fileD、Online redo log filesE、Server parameter file
多选题Which two statements are true regarding the SGA_TARGET initialization parameter（）AIt can be increased up to the value of the SGA_MAX_SIZE parameter.BIncreasing the value of the SGA_TARGET parameter distributes the increased memory among all the Autotuned components.CReducing the value of the SGA_TARGET parameter deallocates memory from both autotuned and Manually sized components.DIncreasing the value of SGA_TARGET up to the value of SGA_MAX_SIZE disables the automatic shared Memory management feature.
多选题You performed the RMAN database backup with the KEEP option.Which two statements are true about this backup?（） (Choose two)AThe KEEP option overrides the configured retention policyBThe KEEP option is an attribute of an individual backup pieceCThe backup contains only data files and archived redo log filesDThe backup contains data files, the server parameter file and the control file even if the control file auto backup is disabled
多选题You performed the RMAN database backup with the KEEP option. Which two statements are true regarding this backup？（）AThe backup contains data files， the server parameter file，and the control file even if the control file autobackup is disabled.BThe KEEP option overrides the configured retention policy.CThe backup contains only data files and archived redo log files.DThe KEEP option is an attribute of an individual backup piece.
多选题Which two statements regarding the control file and Recover Manager are true？ （）AThe control file can grow in size.BThe control file can store RMAN scripts.CCONTROL_FILE_RECORD_KEEP_TIME determines retention time for RMAN records.DThe RMAN catalog can exist solely in the control file of the target database.
多选题Which two statements are true regarding trace options on Junos devices?（）AYou can see the contents of the log file by entering the show log filename commandBTrace options will send information to your screen automaticallyCTrace options are limited to one protocol at a timeDThe file name and set of flags may be specified when enabling trace options
单选题Your boss at Certkiller .com wants you to clarify Oracle 10g. Which statement regarding the contents of the V$PARAMETER view is true？（）ADisplays only the list of default valuesBDisplays only the list of all basic parametersCDisplays the currently in effect parameter valuesDDisplays only the list of all advanced parametersEDisplays the list of all the parameter files of a databaseFDisplays the current contents of the server parameter file.
单选题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
单选题What is true regarding a shared， server-side parameter file for a Real Application Cluster database？ （）AIt can contain parameters with distinct values for each distance.BIt can contain only parameters with identical values for each instance.CIt must contain an IFILE parameter for each instance’s individual parameter file.DIt must be located in the default location for the primary instance’s parameter file.
单选题The database is running in ARCHIVELOG mode. Examine the initialization parameters and theirvalues set to enable archiving on your database server： LOG_ARCHIVE_FORMAT = arch_%t_%s_%r.arc LOG_ARCHIVE_DEST_1 = ’LOCATION = /disk1/archive’ DB_RECOVERY_FILE_DEST = ’/u01/oradata’ DB_RECOVERY_FILE_DEST_SIZE = 20G Which statement is true regarding the archived redo log files（）AIt will be created on the local file system.BIt will be created only in the Flash Recovery Area.CIt will be created in the location specified by the LOG_ARCHIVE_DEST_1 parameter and the defaultlocation $ORACLE_HOME/dbs.DIt will be created in the location specified by the LOG_ARCHIVE_DEST_1 parameter and locationspecified by the DB_RECOVERY_FILE_DEST parameter.
多选题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