Choose twoThe CUSTOMERS table has a

多选题
Choose two
The CUSTOMERS table has a CUST_CREDT_LIMIT column of data type number.
Which two queries execute successfully?

A、 SELECT TO_CHAR(NVL(cust_credit_limit * .15,'Not Available')) FROM customers;

B、 SELECT NVL2(cust_credit_limit * .15,'Not Available') FROM customers;

C、 SELECT NVL(cust_credit_limit * .15, 'Not Available') FROM customers;

D、 SLECT NVL(TO_CHAR(cust_credit_limit * .15),'Not available') from customers;

E、 SELECT NVL2(cust_credit_limit,TO_CHAR(cust_credit_limit * .15),'NOT Available') FROM customers;

查看答案

下载APP答题

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

相关试题

单选题
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
You have been asked to create a table for a banking application.
One of the columns must meet three requirements:

A、Be stored in a format supporting date arithmetic without using conversion functions

B、Store a loan period of up to 10 years

C、Be used for calculating interest for the number of days the loan remains unpaid Which data type should you use?

D、TIMESTAMP WITH TIMEZONE

E、TIMESTAMP

F、TIMESTAMP WITH LOCAL TIMEZONE

G、INTERVAL YEAR TO MONTH

H、INTERVAL DAY TO SECOND

查看答案

多选题
Choose two
Examine the description of the PRODUCT DETALS table:
NAMENULLTYPE
--------------------------------------------------
PRODUCT_IDNOT NULLNUMBER(2)
PRODUCT_NAMENOT NULLVARCHAR2(25)
PRODUCT_PRICENUMBER(8,2)
EXPIRY_DATEDATE
Which two statements are true?

A、PRODUCT_ID can be assigned the PEIMARY KEY constraint.

B、EXPIRY_DATE cannot be used in arithmetic expressions.

C、EXPIRY_DATE contains the SYSDATE by default if no date is assigned to it

D、PRODUCT_PRICE can be used in an arithmetic expression even if it has no value stored in it

E、PRODUCT_PRICE contains the value zero by default if no value is assigned to it.

F、PRODUCT_NAME cannot contain duplicate values.

查看答案

多选题
Choose three
Which three are true about the CREATE TABLE command?

A、It can include the CREATE...INDEX statement for creating an index to enforce the primary key constraint.

B、The owner of the table should have space quota available on the tablespace where the table is defined.

C、It implicitly executes a commit.

D、It implicitly rolls back any pending transactions.

E、A user must have the CREATE ANY TABLE privilege to create tables,

F、The owner of the table must have the UNLIMITED TABLESPACE system privilege

查看答案

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

查看答案

单选题
Choose the best answer.
Examine the description of the EMPLOYEES table:
NameNullType
----------------------------------------------------------
EMP_IDNOT NULNUMBER
EMP_NAMEVARCHAR2 (40)
DEPT_IDNUMBER(2)
SALARYNUMBER(8,2)
JOIN_DATEDATE
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 PRODUCT_INFORMATION table:
NameNULL?Type
------------------------------------------------------------------------
PROD_IDNOT NULLNUMBER(2)
PROD_NANEVARCRAR2 (10)
LIST_PRICENUMBER(6,2)
Which query retrieves the number of products with a null list price?K.SELECT (COUNT(list_price) FROM Product_intormation WHERE list_price=NULL;

A、SELECT count(nvl( list_price,0) ) FROM product_information WHERE list_price is null;

B、SELECT COUNT(DISTINCT list_price) FROM product_information WHERE list_price is null.

C、BELECT COUNT(list_price) FROM product_information where list_price is NULL;

查看答案