1Z0-071 Online Practice Questions and Answers

Examine this statement:

What is returned upon execution?

A. 2 rows

B. 0 rows

C. An error

D. 1 ROW

Which three queries execute successfully?

A. SELECT 1 - SYSDATE - DATE '2019-01-01' FROM DUAL;

B. SELECT SYSDATE - DATE '2019-01-01' - 1 FROM DUAL;

C. SELECT SYSDATE / DATE '2019-01-01' - 1 FROM DUAL;

D. SELECT SYSDATE - 1 - DATE '2019-01-01' FROM DUAL;

E. SELECT (SYSDATE - DATE '2019-01-01') / 1 FROM DUAL;

F. SELECT 1 / SYSDATE - DATE '2019-01-01' FROM DUAL;

Which two are true about the precedence of opertors and condtions

A. + (addition) has a higher order of precedence than * (mliplpition)

B. NOT has a higher order of precedence than AND and OR in a condition.

C. AND and OR have the same order of precedence in a condition

D. Operators are evaluated before conditions.

E. || has a higher order of precedence than +(addition)

Examine this query:

What is the result?

A. an error

B. no rows

C. 1 row

D. 3 rows

E. 6 rows

F. 8 rows

Which two statements are true about the DUAL table: (Choose two.)

A. It can display multiple rows but only a single column.

B. It can be accessed only by the SYS user.

C. It can be accessed by any user who has the SELECT privilege in any schema.

D. It can display multiple rows and columns.

E. It consists of a single row and single column of VARCHAR2 data type.

F. It can be used to display only constants or pseudo columns.

Which three actions can you perform by using the ALTER TABLE command? (Choose three.)

A. Drop pseudocolumns from a table.

B. Restrict all DML statements on a table.

C. Lock a set of rows in a table.

D. Rename a table.

E. Drop all columns simultaneously from a table.

F. Enable or disable constraints on a table.

Which three statements are true regarding the WHERE and HAVING clauses in a SQL statement? (Choose three.)

A. WHERE and HAVING clauses cannot be used together in a SQL statement.

B. The HAVING clause conditions can have aggregate functions.

C. The HAVING clause conditions can use aliases for the columns.

D. The WHERE clause is used to exclude rows before the grouping of data.

E. The HAVING clause is used to exclude one or more aggregated results after grouping data.

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

A. A role can be granted to itself.

B. A role can be granted to PUBLIC.

C. A user can be granted only one role at any point of time.

D. The REVOKE command can be used to remove privileges but not roles from other users.

E. Roles are named groups of related privileges that can be granted to users or other roles.

In Which three situations does a transaction complete?

A. when a PL/SQL anonymous block is executed

B. when a DELETE statement is executed

C. when a ROLLBACK command is executed

D. when a data definition language (DDL) statement is executed

E. when a TRUNCATE statement is executed after the pending transaction

Examine the structure of the INVOICE table.

Which two SQL statements would execute successfully?

A. SELECT inv_no, NVL2(inv_date, 'Pending', 'Incomplete') FROM invoice;

B. SELECT inv_no, NVL2(inv_amt, inv_date, 'Not Available') FROM invoice;

C. SELECT inv_no, NVL2(inv_date, sysdate-inv_date, sysdate) FROM invoice;

D. SELECT inv_no, NVL2(inv_amt, inv_amt*.25, 'Not Available') FROM invoice;