CMS专题
单选题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 co
题目
ALTER SYSTEM SET DB_RECOVERY_FILE_DEST = ’+disk2’ ；
ALTER SYSTEM SET DB_RECOVER_FILE_DEST = ’+disk2’ SCOPE = BOTH；
ALTER SYSTEM SET DB_CREATE_FILE_DEST = ’+disk2’；
ALTER SYSTEM SET DB_CREATE_ONLINE_LOG_DEST_n = ’+disk2’；
参考答案和解析
相似问题和答案
第1题：
According to your resume, you have had some experience working in a foreign company. May I ask you why you left?
第2题：
You are working on an Oracle Database 10g database. You enabled the Flashback Database feature. Which two statements regarding flashback logs are true？ （）
- A、 Flashback logs are not archived.
- B、 Flashback logs are maintained in redo log files.
- C、 Flashback logs are maintained in the Flash Recovery Area.
- D、 Flashback logs are used to maintain Flashback Database related errors.
- E、 Flashback logs need to be cleared manually after you disable Flashback Database.
正确答案:A,C
第3题：
Why are you working in a field other than the one in which you have a degree?
第4题：
You are working on a 24x7 （available 24 hours per day， 7 days per week） production database. An operating system （OS） user deletes the alert log file accidentally. Which statement in this scenario is true？（）
- A、The database crashes.
- B、The DBA needs to re-create the file.
- C、The file gets re-created automatically.
- D、The file gets restored automatically from the last backup.
- E、The DBA needs to perform a complete database recovery.
- F、The DBA needs to perform an incomplete database recovery.
正确答案:C
第5题：
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_LOG
- B、 V$FLASHBACK_DATABASE_STAT
- C、 V$DATABASE
- D、 V$UNDOSTAT
正确答案:A
第6题：
If you know that the vessel you are about to call on the VHF radio maintains a radio watch on both the working and the calling frequencies, which frequency should you call on ?______.
A.Calling frequency
B.Distress frequency
C.Urgency frequency
D.Working frequency
如果你知道你船在甚高频上呼叫保持工作和职守频率，你将呼叫哪个频率？工作频率。
第7题：
You are employed as a DBA in an organization. You are informed that the record of EMP_NO 1000 is missing from the SCOTT.EMP table. You are required to identify the user who deleted the record， the SQL statement that will undo the deletion， and the transaction ID of the transaction that deleted the employee record. Which feature will you use to perform the tasks？（）
- A、 Only the Flashback Table
- B、 Both the Flashback Transaction Query and the Flashback Version Query
- C、 Only the Flashback Drop
- D、 Only the Flashback Version
正确答案:B
第8题：
Why are you interesting in working with this firm?
第9题：
Which view will you use to view information regarding the jobs that are currently running in a database？（）
- A、DBA_SCHEDULER_RUNNING_JOBS
- B、DBA_SCHEDULER_JOB_RUN_DETAILS
- C、DBA_SCHEDULER_JOBS
- D、DBA_SCHEDULER_JOB_LOG
正确答案:A
第10题：
In which two cases would you perform only consistent backup？（）
- A、You are working on a database where downtime is not tolerated.
- B、You are working on a database where downtime can be tolerated.
- C、You are working on a database that operates in ARCHIVELOG mode.
- D、You are working on a database that operates in NOARCHIVELOG mode.
- E、You are working on a database where all the tablespaces are locally managed.
- F、You are working on a database where control files and redo log files are multiplexed.
- G、You are working on a database where control files and redo log files are not multiplexed.
正确答案:B,D