Oracle 1Z0-082 Exam Practice Questions, practice question pack
ORACLE · 1Z0-082

Oracle 1Z0-082 Exam Practice Questions

178 questionsInstant PDF downloadUpdated September 2026

US$39

Try 10 questions free

Card, Apple Pay or Google Pay. Your PDF is sent by email as soon as you check out.

Pass or your money backFail the exam after using this pack and we refund it. How the guarantee works
Category:
TRY BEFORE YOU BUY

Three of the 178 questions in this pack

Question 1

You execute this command: Sufficient storage is available in filesystem /u01. Which two statements are true about the BIG_TBS tablespace? (Choose two.)

Exhibit for question 1

  1. AUTOEXTEND is possible for the datafile
  2. It must be bigger than the largest SMALLFILE tablespace
  3. Additional data files may not be added
  4. It will be a dictionary-managed tablespace by default
  5. It will always have a 32K blocksize
Show answer and explanation

Correct answer: A, C

A. AUTOEXTEND is possible for the datafile C. Additional data files may not be added A bigfile tablespace is built from exactly one data file, so no additional data files can ever be added to it (C). To let it grow, that single file supports AUTOEXTEND, which is fully permitted on a bigfile data file (A). The one file can address up to 4G blocks, which is 32TB with an 8K block size, so a single file is enough. A smallfile tablespace, by contrast, can hold many data files.

Why the other options are wrong

  • B. There is no rule tying a bigfile tablespace's size to any smallfile tablespace; it can be created at any supported size.
  • D. Oracle 10g and later default to locally-managed tablespaces, not dictionary-managed tablespaces.
  • E. The blocksize comes from DB_BLOCK_SIZE unless BLOCKSIZE is specified, so it is not required to be 32K; it defaults to whatever the database blocksize is configured to be.

Question 2

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

  1. Multiple INTERSECT operators are not possible in the same SQL statement
  2. It processes NULLs in the selected columns
  3. INTERSECT is of lower precedence than UNION or UNION ALL
  4. It ignores NULLs
Show answer and explanation

Correct answer: B. It processes NULLs in the selected columns

The INTERSECT operator processes NULLs in the selected columns. When rows from the two result sets are compared, a NULL in a column of one row is treated as matching a NULL in the same column of the other row, so such rows are returned. NULLs are not skipped or discarded, which is the defining characteristic of how INTERSECT handles NULL values in compound queries.

Why the other options are wrong

  • A. Multiple INTERSECT operators are possible in the same SQL statement; you can chain multiple INTERSECT operations together.
  • C. INTERSECT has higher precedence than UNION, UNION ALL and MINUS, so it is evaluated first.
  • D. INTERSECT does not ignore NULLs; it actively processes and matches them as comparable values.

Question 3

Which three statements are true about advanced connection options supported by Oracle Net for connection to Oracle Database instances? (Choose three.)

  1. Connect Time Failover requires the use of Transparent Application Failover (TAF)
  2. Source Routing requires the use of a name server
  3. Source Routing enables the use of Connection Manager (CMAN) which enables network traffic to be routed through a firewall
  4. Load Balancing can balance the number of connections to dispatchers when using a Shared Server configuration
  5. Load Balancing requires the use of a name server
  6. Connect Time Failover requires the connect string to have two or more listener addresses configured
Show answer and explanation

Correct answer: C, D, F

C. Source Routing enables the use of Connection Manager (CMAN) which enables network traffic to be routed through a firewall D. Load Balancing can balance the number of connections to dispatchers when using a Shared Server configuration F. Connect Time Failover requires the connect string to have two or more listener addresses configured Source routing lets a connection be routed through one or more intermediate points such as Connection Manager, which allows traffic to pass through a firewall (C). Load balancing can spread client connections across the dispatchers of a Shared Server configuration (D). Connect time failover requires the connect string to list two or more listener addresses so the client can try the next address when one fails (F).

Why the other options are wrong

  • A. Connect Time Failover operates independently and does not require Transparent Application Failover (TAF).
  • B. Source routing needs only SOURCE_ROUTE=YES with a list of addresses in the connect descriptor; no name server is involved.
  • E. Load Balancing does not require a name server; it can function with local connect descriptors and multiple addresses.

See all 10 free questions Get the full pack, US$39

178 practice questions for Oracle Database Administration I (1Z0-082), with full explanations.

Every question comes with the correct answer, the reasoning behind it, and a note on why each wrong option is wrong. Work through it once with the answers, then again with the questions-only copy under timed conditions.

  • 178 questions mapped to the 1Z0-082 exam objectives
  • Answers and explanations for every question, including the wrong options
  • A questions-only PDF for timed practice runs
  • Instant delivery by email the moment you check out
  • Free monthly updates for as long as the exam is live
  • Pass or your money back

A failed 1Z0-082 attempt costs US$245, plus the weeks it takes to get ready again. This pack is US$39, paid once, and refunded if you fail.

Try 10 questions free before you buy.

Last updated September 2026 · 178 questions

What makes the 1Z0-082 hard

1Z0-082 is the first half of the Oracle DBA OCP path, and it is two exams wearing one code: half administration, half SQL, and candidates reliably prepare for only the half they work in.

The admin half lives in the architecture: instance memory structures and background processes, startup and shutdown stages, tablespace and undo management, users, roles and profiles, and the network stack of listeners and naming. The SQL half re-tests 1Z0-071-grade material. The trick questions are architectural cause and effect: what actually happens at MOUNT, or when undo runs out mid-transaction.

About the exam

1Z0-082 certifies Oracle Database administration fundamentals and SQL: architecture, instance management, storage, users and security, and networking. Passing it plus 1Z0-083 earns the Oracle Database Administration 2019 Certified Professional credential. Does not expire.

Exam topics

  • Oracle architecture: instance, memory, processes
  • Managing database instances and storage
  • Users, roles, profiles and security
  • Oracle Net Services and connectivity
  • SQL: queries, DML, DDL

90 questions, 150 minutes, passing score 60%, US$245 per attempt, at a Pearson VUE centre or online proctored, does not expire.

Reviews

There are no reviews yet.

Only logged in customers who have purchased this product may leave a review.

Questions before you buy

What do I get when I buy the Oracle 1Z0-082 pack?

178 practice questions as a PDF, each with the correct answer, a full explanation and a note on why the other options are wrong, plus a separate questions-only PDF for timed practice.

How quickly do I receive it?

Straight away. The full PDF and a questions-only copy are emailed to you the moment your payment goes through, and the same links are on your order page.

Is there a free sample?

Yes. Ten questions from this pack, with answers and explanations, are free on this page and as a PDF, so you can judge the quality before you pay.

Are updates included?

Yes. The pack is updated every month for as long as the exam is live, and updates are free for everyone who has bought it.

What if I fail the exam?

We refund the pack. Sit the exam 7 to 30 days after buying, then send your official score report within 7 days of the exam date, as set out in the refund policy.

Can I share it with colleagues?

Each purchase is licensed to one person. For a team, school or training organisation, email support@certstash.com for a licence that fits.

Related products