多选题Which three 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 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.
参考解析
解析：
暂无解析
相关考题：
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 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
You are planning the creation of a new multitenant container database (CDB) and want to store the ROOT and SEED container data files in separate directories.You plan to create the database using SQL statements.Which three techniques can you use to achieve this?（）A. Use Oracle Managed Files (OMF).B. Specify the SEED FILE_NAME_CONVERT clause.C. Specify the PDB_FILE_NAME_CONVERT initialization parameter.D. Specify the DB_FILE_NAMECONVERT initialization parameter.E. Specify all files in the CREATE DATABASE statement without using Oracle managed Files (OMF).
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.
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.
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
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 three statements are characteristic of the MEMORY storage engine?（）A、It can support transactionsB、Table contents are not saved if the server is restartedC、It cannot contain text or BLOB columnsD、It can support foreign keysE、Each table is represented on disk as an.frm fileF、Each table has a corresponding.MYI and .MYD file
多选题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 external authentication servers for firewall userauthentication are true？（）AUp to three external authentication server types can be used simultaneously.BOnly one external authentication server type can be used simultaneously.CIf the local password database is not configured in the authentication order， and the configured authentication server is unreachable， authentication is not performed.DIf the local password database is not configured in the authentication order， and the configured authentication server rejects the authentication request， authentication is not performed
单选题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 have created a password file using the following command： ORAPWD file=d：/oracle/ora9i/orapwU01 password=change_on_install entries=3 Which of the following is true about this password file？（）A If the REMOTE_LOGIN_PASSWORDFILE parameter is set to SHARED in the initialization parameter file， then a maximum of three users can be granted the SYSDBA or SYSOPER privileges.B If the REMOTE_LOGIN_PASSWORDFILE parameter is set to EXCLUSIVE in the initialization parameter file， then a maximum of three users can be granted the SYSDBA or SYSOPER privileges.C If the REMOTE_LOGIN_PASSWORDFILE parameter is set to SHARED in the initialization parameter file， then the SYSDBA and SYSOPER privileges can be granted to other users as long as space in the password file isD If the REMOTE_LOGIN_PASSWORDFILE parameter is set to EXCLUSIVE in the initialization parameter file， then the SYSDBAand SYSOPER privileges can be granted to other users as long as space in the password file is available.
多选题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
多选题Which three statements are characteristic of the MEMORY storage engine?（）AIt can support transactionsBTable contents are not saved if the server is restartedCIt cannot contain text or BLOB columnsDIt can support foreign keysEEach table is represented on disk as an.frm fileFEach table has a corresponding.MYI and .MYD file
多选题You are planning the creation of a new multitenant container database (CDB) and want to store the ROOT and SEED container data files in separate directories. You plan to create the database using SQL statements. Which three techniques can you use to achieve this?（）AUse Oracle Managed Files (OMF).BSpecify the SEED FILE_NAME_CONVERT clause.CSpecify the PDB_FILE_NAME_CONVERT initialization parameter.DSpecify the DB_FILE_NAMECONVERT initialization parameter.ESpecify all files in the CREATE DATABASE statement without using Oracle managed Files (OMF).
单选题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.
多选题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