Which two are true?

多选题
Which two are true?

A、 floor returns the largest integer less than or equal to a specified number.

B、 INSTR finds the offset within a string of a single character only.

C、 INSTR finds the offset within a character string, starting from position O.

D、 FLOOR returns the largest positive integer less than or equal to a specified number.

E、 CONCAT joins two or more character strings together.

F、 CONCAT joins two character strings together.

查看答案

下载APP答题

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

相关试题

单选题
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、 3 rows

C、 6 rows

D、 1 row

E、 an error

F、 8 rows

查看答案

单选题
Which is true about the ROUND, TRUNC and MOD functions?

A、 ROUND (MOD (25, 3), -1) is invalid.

B、 ROUND (MOD (25, 3), -1) and TRUNC (MOD (25, 3),-1) are both valid and give the same result.

C、 ROUND (MOD (25, 3), -1) and TRUNC (MOD (25, 3),-1) are both valid but give different results.

D、 TRUNC (MOD (25, 3), -1) is invalid.

查看答案

单选题
Examine the description of the EMPLOYEES table:

Which statement will execute successfully, returning distinct employees with non-
Null first names?

A、 SELECT DISTINCT *FROM employees WHERE first_ name IS NOT NULL;

B、 SELECT first_ name, DISTNCT last_ name FROM employees WHERE first_ name IS NOT NULL;

C、 SELECT Distinct * FROM employees WHERE first_ name < > NULL;

D、 SELECT first_ name, DISTINCT last_ name FROM employees WHERE first_ name < > NULL;

查看答案

单选题
You have been tasked 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 LOCAL TIME ZONE

B、TIMESTAMP

C、You have been tasked to create a table for a banking application.

D、 INTERVAL DAY to SECOND

E、INTERVAL YEAR TO MONTH

查看答案

单选题
Examine this partial query:
SELECT ch.channel_ type, t.month, co. country_ code, SUM (s.amount_sold) SALES
FROM sales S, times t, channels ch, countries co WHERE s. time_ id = t. time_ id AND s.country_ id = co. country_ id AND s.channel_ id = ch.channel_ id AND ch.channel_ type IN (‘Direct Sales ', ' Internet’) AND t.month IN (' 2000-091 ', ' 2000-10) AND co. country_ code IN (‘GB’,' US ' )
Examine this output:

Which GROUP BY clause must be added so the query returns the results shown?

A、 GROUP BY ch.channel_ type, ROLLUP (t.month, co. country_ code);

B、 GROUP BY ch.channel_ type, t.month, co. country_ code;

C、 GROUP BY CUBE (ch.channel_ type, t.month, co. country_ code);

D、 GROUP BY ch.channel_ type, t.month, ROLLUP (co. country_ code);

查看答案

单选题
Examine this statement, which executes successfully:
Examine this statement, which executes successfully:
SELECTd. department_ name, ROUND (AVG (NULLIF (e. salary, 0))) AS avgsal, MAX (e. salary) AS maxsal FROM employees e
JOIN departments d ON (e. department_ id =d. department_ id)
GROUP BYd. department_ name
ORDER BY 2;
In which order are the rows displayed?

A、 sorted by DE PARTMENT_ NAME

B、 sorted by AVGSAL

C、 sorted by MAXSAL

D、 sorted by DE PARTMENT_ NAME and MAXSAL

E、 sorted by DEPARTMENT_ NAME and AVGSAL

查看答案

单选题
Examine this statement:
SELECT 1 AS id, ' John' AS first name FROM DUAL
UNION
SELECT 1 , ' John' AS name FROM DUAL
ORDER BY 1;
What is returned upon execution?

A、 0 rows

B、 an error

C、 1 row

D、 2 rows

查看答案

单选题
The STORES table has a column START_ DATE of data type DATE, containing the date the row was inserted.
You only want to display details of rows where START_ DATE is within the last 25 months.
Which WHERE clause can be used?

A、 WHERE MONTHS_ BETWEEN (SYSDATE, start_ date) <=25

B、 WHERE MONTHS_ BETWEEN (start_ date, SYSDATE) <=25

C、 WHERE TO_ NUMBER (start_ date - SYSDATE) <= 25

D、 WHERE ADD_ MONTHS (start_ date, 25) <=SYSDATE

查看答案