Unlock your Full 1z0-182 Oracle Stable Exam

Oracle Database 23ai Administration Associate Questions and Answers

Question 1

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.

Question 2

Which three relationships between instances and Oracle databases are possible without using Multi-tenant?

Options:

One instance on one server mounting multiple databases.

Two or more instances on separate servers all mounting and opening the same database.

One instance on one server mounting and opening multiple databases.

One instance on one server that has no database mounted.

One instance on one server mounting and opening one database.

Question 3

Which two statements are true about database instances and Real Application Clusters (RAC)?

Options:

A RAC database must have two or more instances.

A RAC database can have one instance.

A RAC database must have three or more instances.

A RAC database can have instances on separate servers.

Two RAC databases can share their instances.

Question 4

Your database instance is started with an SPFILE. A PFILE is also available. You execute this command: ALTER SYSTEM SET DB_CACHE_SIZE=100K; Where does the value change?

Options:

In the SPFILE and PFILE

In the SPFILE and memory

Only in memory

In the SPFILE, PFILE, and memory

Only in the SPFILE

Question 5

Which two statements are true about trace files produced by the Oracle Database server?

Options:

All trace files contain error information that requires contacting Oracle Support.

They can be written by server processes to a file system.

They can be written by background processes to a file system.

Trace file names are based on the database name concatenated with a sequential number.

They can be written by server processes to the Fast Recovery Area (FRA).

Question 6

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.

Question 7

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.

Question 8

In one of your databases, you create a user, HR, and then execute this command: GRANT CREATE SESSION TO hr WITH ADMIN OPTION; Which three actions can HR perform?

Options:

Execute DML statements in the HR schema.

Revoke the CREATE SESSION privilege from other users.

Grant the CREATE SESSION privilege with ADMIN OPTION to other users.

Revoke the CREATE SESSION privilege from user HR.

Execute DDL statements in the HR schema.

Question 9

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

Options:

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.

Question 10

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

Options:

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.

Question 11

Which three tasks are performed by background processes in an Oracle database instance?

Options:

Creating dedicated server connections.

Registering services with Oracle Net listeners.

Writing redo to log files.

Writing dirty database block images from the buffer cache.

Reading database blocks into the buffer cache.

Question 12

Which statement is true about the PDB_DBA role granted to a local user during the creation of a new PDB?

Options:

The role has the privileges to administer the PDB.

The role has the privileges to perform DDL operations on all local schema objects.

The role has the privileges to create and manage users within the PDB.

No privileges are provided with the PDB_DBA role.

Question 13

Which three statements are true about roles?

Options:

Roles must be password protected.

Roles may be granted to other roles.

The SET ROLE statement can enable one or more roles for a session.

Object privileges may not be granted to roles.

All roles granted to a user are set on default when the user logs in.

The SET ROLE statement can disable one or more roles for a session.

Answer:

B, C, F

Explanation:

Roles in Oracle manage privileges efficiently. Let’s dive into each option:

A. Roles must be password protected.

Explanation:False. Roles can be password-protected (e.g., CREATE ROLE mgr IDENTIFIED BY secret), but it’s optional. Non-protected roles (default) are enabled automatically if granted, requiring no password.

Mechanics:Password-protected roles need SET ROLE mgr IDENTIFIED BY secret, enhancing security for sensitive privileges.

B. Roles may be granted to other roles.

Explanation:True. Roles can form hierarchies (e.g., GRANT clerk TO mgr), allowing nested privilege management.

Mechanics:A user with mgr inherits clerk privileges indirectly. Revoking clerk from mgr cascades appropriately.

Practical Use:Simplifies complex privilege structures in large organizations.

C. The SET ROLE statement can enable one or more roles for a session.

Explanation:True. SET ROLE role1, role2; activates specified roles for the session, assuming they’re granted and not password-protected (or password is provided).

Mechanics:Enabled roles grant their privileges immediately within the session scope.

D. Object privileges may not be granted to roles.

Explanation:False. Object privileges (e.g., GRANT SELECT ON emp TO clerk) are a primary use of roles, making this statement incorrect.

Why Incorrect:Roles are designed for this purpose, contradicting the option.

E. All roles granted to a user are set on default when the user logs in.

Explanation:False. Only roles marked as DEFAULT ROLE (via ALTER USER ... DEFAULT ROLE role1) are enabled at login. Non-default roles require SET ROLE.

Mechanics:Check via SELECT * FROM DBA_ROLE_PRIVS WHERE DEFAULT_ROLE='YES'.

F. The SET ROLE statement can disable one or more roles for a session.

Explanation:True. SET ROLE NONE disables all roles, or SET ROLE role1 implicitly disables others not listed, providing granular control.

Practical Use:Useful for testing or restricting privileges temporarily.

