1z0-082 Free Practice Test

You want to write a query that prompts for two column names and the WHERE condition each time it is executed in a session but only prompts for the table name the first time it is executed.
The variables used in your query are never undefined in your session. Which query can be used?

1. A. SELECT &&col1, &&col2FROM &tableWHERE &&condition = &&cond;
2. B. SELECT &col1, &col2FROM &&tableWHERE &condition;
3. C. SELECT &col1, &col2FROM “&table”WHERE &condition;
4. D. SELECT ‘&&col1’, ‘&&col2’FROM &tableWHERE ‘&&condition’ = ‘&cond’;
5. E. SELECT &&col1, &&col2FROM &tableWHERE &&condition;

Correct Answer: B

The SALES_Q1 and USERS tablespaces exist in one of your databases and TEMP is a temporary tablespace. Segment creation is not deferred.
You execute this command:
<>

1. A. The sales user must have a quota on the TEMP tablespace
2. B. The sales user must have a quota on the SALES_Q1 tablespace to hold the initial extends of all tables they plan to create in their schema
3. C. The sales user must have been granted the CREATE SESSION privilege
4. D. The sales user must have their quota on the users tablespace removed
5. E. The sales user must have a quota on the SALES_Q1 tablespace to hold all the rows to be inserted into any table in their schema
6. F. The sales user must have been granted the CREATE TABLE privilege

Correct Answer: BDF

Examine the description of the BOOKS table:
<>>>>>

1. A. The second ROLLBACK command does nothing
2. B. The second ROLLBACK command replays the delete
3. C. The first ROLLBACK command restores the 101 rows that were deleted, leaving the inserted row still to be committed
4. D. The second ROLLBACK command undoes the insert
5. E. The first ROLLBACK command restores the 101 rows that were deleted and commits the inserted row

Correct Answer: DE

What is true about non-equijoin statement performance? (Choose two.)

1. A. Table aliases can improve performance
2. B. The BETWEEN condition always performs better than using the >= and <= conditions
3. C. The join syntax used makes no difference to performance
4. D. The BETWEEN condition always performs less well than using the >= and <= conditions
5. E. The Oracle join syntax performs better than the SQL:1999 compliant ANSI join syntax

Correct Answer: AE

Which statement is true about the INTERSECT operator used in compound queries?

1. A. Multiple INTERSECT operators are not possible in the same SQL statement
2. B. It processes NULLs in the selected columns
3. C. INTERSECT is of lower precedence than UNION or UNION ALL
4. D. It ignores NULLs

Correct Answer: B