Oracle 1z0-182 Exam Questions Free Practice Test

Viewing page 1 out of 3 pages

Viewing questions 1-10 out of questions

Questions # 1:

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.

Expert Solution

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.", , ]

Questions # 2:

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:

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

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

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

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

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

Expert Solution

Questions # 3:

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.

Expert Solution

Questions # 4:

Examine this command: ALTER DATABASE MOVE DATAFILE '/u01/sales01.dbf' TO '/u02/sales02.dbf'; Which two statements are true?

Options:

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.

Expert Solution

Answer

A, E

Questions # 5:

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.

Expert Solution

Questions # 6:

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

Expert Solution

Questions # 7:

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

Options:

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.

Expert Solution

Questions # 8:

You are going to perform a hot remote clone of PDB1 from CDB1 as TESTPDB in CDB2. Which of the following is a necessary prerequisite for the hot remote clone?

Options:

PDB1 must be taken offline before the cloning process begins.

Both CDBs need to be in local undo mode.

PDB1 must be in read-only mode.

TESTPDB must be in read-only mode after the cloning process is complete.

Expert Solution

Questions # 9:

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?

Options:

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.

Expert Solution

Questions # 10:

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.

Expert Solution

Viewing page 1 out of 3 pages

Viewing questions 1-10 out of questions

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