单选题 The backup retention policy is configured as RECOVERY WINDOW 2. You executed the following command in Recovery Manager (RMAN) against your database: RMAN> REPORT OBSOLETE; What would you see in the output?()
a list of all those files that have been deleted in the last two days
a list of all those files that have been recovered within the last two days
a list of all the expired backups and copies
a list of backups and copies that are outside the range covered by the current retention policy
单选题 Why would you use the following FLASHBACK TABLE command?() FLASHBACK TABLE emp TO TIMESTAMP (’11:45’,’hh12:mi’);
to undo the changes made to the EMP table since the specified time
to restore the EMP table that was wrongly dropped from the database
to view the transactions that have modified the EMP table since the specified time
to view the changes made to the EMP table for one or more rows since the specified time
to recover the EMP table to a point in time in the past by restoring the most recent backup
单选题 You executed the following procedure to collect statistics regarding an index: SQL>ANALYZE INDEX EMP_ID VALIDATE STRUCTURE; Which view will you use to determine whether you need to rebuild the index or not?()
INDEX_STATS
DBA_INDEXES
DBA_IND_COLUMNS
V$OBJECT_USAGE
单选题 Using Oracle Scheduler you have scheduled two jobs, JOB_A and JOB_B, to run at 9:00 p.m. every Friday. You want both the jobs to use a single resource plan, WEEKEND_PLAN. Which task must have already been performed to enable you to achieve this objective?()
A window must have been created with the WEEKEND_PLAN resource plan.
A program must have been created with the WEEKEND_PLAN resource plan.
A job class must have been created with the WEEKEND_PLAN resource plan.
A windows group must have been created with the WEEKEND_PLAN resource plan.
单选题 In an Oracle 10g database, the in-memory statistics are gathered at regular intervals and used to perform growth-trend analysis and capacity planning of the database. Which component stores these statistics?()
recovery catalog
Oracle Enterprise Manager Repository
Automatic Workload Repository (AWR)
Oracle 10g Enterprise Manager Grid Control
Automatic Database Diagnostic Monitor (ADDM)
单选题 Your database operates in ARCHIVELOG mode. The redo log files are not multiplexed and one of the online redo logs is missing. The missing redo log sequence, 230, is not archived, and it contained information from 10:35 a.m. onwards. The current time is 11:00 a.m. Because of a disk crash, you executed the following command to perform an incomplete recovery: RMAN> RUN { 2> SET UNTIL SEQUENCE 230 THREAD 1; 3> ALTER DATABASE MOUNT; 4> RESTORE DATABASE; 5> RECOVER DATABASE; 6> ALTER DATABASE OPEN RESETLOGS; 7> }; With reference to this scenario, which statement is true?()
RMAN recovers up to log sequence 230, but not including 230.
RMAN returns an error because the log sequence number mentioned in the command should be 229.
RMAN returns an error because the log sequence number mentioned in the command may never be missing.
RMAN recovers up to and including log sequence 229 but then returns an error because log sequence 230 is missing.
单选题 Your Oracle Database 10g is online when you execute the following statement: SQL>ALTER TABLESPACE MY_TABLESPACE FLASHBACK OFF; What is the result of executing this statement if the Flashback Database feature is already enabled in the database?()
The database does not record flashback logs for MY_TABLESPACE
The tables residing in MY_TABLESPACE are not protected by the Recycle Bin.
All the tablespaces except MY_TABLESPACE can be recovered using Flashback Database feature.
None of the flashback technologies, such as Flashback Table, Flashback Transaction Query and Flashback Version Query can be used to recover individual rows within the objects from MY_TABLESPACE
多选题 Last night, a media failure caused the loss of a temporary file that belongs to your database. Which two things may happen this morning when you try to open your database?()
The database writer writes to a trace file, indicating that the temporary file is not found.
The database prompts for a database recovery.
The database opens normally.
The database gets mounted and throws an error indicating that the temporary file requires recovery.
单选题 Why would you use the following FLASHBACK TABLE command?() FLASHBACK TABLE emp TO TIMESTAMP (’11:45’,’hh12:mi’);
to undo the changes made to the EMP table since the specified time
to restore the EMP table that was wrongly dropped from the database
to view the transactions that have modified the EMP table since the specified time
to view the changes made to the EMP table for one or more rows since the specified time
to recover the EMP table to a point in time in the past by restoring the most recent backup
多选题 In which scenarios would you rebuild an index?()
when you need to disable the index usage
when you need to change storage options
when you need to enable index monitoring
when you need to move the index to another tablespace
在任何情况下,伸缩调节器处轨距的要求为()。
人类有两套影响学习的记忆系统:陈述性记忆和程序记忆。陈述性记忆是对事实或者词汇之类基本认识的记忆。而程序记忆,就是一个人“不劳而获”的记忆。程序记忆是人养成习惯和习得技巧的方式,比如骑自行车。在很多时候,这种学习是无意识的。人们用早期发育的程序记忆系统来学习复杂的东西,比如语法规则。帮助人们学习词汇的陈述性记忆系统,则需要更多时问完成发育。儿童拥有程序记忆系统,并且不受陈述性记忆系统的干扰。由此可以推出()。
宋末元初四大家
公平目标的实现可以通过()实现。
荟萃分析
人员安全疏散分析的性能判定标准为:可用疏散时间(A.SET)必须()必需疏散时间(RSET)。
预防HIV感染的主要措施应当为( )
简述我国混合型债券市场的发展状况。
造成水中某些污染物在生物体内含量大大高于水体中的浓度的生物放大作用是指()
输血的适应证中,不包括()