[Dec-2025 Newly Released] 1Z0-082 Dumps for Oracle Database 19c Certified [Q76-Q90]

4.3/5 - (3 votes)

[Dec-2025 Newly Released] 1Z0-082 Dumps for Oracle Database 19c Certified

Updated Verified 1Z0-082 dumps Q&As – 100% Pass

NEW QUESTION 76
Which two tasks can you perform using DBCA for databases? (Choose two.)

Configure a nonstandard block size for a new database

Change the standard block size of an existing database

Configure incremental backups for a new database

Enable flashback database for an existing database

NEW QUESTION 77
Table EMPLOYEES contains columns including EMPLOYEE_ID, JOB_ID and SALARY.
Only the EMPLOYEE_ID column is indexed.
Rows exist for employees 100 and 200.
Examine this statement:

Which two statements are true? (Choose two.)

Employee 100 will have SALARY set to the same value as the SALARY of employee 200

Employee 200 will have JOB_ID set to the same value as the JOB_ID of employee 100

Employee 200 will have SALARY set to the same value as the SALARY of employee 100

Employee 100 will have JOB_ID set to the same value as the JOB_ID of employee 200

Employees 100 and 200 will have the same JOB_ID as before the update command

Employees 100 and 200 will have the same SALARY as before the update command

NEW QUESTION 78
Table ORDER_ITEMScontains columns ORDER_ID, UNIT_PRICEand QUANTITY, of data type NUMBER.
Examine these SQL statements:
Statement 1:
SELECT MAX(unit_price * quantity) “Maximum Order”
FROM order_items;
Statement 2:
SELECT MAX(unit_price * quantity) “Maximum Order”
FROM order_items
GROUP BY order_id;
Which two statements are true?

Statement 1 returns only one row of output.

Statement 2 returns only one row of output.

Both statements will return NULL if either UNIT_PRICE or QUANTITY contains NULL.

Both the statements give the same output.

Statement 2 may return multiple rows of output.

NEW QUESTION 79
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?

SELECT emp_id, ADD_MONTHS(hire_date, 6), NEXT_DAY(‘MONDAY’) FROM employees;

SELECT emp_id, NEXT_DAY(ADD_MONTHS(hire_date, 6), ‘MONDAY’) FROM employees;

SELECT emp_id, NEXT_DAY(MONTHS_BETWEEN(hire_date, SYSDATE), 6) FROM employees;

SELECT emp_id, NEXT_DAY(ADD_MONTHS(hire_date, 6), 1) FROM employees;

NEW QUESTION 80
You execute this command:
CREATE SMALLFILE TABLESPACE sales
DATAFILE ‘/u01/app/oracle/sales01.dbf
SIZE 5G
SEGMENT SPACE MANAGEMENT AUTO;
Which two statements are true about the SALES tablespace? (Choose two.)

It must be smaller than the smallest BIGFILE tablespace

Free space is managed using freelists

Any data files added to the tablespace must have a size of 5 gigabytes

It uses the database default blocksize

It is a locally managed tablespace

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

Connect Time Failover requires the use of Transparent Application Failover (TAF)

Source Routing requires the use of a name server

Source Routing enables the use of Connection Manager (CMAN) which enables network traffic to be routed through a firewall

Load Balancing can balance the number of connections to dispatchers when using a Shared Server configuration

Load Balancing requires the use of a name server

Connect Time Failover requires the connect string to have two or more listener addresses configured

NEW QUESTION 82
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?

T1, an index segment for the primary key, a LOB segment, and a lobindex segment

no segments are created

T1 only

T1 and an index segment created for the primary key only

T1, an index segment for the primary key, and a LOB segment only

NEW QUESTION 83
Which two statements are true about the ORDER BY clause when used with a SQL statement containing a SET operator such as UNION? (Choose two.)

Column positions must be used in the ORDER BY clause

Only column names from the first SELECT statement in the compound query are recognized

The first column in the first SELECT of the compound query with the UNION operator is used by default to sort output in the absence of an ORDER BY clause

Each SELECT statement in the compound query must have its own ORDER BY clause

Each SELECT statement in the compound query can have its own ORDER BY clause

NEW QUESTION 84
Which two are true about the roles? (Choose two.)

All privileges and roles granted to a user are enabled by default when the user logs in.

The SET ROLE statement can be used once per session.

The SET ROLE statement enables as well as disables roles in a session.

A role must be disabled before it can be revoked from a user.

The ALTER USER statement must be used to set specific default roles for a user.

NEW QUESTION 85
Which statement is true about smallfile tablespaces?

Extent location metadata is stored in the data dictionary by default.

The number of data files is constrained only by the size of the storage array.

Maximum file size can be set to unlimited only if the logical volume manager supports striping.

Segments can span multiple tablespaces.

Segments can span multiple data files.

NEW QUESTION 86
Table ORDER_ITEMS contains columns ORDER_ID, UNIT_PRICE and QUANTITY, of data type NUMBER.
Examine these SQL statements:
Statement 1:
SELECT MAX(unit_price * quantity) “Maximum Order”
FROM order_items;
Statement 2:
SELECT MAX(unit_price * quantity) “Maximum Order”
FROM order_items
GROUP BY order_id;
Which two statements are true?

Statement 1 returns only one row of output.

Statement 2 returns only one row of output.

Both statements will return NULL if either UNIT_PRICE or QUANTITY contains NULL.

Both the statements give the same output.

Statement 2 may return multiple rows of output.

NEW QUESTION 87
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.)

The second ROLLBACK command does nothing

The second ROLLBACK command replays the delete

The first ROLLBACK command restores the 101 rows that were deleted, leaving the inserted row still to be committed

The second ROLLBACK command undoes the insert

The first ROLLBACK command restores the 101 rows that were deleted and commits the inserted row

NEW QUESTION 88
Which three statements are true about single-row functions? (Choose three.)

They can be used only in the WHERE clause of a SELECT statement

The argument can be a column name, variable, literal or an expression

The data type returned can be different from the data type of the argument

They can be nested to any level

They can accept only one argument

They return a single result row per table

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

undo

index

stored procedures

sequences

tables

clusters

NEW QUESTION 90
Your database instance was shut down normally and then started in NOMOUNT state. You then execute this command:
ALTER DATABASE MOUNT;
Which two actions are performed? (Choose two.)

The online redo logs are opened

The online data files are opened

The alert log records the execution details

The Oracle background processes are started

The initialization parameter file is read

The control file is read