Which is the default column or columns for sorting output from compound queries using SETOperators such as INTERSECT in a SQL statement? | 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 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

查看答案

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

查看答案

单选题 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 statement is true about database links?

A、A database link created in a database allows a connection from that database's instance to the
Target database's instance, but not vice versa

B、Private database link creation requires the same user to exist in both the local and the remote
Databases

C、A public database link can be used by a user connected to the local database instance to connect
To any schema in the remote database instance

D、A public database link can be created only by sys

E、A database link can be created only between two Oracle databases

查看答案

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

查看答案

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

查看答案