多选题
Examine the description of the STUDENTS table:
Which two aggregate functions are valid on the START_DATE column?（）
SUM(start_date)
AVG(start_date)
COUNT(start_date)
AVG(start_date, end_date)
MIN(start_date)
MAXIMUM(start_date)
单选题
A data manipulation language statement （）.
completes a transaction on a table
modifies the structure and data in a table
modifies the data but not the structure of a table
modifies the structure but not the data of a table
多选题
What are two reasons to create synonyms? （）
You have too many tables.
Your tables are too long.
Your tables have difficult names.
You want to work on your own tables.
You want to use another schema's tables.
You have too many columns in your tables.
单选题
Which SQL statement defines a FOREIGN KEY constraint on the DEPTNO column of the EMP table?（）
CREATE TABLE EMP (empno NUMBER(4), ename VARCHAR2(35), deptno NUMBER(7,2) NOT NULL, CONSTRAINT emp_deptno_fk FOREIGN KEY deptno REFERENCES dept deptno);
CREATE TABLE EMP (empno NUMBER(4), ename VARCHAR2(35), deptno NUMBER(7,2) CONSTRAINT emp_deptno_fk REFERENCES dept (deptno));
CREATE TABLE EMP (empno NUMBER(4), ename VARCHAR2(35), deptno NUMBER(7,2) NOT NULL, CONSTRAINT emp_deptno_fk REFERENCES dept (deptno) FOREIGN KEY (deptno));
CREATE TABLE EMP (empno NUMBER(4), ename VARCHAR2(35), deptno NUMBER(7,2) FOREIGN KEY CONSTRAINT emp_deptno_fk REFERENCES dept (deptno));
单选题
Which SQL statement displays the date March 19, 2001 in a format that appears as "Nineteenth of March 2001 12:00:00 AM"? （）
SELECT TO_CHAR(TO_DATE('19-Mar-2001', 'DD-Mon-YYYY'), 'fmDdspth of Month YYYY fmHH:MI:SS AM') NEW_DATE FROM dual;
SELECT TO_CHAR(TO_DATE('19-Mar-2001', 'DD-Mon-YYYY'), 'Ddspth of Month YYYY fmHH:MI:SS AM') NEW_DATE HH:MI:SS AM') NEW _ DATE FROM dual;
SELECT TO_CHAR(TO_DATE('19-Mar-2001', 'DD-Mon-YYYY'), 'fmDdspth of Month YYYY NEW _ DATE FROM dual;
SELECT TO_CHAR(TO_DATE('19-Mar-2001', 'DD-Mon-YYYY), 'fmDdspth of Month YYYYfmtHH:HI:SS AM')NEW_DATE FROM dual;
单选题
Which view should a user query to display the columns associated with the constraints on a table owned by the user?（）
USER_CONSTRAINTS
USER_OBJECTS
ALL_CONSTRAINTS
USER_CONS_COLUMNS
USER_COLUMNS
多选题
Which three are true regarding the use of outer joins? （）
You cannot use IN operator in a condition that involves an outerjoin.
You use (+) on both sides of the WHERE condition to perform an outerjoin.
You use (*) on both sides of the WHERE condition to perform an outerjoin.
You use an outerjoin to see only the rows that do not meet the join condition.
In the WHERE condition, you use (+) following the name of the column in the table without matching rows, to perform an outerjoin.
You cannot link a condition that is involved in an outerjoin to another condition by using the OR operator.
多选题
Which four are types of functions available in SQL? （）
string
character
integer
calendar
numeric
translation
date
conversion
多选题
From SQL*Plus, you issue this SELECT statement:
You use this statement to retrieve data from a data table for（）。
Updating
Viewing
Deleting
Inserting
Truncating
单选题
The CUSTOMERS table has these columns:
Which statement finds the rows in the CUSTOMERS table that do not have a postal code?（）
SELECT customer_id, customer_name FROM customers WHERE postal_code CONTAINS NULL;
SELECT customer_id, customer_name FROM customers WHERE postal_code = '________';
SELECT customer_id, customer_name FROM customers WHERE postal_code IS NULL;
SELECT customer_id, customer_name FROM customers WHERE postal code IS NVL;
SELECT customer_id, customer_name FROM customers WHERE postal_code = NULL;
推荐考题
-
在任何情况下，伸缩调节器处轨距的要求为（）。
-
人类有两套影响学习的记忆系统：陈述性记忆和程序记忆。陈述性记忆是对事实或者词汇之类基本认识的记忆。而程序记忆，就是一个人“不劳而获”的记忆。程序记忆是人养成习惯和习得技巧的方式，比如骑自行车。在很多时候，这种学习是无意识的。人们用早期发育的程序记忆系统来学习复杂的东西，比如语法规则。帮助人们学习词汇的陈述性记忆系统，则需要更多时问完成发育。儿童拥有程序记忆系统，并且不受陈述性记忆系统的干扰。由此可以推出()。
-
宋末元初四大家
-
公平目标的实现可以通过（）实现。
-
荟萃分析
-
人员安全疏散分析的性能判定标准为：可用疏散时间（A.SET）必须（）必需疏散时间（RSET）。
-
预防HIV感染的主要措施应当为（ ）
-
简述我国混合型债券市场的发展状况。
-
造成水中某些污染物在生物体内含量大大高于水体中的浓度的生物放大作用是指（）
-
输血的适应证中，不包括（）