Weekend Sale Limited Time 70% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: cramtick70

1z0-182 Oracle Database 23ai Administration Associate Questions and Answers

Questions 4

Which two statements are true about views used for viewing tablespace and datafile information?

Options:

A.

Tablespace free space can be viewed in V$TABLESPACE.

B.

V$TABLESPACE displays information about tablespaces contained in the data dictionary.

C.

A datafile can be renamed when the database is in MOUNT state and the new file name is displayed when querying DBA_DATA_FILES after the database is opened.

D.

Tablespace free space can be viewed in DBA_TABLESPACES.

E.

V$TABLESPACE displays information that is contained in the control file about tablespaces.

Buy Now
Questions 5

Which advisor is used to detect missing or stale object statistics?

Options:

A.

SQL Tuning Advisor

B.

SQL Statistics Advisor

C.

SQL Performance Analyzer

D.

SQL Access Advisor

Buy Now
Questions 6

Which statement regarding PDBs (Pluggable Databases) is correct?

Options:

A.

You can drop a PDB as long as it is not the PDB seed.

B.

You cannot drop a source PDB of a refreshable PDB.

C.

You can drop an application root along with the associated PDBs.

D.

When the relocation of a PDB is finished, the source PDB must be dropped.

Buy Now
Questions 7

You execute the SHUTDOWN ABORT command. Which two statements are true?

Options:

A.

A checkpoint is written.

B.

Subsequent instance startup performs media recovery.

C.

Subsequent instance startup performs instance recovery.

D.

Data files are closed normally.

E.

Uncommitted transactions are not rolled back by the shutdown.

Buy Now
Questions 8

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

Options:

A.

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

B.

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

C.

It reduces I/Os to the SYSTEM tablespace.

D.

It reduces the amount of redo generated.

E.

It reduces I/Os to the SYSAUX tablespace.

Buy Now
Questions 9

Which three statements are true about the Oracle Database server during and immediately after SHUTDOWN TRANSACTIONAL?

Options:

A.

Instance recovery occurs automatically during the shutdown.

B.

Uncommitted transactions are allowed to continue to the next ROLLBACK.

C.

New connection requests made to the database instance are refused.

D.

Sessions remain connected even if they are not running a transaction.

E.

Uncommitted transactions are allowed to continue to the next COMMIT.

Buy Now
Questions 10

Which three statements are true about Automatic Diagnostic Repository (ADR)?

Options:

A.

It is a file-based repository held outside any database.

B.

It is only used for Oracle database diagnostic information.

C.

It is held inside an Oracle database schema.

D.

It can be used for the problem diagnosis of a database when that database’s instance is down.

E.

The ADR base is specified in the DIAGNOSTIC_DEST database parameter.

Buy Now
Questions 11

You execute this command: [oracle@host01 ~]$ expdp system/oracle FULL=Y DUMPFILE=exp_db_full.dmp PARALLEL=4 LOGFILE=exp_db_full.log JOB_NAME=exp_db_full. 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?

Options:

A.

It continues to run in the background.

B.

You cannot monitor it.

C.

You can reattach to it and monitor it.

D.

It terminates.

Buy Now
Questions 12

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

Options:

A.

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

B.

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

C.

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

D.

The ability to prevent a password from ever being reused.

E.

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

Buy Now
Questions 13

Which two Oracle database space management features require the use of locally managed tablespaces?

Options:

A.

Automatic data file extension (AUTOEXTEND).

B.

Free space management with bitmaps.

C.

Oracle Managed Files (OMF).

D.

Server-generated tablespace space alerts.

E.

Online segment shrink.

Buy Now
Questions 14

You execute this command: CREATE BIGFILE TABLESPACE big_tbs DATAFILE '/u01/oracle/data/big_f1.dbf' SIZE 20G; Sufficient storage is available in filesystem /u01. Which two statements are true about the BIG_TBS tablespace?

Options:

A.

It will be a dictionary-managed tablespace by default.

B.

Additional data files may not be added.

C.

AUTOEXTEND is possible for the datafile.

D.

It will always have a 32K blocksize.

E.

It must be bigger than the largest SMALLFILE tablespace.

Buy Now
Questions 15

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

Options:

A.

Enabling Unified Auditing.

B.

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

C.

Using Access Control Lists (ACLs).

D.

Setting the O7_DICTIONARY_ACCESSIBILITY parameter to TRUE.

E.

Setting the REMOTE_OS_AUTHENT parameter to TRUE.

Buy Now
Questions 16

Which three statements are true about dynamic performance views?

Options:

A.

Read consistency is not guaranteed.

B.

V$FIXED_TABLE can be queried to display the names of all dynamic performance views.

C.

Data displayed by querying dynamic performance views is derived from metadata in the data dictionary.

D.

They are owned by the SYSTEM user.

E.

They can be queried only when the database is open.

Buy Now
Questions 17

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

Options:

A.

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

B.

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

C.

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

D.

REMOTE_LOGIN_PASSWORDFILE must be set to EXCLUSIVE to permit password changes for system-privileged administrative users.

E.

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

Buy Now
Questions 18

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?

Options:

A.

DB_32K_CACHE_SIZE must be less than DB_CACHE_SIZE.

B.

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

C.

The operating system must use a 32K block size.

D.

DB_32K_CACHE_SIZE should be set to a value greater than DB_CACHE_SIZE.

