单项选择题
What does the FORCE option for creating a view do?（）
A.creates a view with constraints
B.creates a view even if the underlying parent table has constraints
C.creates a view in another schema even if you don't have privileges
D.creates a view regardless of whether or not the base tables exist
相关考题
-
多项选择题
Which three SELECT statements display 2000 in the format "$2,000.00"? （）
A. SELECT TO_CHAR(2000, '$#,###.##') FROM dual;
B. SELECT TO_CHAR(2000, '$0,000.00') FROM dual;
C. SELECT TO_CHAR(2000, '$9,999.00') FROM dual;
D. SELECT TO_CHAR(2000, '$9,999.99') FROM dual;
E. SELECT TO_CHAR(2000, '$2,000.00') FROM dual;
F. SELECT TO_CHAR(2000, '$N,NNN.NN') FROM dual; -
单项选择题
Which are iSQL*Plus commands? （）
A.INSERT
B.UPDATE
C.SELECT
D.DESCRIBE
E.DELETE
F.RENAME -
多项选择题
Examine the description of the MARKS table: STD_ID NUMBER(4) STUDENT_NAME VARCHAR2(30) SUBJ1 NUMBER(3) SUBJ2 NUMBER(3) SUBJ3 NUMBER(3) SUBJ1, SUBJ2, and SUBJ3 indicate the marks (grades) obtained by a student in the three subjects. Which two statements are valid? （）
A.SELECT SUM(subj1, subj2, subj3) FROM marks;
B.SELECT SUM(subj1 + subj2 + subj3) FROM marks;
C.SELECT SUM(subj1), SUM(subj2), SUM(subj3) FROM marks;
D.SELECT MAX(subj1, subj2, subj3) FROM marks;
E.SELECT MINIMUM(subj1) FROM marks;
F.SELECT COUNT(std_id) FROM marks WHERE subj1 >= AVG(subj1);
