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:

Exhibit 1.

Exhibit 2.

What will be the result?

• A.It gives an error because the GROUP BY clause is not valid
• B.It gives an error because the ALL keyword is not valid
• C.It executes successfully and gives the required result
• D.It executes successfully but does not give the required result

Comment: *

Name: *

Email: *

Verification: *

Which three statements are true about inner and outer joins? (Choose three.)

• A.A full outer join returns matched and unmatched rows
• B.An inner join returns matched rows
• C.Outer joins can only be used between two tables per query
• D.A full outer join must use Oracle syntax
• E.Outer joins can be used when there are multiple join conditions on two tables
• F.A left or right outer join returns only unmatched rows

Comment: *

Name: *

Email: *

Verification: *

A database is configured to use automatic undo management with temporary undo enabled.
An UPDATE is executed on a temporary table.
Where is the UNDO stored?

• A.in the undo tablespace
• B.in the SYSAUX tablespace
• C.in the SGA
• D.in the PGA
• E.in the temporary tablespace

Comment: *

Name: *

Email: *

Verification: *

You want to write a query that prompts for two column names and the WHERE condition each time it is executed in a session but only prompts for the table name the first time it is executed.
The variables used in your query are never undefined in your session.
Which query can be used?
SELECT &&col1, &&col2

• A.FROM "&table"
  WHERE &condition;
  SELECT '&&col1', '&&col2'
• B.FROM &table
  WHERE &&condition;
• C.FROM &table
  WHERE &&condition = &&cond;
  SELECT &col1, &col2
• D.FROM &table
  WHERE '&&condition' = '&cond';
  SELECT &&col1, &&col2
• E.FROM &&table
  WHERE &condition;
  SELECT &col1, &col2

Comment: *

Name: *

Email: *

Verification: *

The SCOTT/TIGER user exists in two databases, BOSTON_DB and DALLAS_DB, in two different locations.
Each database has a tnsnames.ora file defining DALLAS_DB as a service name.
Examine this command:
CREATE DATABASE LINK dblink1 CONNECT TO scott IDENTIFIED BY tiger USING 'dallas_db'; How do you execute the command so that only SCOTT in BOSTON_DB can access the SCOTT schema in DALLAS_DB?

• A.as SYS in both the databases
• B.as SCOTT in BOSTON_DB and SYS in DALLAS_DB
• C.as SCOTT in DALLAS_DB
• D.as SCOTT in BOSTON_DB
• E.as SCOTT in both the databases

Comment: *

Name: *

Email: *

Verification: *