Examine the structure of the BOOKS_TRANSACTIONS table:

Examine the SQL statement:

Which statement is true about the outcome?

• A.It displays details for only members A101 and A102 who have borrowed before today with RM TRANSACTION_TYPE.
• B.It displays details for members who have borrowed before today's date with either RM as TRANSACTION_TYPE or MEMBER_ID as A101 and A102.
• C.It displays details for members who have borrowed before today with RM as TRANSACTION_TYPE and the details for members A101 or A102.
• D.It displays details only for members who have borrowed before today with RM as TRANSACTION_TYPE.

Comment: *

Name: *

Email: *

Verification: *

View the exhibits and examine the structures of the COSTS and PROMOTIONS tables.


Evaluate the following SQL statement:

What would be the outcome of the above SQL statement?

• A.It displays prod IDs in the promos which cost less than the highest cost in the same time interval.
• B.It displays prod IDs in the promos with the lowest cost in the same time interval.
• C.It displays prod IDs in the promos with the highest cost in the same time interval.
• D.It displays prod IDs in the promo with the lowest cost.

Comment: *

Name: *

Email: *

Verification: *

Which three statements are true about time zones, date data types, and timestamp data types in an Oracle database?

• A.The CURRENT_TIMESTAMP function returns data without time zone information.
• B.The SESSIONTIMEZONE function can return an offset from Universal Coordinated Time (UTC).
• C.A TIMESTAMP WITH LOCAL TIMEZONE data type column is stored in the database using the time zone of the session that inserted the row.
• D.The DBTIMEZONE function can return an offset from Universal Coordinated Time (UTC).
• E.A TIMESTAMP data type column contains information about year, month, and day.

Comment: *

Name: *

Email: *

Verification: *

View the Exhibit and examine the structure in the DEPARTMENTS tables. (Choose two.) Examine this SQL statement:
SELECT department_id "DEPT_ID", department_name, 'b' FROM
departments
WHERE departments_id=90
UNION
SELECT department_id, department_name DEPT_NAME, 'a' FROM
departments
WHERE department_id=10
Which two ORDER BY clauses can be used to sort output?

• A.ORDER BY 3;
• B.ORDER BY DEPT_NAME;
• C.ORDER BY 'b';
• D.ORDER BY DEPT_ID;

Comment: *

Name: *

Email: *

Verification: *

Which three actions can you perform by using the ALTER TABLE command?

• A.Rename a table
• B.Enable or disable constraints on a table.
• C.Lock a set of rows in a table CE Rename a table.
• D.Drop pseudo columns from a table.
• E.Drop all columns simultaneously from a table.
• F.Restrict all DML statements on a table.

Comment: *

Name: *

Email: *

Verification: *