Summer Certification Limited Time 70% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code = getmirror

Pass the Oracle Database 23ai 1z0-182 Questions and answers with ExamsMirror

Practice at least 50% of the questions to maximize your chances of passing.

Exam 1z0-182 Premium Access

View all detail and faqs for the 1z0-182 exam

Go to Exam

735 Students Passed

84% Average Score

94% Same Questions

Viewing page 2 out of 3 pages

Viewing questions 11-20 out of questions

Questions # 11:

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

Options:

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.

Questions # 12:

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

Options:

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

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

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

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

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

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

Questions # 13:

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

Options:

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.

Questions # 14:

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

Options:

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.

Questions # 15:

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:

It will be a dictionary-managed tablespace by default.

Additional data files may not be added.

AUTOEXTEND is possible for the datafile.

It will always have a 32K blocksize.

It must be bigger than the largest SMALLFILE tablespace.

Questions # 16:

Which two statements are true about the configuration and use of UNDO?

Options:

Active UNDO is always retained.

Unexpired UNDO is always retained.

UNDO_RETENTION specifies for how long Oracle attempts to keep expired and unconsumed UNDO.

UNDO_RETENTION specifies how long all types of UNDO are retained.

UNDO_RETENTION specifies for how long Oracle attempts to keep unexpired UNDO.

Questions # 17:

Which two actions can you perform using DBCA for an existing database?

Options:

Change the character set.

Create an additional listener.

Change the server mode from dedicated to shared, and vice versa.

Create nonstandard block size tablespaces.

Create a template that can be used to clone the database.

Questions # 18:

Which two tasks can be performed in the NOMOUNT state?

Options:

Renaming data files.

Enabling online redo log archiving.

Creating a database.

Re-creating control files.

Full database recovery.

Questions # 19:

Which two statements are true about the DUAL table?

Options:

It can be accessed by any user who has the SELECT privilege in any schema.

It consists of a single row and single column of VARCHAR2 data type.

It can display multiple rows but only a single column.

It can be accessed only by the SYS user.

It can display multiple rows and columns.

It can be used to display only constants or pseudo columns.

Questions # 20:

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?