1Z1-182 Exam Dumps Pass with Updated 2026 Certified Exam Questions [Q17-Q31]

Rate this post

1Z1-182 Exam Dumps Pass with Updated 2026 Certified Exam Questions

1Z1-182 Exam Questions – Real & Updated Questions PDF

NEW QUESTION 17
Which two account management capabilities can be configured using Oracle profiles?

The maximum number of sessions permitted for a user before the password must be changed.

The maximum amount of CPU time allowed for a user’s sessions before their account is locked.

The number of days for which an account may be logged in to one or more sessions before it is locked.

The ability to prevent a password from ever being reused.

The number of days for which an account may be inactive before it is locked.

NEW QUESTION 18
Which two statements are true about Fine-Grained Auditing (FGA)?

FGA policies by default can be created by a schema owner on an object in their schema.

FGA policies can only be created by a user with SYSDBA privilege.

FGA policies can be created by a user having the AUDIT_ADMIN privilege.

FGA policies can be created by a user having granted the CREATE_FGA_POLICY role.

FGA policies can be created by a user having EXECUTE privilege on the DBMS_FGA package.

NEW QUESTION 19
What is the result of the following command? ALTER PLUGGABLE DATABASE PDB1 DISCARD STATE;

It is unnecessary if the PDB is in the process of being upgraded.

PDB1 is reverted to its default properties, which includes not to automatically open after a CDB restart.

PDB1 is reverted to its default properties, which includes automatic opening after a CDB restart.

It should be used whenever PDB1 open mode needs to be changed.

NEW QUESTION 20
One of your database instances was shut down normally and then started in NOMOUNT state. You then executed this command: ALTER DATABASE MOUNT; Which two of these actions are performed?

Online data files are opened.

Online redo logs are opened.

The initialization parameter file is read.

Oracle shared memory structures are allocated.

The alert log has instance startup details written to it.

Control files are read.

NEW QUESTION 21
Which three actions are ways to apply the principle of least privilege?

Enabling Unified Auditing.

Revoking execute privilege on UTL_SMTP, UTL_TCP, UTL_HTTP, and UTL_FILE from the roles/users (assuming typo for duplicate option).

Using Access Control Lists (ACLs).

Setting the O7_DICTIONARY_ACCESSIBILITY parameter to TRUE.

Setting the REMOTE_OS_AUTHENT parameter to TRUE.

NEW QUESTION 22
Which three are benefits of using temp UNDO when performing DML on global temporary tables?

It permits DML on global temporary tables even if the database is opened read-only.

It reduces the amount of UNDO stored in the UNDO tablespace.

It reduces I/Os to the SYSTEM tablespace.

It reduces the amount of redo generated.

It reduces I/Os to the SYSAUX tablespace.

NEW QUESTION 23
Which of the following is true about the status of a PDB that has been unplugged from a CDB?

The STATUS column in CDB_PDBS of the unplugged PDB will be UNPLUGGED.

The STATUS column in CDB_PDBS of the unplugged PDB will be UNAVAILABLE.

The STATUS column in CDB_PDBS of the unplugged PDB will be REMOVED.

The STATUS column in CDB_PDBS of the unplugged PDB will be DISABLED.

NEW QUESTION 24
You want to view the initialization parameter settings for only a specific PDB. Which of the following statements is true?

From the PDB, execute SELECT db_uniq_name, pdb_uid, name, value$ FROM pdb_spfile$;

From the CDB root, execute SELECT NAME, VALUE, ISPDB_MODIFIABLE FROM v$parameter;

From the CDB root, execute SELECT db_uniq_name, pdb_uid, name, value$ FROM pdb_spfiles;

From the PDB, execute SELECT NAME, VALUE, ISPDB_MODIFIABLE FROM v$parameter;

NEW QUESTION 25
Which three statements are true about using SQL*Plus?

It can run scripts passed to it by a shell script.

It can run Recovery Manager (RMAN) commands.

It must be downloaded from the Oracle Technology Network (OTN).

It has both command-line and graphical user interfaces (GUI).

It can run scripts entered at the SQL prompt.

It has its own commands that are separate from any SQL statements.

