首页  /  试题详情

单选题
Examine this statement which executes successfully:
CREATE view emp80 AS
SELECT
FROM employees
WHERE department_ id = 80
WITH CHECK OPTION;
Which statement will violate the CHECK constraint?

A、 DELETE FROM emp80 WHERE department_ id = 90;
B、 SELECT
C、 SELECT
D、 UPDATE emp80 SET department. 1d =80;
查看答案
下载APP答题
由4l***3u提供 分享 举报 纠错
相关题库推荐
071英文
2021-01-26
共337道

相关试题

单选题
Choose the best answer
You have been asked to create a table for a banking application.
One of the columns must meet three requirements:

A、 TIMESTAMP WITH TIMEZONE
B、 TIMESTAMP
C、 TIMESTAMP WITH LOCAL TIMEZONE
D、 INTERVAL YEAR TO MONTH
E、 INTERVAL DAY TO SECOND

单选题
Choose the best answer
Examine the description of the PRODUCT_INFORMATION table:
Name NULL? Type
------------------------------------------------------------------------
PROD_ID NOT NULL NUMBER(2)
PROD_NANE VARCRAR2 (10)
LIST_PRICE NUMBER(6,2)
Which query retrieves the number of products with a null list price?

A、 SELECT (COUNT(list_price) FROM Product_intormation WHERE list_price=NULL;
B、 SELECT count(nvl( list_price,0) ) FROM product_information WHERE list_price is null;
C、 SELECT COUNT(DISTINCT list_price) FROM product_information WHERE list_price is null.
D、 BELECT COUNT(list_price) FROM product_information where list_price is NULL;

单选题
Choose the best answer.
Examine this query:
SELECT 2 FROM dual d1 CROSS JOIN dual d2 CROSS JOIN dual d3; What is returned upon execution?

A、 0 rows
B、 an error
C、 8 rows
D、 6 rows
E、 1 row
F、 3 rows

单选题
Choose the best answer
Examine the description of the CUSTOMERS table:
Name Null? Type
-----------------------------------------------------------------------------------------

A、 SELECT * FROM customers WHERE city = 'D_%';
B、 SELECT * FROM customers WHERE city = '%D_';
C、 SELECT * FROM customers WHERE city LIKE 'D %';
D、 SELECT * FROM customers WHERE city LIKE 'D_';

单选题

Choose the best answer.

Examine the description of the EMPLOYEES table:

Name Null Type

----------------------------------------------------------

EMP_ID NOT NUL NUMBER

EMP_NAME VARCHAR2 (40)

DEPT_ID NUMBER(2)

SALARY NUMBER(8,2)

JOIN_DATE DATE

Which query is valid?

A、

SELECT dept_id, join_date,SUM(salary) FROM employees GROUP BY dept_id, join_date;

B、

SELECT depe_id,join_date,SUM(salary) FROM employees GROUP BY dept_id:

C、

SELECT dept_id,MAX(AVG(salary)) FROM employees GROUP BY dept_id;

D、

SELECT dept_id,AVG(MAX(salary)) FROM employees GROUP BY dapt_id;

单选题
Choose the best answer
The EMPLOYEES table contains columns EMP_ID of data type NUMBER and HIRE_DATE of data type DATE
You want to display the date of the first Monday after the completion of six months since hiring
The NLS_TERRITORY parameter is set to AMERICA in the session and, therefore, Sunday is the first day of the week
Which query can be used?

A、 SELECT emp_id,NEXT_DAY(ADD_MONTHS(hite_date,6), 'MONDAY') FROM employees;
B、 SELECT emp_id,ADD_MONTHS(hire_date,6), NEXT_DAY('MONDAY') FROM employees;
C、 SELECT emp_id,NEXT_DAY(MONTHS_BETWEEN(hire_date,SYSDATE),6) FROM employees;
D、 SELECT emp_id,NEXT_DAY(ADD_MONTHS(hire_date,6),1) FROM employees;

单选题
Choose the best answer
The CUSTOMERS table has a CUST_LAST_NAME column of data type VARCHAR2.
The table has two rows whose COST_LAST_MANE values are Anderson and Ausson.
Which query produces output for CUST_LAST_SAME containing Oder for the first row and Aus for the second?

A、 SELECT REPLACE (REPLACE(cust_last_name,'son',''),'An','O') FROM customers;
B、 SELECT REPLACE (TRIM(TRALING 'son' FROM cust_last_name), 'An','O') FROM customers;
C、 SELECT INITCAP (REPLACE(TRIM('son' FROM cust_last_name),'An','O')) FROM customers;
D、 SELECT REPLACE (SUBSTR(cust_last_name,-3), 'An', 'O') FROM customers;

单选题
Choose the best answer.
Examine this query:
SELECT TRUNC (ROUND(156.00,-2),-1) FROM DUAL;
What is the result?

A、 16
B、 160
C、 150
D、 200
E、 100