Free Oracle 1Z1-082 Practice Test & Real Exam Questions

Exam Code/Number: 1Z1-082
Exam Name/Title: Oracle Database Administration I
Certification Provider: Oracle
Corresponding Certification: Oracle Database 19c

Exam Questions: 165
Updated On: Oct 09, 2026

Question #53

Which two statements are true about interval data types?

A. INTERVAL year to month columns only support monthly intervals within a range of years.

B. INTERVAL year to month columns only support monthly Intervals within a single year.

C. The value in an interval day to SECOND column can be copied into an interval year to month column.

D. INTERVAL year TO month columns support yearly intervals.

E. INTERVAL day to second columns support fractions of seconds.

F. The year field in an interval year to month column must be a positive value.

Discussion 0

Correct Answer: D,E Vote an answer

Question #54

The customers table has a cust_last_name column of data type varchar2. The table has two rows whose "jst_last_name values are Andersen and Ausson. Which query produces output for cust_last_xame containing Oder for the first row and Aus for the second?

A. SELECT REPLACE(REPLACE(cust_last_name, 'son', ''), 'An', 'O'> FROM customers;

B. SELECT REPLACE<TRIM<TRAILING 'son* FROM cust_last_name), 'An', *O'> FROM customers;

C. SELECT INITCAP (REPLACE(TRIM('son' FROM cust_last_name), 'An', 'O*)) FROM customers;

D. SELECT REPLACE(SUBSTR(cust_last_name, -3), 'An', 'O') FROM customers;

Discussion 0

Correct Answer: B Vote an answer

Question #55

Which three statements are true about sequences in a single instance Oracle database?

A. A sequence can Issue duplicate values.

B. Two or more tables cannot have keys generated from the same sequence.

C. A sequence can only be dropped by a DBA.

D. Sequences can always have gaps.

E. A sequence number that was allocated can be rolled back if a transaction fails.

F. A sequence's unallocated cached values are lost if the instance shuts down.

Discussion 0

Correct Answer: A,B,F Vote an answer

Question #56

In which three situations does a new transaction always start? (Choose three.)

A. when issuing a TRUNCATE statement after a SELECT statement was issued in the same session

B. when issuing the first Data Manipulation Language (DML) statement after a COMMIT OR ROLLBACK statement was issued in the same session

C. when issuing a CREATE INDEX statement after a CREATE TABLE statement completed successfully in the same session

D. when issuing a DML statement after a DML statement failed in the same session

E. when issuing a SELECT FOR UPDATE statement after a CREATE TABLE AS SELECT statement was issued in the same session

F. when issuing a CREATE TABLE statement after a SELECT statement was issued in the same session

Discussion 0

Correct Answer: B,D,E Vote an answer

Question #57

Examine the description of the EMPLOYEES table:

Which query is valid?

A. SELECT dept_id, MAX(AVG(salary)) FROM employees GROUP BY dept_id;

B. SELECT dept_id, join_date, SUM(salary) FROM employees GROUP BY dept_id, join_date;

C. SELECT dept_id, join_date, SUM(salary) FROM employees GROUP BY dept_id;

D. SELECT dept_id, AVG(MAX(salary)) FROM employees GROUP BY dept_id;

Discussion 0

Correct Answer: C Vote an answer

Question #58

Which three failures do not require intervention for recovery? (Choose three.)

A. transaction failure

B. statement failure

C. user process failure

D. media failure

E. network interface card (NIC) failure

Discussion 0

Correct Answer: A,B,C Vote an answer

Question #59

View the Exhibit and examine the description of the tables.
You execute this SQL statement:

Which three statements are true?

A. The statement will fail because a subquery may not be contained in a values clause.

B. A product can have a different unit price at different times.

C. The statement will execute successfully and a new row will be inserted into the sales table.

D. The sales table has five foreign keys.

E. The statement will fall if a row already exists in the sales table for product 23.

F. A customer can exist in many countries.

Discussion 0

Correct Answer: B,C,D Vote an answer

Question #60

Which compression method is recommended for Direct-Path Insert operations?

A. COLUMN STORE COMPRESS BASIC

B. RON STORE COMPRESS BASIC

C. COLUMN STORE COMPRESS ADVANCED

D. ROW STORE COMPRESS ADVANCED

Discussion 0

Correct Answer: B Vote an answer

Question #61

Which three statements are true about Deferred Segment Creation in Oracle databases?

A. It Is the default behavior for tables and indexes.

B. It is supported for SYS-owned tables contained in locally managed tablespaces.

C. Sessions may dynamically switch back and forth from deferred to immediate segment creation.

D. It Is supported for Index Organized Tables (IOTs) contained in locally managed tablespaces.

E. Indexes inherit the deferred or immediate segment creation attribute from their parent table

Discussion 0

Correct Answer: A,C,E Vote an answer

Question #62

The INVOICE table has a QTY_SOLD column of data type NUMBER and an INVOICE_DATE column of data type DATE.
NLS_DATE_FORMAT is set to DD-MON-RR.
Which two are true about data type conversions involving these columns in query expressions?
(Choose two.)

A. invoice_date = '15-march-2019' : uses implicit conversion

B. invoie_date > '01-02-2019' : uses implicit conversion

C. qty_sold = `0554982' uses implicit conversion

D. CONCAT (qty_sold, invoice_date) : requires explicit conversion

E. qty_sold BETWEEN `101' AND '110' : uses implicit conversion

Discussion 0

Correct Answer: A,E Vote an answer

Question #63

Which two statements are true about User Authentication in an Oracle Database?

A. Operating System authentication may be used for system-privileged administrative users.

B. Password File authentication must be used for system-privileged administrative users.

C. Password authentication must be used for system-privileged administrative users.

D. Password File authentication is supported for any type of database user.

E. REKOTE_LOGIN_PASSMOREFiLE must be set to exclusive to permit password changes for system- privileged administrative users.

Discussion 0

Correct Answer: A,C Vote an answer

Question #64

Which two types of files are opened by a database instance in the NOMOUNT state?

A. data files

B. the initialization parameter file

C. online redo logs

D. control files

E. the alert log

Discussion 0

Correct Answer: A,B Vote an answer

Question #65

Which statement is true about aggregate functions?

A. Aggregate functions can be nested to any number of levels

B. The MAX and MIN functions can be used on columns with character data types

C. The AVG function implicitly converts NULLS to zero

D. Aggregate functions can be used in any clause of a SELECT statement

Discussion 0

Correct Answer: A Vote an answer

Download Free Oracle 1Z1-082 Demo

Simply submit your e-mail address below to get started with our free demo of your Oracle 1Z1-082 exam.