[May 13, 2026] Fully Updated Free Actual Oracle 1Z1-082 Exam Questions
Free 1Z1-082 Questions for Oracle 1Z1-082 Exam [May-2026]
Oracle 1Z1-082 exam is a critical step in advancing your career as an Oracle Database Administrator. Achieving this certification demonstrates to employers that you have the knowledge and skills necessary to manage and maintain Oracle Databases effectively. It also opens up new job opportunities and can lead to higher salaries.
Oracle 1Z0-082 is a certification exam that focuses on database administration. 1Z1-082 exam is designed to test a candidate's knowledge and skills in managing and maintaining an Oracle database system. Passing 1Z1-082 exam is a crucial step towards becoming an Oracle Certified Associate (OCA) in database administration.
NEW QUESTION # 59
In one of your databases, user KING is:
1. Not a DBA user
2. An operating system (OS) user
Examine this command and its output:
What must you do so that KING is authenticated by the OS when connecting to the database instance?
- A. Unset REMOTE_LOGIN_PASSWORDFILE
- B. Set OS_AUTHEN_PREFIX to OPS$
- C. Have the OS administrator add KING to the OSDBA group
- D. Grant DBA to KING
- E. Alter user KING to be IDENTIFIED EXTERNALLY
Answer: A
NEW QUESTION # 60
Which two statements are true about date/time functions in a session where NLS_DATE_FORMAT is set to DD-MON-YYYY HH24:MI:SS? (Choose two.)
- A. SYSDATE can be used in expressions only if the default date format is DD-MON-RR
- B. CURRENT_TIMESTAMP returns the same date and time as SYSDATE with additional details of fractional seconds
- C. CURRENT_TIMESTAMP returns the same date as CURRENT_DATE
- D. CURRENT_DATE returns the current date and time as per the session time zone
- E. SYSDATE and CURRENT_DATE return the current date and time set for the operating system of the database server
- F. SYSDATE can be queried only from the DUAL table
Answer: C,D
Explanation:
https://www.w3resource.com/oracle/datetime-functions/oracle-current_timestamp-function.php
NEW QUESTION # 61
Which two tasks can you perform using DBCA for databases? (Choose two.)
- A. Enable flashback database for an existing database
- B. Configure incremental backups for a new database
- C. Configure a nonstandard block size for a new database
- D. Register a new database with an available Enterprise Manager Management server
- E. Change the standard block size of an existing database
Answer: D,E
NEW QUESTION # 62
Which two statements are true about Database Instances and Real Application Clusters (RAC)?
- A. Two RAC databases can share their instances.
- B. A RAC database can have instances on separate servers.
- C. A RAC database must have two or more instances.
- D. A RAC database must have three or more Instances.
- E. A RAC database can have one Instance.
Answer: B,E
NEW QUESTION # 63
Examine the description of the BOOKS table:
The table has 100 rows.
Examine this sequence of statements issued in a new session:
INSERT INTO books VALUES ('ADV112', 'Adventures of Tom Sawyer', NULL, NULL); SAVEPOINT a; DELETE FROM books; ROLLBACK TO SAVEPOINT a; ROLLBACK; Which two statements are true? (Choose two.)
- A. The first ROLLBACK command restores the 101 rows that were deleted, leaving the inserted row still to be committed
- B. The second ROLLBACK command replays the delete
- C. The second ROLLBACK command undoes the insert
- D. The second ROLLBACK command does nothing
- E. The first ROLLBACK command restores the 101 rows that were deleted and commits the inserted row
Answer: A,C
NEW QUESTION # 64
In the SALES database, DEFERRED_SEGMENT_CREATION is TRUE.
Examine this command:
SQL> CREATE TABLE T1(c1 INT PRIMARY KEY, c2 CLOB);
Which segment or segments, if any, are created as a result of executing the command?
- A. no segments are created
- B. T1, an index segment for the primary key, and a LOB segment only
- C. T1 only
- D. T1, an index segment for the primary key, a LOB segment, and a lobindex segment
- E. T1 and an index segment created for the primary key only
Answer: A
NEW QUESTION # 65
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:
Which statement is true?
- A. The LREG process registers services dynamically with the LISTENER_1 listener
- B. The definition for LISTENER_1 requires a CONNECT_DATA section to enable dynamic service registration
- C. Dynamic service registration cannot be used for this database instance
- D. There are two listeners named LISTENER and LISTENER_1 running simultaneously using port
1521 on the same host as the database instances - E. LISTENER_1 must also be defined in the LISTENER.ORA file to enable dynamic service registration
Answer: E
Explanation:
https://docs.oracle.com/database/121/NETAG/listenercfg.htm#NETAG292
NEW QUESTION # 66
Evaluate these commands which execute successfully:
Which two statements are true about the ORD_ITEMS table and the ORD_SEQ sequence? (Choose two.)
- A. Any user inserting rows into table ORD_ITEMS must have been granted access to sequence ORD_SEQ
- B. If sequence ORD_SEQ is dropped then the default value for column ORD_NO will be NULL for rows inserted into ORD_ITEMS
- C. 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
- D. Sequence ORD_SEQ is guaranteed not to generate duplicate numbers
- E. Sequence ORD_SEQ cycles back to 1 after every 5000 numbers and can cycle 20 times
Answer: A,D
NEW QUESTION # 67
You currently have an active transaction in your session and have been granted select access to vstransaction.
In which three situations will re-executing this query still return a row but with a different XID, indicating a new transaction has started?
- A. after successfully executing a truncate statement followed by a DML statement
- B. after successfully executing a commit or rollback followed by a DML statement
- C. after successfully executing a DML statement following a failed DML statement
- D. after successfully executing a create table statement followed by a create index statement
- E. after successfully executing a create table as select statement followed by a select for update statement
- F. after successfully executing a commit or rollback followed by a select statement
Answer: A,B,E
NEW QUESTION # 68
You execute this command:
Sufficient storage is available in filesystem /u01.
Which two statements are true about the BIG_TBS tablespace? (Choose two.)
- A. It will be a dictionary-managed tablespace by default
- B. It will always have a 32K blocksize
- C. AUTOEXTEND is possible for the datafile
- D. Additional data files may not be added
- E. It must be bigger than the largest SMALLFILE tablespace
Answer: C,D
NEW QUESTION # 69
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.)
- A. Add the AUTOEXTEND ON clause with NEXT set to 100M.
- B. Ensure that DB_RECOVERY_FILE_DEST and DB_CREATE_FILE_DEST each specify locations with at least 50 Mb of available space.
- C. Specify a path in the DATAFILE clause of the command specifying a location with at least 100M of available space.
- D. Ensure that DB_RECOVERY_FILE_DEST and DB_CREATE_FILE_DEST each specify with at least 50 Mb of available space.
- E. Ensure that DB_CREATE_FILE_DEST specifies a location with at least 100 Mb of available space.
Answer: A,C
NEW QUESTION # 70
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?
- A. as SCOTT in BOSTON_DB
- B. as SCOTT in BOSTON_DB and SYS in DALLAS_DB
- C. as SCOTT in both the databases
- D. as SCOTT in DALLAS_DB
- E. as SYS in both the databases
Answer: E
NEW QUESTION # 71
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.)
- A. SELECT promo_cost, promo_category FROM promotions ORDER BY by 1;
- B. SELECT DISTINCT promo_cost || ' in ' || DISTINCT promo_category FROM promotions ORDER BY 1;
- C. SELECT promo_category, DISTINCT promo_cost FROM promotions ORDER BY 2;
- D. SELECT DISTINCT promo_category, promo_cost FROM promotions ORDER BY 1;
- E. SELECT DISTINCT promo_category || ' has ' || promo_cost AS COSTS FROM promotions ORDER BY 1;
Answer: D,E
NEW QUESTION # 72
Which two statements are true about the results of using the INTERSECT operator in compound queries?
(Choose two.)
- A. The number of columns in each SELECT in the compound query can be different
- B. Column names in each SELECT in the compound query can be different
- C. Reversing the order of the intersected tables can sometimes affect the output
- D. INTERSECT ignores NULLs
- E. INTERSECT returns rows common to both sides of the compound query
Answer: B,D
NEW QUESTION # 73
Which two statements are true about the Automatic Diagnostic Repository (ADR)? (Choose two.)
- A. The ADR base defaults to $ORACLE_HOME/rdbms/admin if
neither DIAGNOSTIC_DEST nor ORACLE_BASE is set - B. It is held inside an Oracle database schema
- C. The ADR base defaults to $ORACLE_HOME/dbs if the DIAGNOSTIC_DEST parameter and the ORACLE_BASE environment variable are not set
- D. It supports diagnostics for Oracle Clusterware
- E. It supports diagnostics for Automatic Storage Management (ASM)
Answer: A,B
Explanation:
Explanation/Reference: https://docs.oracle.com/cd/E11882_01/install.112/e27508/admin.htm
NEW QUESTION # 74
Which two statements are true about User Authentication in an Oracle Database?
- A. Password File authentication is supported for any type of database user.
- B. Operating System authentication may be used for system-privileged administrative users.
- C. REKOTE_LOGIN_PASSMOREFiLE must be set to exclusive to permit password changes for system-privileged administrative users.
- D. Password authentication must be used for system-privileged administrative users.
- E. Password File authentication must be used for system-privileged administrative users.
Answer: B,D
NEW QUESTION # 75
View the Exhibit and examine the structure of the PRODUCTS table.
Which two tasks require subqueries? (Choose two.)
- A. Display the total number of products supplied by supplier 102 which have a product status of obsolete
- B. Display products whose PROD_MIN_PRICE is more than the average PROD_LIST_PRICE of all products, and whose status is orderable
- C. Display suppliers whose PROD_LIST_PRICE is less than 1000
- D. Display the minimum PROD_LIST_PRICE for each product status
- E. Display the number of products whose PROD_LIST_PRICE is more than the average PROD_LIST_PRICE
Answer: B,E
NEW QUESTION # 76
You execute this command:
During the export operation, you detach from the job by using CTRL+C and then execute this command:
Export> STOP_JOB=immediate
Are you sure you wish to stop the job ([yes]/no): yes
Which two statements are true about the job? (Choose two.)
- A. You can no longer monitor it
- B. It terminates
- C. It is paused and can be resumed
- D. It continues to run in the background
- E. You can reattach to it and monitor it
Answer: A,B
Explanation:
Explanation/Reference: https://blog.oracle48.nl/killing-and-resuming-datapump-expdp-and-impdp-jobs/
NEW QUESTION # 77
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?
- A. SELECT * FROM customers WHERE city LIKE `D_%';
- B. SELECT * FROM customers WHERE city = `D_%';
- C. SELECT * FROM customers WHERE city LIKE `D_';
- D. SELECT * FROM customers WHERE city = `%D_';
Answer: A
NEW QUESTION # 78
The stores table has a column START_DATE of data type DATE, containing the date the row was inserted. You only want to display details of rows where START_DATE is within the last 25 months. Which where clause can be used?
- A. WHERE ADD_MONTHS<start_date, 25) <= SYSDATE
- B. WHERE MON'THS_BETWEEN (start_date, SYSDATE) <= 25
- C. WHERE MON'THS_BETWEEN (SYSDATE, start_date) <= 25
- D. WHERE TO_XUMBER(start_date - SYSDATE) <= 25
Answer: B
NEW QUESTION # 79
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:
Which statement is true?
- A. The LREG process registers services dynamically with the LISTENER_1 listener
- B. The definition for LISTENER_1 requires a CONNECT_DATA section to enable dynamic service registration
- C. Dynamic service registration cannot be used for this database instance
- D. LISTENER_1 must also be defined in the LISTENER.ORA file to enable dynamic service registration
- E. There are two listeners named LISTENER and LISTENER_1 running simultaneously using port 1521 on the same host as the database instances
Answer: D
NEW QUESTION # 80
......
Validate your 1Z1-082 Exam Preparation with 1Z1-082 Practice Test: https://www.actual4dump.com/Oracle/1Z1-082-actualtests-dumps.html
Get all the Information About Oracle 1Z1-082 Exam 2026 Practice Test Questions: https://drive.google.com/open?id=1olswxFNyG-SNxtHV1D1jVqsOPsEE56K5