Examine this statement:
SELECT1 AS id,' John' AS first_name, NULL AS commission FROM dual
INTERSECT
SELECT 1,'John' null FROM dual ORDER BY 3;
What is returned upon execution?[

• A.0 rows
• B.1 ROW
• C.An error
• D.2 rows

Comment: *

Name: *

Email: *

Verification: *

Examine the structure of the PROMOTIONS table: (Choose the best answer.)

Management requires a report of unique promotion costs in each promotion category.
Which query would satisfy this requirement?

• A.SELECT DISTINCT promo_cost, DISTINCT promo_category FROM promotions;
• B.SELECT promo_category, DISTINCT promo_cost FROM promotions
• C.SELECT DISTINCT promo_category, promo_cost FROM promotions ORDER BY 1
• D.SELECT DISTINCT promo_cost, promo_category FROM promotions

Comment: *

Name: *

Email: *

Verification: *

Which two statements are true about a full outer join?

• A.It returns matched and unmatched rows from both tables being joined.
• B.It includes rows that are returned by an inner join.
• C.The Oracle join operator (+) must be used on both sides of the join condition in the WHERE clause.
• D.It includes rows that are returned by a Cartesian product.
• E.It returns only unmatched rows from both tables being joined.

Comment: *

Name: *

Email: *

Verification: *

An Oracle database server session has an uncommitted transaction in progress which updated 5000 rows in a table.
In which three situations does the transactions complete thereby committing the updates? (Choose three.)

• A.when a DBA issues a successful SHUTDOWN TRANSACTIONAL statement and the user then issues a COMMIT
• B.when a DBA issues a successful SHUTDOWN IMMEDIATE statement and the user then issues a COMMIT
• C.when a COMMIT statement is issued by the same user from another session in the same database instance
• D.when a CREATE INDEX statement is executed successfully in the same session
• E.when the session logs out successfully
• F.when a CREATE TABLE AS SELECT statement is executed unsuccessfully in the same session

Comment: *

Name: *

Email: *

Verification: *

Which task can be performed by using a single Data Manipulation Language (DML) statement?

• A.removing all data only from a single column on which a primary key constraint is defined
• B.removing all data only from a single column on which a unique constraint is defined
• C.adding a column with a default value while inserting a row into a table
• D.adding a column constraint while inserting a row into a table

Comment: *

Name: *

Email: *

Verification: *