单选题
What is the danger associated with stopping a running job by using the STOP_JOB procedure?（）
The job will need to be reenabled before it will execute again.
The job may hold locks on objects referenced within it.
All jobs within the job group will also be stopped.
The job may leave data in an inconsistent state.
There is no danger in using the STOP_JOB procedure.
多选题
You have enabled resumable space allocation in your database by setting the RESUMABLE_TIMEOUT parameter set to a nonzero value.Which three statements about resumable space allocation are true? （）
Even with resumable space allocation enabled for your database, you can disable resumable space allocation for a single session.
A resumable statement is suspended only if an out of space error occurs. （Out of space condition Maximum extents reached condition，Space quota exceeded condition）
When a resumable statement is suspended, the transaction that contains the statement is also suspended.
A resumable statement can only be suspended and resumed once during the execution of the statement.
You can query the V$SESSION_WAIT dynamic performance view to identify the statements that are suspended for a session.
单选题
Which statement is true about a running session that belongs to the online transaction processing (OLTP) group?（）
It permanently switches to the low_group consumer group if the session exceeds 10,000 I/O requests or 2,500 MB of data transfer.
It performs the first 10000 I/O requests or 2,500 MB of data transfer in the LOW-GROUP consumer group, and then switches to the original group.
It switches to the LOW_GROUP consumer group if the session exceeds 10000 I/O requests or 2500 MB of data transfer and returns to the original group after the operation.
It switches to the LOW_GROUP consumer group if the session exceeds 10000 I/O requests or 2500MB of data transfer for queries, but not for data manipulation language (DML) operations.
多选题
You are using the control file to maintain information about the database backups that are being performed by Recovery Manager (RMAN). Identify two scenarios is which you must have a recovery catalog.（）
To store the backup information of multiple database
To restrict the amount of space that is used by the backups
To maintain a backup for a certain time is set by the CONTROL_FILE_RECORD_KEEP_TIME parameter.
To list the data files that were in a target database at a given time by using the AT option of REPORT SCHEMA command.
单选题
You are working on a 24X7 database. You want to design a backup strategy for your database that uses user managed backups. You want to be able to perform all backups while the database remains online. Which statement about performing user-managed backups in a 24x7 environment is true?（）
You must have change tracking enabled in your database
Your database must be running in NOARCHIVELOG mode
To back up a tablespace, it must be in backup mode
To back up a tablespace, it must first be taken offline
单选题
The database is currently open and the temp03.dbf tempfile belonging to the default temporary tablespace TEMP has been corrupted. What steps should you take to recover from this tempfile loss in an efficient manner?（）
Allow the database to continue running, drop the TEMP tablespace, and then re-create it with new tempfiles
Shut down the database, restore and recover the tempfile from backup, and then open the database with RESETLOGS
Allow the database to continue running, take the TEMP tablespace offline, drop the missing tempfile, and then create a new tempfile
Allow the database to continue running, add a new tempfile to TEMP tablespace with a new name, and drop the tempfile that has been corrupted.
多选题
Which two statements about the SQL Management Base (SMB) are true?（）
It contains only SQL profiles generated by SQL Tuning Advisor.
It stores plans generated by the optimizer using a stored outline.
It is part of the data dictionary and stored in the SYSAUX tablespace.
It is part of the data dictionary and stored in the SYSTEM tablespace.
It contains the statement log, the plan history, plan baselines, and SQL profiles.
多选题
Which of the following are valid settings for the NLS_COMP parameter?（）
ASCII
ANSI
BINARY
MONOLINGUAL
MULTILINGUAL
推荐考题
-
在任何情况下，伸缩调节器处轨距的要求为（）。
-
人类有两套影响学习的记忆系统：陈述性记忆和程序记忆。陈述性记忆是对事实或者词汇之类基本认识的记忆。而程序记忆，就是一个人“不劳而获”的记忆。程序记忆是人养成习惯和习得技巧的方式，比如骑自行车。在很多时候，这种学习是无意识的。人们用早期发育的程序记忆系统来学习复杂的东西，比如语法规则。帮助人们学习词汇的陈述性记忆系统，则需要更多时问完成发育。儿童拥有程序记忆系统，并且不受陈述性记忆系统的干扰。由此可以推出()。
-
宋末元初四大家
-
公平目标的实现可以通过（）实现。
-
荟萃分析
-
人员安全疏散分析的性能判定标准为：可用疏散时间（A.SET）必须（）必需疏散时间（RSET）。
-
预防HIV感染的主要措施应当为（ ）
-
简述我国混合型债券市场的发展状况。
-
造成水中某些污染物在生物体内含量大大高于水体中的浓度的生物放大作用是指（）
-
输血的适应证中，不包括（）