[References:Oracle Database Security Guide 23ai, "Managing Roles"; Oracle Database SQL Language Reference 23ai, "SET ROLE.", , ]

Question 14

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.

Question 15

Examine this command: SQL> ALTER TABLE ORDERS SHRINK SPACE COMPACT; Which two statements are true?

Options:

Dependent indexes become UNUSABLE.

The SHRINK operation causes rows to be moved to empty space starting toward the end of the ORDERS segment.

Only queries are allowed on ORDERS while SHRINK is executing.

The high-water mark (HWM) of ORDERS is adjusted.

Queries and DML statements are allowed on ORDERS while the SHRINK is executing.

The SHRINK operation causes rows to be moved to empty space starting from the beginning of the ORDERS segment.

Question 16

Which four statements are true about the Oracle Server architecture?

Options:

A person or program can have more than one session with an instance by logging in with different users.

The buffer cache and the redo log buffer are held in the large pool.

A session represents the state of a user's login to an instance.

Each server process or background process has their own Program Global Area (PGA).

A connection represents the state of a user's login to an instance.

A person or program can have more than one session with an instance by logging in with the same user.

Question 17

Which two statements are true concerning logical and physical database structures?

Options:

A segment can span multiple data files in some tablespaces.

Segments can span multiple tablespaces.

A segment might have only one extent.

All tablespaces may have one or more data files.

A segment’s blocks can be of different sizes.

Answer:

A, C

Explanation:

Logical structures (e.g., segments, extents) map to physical structures (e.g., data files, blocks). Let’s dissect each option:

A. A segment can span multiple data files in some tablespaces.

Explanation:True. A segment (e.g., a table or index) is a logical entity stored in a tablespace. In a smallfile tablespace (default in Oracle), a segment’s extents can span multiple data files if the tablespace has multiple files and space allocation requires it. This is common in large tables or when autoextend adds new files.

Mechanics:Oracle allocates extents across available data files in a round-robin fashion (with ASSM) or as needed, ensuring the segment’s data is distributed. This doesn’t apply to bigfile tablespaces, which use a single data file.

Example:A 10GB table in a tablespace with two 5GB data files will span both.

B. Segments can span multiple tablespaces.

Explanation:False. A segment is confined to a single tablespace. Oracle enforces this to maintain logical separation (e.g., a table’s data stays in its assigned tablespace). Partitioned tables can have partitions in different tablespaces, but each partition is a separate segment.

Why Not:The segment header and extent map reside in one tablespace, preventing cross-tablespace spanning for a single segment.

C. A segment might have only one extent.

Explanation:True. A segment starts with one extent upon creation (e.g., a small table or index). If no further growth occurs, it remains a single-extent segment. This is common with small objects or when INITIAL extent size suffices.

Mechanics:In locally managed tablespaces (default), the initial extent is allocated based on INITIAL or tablespace defaults (e.g., 64KB), and additional extents are added only as needed.

D. All tablespaces may have one or more data files.

Explanation:False. Bigfile tablespaces are restricted to one data file (up to 128TB). Smallfile tablespaces (traditional) can have multiple data files (up to 1022), but the “all” phrasing makes this false due to bigfile exceptions.

Clarification:The question’s intent may assume smallfile tablespaces, but Oracle 23ai supports both types.

E. A segment’s blocks can be of different sizes.

Explanation:False. All blocks in a segment use the tablespace’s block size (e.g., 8KB). While a database can have tablespaces with different block sizes (e.g., 8KB, 32KB), a single segment’s blocks are uniform, as it resides in one tablespace.

[References:Oracle Database Concepts 23ai, "Logical Storage Structures"; Oracle Database Administrator’s Guide 23ai, "Managing Tablespaces.", , ]

Question 18

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:

It continues to run in the background.

You cannot monitor it.

You can reattach to it and monitor it.

It terminates.

Question 19

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

Options:

SQL Tuning Advisor

SQL Statistics Advisor

SQL Performance Analyzer

SQL Access Advisor

Question 20

What are Oracle Database Metrics?

Options:

Oracle Database Metrics monitor performance using thresholds to generate alerts.

Oracle Database Metrics are part of the Oracle Database Notification system to email information about major database events.

Oracle Database Metrics are a set of measured statistics per unit of time (per second), transaction, or sessions that are used to evaluate performance.

Oracle Database Metrics are part of Oracle Enterprise Manager Cloud Control's Notification system used to email alerts.

Oracle Database Metrics are a set of statistics built in Oracle Enterprise Manager Cloud Control and used for automation.

Question 21

Which three functions are performed by dispatchers in a shared server configuration?

Options:

Sending shared server session responses back to requesters on the appropriate connection.

