1Z0-082 Exam Questions and Answers | Exam-Dumps.net (Page: 3)

QUESTION: 11

Which two statements are true about the SET VERIFY ON command? (Choose two.)

It can be used only in SQL*Plus
It displays values for variables used only in the WHERE clause of a query
It can be used in SQL Developer and SQL*Plus
It displays values for variables created by the DEFINE command
It displays values for variables prefixed with &&

Answer(s): A,D

Reveal Solution Next Question

QUESTION: 12

Which three statements are true about a self join? (Choose three.)

The ON clause must be used
The query must use two different aliases for the table
It must be an equijoin
It must be an inner join
The ON clause can be used
It can be an outer join

Answer(s): B,D,E

Reveal Solution Next Question

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?

SELECT &&col1, &&col2
FROM &table
WHERE &&condition = &&cond;
SELECT &col1, &col2
FROM &&table
WHERE &condition;
SELECT &col1, &col2
FROM “&table”
WHERE &condition;
SELECT ‘&&col1’, ‘&&col2’
FROM &table
WHERE ‘&&condition’ = ‘&cond’;
SELECT &&col1, &&col2
FROM &table
WHERE &&condition;

Answer(s): B

Reveal Solution Next Question

QUESTION: 14

Examine the description of the CUSTOMERS table:

You want to display details of all customers who reside in cities starting with the letter D followed by at least two characters. Which query can be used?

SELECT * FROM customers WHERE city LIKE ‘D_%’;
SELECT * FROM customers WHERE city = ‘%D_’;
SELECT * FROM customers WHERE city LIKE ‘D_’;
SELECT * FROM customers WHERE city = ‘D_%’;

Answer(s): A

Reveal Solution Next Question

QUESTION: 15

Examine this command:

Which two statements are true? (Choose two.)

DML may be performed on tables with one or more extents in this data file during the execution of this command.
The tablespace containing SALES1.DBF must be altered READ ONLY before executing the command.
The tablespace containing SALES1.DBF must be altered OFFLINE before executing the command.
If Oracle Managed Files (OMF) is used, then the file is renamed but moved to DB_CREATE_FILE_DEST.
The file is renamed and stored in the same location

Answer(s): A,B

Reveal Solution Next Question

Oracle 1Z0-082 Exam (page: 3)
Oracle Database Administration I
Updated on: 29-Aug-2025

QUESTION: 11

QUESTION: 12

QUESTION: 13

QUESTION: 14

QUESTION: 15

Oracle 1Z0-082 Exam (page: 3) Oracle Database Administration I Updated on: 29-Aug-2025

QUESTION: 11

QUESTION: 12

QUESTION: 13

QUESTION: 14

QUESTION: 15

Oracle 1Z0-082 Exam (page: 3)
Oracle Database Administration I
Updated on: 29-Aug-2025