首页  /  试题详情

多选题 Which two statements are true regarding the WHERE and HAVING clauses in a SELECT statement? (Choose two.)

A、 The WHERE and HAVING clauses can be used in the same statement only if they are applied to different columns in the table.
B、 The aggregate functions and columns used in the HAVING clause must be specified in the SELECT list of the query.
C、 The WHERE clause can be used to exclude rows after dividing them into groups.
D、 The HAVING clause can be used with aggregate functions in subqueries.
E、 The WHERE clause can be used to exclude rows before dividing them into groups.
查看答案
下载APP答题
由4l***vq提供 分享 举报 纠错
相关题库推荐
OCP 19c 1z0-082第一部分241题
2024-07-16
共275道
test
2023-02-23
共209道
082-汇总
2025-04-27
共300道
瑞-082
2021-11-29
共285道
OCP刷题082
2022-08-27
共324道
1Z0 - 082
2022-09-15
共191道

相关试题

单选题 Which statement is true about the INTERSECT operator used in compound queries?

A、

Multiple INTERSECT operators are not possible in the same SQL statement

B、

It processes NULLs in the selected columns

C、

INTERSECT is of lower precedence than UNION or UNION ALL

D、

It ignores NULLs

单选题 The CUSTOMERS table has a CUST LAST NAME column of data type VARCHAR2. The table has two rows whose CUST LAST NAME values are Anderson and Ausson. Which query produces output for CUST LAST NAME containing oder for the first row and Aus for the second?

A、

SELECT REPLACE (SUBSTR(Cust. last name, -3)， An', 'O') FROM customers;

B、

SELECT REPLACE (REPLACE (cust last name,'son',' ' ), 'An', 'O') FROM customers ;

C、

SELECT INITCAP (EPLACE (TRIM('son' FROM cust_ last_ name), 'An', 'o')) FROM customers;

D、

SELECT REPLACE (TRIM (TRAILING 'son' FROM cust_last_ name)， 'AN' , 'O' ROM customers ;

单选题 You have been tasked to create a table for a banking application. One of the columns must meet three requirements: Be stored in a format supporting date arithmetic without using conversion functions Store a loan period of up to 10 years Be used for calculating interest for the number of days the loan remains unpaid Which data type should you use?

A、

INTERVAL YEAR TO MONTH

B、

INTERVAL DAY TO SECOND

C、

TIMESTAMP WITH LOCAL TIMEZONE

D、

TIMESTAMP

E、 TIMESTAMP WITH TIMEZONE

单选题 In the spfile of a single instance database, LOCAL_LISTENER is set to LISTENER_1. The TNSNAMES.ORA file in $ORACLE_HOME/network/admin in the database home contains:

Which statement is true?

A、

Dynamic service registration cannot be used for this database instance

B、

The LREG process registers services dynamically with the LISTENER_1 listener

C、

LISTENER_1 must also be defined in the LISTENER.ORA file to enable dynamic service registration

D、

There are two listeners named LISTENER and LISTENER_1 running simultaneously using port 1521 on the same host as the database instances

E、 The definition for LISTENER_1 requires a CONNECT_DATA section to enable dynamic service Registration

单选题 c39f27d87431f8751a710aecceca7813.png

NLS_DATE FORMAT is set to DD-MON-YY.

Which query requires explicit data type conversion?

A、

SELECT salary+ '120.50' FROM employees;

B、

SELECT join_date 11 ' ' 11 salary FROM employees;

C、

SELECT join_date FROM employees WHERE join_date > '10-02-2018';

D、

SELECT join_date + '20' FROM employees;

E、 SELECT SUBSTR(join_date, 1, 2) - 10 FROM employees;

单选题 Which is the default column or columns for sorting output from compound queries using SET operators such as INTERSECT in a SQL statement?

A、

the first NUMBER column in the first SELECT of the compound query

B、

the first column in the first SELECT of the compound query

C、

the first NUMBER or VARCHR2 column in the last SELECE of the compound query

D、

the first VARCHAR2 column in the first SELECT of the compound query

E、 the first column in the last SELECT of the compound query

单选题 What is true about non-equijoin statement performance?

A、

The Oracle join syntax performs less well than the SQI:1999 compliant ANSI join syntax.

B、

The BETWEEN condition used with an non-equijoin always performs better than when using the >= and <= conditions.

C、

The BETWEEN condition used with an non-equijoin sometimes performs better than using the >= and <= conditions.

D、

The join syntax used makes no difference to performance.

E、 The Oracle join syntax performs better than the SQL:1999 compliant ANSI join syntax.

单选题 Examine the description of the PRODUCTS table:

1661697b0a541baebae9c58cf7aaae77.png

Which query is valid?

A、

SELECT prod_id, MAX (AVG(cost)) FROM products GROUP BY prod_id;

B、

SELECT prod_id, AVG (MAX(cost)) FROM products GROUP BY prod_id;

C、

SELECT prod_id, release_date, SUM (cost) FROM products GROUP BY prod_id,release_date;

D、

SELECT prod_id, release_date, SUM(cost) FROM products GROUP BY prod_id;