单选题
Examine the following commands and their output: SQL> SELECT ename, sal FROM emp WHERE ename='JAMES'; ENAME SAL JAMES 1050 QL> UPDATE emp SET sal=sal+sal*1.2 WHERE ename='JAMES'; 1 row updated. SQL> SELECT ename, sal FROM emp WHERE ename='JAMES'; ENAME SAL JAMES 2310 View the exhibit and examine the Flashback Version Query that was executed after the preceding commands. What could be the possible cause for the query not displaying any row?（）
Flashback logging is not enabled for the database.
The changes made to the table are not committed.
Supplemental logging is not enabled for the database.
The database is not configured in ARCHIVELOG mode.
单选题
What view might you use to try to determine how long a particular backup will take?（）
V$SESSION_EVENT
V$SESSION
V$W0041ITS
V$WAITSTAT
V$SESSION_LONGOPS
单选题
Which statement is true regarding subqueries?（）
The LIKE operator cannot be used with single-row subqueries
The NOT IN operator is equivalent to IS NULL with single-row subqueries
=ANY and =ALL operators have the same functionality in multiple-row subqueries
The NOT operator can be used with IN, ANY, and ALL operators in multiple-row subqueries
单选题
Which tasks can be accomplished using the DBMS_LOB. SETOPTIONS procedure?（）
only encryption and compression settings for all SecureFile LOBs
only encryption and deduplication settings for only SecureFile CLOBs
deduplication, encryption, and compression settings for all SecureFile LOBs
deduplication, encryption, and compression settings only for SecureFile CLOBs
单选题
Evaluate the following block of code:
What is the outcome of the above code?（）
It produces an error because a fully qualified host name needs to be specified.
It produces an error because the range of ports associated with the hosts has not been specified.
It creates an access control list (ACL) with the user ACCT_MGR who gets the CONNECT and RESOLVE privileges.
It creates an access control list (ACL) with the user ACCT_MGR who gets the CONNECT privilege but not the RESOLVE privilege.
单选题
Examine the output of the query that you executed to list the objects in the recycle bin: You verified that no table named SALES_TAB exists in the schema. Then you executed the following command to purge the objects in the recycle bin: SQL> PURGE TABLE sales_tab; What would be the outcome of this command?（）
All three tables in the recycle bin are purged
Only the table with the oldest DROPSCN is purged
The command returns an error because multiple entries with the same name exist in the recycle bin
Only the table with the latest DROPSCN is purged
单选题
What is the outcome of this block of code?（）
It creates a task and workload, and executes the task.
It creates a task and workload but does not execute the task.
It produces an error because a template has not been created.
It produces an error because the SQL Tuning Set has not been created.
单选题
You want to set the following initialization parameters for your database instance：
Identify the statement that correctly describes this setting.（）
The MANDATORY location must be a flash recovery area.
The optional destinations may not use the flash recovery area.
This setting is not allowed because the first destination is not set as MANDATORY.
The online redo log file is not allowed to be overwritten if the archived log cannot be created in the fourth destination.
单选题
Your archive-log destination directory runs out of space. What is the impact of this on the database?（）
None. The database will switch over to the stand-by archive-log destination directory.
A warning message will be written to the alert log of the database, but no adverse impacts to the database will be experienced.
The database will shut down, and will not restart until you correct the out-of-space situation.
The database will continue to try to write to the archive-log destination directory for one hour. After one hour, the database will shut down normally.
Once Oracle has cycled through all online redo logs, it will stop processing any DML or DDL until the out-of-space condition is corrected.
单选题
Which statement about recovering from the loss of a redo log group is true?（）
If the lost redo log group is ACTIVE, you should first attempt to clear the log file.
If the lost redo log group is CURRENT, you must clear the log file.
If the lost redo log group is ACTIVE, you must restore, perform cancel-based incomplete recovery, and open the database using the RESETLOGS option.
If the lost redo log group is CURRENT, you must restore, perform cancel-based incomplete recovery, and open the database using the RESETLOGS option.
推荐考题
-
在任何情况下，伸缩调节器处轨距的要求为（）。
-
人类有两套影响学习的记忆系统：陈述性记忆和程序记忆。陈述性记忆是对事实或者词汇之类基本认识的记忆。而程序记忆，就是一个人“不劳而获”的记忆。程序记忆是人养成习惯和习得技巧的方式，比如骑自行车。在很多时候，这种学习是无意识的。人们用早期发育的程序记忆系统来学习复杂的东西，比如语法规则。帮助人们学习词汇的陈述性记忆系统，则需要更多时问完成发育。儿童拥有程序记忆系统，并且不受陈述性记忆系统的干扰。由此可以推出()。
-
宋末元初四大家
-
公平目标的实现可以通过（）实现。
-
荟萃分析
-
人员安全疏散分析的性能判定标准为：可用疏散时间（A.SET）必须（）必需疏散时间（RSET）。
-
预防HIV感染的主要措施应当为（ ）
-
简述我国混合型债券市场的发展状况。
-
造成水中某些污染物在生物体内含量大大高于水体中的浓度的生物放大作用是指（）
-
输血的适应证中，不包括（）