Examine this description of the EMP

单选题
Examine this description of the EMP table:
Name Null? Type
EMPNO NOT NULL NUMBER (4)
ENAME VARCHAR2 (10)
SAL NUMBER (7, 2)
DEPTNO NUMBER (2)
You execute this query:
SELECT deptno AS "departments", SUM (sal) AS "salary"
FROM emp
GROUP | BY 1
HAVING SUM (sal)> 3 000; What is the result?

A、 only departments where the total salary is greater than 3000, returned in no particular order

B、 all departments and a sum of the salaries of employees with a salary greater than 3000

C、 an error

D、 only departments where the total salary is greater than 3000, ordered by department

查看答案

下载APP答题

由4l***3u提供分享举报纠错

相关试题

单选题
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

查看答案

单选题
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
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 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
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
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
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;

查看答案