网友您好， 请在下方输入框内输入要搜索的题目：
题目内容
（请给出正确答案）
单选题
You decided to change the location of the flash recovery area. You executed the following command： Which statement is true？（）
A
The location can be changed only if the flash recovery area is empty.
B
After executing the command， all new flash recovery area files will be created in the new location.
C
The command will generate an error because you cannot change the flash recovery area while the database is open.
D
All the existing files in the flash recovery area will be moved to the new location， and all new Flash Recovery Area files will be created in the new location.
参考答案
参考解析
解析：
暂无解析
更多 “单选题You decided to change the location of the flash recovery area. You executed the following command： Which statement is true？（）A The location can be changed only if the flash recovery area is empty.B After executing the command， all new flash recovery area files will be created in the new location.C The command will generate an error because you cannot change the flash recovery area while the database is open.D All the existing files in the flash recovery area will be moved to the new location， and all new Flash Recovery Area files will be created in the new location.” 相关考题
考题
多选题You are working in a dedicated server environment. Your database is running in the automatic Program Global Area （PGA） memory management mode. Which two statements are correct in this scenario？（）AThe WORK_AREASIZE_POLICY initialization parameter cannot be set to AUTO.BThe Oracle database automatically controls the amount of PGA memory allotted to SQL work areas.CSetting the value of the SGA_TARGET initialization parameter to 0 will disable the automatic PGA memory management.DThe SORT_AREA_SIZE parameter is ignored by all the sessions running in the automatic PGA memory management mode.
考题
单选题In which of the following scenarios is a tablespace recovery required？（）A
when recovering a lost read-only tablespace from a read-only tablespace backupB
when recovering a lost read-only tablespace from a read-write tablespace backup when the database is running in ARCHIVELOG modeC
when recovering a lost read-only tablespace from a read-write tablespace backup when the database is running in NOARCHIVELOG mode and the changes in the online redo log files have been overwrittenD
when recovering a lost read-only tablespace from a read-only tablespace backup using the backup of the control file， the control file was created using the ALTER DATABASE BACKUP CONTROLFILE TO TRACE statement， and this statement was issued when the tablespace was read-only
考题
单选题You are working as a DBA at NetFx Corporation. You discover that the SCOTT schema is deleted by mistake. You decide to flash the database back to the time when the schema existed. Which view will you query to determine the estimated size of the flashback data that you require for your current target retention？（）A
V$FLASHBACK_DATABASE_LOGB
V$FLASHBACK_DATABASE_STATC
V$DATABASED
V$UNDOSTAT
考题
多选题You are working on an Oracle Database 10g database. For which purposes would you use the Flashback Transaction Query feature？ （）ATo recover a dropped table.BTo recover a dropped schema.CTo recover data from a truncated table.DTo view changes made by all the transactions during a given period of time.ETo view changes made by a single transaction during a given period of time.
考题
单选题Your database block size is 4 KB. In this database， you are required to create a tablespace with a block size of 8 KB. Which is the prerequisite for creating this tablespace？（）A
The parameter DB_CACHE_SIZE must be a multiple of 8.B
The value of the parameter SGA_MAX_SIZE must be increased.C
The tablespace must be created with a uniform extent size of 8 KBD
The parameter DB_8K_CACHE_SIZE must be defined in the parameter file.
考题
多选题You are required to remove the default EXTPROC entry from the default listener configuration to create a listener that will listen specifically for EXTPROC calls. Which two methods can you use to remove the default EXTPROC entry from the default listener configuration？ （）Athe RMAN utilityBthe import/export utilityCthe Oracle Enterprise ManagerDthe change tracking featureEthe Net Manager utility
考题
单选题Which type of PL/SQL construct would you use to automatically correct the error resulting from a statement that was suspended due to a space-related problem？（）A
functionsB
packageC
procedureD
database triggerE
anonymous PL/SQL block
考题
单选题In your database， online redo log files are multiplexed and one of the members in a group is lost due to media failure？ How would you recover the lost redo log member？（）A
import the database from the last exportB
restore all the members in the group from the last backupC
drop the lost member from the database and then add a new member to the groupD
restore all the database files from the backup and then perform a complete recoveryE
restore all the database files from the backup and then perform an incomplete recovery
考题
单选题You are maintaining your database in Oracle10g. On Tuesday at 8：00 A.M.， while starting the database， you discover that all the control files are missing. The backup of the full database was performed on Sunday at 6：00 P.M. Which type of recovery will you perform？（）A
incomplete recoveryB
complete recoveryC
recovery using the Flashback Database featureD
recovery using the export/import utility
考题
单选题On Monday， you dropped the DEPT table from your schema and then you re-created the DEPT table in your schema. On Wednesday， you have a requirement to restore the DEPT table from the recycle bin. Which statement is correct？（）A
You can restore the DEPT table by using the Oracle Flashback Drop feature， provided you use the RENAME TO clause.B
You can restore the DEPT table by using the Oracle Flashback Drop feature and a system-generated name will be assigned to the restored table.C
You cannot restore the DEPT table by using the Oracle Flashback Drop feature because a table with the name DEPT already exists in your schema.D
You cannot restore the DEPT table by using the Oracle Flashback Drop feature because the contents of the recycle bin are purged every 12 hours by default.
考题
单选题You are maintaining the PROD database of NetFx Corporation. You set the value of the SQL_TRACE parameter to TRUE. What will be the impact of this setting？（）A
The SQL trace facility will generate the performance statistics for all the SQL statements for an instance and write them in the USER_DUMP_DEST directory.B
The SQL trace facility will generate the performance statistics for all the SQL statements for a session and write them in the USER_DUMP_DEST directory.C
The SQL trace facility will generate the performance statistics for all the SQL statements for an instance and write them in the BACKGROUND_DUMP_DEST directory.D
The SQL trace facility will generate the performance statistics for all the SQL statements for a session and write them in the BACKGROUND_DUMP_DEST directory.
热门标签
最新试卷