- Evaluate the following query: SELECT INTERVAL’300’ MONTH,INTERVAL ‘54-2’ YEARTO MONTH, INTERVAL’11:12:10.1234567’ HOUR TO SECOND FROM dual; What is the correct output of the above query?
A) +25-00,+54-02,+00 11:12:10.123457
B) +00-300,+54-02,+00 11:12:10.123457
C) +25-00,+00-650,+00 11:12:10.123457
D) +00-300,+00-650,+00 11:12:10.123457
INTERVAL ‘300’ MONTH:300 个月为+25-00(25 年-0 个月,即 25*12+0) INTERVAL ‘54-2’ YEAR TO MONTH:+54-02
INTERVAL ‘11:12:10.1234567’ HOUR TO SECOND: +00 11:12:10.123457(+00 表示 0 天) - Which two statements are true regarding savepoints?
A) Savepoints are effective only for COMIT.
B) Savepoints may be used to ROILBACK.
C) Savepoints can be used for only DML statements.
D) Savepoints are effective for both COMMIT and ROLLBACK.
E) Savepoints can be used for both DML and DDL statements.
Use the SAVEPOINT statement to identify a point in a transaction to which you can later roll back.(使用 SavePoint 语句标识事务中的一个点,您以后可以回滚到该点。)
- View the Exhibit and examine the data in the PRODUCTS table. Which statement would add a column called PRICE, which cannot contain NULL?
A) ALTER TABLE products ADD price NUMBER (8,2) NOT NULL;
B) ALTER TABLE products ADD price NUMBER (8,2) DEFAULT NOT NULL;
C) AITERTABLE products ADD price NUMBER(8, 2) DEFAUIT 0 NOT NULL;
D) ALTER TABLE products ADD price NUMBER(8, 2) DEFAULE CONSTRAINT p_nn NOT NULL;
要考虑表可能已经有数据,如果新加的列为非空约束,则必须要有一个默认值,否则已经存在的行该列上的值为空,会违反非空约束)