What is true about non-equijoin statement performance? | OCP-082-90

单选题 Examine the description of the products table
Name Null type
-----------------------------------------------------
PROD_ID NOT NULL NUMBER
PROD_NAME VARCHAR2(40)
COST NUMBER(8,2)
PRLEASE_DATE DATE
Which query is valid?

A、SELECT prod id, AVG(MAX (cost)) FROM products GROUP BY prod.

B、SELECT prod id, MAX (AVG (cost)) FROM products GROUP BY prod id:

C、Select prod id, release date, SUM(cost) FROM products GROUP BY prod id

D、SELECT prod id, release date, SUM(cost) FROM products GROUP BY prod id, release date

查看答案

单选题 Examine the description of the SATES1 table
Name Null type
-----------------------------------------------------
SALES_ID NOT NULL NUMBER
STORE_ID NOT NULL NUMBER
ITMES_ID NUMBER
UANTITY NUMBER
SALES_DATE DATE
SALES2 is a table with the same description as sAleS1
Some sales data is contained erroneously in both tables
You must display rows from sAlEs1 and SALES and wish to see the duplicates too
Which set operator generates the required output?

A、MINUS

B、UNION ALL

C、SUBTRACT

D、 UNION

E、 INTERSECT

查看答案

单选题 Which compression method is recommended for Direct-Path Insert operations?

A、COLUMN STORE COMPRESS ADVANCED

B、ROW STORE COMPRESS ADVANCED

C、COLUMN STORE COMPRESS BASIC

D、ROW STORE COMPRESS BASIC

查看答案

单选题 Examine the description of the EMPLOYEES table
NIS DATE FORMAT is set to DD-MON-YY
Which query requires explicit data type conversion?

A、SELECT join date FROM employees WHERE join date >'10-02-2018';

B、SELECT join date || ' '|| salary FROM employees

C、SELECT salary + '120.50' FROM employees

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

E、SELECT join date + '20' FROM employees

查看答案

单选题 View the Exhibits and examine the structure of the costs and PROMOTIONS tables
You want to display PROD IDS whose promotion cost is less than the highest cost PROD ID in a
Promotion time interval
Examine this SQL statement
SELECT prod_id
FROM costs
WHERE promo_id IN
(SELECT promo_id
FROM promotions
WHERE promo_cost < ALL
(SELECT MAX(promo_cost)
FROM promotions
GROUP BY (promo end date - promo begin date)));
What will be the result?

A、It executes successfully and gives the required result.

B、It gives an error because the GROUP BY clause is not valid

C、It executes successfully but does not give the required result

D、It gives an error because the ALL keyword is not valid

查看答案

单选题 In the spfile of a single instance database, LOCAL LISTENER is set to LISTENER 1.
The TNSNAMES ORA file in SORACLE HOME/network/admin in the database home contains:
LISTENER 1 =
(ADDRESS=
(PROTOCOL= TCP)
(HOST =host1 abc. com)
(PORT=1521)
) Which statement is true?

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

B、The definition for LISTENER 1 requires a CONNECT DATA section to enable dynamic service
Registration

C、 LISTENER 1 must also be defined in the LISTENER. ORA file to enable dynamic service
Registration

D、The LREG process registers services dynamically with the LISTENER_1 listener

E、Dynamic service registration cannot be used for this database instance

查看答案

单选题 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 or VARCHAR2 column in the last select of the compound query

B、the first NUMBER column in the first select of the compound query

C、the first vARCHAR2 column in the first select of the compound query

D、the first column in the first select of the compound query

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

查看答案

单选题 Your database instance is started with an SPFILE
A PFILE is also available
You execute this command
ALTER SYSTEM SET DB CACHE SIZE=100K
Where is the value changed?

A、in the SPFILE and PFTIE

B、in the SPFILE, PFILE, and memory

C、only in the SPFILE

D、in the SPFILE and in memory

E、only in memory

查看答案