网友您好， 请在下方输入框内输入要搜索的题目：
题目内容
（请给出正确答案）
Examinethefollowingparametersettingsfromaninitialization（init.ora）file：DB_CREATE_FILE_DEST=’/u01/oradata/’DB_CREATE_ONLINE_LOG_DEST_1=’/u02/oradata/’DB_CREATE_ONLINE_LOG_DEST_2=’/u03/oradata/’IfyoucreateanOracleManagedFiles（OMF）databaseusingthesesettings，whatistheresult？（）
A.A
B.B
C.C
D.D
参考答案
更多 “ Examinethefollowingparametersettingsfromaninitialization（init.ora）file：DB_CREATE_FILE_DEST=’/u01/oradata/’DB_CREATE_ONLINE_LOG_DEST_1=’/u02/oradata/’DB_CREATE_ONLINE_LOG_DEST_2=’/u03/oradata/’IfyoucreateanOracleManagedFiles（OMF）databaseusingthesesettings，whatistheresult？（）A.AB.BC.CD.D ” 相关考题
考题
Viewthisparametersettinginyourdatabase：DB_CREATE_FILE_DEST=’D：\oracle\product\10.2.0\oradata\oracle’Youcreatedatablespacebyusingthiscommand：CREATETABLESPACEUSERS；WhichtwostatementsaretrueabouttheUSERStablespace？（）A.Thetablespacehastwodatafiles.B.Anerrorisreportedandtablespacecreationfails.C.Datafilesarecreatedwithnamesgeneratedbytheinstance.D.Thetablespacecanbeextendedwithoutspecifyingthedatafile.E.DatafilesbelongingtotheUSERStablespacecannotberenamed.
考题
Williamspecifiedthefollowinginitializationparametersettingsinthepfile：BACKGROUND_DUMP_DEST=’u01\oradata\dir_A’USER_DUMP_DEST=’u01\oradata\dir_B’DB_CREATE_FILE_DEST=’u01\oradata\dir_C’DB_CREATE_ONLINE_LOG_DEST_n=’u01\oradata\dir_D’Williamenabledthechange-trackingfeaturebecausehedoesnotwanttoscantheentiredatafileduringbackup.Whatisthedefaultstoragelocationforthechangetrackingfile？（）A.’u01\oradata\dir_A’B.’u01\oradata\dir_B’C.’u01\oradata\dir_C’D.’u01\oradata\dir_D’
考题
数据库参数文件的执行优先级由高到低是:()
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 of the following choices identifies a database component that will be used for multiplexing control files?（）A、V$CONTROLFILE B、V$DATABASE C、init.ora D、DBA FILES
考题
How is block-change tracking enabled？（） A、 With alter database enable block change trackingB、 With alter system enable block change trackingC、 With an init.ora parameter changeD、 With an spfile parameter change
考题
You decided to configure the flash recovery area in your database to centralize the storage of all the recovery files in a certain location on disk. Which two parameters will you specify in the init.ora file？（）A、 DB_CREATE_FILE_DESTB、 DB_RECOVERY_FILE_DESTC、 DB_RECOVERY_FILE_DEST_SIZED、 DB_ONLINE_LOG_DEST_n
考题
ASM supports all but which of the following file types？（）A、 Database filesB、 SpfilesC、 Redo-log filesD、 Archived log filesE、 RMAN backup setsF、 Password filesG、 init.ora files
考题
View this parameter setting in your database： DB_CREATE_FILE_DEST=’D:// /oracle/product/10.2.0/oradata/oracle’ You created a tablespace by using this command： CREATE TABLESPACE USERS； Which two statements are true about the USERS tablespace？（）A、The tablespace has two data files.B、An error is reported and tablespace creation fails.C、Data files are created with names generated by the instance.D、The tablespace can be extended without specifying the data file.E、Data files belonging to the USERS tablespace cannot be renamed.
考题
If you wanted to find the name and location of your control files, you could find that information in each of the following locations except one. Which is it?（）A、V_CONTROLFILE_RECORD_SECTION B、V_CONTROLFILE C、V$PARAMETER D、init.ora file
考题
Which of the following steps is incorrect in the following sequence of enabling the ARCHIVELOG mode of a database？（）A、Shut down the database.B、Set the appropriate parameters in init.ora file.C、Start the database in NOMOUNT state.D、Issue the ALTER DATABASE ARCHIVELOG command.E、Open the database.F、Take a full closed backup.
考题
You are maintaining the PROD database of TeleSoft Corporation. You have initialized the following DB_BLOCK_CHECKING parameter in the init.ora file： DB_BLOCK_CHECKING = TRUE； What will be the result of setting this parameter？（）A、 Only data blocks of the SYSTEM tablespace will be checked.B、 Only data blocks of the SYSAUX tablespace will be checked.C、 A checksum will occur only on the checkpoint.D、 A checksum will occur every time a block is modified.
考题
You issue the following command in Oracle: CREATE TABLESPACE DAT_TBS DATAFILE "dat_tbs.dbf" SIZE 2M;. Later queries against the database reveal that the tablespace is located in the /u01/oradata/oracle directory. Which of the following choices identifies how Oracle likely determined what directory to place dat_tbs.dbf file in?（）A、DB_CREATE_FILE_DEST B、DB_CREATE_ONLINE_LOG_1 C、DB_CREATE_ONLINE_LOG_2D、The directory is an operating system-specific default value in Oracle that can neigher be specified manually nor changed
考题
You want an ASM instance to manage the files of your database. To achieve this objective， you specify the following parameters in the parameter file of the database： INSTANCE_TYPE = RDBMS DB_NAME = PROD LARGE_POOL_SIZE = 8MB DB_BLOCK_SIZE = 4K LOG_ARCHIVE_DEST = +dgroupA LOG_ARCHIVE_FORMAT = "$ORACLE_SID_%s_%t.%t" DB_CREATE_FILE_DEST = +dgroupA COMPATIBLE = 10.1.0.2.0 CONTROL_FILES = +dgroupA Which parameter would be ignored while starting up the instance for the database PROD？（）A、DB_BLOCK_SIZEB、CONTROL_FILESC、LARGE_POOL_SIZED、LOG_ARCHIVE_DESTE、LOG_ARCHIVE_FORMATF、DB_CREATE_FILE_DEST
考题
单选题You want an ASM instance to manage the files of your database. To achieve this objective， you specify the following parameters in the parameter file of the database： INSTANCE_TYPE = RDBMS DB_NAME = PROD LARGE_POOL_SIZE = 8MB DB_BLOCK_SIZE = 4K LOG_ARCHIVE_DEST = +dgroupA LOG_ARCHIVE_FORMAT = "$ORACLE_SID_%s_%t.%t" DB_CREATE_FILE_DEST = +dgroupA COMPATIBLE = 10.1.0.2.0 CONTROL_FILES = +dgroupA Which parameter would be ignored while starting up the instance for the database PROD？（）A
LARGE_POOL_SIZEB
DB_CREATE_FILE_DESTC
LOG_ARCHIVE_DESTD
CONTROL_FILESE
LOG_ARCHIVE_FORMATF
DB_BLOCK_SIZE
考题
多选题You decided to configure the flash recovery area in your database to centralize the storage of all the recovery files in a certain location on disk. Which two parameters will you specify in the init.ora file？（）ADB_CREATE_FILE_DESTBDB_RECOVERY_FILE_DESTCDB_RECOVERY_FILE_DEST_SIZEDDB_ONLINE_LOG_DEST_n
考题
单选题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 of the following steps is incorrect in the following sequence of enabling the ARCHIVELOG mode of a database？（）A
Shut down the database.B
Set the appropriate parameters in init.ora file.C
Start the database in NOMOUNT state.D
Issue the ALTER DATABASE ARCHIVELOG command.E
Open the database.F
Take a full closed backup.
考题
单选题You are maintaining an OLTP database in Oracle10g. You find that the database is generating a large number of trace files. You decide to disable the trace files generated by the ARCn background process. Which action will enable you to disable the trace files generated by the ARCn background process？（）A
Remove the LOG_ARCHIVE_DEST parameter from the init.ora file.B
Set the value of the SQL_TRACE parameter to FALSE in the init.ora file.C
Use the DBMS_MONITOR.SESSION_TRACE_DISABLE procedure.D
Set the value of the LOG_ARCHIVE_TRACE initialization parameter to zero.
考题
单选题You are working as a DBA in an organization. The flash recovery area files are created in ’+disk1’. You want to create new flash recovery area files in the ’+disk2’ location. The new location of the flash recovery area files should be written in the control file and the spfile.Which command will you issue to change the location of the flash recovery area files？（）A
ALTER SYSTEM SET DB_RECOVERY_FILE_DEST = ’+disk2’ ；B
ALTER SYSTEM SET DB_RECOVER_FILE_DEST = ’+disk2’ SCOPE = BOTH；C
ALTER SYSTEM SET DB_CREATE_FILE_DEST = ’+disk2’；D
ALTER SYSTEM SET DB_CREATE_ONLINE_LOG_DEST_n = ’+disk2’；
考题
单选题William specified the following initialization parameter settings in the pfile： BACKGROUND_DUMP_DEST = ’u01/oradata/dir_A’ USER_DUMP_DEST = ’u01/oradata/dir_B’ DB_CREATE_FILE_DEST = ’u01/oradata/dir_C’ DB_CREATE_ONLINE_LOG_DEST_n = ’u01/oradata/dir_D’ William enabled the change-tracking feature because he does not want to scan the entire datafile during backup. What is the default storage location for the change tracking file？（）A
’u01/oradata/dir_A’B
’u01/oradata/dir_B’C
’u01/oradata/dir_C’D
’u01/oradata/dir_D’
考题
单选题You are managing the Oracle database. Which of the following choices correctly identifies when Oracle reads the contents of the init.ora file?（）A
When the instance is started B
When the database is mounted C
When the database is opened D
When the database is closed
考题
单选题You want an ASM instance to manage the files of your database. To achieve this objective， you specify the following parameters in the parameter file of the database： INSTANCE_TYPE = RDBMS DB_NAME = PROD LARGE_POOL_SIZE = 8MB DB_BLOCK_SIZE = 4K LOG_ARCHIVE_DEST = +dgroupA LOG_ARCHIVE_FORMAT = "$ORACLE_SID_%s_%t.%t" DB_CREATE_FILE_DEST = +dgroupA COMPATIBLE = 10.1.0.2.0 CONTROL_FILES = +dgroupA Which parameter would be ignored while starting up the instance for the database PROD？（）A
DB_BLOCK_SIZEB
CONTROL_FILESC
LARGE_POOL_SIZED
LOG_ARCHIVE_DESTE
LOG_ARCHIVE_FORMATF
DB_CREATE_FILE_DEST
考题
单选题You are maintaining the PROD database of TeleSoft Corporation. You have initialized the following DB_BLOCK_CHECKING parameter in the init.ora file： DB_BLOCK_CHECKING = TRUE； What will be the result of setting this parameter？（）A
Only data blocks of the SYSTEM tablespace will be checked.B
Only data blocks of the SYSAUX tablespace will be checked.C
A checksum will occur only on the checkpoint.D
A checksum will occur every time a block is modified.
考题
多选题View this parameter setting in your database： DB_CREATE_FILE_DEST=’D:// /oracle/product/10.2.0/oradata/oracle’ You created a tablespace by using this command： CREATE TABLESPACE USERS； Which two statements are true about the USERS tablespace？（）AThe tablespace has two data files.BAn error is reported and tablespace creation fails.CData files are created with names generated by the instance.DThe tablespace can be extended without specifying the data file.EData files belonging to the USERS tablespace cannot be renamed.
热门标签
最新试卷
