Which two tasks can be performed by using Oracle SQL statements?

• A.changing the password for an existing database user
• B.connecting to a database instance
• C.querying data from tables across databases
• D.starting up a database instance
• E.executing operating system (OS) commands in a session

Comment: *

Name: *

Email: *

Verification: *

Which statements is true about using functions in WHERE and HAVING?

• A.using single-row functions in the WHERE clause requires a subquery
• B.using aggregate functions in the HAVING clause requires a subquery
• C.using single-row functions in the HAVING clause requires a subquery
• D.using aggregate functions in the WHERE clause requires a subquery

Comment: *

Name: *

Email: *

Verification: *

Examine the structure of the BOOKS_TRANSACTIONS table:

You want to display the member IDs, due date, and late fee as $2 for all transactions.
Which SQL statement must you execute?

• A.SELECT member_id AS "MEMBER ID", due_date AS "DUE DATE", $2 AS "LATE FEE" FROM BOOKS_TRANSACTIONS;
• B.SELECT member_id AS "MEMBER ID", due_date AS "DUE DATE", '$2' AS "LATE FEE" FROM BOOKS_TRANSACTIONS;
• C.SELECT member_id AS MEMBER_ID, due_date AS DUE_DATE, $2 AS LATE_FEE FROM BOOKS_TRANSACTIONS;
• D.SELECT member_id 'MEMBER ID', due_date 'DUE DATE', '$2 AS LATE FEE' FROM BOOKS_TRANSACTIONS;

Comment: *

Name: *

Email: *

Verification: *

Examine the data in the COLORStable:

Examine the data in the BRICKStable:

Which two queries return all the rows from COLORS? (Choose two.)

• A.
• B.
• C.
• D.
• E.

Comment: *

Name: *

Email: *

Verification: *

Evaluate the following SELECT statement and view the exhibit to examine its output:
SELECT constraint_name, constraint_type, search_condition, r_constraint_name, delete_rule, status, FROM user_constraints WHERE table_name = 'ORDERS'; CONSTRAINT_NAME CON SEARCH_CONDITION R_CONSTRAINT_NAME DELETE_RULE STATUS
ORDER_DATE_NN
C
"ORDER_DATE" IS NOT NULL
ENABLED
ORDER_CUSTOMER_ID_NN
C
"CUSTOMER_ID" IS NOT NULL
ENABLED
ORDER_MODE_LOV
C
order _mode in ('direct', 'online')
ENABLED
ORDER TOTAL MIN
C
order total >= 0
ENABLED
ORDER PK
P
ENABLED
ORDERS CUSTOMER ID
R
CUSTOMERS ID
SET NULL
ENABLED
ORDERS SALES REP
R
EMP EMP ID
SET NULL
ENABLED
Which two statements are true about the output? (Choose two.)

• A.The column DELETE_RULE decides the state of the related rows in the child table when the corresponding row is deleted from the parent table.
• B.In the second column, 'c' indicates a check constraint.
• C.The R_CONSTRAINT_NAME column gives the alternative name for the constraint.
• D.The STATUS column indicates whether the table is currently in use.

Comment: *

Name: *

Email: *

Verification: *