E.

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

Buy Now
Questions 19

Which three statements are true about Oracle Managed Files (OMF)?

Options:

A.

If DB_RECOVERY_FILE_DEST is specified but DB_CREATE_ONLINE_LOG_DEST_n is not, the redo logs and control files are placed in DB_RECOVERY_FILE_DEST by default.

B.

If only DB_CREATE_FILE_DEST is specified, only data files and temp files are Oracle managed.

C.

If DB_CREATE_ONLINE_LOG_DEST_1 is specified but DB_CREATE_FILE_DEST is not, new data files and temp files are stored in DB_CREATE_ONLINE_LOG_DEST_1 by default.

D.

If DB_CREATE_FILE_DEST is specified but DB_CREATE_ONLINE_LOG_DEST_n is not, new redo logs and control files are stored in DB_CREATE_FILE_DEST by default.

E.

If only DB_CREATE_ONLINE_LOG_DEST_1 is specified, only redo logs and control files are Oracle Managed.

F.

If DB_RECOVERY_FILE_DEST is specified, at least two different locations must be specified for DB_CREATE_ONLINE_LOG_DEST_n.

Buy Now
Questions 20

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

Options:

A.

By querying V$OPTION for parameter Unified Auditing.

B.

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

C.

By querying the DBA_UNIFIED_AUDIT_OPTION view.

D.

By executing DBMS_AUDIT_MGMT PL/SQL package in Verify mode.

Buy Now
Questions 21

Which three statements are true about UNDO and REDO?

Options:

A.

REDO is used for read consistency.

B.

UNDO is used for some flashback operations.

C.

UNDO is used for read consistency.

D.

Both REDO and UNDO can be multiplexed.

E.

REDO is used for ROLLBACK.

F.

REDO is used for instance recovery.

Buy Now
Questions 22

Which two statements are true about the Automatic Diagnostic Repository (ADR)?

Options:

A.

It is held inside an Oracle database schema.

B.

The ADR base defaults to $ORACLE_HOME/rdbms/admin if neither DIAGNOSTIC_DEST nor ORACLE_BASE is set.

C.

It supports diagnostics for Automatic Storage Management (ASM).

D.

It supports diagnostics for Oracle Clusterware.

E.

The ADR base defaults to $ORACLE_HOME/dbs if the DIAGNOSTIC_DEST parameter and the ORACLE_BASE environment variable are not set.

Buy Now
Questions 23

In one of your databases, the user HR has the password HRMGR. You want to connect to a database instance whose listener listens on port 1531 by using this statement: CONNECT HR/HRMGR@orcl. No name server is used. Which statement is true about ORCL?

Options:

A.

It must be the name of the database to whose instance HR wishes to connect.

B.

It must resolve to a valid connect descriptor in the client's tnsnames.ora file.

C.

It must be the name of the server running the database to whose instance HR wishes to connect.

D.

It must resolve to a valid connect descriptor in the server's tnsnames.ora file.

E.

It must be the value of the SERVICE_NAMES parameter on the client side.

Buy Now
Questions 24

Which three statements are true about resumable space allocation in Oracle databases?

Options:

A.

Resumable space allocation may be enabled for some sessions and not others.

B.

A user’s session may be suspended and resumed multiple times.

C.

Resumable space allocation is only possible with locally managed tablespaces.

D.

All sessions must have the same timeout value when waiting for resumable space allocations.

E.

A user’s session may be suspended even if the user has the UNLIMITED TABLESPACE system privilege.

F.

The AFTER SUSPEND event trigger can itself be suspended due to space conditions.

Buy Now
Questions 25

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

Options:

A.

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

B.

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

C.

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

D.

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

E.

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

F.

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

Buy Now
Questions 26

Which statement is true about database links?

Options:

A.

A public database link can be created only by SYS.

B.

A database link can be created only between two Oracle databases.

C.

A database link created in a database allows a connection from that database's instance to the target database's instance, but not vice versa.

D.

A public database link can be used by a user connected to the local database instance to connect to any schema in the remote database instance.

E.

Private database link creation requires the same user to exist in both the local and the remote databases.

Buy Now
Questions 27

Which three statements are true about the tools used to configure Oracle Net Services?

Options:

A.

Oracle Net Manager can be used to centrally configure listeners on any database server target.

B.

The Oracle Net Configuration Assistant is only used when running the Oracle installer.

C.

Enterprise Manager Cloud Control can be used to centrally configure net service names for any database server target.

D.

Enterprise Manager Cloud Control can be used to centrally configure listeners on any managed database server.

E.

The lsnrctl utility requires a listener.ora file to exist before it is started.

F.

Oracle Net Manager can be used to locally configure naming methods on a database server.

Buy Now
Questions 28

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?

Options:

A.

Free space is managed using freelists.

B.

It uses the database default block size.

C.

It must be smaller than the smallest BIGFILE tablespace.

D.

It is a locally managed tablespace.

E.

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

Buy Now
Exam Code: 1z0-182
Exam Name: Oracle Database 23ai Administration Associate
Last Update: Jul 19, 2025
Questions: 94
1z0-182 pdf

1z0-182 PDF

$25.5  $84.99
1z0-182 Engine

1z0-182 Testing Engine

$30  $99.99
1z0-182 PDF + Engine

1z0-182 PDF + Testing Engine

$40.5  $134.99