Choose two.You need to calculate the

多选题 Choose two.
You need to calculate the number of days from 1st January 2019 until today. Dates are stored in the default format of DD-MON-RR.
Which two queries give the required output?

A、 SELECT SYSDATE - TO_DATE ('01-JANUARY-2019') FROM DUAL;

B、 SELECT TO_DATE (SYSDATE, ' DD/MONTH/YYYY') - '01/JANUARY/2019' FROM DUAL;

C、 SELECT ROUND (SYSDATE - TO_DATE ('01/JANUARY/2019' ) ) FROM DUAL;

D、 SELECT TO_CHAR (SYSDATE, ' DD-MON-YYYY') - '01-JAN-2019' FROM DUAL;

E、 SELECT ROUND (SYSDATE- '01-JAN-2019') FROM DUAL:

查看答案

下载APP答题

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

相关试题

单选题 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 the description of the CUSTOMERS table:
Name Null? Type
CUST_ID Not NULL VARCHAR2(6)
FIRST_NAME VARCHAR2(50)
LAST_NAME Not NULL VARCHAR2(50) ADDRRESS VARCHAR2(50)
CITY VARCHAR2(25)
You want to display details of all customers who reside in cities starting with the letter D followed by at least two character
Which query can be used?

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 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:
1) Be stored in a format supporting date arithmetic without using conversion functions
2) Store a loan period of up to 10 years
3) Be used for calculating interest for the number of days the loan remains unpaid Which data type should you use?

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 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
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') FROMemployees;

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;

查看答案

单选题
Examine the description or the CUSTOMERS table: Name Null? Type
CUST_ID NOT NULL NUMBER CUST_FIRST_NAM NOT NULL VARCHAR2(20)
CUST_LAST_NAME NOT NULL VARCHAR2(30) CUST_INCOME_LEVEL VARCHAR2(30)
CUST_CREDIT_LIMIT NUMBER
For Customers whose income level has a value, you want to display the first name and due amount as 5% of their credit limit. Customers whose due amount is null should not be displayed.
Which query should be used?

A、 SELECT cust_first_name, cust_credit_limit * .05 AS DUE_AMOUNT FROM customers
WHERE cust_income_level != NULL AND cust_credit_level != NULL;

B、 SELECT cust_first_name, cust_credit_limit * .05 AS DUE_AMONT FROM customers
WHERE cust_income_level <> NULL AND due_amount <> NULL;

C、 SELECT cust_first_name, cust_credit_limit * .05 AS DUE_AMONT FROM customers
WHERE cust_income_level IS NOT NULL AND cust_credit_limit IS NOT NULL;

D、 SELECT cust_first_name, cust_credit_limit * .05 AS DUE_AMONT FROM customers
WHERE cust_income_level IS NOT NULL AND due_amount IS NOT NULL;

E、 SELECT cust_first_name, cust_credit_limit * .05 AS DUE_AMONT FROM customers
WHERE cust_income_level != NULL AND due_amount != NULL;

查看答案

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

查看答案