Oracle 1Z0-071 Quiz 30 Topic 16 Questions 146-150

Question: 1

Examine the structure of the BOOKS_TRANSACTIONS table:

q1_1Z0-071

Examine the SQL statement:

q1_1Z0-071

Which statement is true about the outcome?

AIt displays details only for members who have borrowed before today with RM as TRANSACTION_TYPE.

BIt displays details for members who have borrowed before today's date with either RM as TRANSACTION_TYPE or MEMBER_ID as A101 and A102.

CIt displays details for only members A101 and A102 who have borrowed before today with RM TRANSACTION_TYPE.

DIt displays details for members who have borrowed before today with RM as TRANSACTION_TYPE and the details for members A101 or A102.

Show Answer

Question: 2

View the Exhibit and examine the data in the EMPLOYEES table.

Exhibit

q2_1Z0-071

You want to generate a report showing the total compensation paid to each employee to date.

You issue the following query:

q2_1Z0-071

What is the outcome?

AIt executes successfully but does not give the correct output.

BIt generates an error because the concatenation operator can be used to combine only two items.

CIt generates an error because the usage of the ROUND function in the expression is not valid.

DIt generates an error because the alias is not valid.

EIT executes successfully and gives the correct output.

Show Answer

Question: 3

Evaluate the following query

q3_1Z0-071

What is the correct output of the above query?

A+00-300, +00-650, +00 11:12:10.123457

B+25-00, +54-02, +00 11:12:10.123457

C+00-300, +54-02, +00 11:12:10.123457

D+25-00, +00-650, +00 11:12:10.123457

Show Answer

Question: 4

Which two statements are true regarding savepoints? (Choose two.)

ASavepoints may be used to ROLLBACK.

BSavepoints can be used for only DML statements.

CSavepoints are effective only for COMMIT.

DSavepoints are effective for both COMMIT and ROLLBACK.

ESavepoints can be used for both DML and DDL statements.

Show Answer

Question: 5

Examine the commands used to create DEPARTMENT_DETAILS and COURSE_DETAILS tables:

q5_1Z0-071

You want to generate a list of all department IDs that do not exist in the COURSE_DETAILS table.

You execute the SQL statement:

q5_1Z0-071

What is the outcome?

AIt fails because the join type used is incorrect.

BIt executes successfully and displays the required list.

CIt executes successfully but displays an incorrect list.

DIt fails because the ON clause condition is not valid.

Show Answer

Oracle 1Z0-071 Quiz:30 Topic:16 Questions:146-150