Oracle Database 23ai 1Z1-182最新問題集で2025年11月25日
2025年最新の問題をマスター！Oracle Database 23ai合格目指そう！1Z1-182リアル試験問題集！
質問 # 53
Which two statements are true about the configuration and use of UNDO?
- A. Unexpired UNDO is always retained.
- B. UNDO_RETENTION specifies for how long Oracle attempts to keep expired and unconsumed UNDO.
- C. Active UNDO is always retained.
- D. UNDO_RETENTION specifies how long all types of UNDO are retained.
- E. UNDO_RETENTION specifies for how long Oracle attempts to keep unexpired UNDO.
正解：C、E
質問 # 54
Examine this command: ALTER DATABASE MOVE DATAFILE '/u01/sales01.dbf' TO '/u02/sales02.dbf'; Which two statements are true?
- A. DML may be performed on tables with one or more extents in this data file during the execution of this command.
- B. The "TO" clause containing the new file name must be specified even if Oracle Managed Files (OMF) is used.
- C. Tables with one or more extents in this data file may be queried during the execution of this command.
- D. Compressed objects in sales01.dbf will be uncompressed in sales02.dbf after the move.
- E. It overwrites any existing file with the name sales02.dbf in /u02 by default.
正解：A、C
解説：
The ALTER DATABASE MOVE DATAFILE command relocates a data file to a new location while the database remains online, introduced in Oracle 12c and enhanced in subsequent releases like 23ai. Let's evaluate each option:
A . DML may be performed on tables with one or more extents in this data file during the execution of this command.True. The move operation is online by default in Oracle 23ai, allowing DML (INSERT, UPDATE, DELETE) operations on tables within the data file being moved. The database ensures consistency using redo and undo mechanisms.
B . It overwrites any existing file with the name sales02.dbf in /u02 by default.False. By default, the command does not overwrite an existing file unless the REUSE clause is specified (e.g., ALTER DATABASE MOVE DATAFILE ... REUSE). Without it, the command fails if the target file exists.
C . The "TO" clause containing the new file name must be specified even if Oracle Managed Files (OMF) is used.False. When OMF is enabled (via DB_CREATE_FILE_DEST), the TO clause is optional. If omitted, Oracle automatically generates a file name and places it in the OMF destination.
D . Compressed objects in sales01.dbf will be uncompressed in sales02.dbf after the move.False. The move operation is a physical relocation of the data file; it does not alter the logical structure or compression state of objects within it. Compressed data remains compressed.
E . Tables with one or more extents in this data file may be queried during the execution of this command.True. The online nature of the move allows queries (SELECT statements) to proceed without interruption, leveraging Oracle's multi-version consistency model.
質問 # 55
Which two statements are true about database instances and Real Application Clusters (RAC)?
- A. A RAC database can have one instance.
- B. A RAC database can have instances on separate servers.
- C. Two RAC databases can share their instances.
- D. A RAC database must have three or more instances.
- E. A RAC database must have two or more instances.
正解：A、B
解説：
A .False. RAC can run with one instance (degraded mode).
B .True. Possible, though not typical for RAC.
C .False. No minimum of three.
D .True. RAC instances run on separate nodes.
E .False. Instances are DB-specific in RAC.
質問 # 56
What services does the Automatic Workload Repository (AWR) provide for the database self-tuning functionality?
- A. Enables the creation of a Non-CDB from a CDB.
- B. Creates a new PDB by plugging in a previously unplugged Non-CDB.
- C. Creates a new PDB with the original SID of the Non-CDB.
- D. Simplifies the process of migrating Non-CDB databases to the cloud.
正解：D
解説：
A .False. AWR doesn't create PDBs.
B .True. AWR stats aid migration planning (e.g., performance baselines).
C .False. AWR doesn't convert CDB to Non-CDB.
D .False. SID management isn't AWR's role.
質問 # 57
Which two statements are true about the tools used to configure Oracle Net Services?
- A. Oracle Net Manager can be used to centrally configure listeners on any database server target.
- B. The lsnrctl utility requires a listener.ora file to exist before it is started.
- C. The Oracle Net Configuration Assistant is only used when running the Oracle installer.
- D. Enterprise Manager Cloud Control can be used to centrally configure net service names for any database server target.
- E. Oracle Net Manager can be used to locally configure naming methods on a database server.
正解：D、E
解説：
A .False. lsnrctl can start a default listener without listener.ora.
B .True. EMCC provides centralized Net Services configuration.
C .False. NetCA can run standalone, not just during installation.
D .True. Net Manager configures local naming (e.g., TNSNAMES.ORA).
E .False. Net Manager is local, not centralized like EMCC.
質問 # 58
Which three relationships between instances and Oracle databases are possible without using Multi-tenant?
- A. One instance on one server mounting and opening multiple databases.
- B. One instance on one server that has no database mounted.
- C. Two or more instances on separate servers all mounting and opening the same database.
- D. One instance on one server mounting multiple databases.
- E. One instance on one server mounting and opening one database.
正解：B、C、E
解説：
A .False. One instance can't mount multiple DBs without multitenant.
B .True. RAC allows multiple instances to share one DB.
C .False. Same as A; not possible without CDB.
D .True. An instance can start in NOMOUNT with no DB.
E .True. Standard single-instance configuration.
質問 # 59
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?
- A. Online redo logs are opened.
- B. Oracle shared memory structures are allocated.
- C. Online data files are opened.
- D. The alert log has instance startup details written to it.
- E. The initialization parameter file is read.
- F. Control files are read.
正解：D、F
解説：
A .False. Data files open in OPEN.
B .False. Redo logs open in OPEN.
C .False. PFILE/SPFILE is read at NOMOUNT.
D .False. SGA is allocated at NOMOUNT.
E .True. Alert log records mount event.
F .True. Control files are read in MOUNT.
質問 # 60
Which three statements are true about Oracle Managed Files (OMF)?
- A. If only DB_CREATE_FILE_DEST is specified, only data files and temp files are Oracle managed.
- B. 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.
- C. 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.
- D. If only DB_CREATE_ONLINE_LOG_DEST_1 is specified, only redo logs and control files are Oracle Managed.
- E. 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.
- F. If DB_RECOVERY_FILE_DEST is specified, at least two different locations must be specified for DB_CREATE_ONLINE_LOG_DEST_n.
正解：B、C、E
解説：
A .True. Without DB_CREATE_ONLINE_LOG_DEST_n, redo logs and control files default to DB_RECOVERY_FILE_DEST.
B .False. If only DB_CREATE_FILE_DEST is set, redo logs and control files also use it unless overridden.
C .True. DB_CREATE_ONLINE_LOG_DEST_1 becomes the default for data files and temp files if DB_CREATE_FILE_DEST is unset.
D .True. DB_CREATE_FILE_DEST serves as the default for all file types if no log-specific parameter is set.
E .False. Data files and temp files would also use DB_CREATE_ONLINE_LOG_DEST_1 if no other parameter is specified.
F .False. No such requirement exists; DB_RECOVERY_FILE_DEST operates independently.
質問 # 61
Which two statements are true about Fine-Grained Auditing (FGA)?
- A. FGA policies can only be created by a user with SYSDBA privilege.
- B. FGA policies can be created by a user having granted the CREATE_FGA_POLICY role.
- C. FGA policies by default can be created by a schema owner on an object in their schema.
- D. FGA policies can be created by a user having EXECUTE privilege on the DBMS_FGA package.
- E. FGA policies can be created by a user having the AUDIT_ADMIN privilege.
正解：D、E
解説：
A .False. Schema owners need EXECUTE on DBMS_FGA.
B .False. Not limited to SYSDBA.
C .True. AUDIT_ADMIN includes FGA creation rights.
D .False. No such role exists.
E .True. DBMS_FGA.ADD_POLICY requires this privilege.
質問 # 62
Which two SQL Plan Management Advisor tasks are part of Automatic Maintenance Tasks?
- A. The Automatic SQL Tuning Advisor tasks, which would examine the performance of high-load SQL statements and make recommendations for those statements.
- B. The Automatic Index Advisor task, which is used to create and maintain table indexes based on the DML load and operations.
- C. The Automatic SQL Plan Management Evolve Advisor task, which evolves plans that have recently been added as the SQL plan baseline for statements.
- D. The Automatic SQL Performance Analyzer task, which is used to provide details about impact of database changes to application SQL batch.
- E. The Automatic SQL Access Advisor task, which is used to manage an application SQL load.
正解：A、C
解説：
Automatic Maintenance Tasks (AMTs) in 23ai optimize database performance. Let's explore:
A .False. SQL Access Advisor exists but isn't an AMT; it's manual or invoked separately.
B .False. SQL Performance Analyzer assesses change impacts but isn't part of AMTs.
C .False. No "Automatic Index Advisor" exists as an AMT; Auto Index is a separate feature.
D .True. The SPM Evolve Advisor task (part of ORA$AUTOTASK) automatically evolves SQL plan baselines, testing and accepting new plans.
Mechanics:Runs in maintenance windows, managed by DBMS_SPM.
E .True. SQL Tuning Advisor (STA) runs automatically via AMTs, tuning high-load SQL.
Mechanics:Identifies candidates from AWR and suggests indexes, profiles, etc.
質問 # 63
What memory structure caches the data dictionary providing access to all database user processes?
- A. The Streams Pool
- B. The Java Pool
- C. The Shared Pool
- D. The Large Pool
正解：C
解説：
D .True. The Shared Pool caches data dictionary metadata (e.g., table definitions) in the Library Cache and Dictionary Cache, accessible to all processes. Others serve different purposes (e.g., Large Pool for backups).
質問 # 64
Which three Oracle database space management features will work with both Dictionary and Locally managed tablespaces?
- A. Automatic data file extension (AUTOEXTEND).
- B. Oracle Managed Files (OMF).
- C. Online index segment shrink.
- D. Capacity planning growth reports based on historical data in the Automatic Workload Repository (AWR).
- E. Online table segment shrink.
正解：A、B、D
解説：
Dictionary-managed tablespaces (DMTs) use the data dictionary for extent management, whilelocally managed tablespaces (LMTs) use bitmaps. Let's evaluate compatibility:
A . Capacity planning growth reports based on historical data in the Automatic Workload Repository (AWR).
True. AWR tracks space usage (e.g., DBA_HIST_TBSPC_SPACE_USAGE) regardless of tablespace type, enabling growth reports for both DMTs and LMTs.
Mechanics:MMON collects metrics like segment growth, stored in SYSAUX, accessible via EM or scripts.
Practical Use:Helps predict when to add data files, universal across management types.
B . Online table segment shrink.
False. ALTER TABLE ... SHRINK SPACE requires LMTs with Automatic Segment Space Management (ASSM), unavailable in DMTs, which lack bitmap-based free space tracking.
Why Incorrect:DMTs use freelists, incompatible with shrink operations.
C . Online index segment shrink.
False. Like tables, ALTER INDEX ... SHRINK SPACE requires LMTs with ASSM, not supported in DMTs.
Why Incorrect:Same limitation as B; DMTs can't compact online.
D . Oracle Managed Files (OMF).
True. OMF automates file naming and placement (via DB_CREATE_FILE_DEST) for both DMTs and LMTs, agnostic to extent management.
Mechanics:Example: CREATE TABLESPACE ts1; creates an OMF file in either type.
Edge Case:DMTs are rare in 23ai, but OMF still applies.
E . Automatic data file extension (AUTOEXTEND).
True. AUTOEXTEND ON allows data files to grow as needed, supported in both DMTs and LMTs since early versions.
Mechanics:ALTER DATABASE DATAFILE ... AUTOEXTEND ON NEXT 100M; works universally.
質問 # 65
Which three functions are performed by dispatchers in a shared server configuration?
- A. Sending shared server session responses back to requesters on the appropriate connection.
- B. Checking for outbound shared server responses on the common outbound response queue.
- C. Sending each connection input request to the appropriate shared server input queue.
- D. Receiving inbound requests from processes using shared server connections.
- E. Broadcasting shared server session responses back to requesters on all connections.
- F. Writing inbound requests to the common request queue from all shared server connections.
- G. True. Dispatchers monitor the response queue.
正解：A、B、D
解説：
A :True. Dispatchers return responses to clients.
B :False. Dispatchers manage queues, not write directly.
C :False. Responses are connection-specific, not broadcast.
D :True. Dispatchers receive client requests.
E :False. Queues are common, not per-connection.
質問 # 66
Which of the following statements is true about external tables?
- A. They describe data stored in the database.
- B. They are read/write tables.
- C. They describe how data is stored in the external source.
- D. They describe how the external table layer presents data to the server.
正解：D
解説：
A .False. External tables are read-only.
B .True. Defines how external data (e.g., CSV) is mapped to SQL.
C .False. Data is external, not in the DB.
D .False. Storage is external; Oracle doesn't define it.
質問 # 67
Which of the following ALTER SYSTEM statements can be run from within a pluggable database (PDB)?
- A. ALTER SYSTEM ENABLE / DISABLE RESTRICTED SESSION
- B. ALTER SYSTEM SWITCH LOGFILE
- C. ALTER SYSTEM FLUSH BUFFER_CACHE
- D. ALTER SYSTEM CHECKPOINT
正解：A、D
解説：
A .True. Local checkpoints are allowed in PDBs.
B .False. Buffer cache is CDB-level.
C .False. Log switching is CDB-level.
D .True. Restricted session can be toggled per PDB.
質問 # 68
Which two account management capabilities can be configured using Oracle profiles?
- A. The maximum amount of CPU time allowed for a user's sessions before their account is locked.
- B. The number of days for which an account may be inactive before it 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 maximum number of sessions permitted for a user before the password must be changed.
正解：B、D
解説：
A .False. Session limits don't tie to password changes.
B .False. CPU limits don't lock accounts.
C .False. No direct "logged-in days" parameter.
D .True. PASSWORD_REUSE_MAX=UNLIMITED prevents reuse.
E .True. PASSWORD_LOCK_TIME sets inactivity lockout.
質問 # 69
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?
- A. It must be bigger than the largest SMALLFILE tablespace.
- B. It will always have a 32K blocksize.
- C. Additional data files may not be added.
- D. AUTOEXTEND is possible for the datafile.
- E. It will be a dictionary-managed tablespace by default.
正解：C、D
解説：
A .False. LMT is default in 23ai.
B .True. Bigfile tablespaces have one data file only.
C .True. AUTOEXTEND works with bigfile data files.
D .False. Block size defaults to DB_BLOCK_SIZE (e.g., 8K).
E .False. No size comparison requirement.
質問 # 70
Which two statements are true concerning logical and physical database structures?
- A. A segment's blocks can be of different sizes.
- B. Segments can span multiple tablespaces.
- C. A segment might have only one extent.
- D. A segment's blocks can be of different sizes.
- E. A segment can span multiple data files in some tablespaces.
- F. All tablespaces may have one or more data files.
正解：C、E
解説：
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.
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.
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.
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.
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.
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.
質問 # 71
Which two Oracle database space management features require the use of locally managed tablespaces?
- A. Free space management with bitmaps.
- B. Online segment shrink.
- C. Automatic data file extension (AUTOEXTEND).
- D. Oracle Managed Files (OMF).
- E. Server-generated tablespace space alerts.
正解：A、B
解説：
A .False. Works with DMTs too.
B .True. LMTs use bitmaps, unlike DMT freelists.
C .False. OMF is independent of management type.
D .False. Alerts work with both.
E .True. Shrink requires LMTs with ASSM.
質問 # 72
Examine this command: SQL> ALTER TABLE ORDERS SHRINK SPACE COMPACT; Which two statements are true?
- A. The SHRINK operation causes rows to be moved to empty space starting from the beginning of the ORDERS segment.
- B. The high-water mark (HWM) of ORDERS is adjusted.
- C. The SHRINK operation causes rows to be moved to empty space starting toward the end of the ORDERS segment.
- D. Queries and DML statements are allowed on ORDERS while the SHRINK is executing.
- E. Only queries are allowed on ORDERS while SHRINK is executing.
- F. Dependent indexes become UNUSABLE.
正解：A、D
解説：
A . Dependent indexes become UNUSABLE.False. SHRINK SPACE COMPACT does not affect index usability; only SHRINK SPACE without COMPACT may require index maintenance if CASCADE is omitted.
B . ... starting toward the end of the ORDERS segment.False. Rows are compacted toward the beginning of the segment, not the end.
C . Only queries are allowed ...False. Both queries and DML are allowed during SHRINK SPACE COMPACT as it's an online operation.
D . The high-water mark (HWM) of ORDERS is adjusted.False. COMPACT moves rows but doesn't adjust the HWM; the full SHRINK SPACE command is needed for HWM adjustment.
E . Queries and DML statements are allowed ...True. This is an online operation in 23ai, allowing concurrent access.
F . ... starting from the beginning of the ORDERS segment.True. Rows are moved to fill free space from the segment's start.
質問 # 73
......
完全版は2025年最新の1Z1-182試験問題集テストガイドはトレーニング専門JPNTest：https://www.jpntest.com/shiken/1Z1-182-mondaishu
合格準備1Z1-182にはJPNTestが提供するあなたをOracle Database 23ai Administration Associate試験合格させます顕著練習問題：https://drive.google.com/open?id=1T0uiqM9_vW49eG0Z-7ImFqxzYxlfnGc1