单选题
View the Exhibit and examine the structure of the ORDERS table. Which task would require subqueries？ （）
displaying the total order value for sales representatives 161 and 163
displaying the order total for sales representative 161 in the year 1999
displaying the number of orders that have order mode online and order date in 1999
displaying the number of orders whose order total is more than the average order total for all online orders
单选题
Evaluate the CREATE TABLE statement： CREATE TABLE products （product_id NUMBER （6） CONSTRAINT prod_id_pk PRIMARY KEY， product_name VARCHAR2 （15））； Which statement is true regarding the PROD_ID_PK constraint？（）
It would be created only if a unique index is manually created first.
It would be created and would use an automatically created unique index.
It would be created and would use an automatically created nonunique index.
It would be created and remains in a disabled state because no index is specified in the command.
单选题
Which statement is true regarding Flashback Version Query？ （）
It returns versions of rows only within a transaction.
It can be used in subqueries contained only in a SELECT statement.
It will return an error if the undo retention time is less than the lower bound time or SCN specified.
It retrieves all versions including the deleted as well as subsequently reinserted versions of the rows.
多选题
Which three statements are true regarding single-row functions？（）
They can accept only one argument.
They can be nested up to only two levels.
They can return multiple values of more than one data type.
They can be used in SELECT， WHERE， and ORDER BY clauses.
They can modify the data type of the argument that is referenced.
They can accept a column name， expression， variable name， or a user-supplied constant as arguments.
单选题
The user SCOTT who is the owner of ORDERS and ORDERJTEMS tables issues the following GRANT command： GRANT ALL ON orders， order_items TO PUBLIC； What correction needs to be done to the above statement？ （）
PUBLIC should be replaced with specific usernames.
ALL should be replaced with a list of specific privileges.
WITH GRANT OPTION should be added to the statement.
Separate GRANT statements are required for ORDERS and ORDERJTEMS tables.
多选题
Which three tasks can be performed using regular expression support in Oracle Database 10g？（）
it can be used to concatenate two strings.
it can be used to find out the total length of the string.
it can be used for string manipulation and searching operations.
it can be used to format the output for a column or expression having string data.
it can be used to find and replace operations for a column or expression having string data.
单选题
View the Exhibit and examine the structure of the ORDERS and ORDERJTEMS tables. Evaluate the following SQL statement： SELECT oi.order_id， product_jd， order_date FROM order_items oi JOIN orders o USING （order_id）； Which statement is true regarding the execution of this SQL statement？（）
The statement would not execute because table aliases are not allowed in the JOIN clause.
The statement would not execute because the table alias prefix is not used in the USING clause.
The statement would not execute because all the columns in the SELECT clause are not prefixed with table aliases.
The statement would not execute because the column part of the USING clause cannot have a qualifier in the SELECT list.
多选题
Which three possible values can be set for the TIME_ZONE session parameter by using the ALTER SESSION command？（）
’os’
local
-8：00’
dbtimezone Li
’Australia’
单选题
View the Exhibit and examine the data in ORDERS_MASTER and MONTHLYjDRDERS tables. What would be the outcome of the above statement？（）
The ORDERS_MASTER table would contain the ORDERJDs 1 and 2.
The ORDERS_MASTER table would contain the ORDERJDs 1， 2 and 3.
The ORDERS_MASTER table would contain the ORDERJDs 1， 2 and 4.
The ORDERS MASTER table would contain the ORDER IDs 1， 2， 3 and 4.
单选题
Which statement is true regarding Flashback Version Query？（）
It returns versions of rows only within a transaction.
It can be used in subqueries contained only in a SELECT statement.
It will return an error if the undo retention time is less than the lower bound time or SCN specified.
It retrieves all versions including the deleted as well as subsequently reinserted versions of the rows.
推荐考题
-
在任何情况下，伸缩调节器处轨距的要求为（）。
-
人类有两套影响学习的记忆系统：陈述性记忆和程序记忆。陈述性记忆是对事实或者词汇之类基本认识的记忆。而程序记忆，就是一个人“不劳而获”的记忆。程序记忆是人养成习惯和习得技巧的方式，比如骑自行车。在很多时候，这种学习是无意识的。人们用早期发育的程序记忆系统来学习复杂的东西，比如语法规则。帮助人们学习词汇的陈述性记忆系统，则需要更多时问完成发育。儿童拥有程序记忆系统，并且不受陈述性记忆系统的干扰。由此可以推出()。
-
宋末元初四大家
-
公平目标的实现可以通过（）实现。
-
荟萃分析
-
人员安全疏散分析的性能判定标准为：可用疏散时间（A.SET）必须（）必需疏散时间（RSET）。
-
预防HIV感染的主要措施应当为（ ）
-
简述我国混合型债券市场的发展状况。
-
造成水中某些污染物在生物体内含量大大高于水体中的浓度的生物放大作用是指（）
-
输血的适应证中，不包括（）