NEW QUESTION 26
Examine this command: ALTER DATABASE MOVE DATAFILE ‘/u01/sales01.dbf’ TO ‘/u02/sales02.dbf’; Which two statements are true?

DML may be performed on tables with one or more extents in this data file during the execution of this command.

It overwrites any existing file with the name sales02.dbf in /u02 by default.

The “TO” clause containing the new file name must be specified even if Oracle Managed Files (OMF) is used.

Compressed objects in sales01.dbf will be uncompressed in sales02.dbf after the move.

Tables with one or more extents in this data file may be queried during the execution of this command.

NEW QUESTION 27
Which two statements describe why Database Auditing is a security requirement?

To monitor suspicious activity.

To alert DBAs about system issues.

To protect against data theft by a non-authorized user.

To protect against data corruption.

To monitor proper usage of the system and data by privileged users.

NEW QUESTION 28
How do you validate that the database was migrated to Unified Auditing?

By querying V$OPTION for parameter Unified Auditing.

By using the LSINVENTORY Command to query the Oracle Database Software Library.

By querying the DBA_UNIFIED_AUDIT_OPTION view.

By executing DBMS_AUDIT_MGMT PL/SQL package in Verify mode.

NEW QUESTION 29
Which three statements are true about UNDO and REDO?

REDO is used for read consistency.

UNDO is used for some flashback operations.

UNDO is used for read consistency.

Both REDO and UNDO can be multiplexed.

REDO is used for ROLLBACK.

REDO is used for instance recovery.

NEW QUESTION 30
What are the three components of Oracle Database Automatic Maintenance Tasks?

A diagnostic system that collects database error logs and details about database failures that can be found to diagnose complete file.

Oracle Database Resource Manager, which enables you to manage and configure system resources used by the Automatic Maintenance Tasks.

The maintenance windows managed by Oracle Database Scheduler, which are predefined time intervals permitting scheduled tasks.

A packaging system that allows you to combine all error and failure logs to share with Oracle Support.

A database alert log that stores details about major database operations and errors, which is used to manage cluster performance.

A set of tasks that are started automatically at regular intervals to perform maintenance operations on the database.

NEW QUESTION 31
You must create a tablespace of nonstandard block size in a new file system and plan to use this command: CREATE TABLESPACE ns_tbs DATAFILE ‘/u02/oracle/data/nstbs_f01.dbf’ SIZE 100G BLOCKSIZE 32K; The standard block size is 8K, but other nonstandard block sizes will also be used. Which two are requirements for this command to succeed?

DB_32K_CACHE_SIZE must be less than DB_CACHE_SIZE.

DB_32K_CACHE_SIZE must be set to a value that can be accommodated in the SGA.

The operating system must use a 32K block size.

DB_32K_CACHE_SIZE should be set to a value greater than DB_CACHE_SIZE.

The /u02 file system must have at least 100G space for the datafile.

Oracle 1Z1-182 Exam Syllabus Topics:

Topic	Details
Topic 1	Managing Undo: This domain measures the skills of Database Administrators in using undo data effectively. It compares undo data with redo data and explains temporary undo usage for efficient transaction management.
Topic 2	Employ Oracle-Supplied Database Tools: This section evaluates the abilities of Database Engineers and Support Specialists in identifying and using Oracle-supplied tools for managing databases. It focuses on leveraging tools to monitor, troubleshoot, and optimize database performance effectively.
Topic 3	Introduction to Performance: This section evaluates the expertise of Performance Analysts in summarizing Oracle database performance management techniques. It includes measuring database performance using SQL execution plans, directives, and advisors to ensure optimal system efficiency.
Topic 4	Introduction to Auditing: This domain tests the abilities of Compliance Specialists in implementing database auditing practices. It includes creating, modifying, and maintaining auditing policies while applying value-based auditing techniques like Fine-Grained Auditing (FGA).
Topic 5	Managing Users, Roles, and Privileges: This domain evaluates the expertise of Security Administrators in implementing user security measures. It focuses on creating and managing users, roles, and privileges to ensure secure access to Oracle databases.
Topic 6	Configuring Oracle Net Services: This section measures the skills of Network Administrators and Database Administrators in configuring Oracle Net Services. It includes identifying administration components, describing connection methods, and ensuring seamless communication between clients and databases.