1z0-071 Practice Test

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 'MEMBER ID', due_date 'DUE DATE', '$2 AS LATE FEE' FROM
BOOKS_TRANSACTIONS;

D.

SELECT member_id AS MEMBER_ID, due_date AS DUE_DATE, $2 AS LATE_FEE
FROM BOOKS_TRANSACTIONS

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

A.

Savepoints are effective only for COMMIT.

B.

Savepoints may be used to ROLLBACK.

C.

Savepoints can be used for only DML statements.

D.

Savepoints are effective for both COMMIT and ROLLBACK.

E.

Savepoints can be used for both DML and DDL statements.

Which two statements are true regarding the GROUP BY clause in a SQL statement?
(Choose two.)

A.

You can use column alias in the GROUP BY clause.

B.

Using the WHERE clause after the GROUP BY clause excludes the rows after creating
groups.

C.

The GROUP BY clause is mandatory if you are using an aggregate function in the
SELECT clause.

D.

Using the WHERE clause before the GROUP BY clause excludes the rows before
creating groups.

E.

If the SELECT clause has an aggregate function, then those individual columns without
an aggregate function in the SELECT clause should be included in the GROUP BY cause.

Which statement is true regarding the default behaviour of the ORDER by clause?

A.

Numeric values are displayed in descending order if they have decimal positions.

B.

Only columns that are specified in the SELECT list can be used in the ORDER by
clause.

C.

In a character sort, the values are case-sensitive.

D.

NULLs are not including in the sort operation

Which three arithmetic operations can be performed on a column by using a SQL function
that is built into Oracle database? (Choose three.)

A.

Finding the lowest value

B.

Finding the quotient

C.

Raising to a power

D.

Subtraction

E.

Addition