In the spfile of a single instance database, LOCAL_LISTENER is set to LISTENER_1. The TNSNAMES.ORA file in $ORACLE_HOME/network/admin in the database home contains: https://kxbjsyuhceggsyvxdkof.supabase.co/storage/v1/object/public/file-images/1Z0-082/page_5_img_1.jpg Which statement is true?

The LREG process registers services dynamically with the LISTENER_1 listener

Dynamic service registration cannot be used for this database instance

The LREG process registers services dynamically with the LISTENER_1 listener

LISTENER_1 must also be defined in the LISTENER.ORA file to enable dynamic service registration

There are two listeners named LISTENER and LISTENER_1 running simultaneously using port 1521 on the same host as the database instances

The definition for LISTENER_1 requires a CONNECT_DATA section to enable dynamic service registration

Examine the description of the PROMOTIONS table: https://kxbjsyuhceggsyvxdkof.supabase.co/storage/v1/object/public/file-images/1Z0-082/page_23_img_1.jpg You want to display the unique promotion costs in each promotion category. Which two queries can be used? (Choose two.)

SELECT DISTINCT promo_category || ‘ has ‘ || promo_cost AS COSTS FROM promotions ORDER BY 1;

SELECT DISTINCT promo_category, promo_cost FROM promotions ORDER BY 1;

SELECT promo_cost, promo_category FROM promotions ORDER BY by 1;

SELECT DISTINCT promo_cost || ’ in ‘ || DISTINCT promo_category FROM promotions ORDER BY 1;

SELECT DISTINCT promo_category || ‘ has ‘ || promo_cost AS COSTS FROM promotions ORDER BY 1;

SELECT promo_category, DISTINCT promo_cost FROM promotions ORDER BY 2;

SELECT DISTINCT promo_category, promo_cost FROM promotions ORDER BY 1;

Examine this command: https://kxbjsyuhceggsyvxdkof.supabase.co/storage/v1/object/public/file-images/1Z0-082/page_8_img_2.jpg 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 file is renamed and stored in the same location

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

Evaluate these commands which execute successfully: https://kxbjsyuhceggsyvxdkof.supabase.co/storage/v1/object/public/file-images/1Z0-082/page_10_img_1.jpg Which two statements are true about the ORD_ITEMS table and the ORD_SEQ sequence? (Choose two.)

Any user inserting rows into table ORD_ITEMS must have been granted access to sequence ORD_SEQ

Column ORD_NO gets the next number from sequence ORD_SEQ whenever a row is inserted into ORD_ITEMS and no explicit value is given for ORD_NO

If sequence ORD_SEQ is dropped then the default value for column ORD_NO will be NULL for rows inserted into ORD_ITEMS

Any user inserting rows into table ORD_ITEMS must have been granted access to sequence ORD_SEQ

Column ORD_NO gets the next number from sequence ORD_SEQ whenever a row is inserted into ORD_ITEMS and no explicit value is given for ORD_NO

Sequence ORD_SEQ cycles back to 1 after every 5000 numbers and can cycle 20 times

Sequence ORD_SEQ is guaranteed not to generate duplicate numbers

Free 1Z0-082 Practice Test Questions and Answers (2026)

Q: 1

In the spfile of a single instance database, LOCAL_LISTENER is set to LISTENER_1. The TNSNAMES.ORA file in $ORACLE_HOME/network/admin in the database home contains: Oracle 1Z0-082 question

Which statement is true?

Options

Q: 2

Which three statements are true about connection strings and service names used to connect to an Oracle database instance?

Options

Q: 3

In one of your databases, the user HR has the password HRMGR. You want to connect to a database instance whose listener listens on port 1531 by using this statement: CONNECT HR/HRMGR@orcl No name server is used. Which statement is true about ORCL?

Options

Q: 4

The EMPLOYEES table contains columns EMP_ID of data type NUMBER and HIRE_DATE of data type DATE. You want to display the date of the first Monday after the completion of six months since hiring. The NLS_TERRITORY parameter is set to AMERICA in the session and, therefore, Sunday is the first day on the week. Which query can be used?

Options

Q: 5

Which three statements are true concerning logical and physical database structures? (Choose three.)

Options

Q: 6

Which three statements are true about undo segments and the use of undo by transactions in an Oracle database instance? (Choose three.)

Options

Q: 7

In your data center, Oracle Managed Files (OMF) is used for all databases. All tablespaces are smallfile tablespaces. SALES_Q1 is a permanent user-defined tablespace in the SALES database. Examine this command which is about to be issued by a DBA logged in to the SALES database: ALTER TABLESPACE sales_q1 ADD DATAFILE; Which are two actions, either one of which you could take to ensure that the command executes successfully? (Choose two.)

Options

Q: 8

Which three statements are true about the DESCRIBE command? (Choose three.)

Options

Q: 9

Examine the description of the PROMOTIONS table:

You want to display the unique promotion costs in each promotion category. Which two queries can be used? (Choose two.)

Options

Q: 10

Which two statements are true about single row functions? (Choose two.)

Options

Q: 11

Examine the description of the CUSTOMERS table:

For customers whose income level has a value, you want to display the first name and due amount as 5% of their credit limit. Customers whose due amount is null should not be displayed. Which query should be used?

Options

Q: 12

The SCOTT/TIGER user exists in two databases, BOSTON_DB and DALLAS_DB, in two different locations. Each database has a tnsnames.ora file defining DALLAS_DB as a service name. Examine this command: CREATE DATABASE LINK dblink1 CONNECT TO scott IDENTIFIED BY tiger USING ‘dallas_db’; How do you execute the command so that only SCOTT in BOSTON_DB can access the SCOTT schema in DALLAS_DB?

Options

Q: 13

Which four account management capabilities can be configured using Oracle profiles? (Choose four.)

Options

Q: 14

Examine this command:

Which two statements are true? (Choose two.)

Options

Q: 15

Which two statements are true about views used for viewing tablespace and datafile information? (Choose two.)

Options

Q: 16

Which two statements are true about the configuration and use of UNDO_RETENTION with GURANTEED RETENTION? (Choose two.)

Options

Q: 17

Evaluate these commands which execute successfully:

Which two statements are true about the ORD_ITEMS table and the ORD_SEQ sequence? (Choose two.)

Options

Q: 18

Which two statements are true about the Automatic Diagnostic Repository (ADR)? (Choose two.)

Options

Q: 19

Which two statements are true about the results of using the INTERSECT operator in compound queries? (Choose two.)

Options

Q: 20

Which three are types of segments in an Oracle Database? (Choose three.)

Options

Question 1 of 20

Free 1Z0-082 Practice Test Questions and Answers (2026)

Premium Access Includes

FLASH OFFER

avail 10% DISCOUNT on YOUR PURCHASE