Writing inbound requests to the common request queue from all shared server connections.

Broadcasting shared server session responses back to requesters on all connections.

Receiving inbound requests from processes using shared server connections.

Sending each connection input request to the appropriate shared server input queue.

Checking for outbound shared server responses on the common outbound response queue.

Question 22

You want to apply the principle of Least Privilege in all your live databases. One of your requirements is to revoke unnecessary privileges from all users who have them using Privilege Analysis. Which three types of analyses can be done using the DBMS_PRIVILEGE_CAPTURE package?

Options:

Analysis of privileges that a user has on their own schema objects that they did not use.

Analysis of all privileges used by all users including administrative users in the database.

Analysis of all privileges used by all users but excluding administrative users in the database.

Analysis of privileges granted directly to a role that are then used by a user who has been granted that role.

Analysis of privileges granted indirectly to a role that are then used by a user who has beengranted that role.

Analysis of privileges that a user has on their own schema objects that they did use.

Question 23

Which two statements are true about advanced connection options supported by Oracle Net for connection to Oracle?

Options:

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

Source Routing requires the use of encrypted connections.

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

Load Balancing requires the use of a name server.

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

Question 24

Which resource plan is used to manage the resources for the predefined maintenance window?

Options:

By default, all predefined maintenance windows use the DEFAULT_MAINTENANCE_PLANresource plan, and automated maintenance tasks run under subplan called ORA$AUTOTASK.

The resources used by the predefined maintenance window can only be adjusted if you create a new resource plan in Resource Manager ...

The predefined maintenance window starts automatically with 20% of the system resources ...

The SYS_GROUP consumer resource group policies define the resources assigned ...

Question 25

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

Options:

Instance recovery occurs automatically during the shutdown.

Uncommitted transactions are allowed to continue to the next ROLLBACK.

New connection requests made to the database instance are refused.

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

Uncommitted transactions are allowed to continue to the next COMMIT.

Question 26

Which three statements are true about a dedicated server configuration?

Options:

The DBA configures the maximum number of dedicated server processes that can share the samedispatcher process.

A dedicated server process may be reused by a new session after the session using that process terminates.

A dedicated server process communicates directly with a client or middle-tier process once the session is established.

Each dedicated server process has its own dispatcher process.

A dedicated server process can be spawned by the listener when using local clients.

A dedicated server process can be spawned without a listener when using local clients.

Question 27

Which three statements are true about Deferred Segment Creation in Oracle databases?

Options:

It is supported for Index Organized Tables (IOTs) contained in locally managed tablespaces.

It is supported for SYS-owned tables contained in locally managed tablespaces.

It is the default behavior for tables and indexes.

Indexes inherit the DEFERRED or IMMEDIATE segment creation attribute from their parent table.

Sessions may dynamically switch back and forth from DEFERRED to IMMEDIATE segment creation.

Question 28

You want to apply the principle of least privilege in all your live databases. One of your requirements is to revoke unnecessary privileges from all users who have them using Privilege Analysis. Which two types of analyses can be done using the DBMS_PRIVILEGE_CAPTURE package?

Options:

Analysis of privileges that a user has on other schemas’ objects.

Analysis of all privileges used by the SYS user.

Analysis of privileges granted indirectly to a role that are then used by a user who has been granted that role.

Analysis of privileges granted directly to a role that are then used by a user who has been granted that role.

Analysis of privileges that a user has on their own schema objects.

Load More 1z0-182 Questions

Special Summer Sale Limited Time Flat 70% Discount offer - Ends in 0d 00h 00m 00s - Coupon code: 70spcl

Activedumpsnet Logo

Activedumpsnet Navigation

Activedumpsnet Slider

Oracle 1z0-182 Oracle Database 23ai Administration Associate Exam Practice Test

Oracle Database 23ai Administration Associate Questions and Answers

Options:

Answer:

Explanation:

Options:

Answer:

Explanation:

Options:

Answer:

Explanation:

Options:

Answer:

Explanation:

Options:

Answer:

Explanation:

Options:

Answer:

Explanation:

Options:

Answer:

Explanation:

Options:

Answer:

Explanation:

Options:

Answer:

Explanation:

Options:

Answer:

Explanation:

Options:

Answer:

Explanation:

Options:

Answer:

Explanation:

Options:

Answer:

Explanation:

Options:

Answer:

Explanation:

Options:

Answer:

Explanation:

Options:

Answer:

Explanation:

Options:

Answer:

Explanation:

Options:

Answer:

Explanation:

Options:

Answer:

Explanation:

Options:

Answer:

Explanation:

Options:

Answer:

Explanation:

Options:

Answer:

Explanation:

Options:

Answer:

Explanation:

Options:

Answer:

Explanation:

Options:

Answer: