2025年11月13日合格確定ガイド準備1Z1-182試験知能問題集 [Q10-Q32]

2025年11月13日合格確定ガイド準備1Z1-182試験知能問題集

無料最新Oracle Database 23ai 1Z1-182リアル試験問題と回答2025年更新

質問 # 10
Which two tasks can you perform using DBCA for databases?

• A. Register a new database with an available Enterprise Manager Management server.
• B. Configure a nonstandard block size for a new database.
• C. Change the standard block size of an existing database.
• D. Configure incremental backups for a new database.
• E. Enable flashback database for an existing database.

正解：A、B

解説：
A .False. Backups are configured via RMAN, not DBCA.
B .True. DBCA allows nonstandard block sizes during DB creation.
C .True. DBCA can register new DBs with EM.
D .False. Block size is fixed post-creation.
E .False. Flashback is enabled via SQL, not DBCA for existing DBs.

質問 # 11
Which of the following ALTER SYSTEM statements can be run from within a pluggable database (PDB)?

• A. ALTER SYSTEM CHECKPOINT
• B. ALTER SYSTEM ENABLE / DISABLE RESTRICTED SESSION
• C. ALTER SYSTEM SWITCH LOGFILE
• D. ALTER SYSTEM FLUSH BUFFER_CACHE

正解：A、B

解説：
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.

質問 # 12
Which three statements are true about Enterprise Manager Cloud Control?

• A. It uses a web-based console built into the Oracle database using XML DB.
• B. It is integrated with My Oracle Support.
• C. It provides management for Oracle-engineered systems.
• D. It is available to manage a database only when that database is open.
• E. It provides management for Oracle middleware.

正解：B、C、E

解説：
A .True. Integrates with MOS for patches and support.
B .True. Manages Exadata, etc.
C .True. Covers WebLogic and other middleware.
D .False. Web-based, but not built into the DB.
E .False. Can manage stopped instances via agents.

質問 # 13
Which resource plan is used to manage the resources for the predefined maintenance window?

• A. The SYS_GROUP consumer resource group policies define the resources assigned ...
• B. The predefined maintenance window starts automatically with 20% of the system resources ...
• C. By default, all predefined maintenance windows use the DEFAULT_MAINTENANCE_PLANresource plan, and automated maintenance tasks run under subplan called ORA$AUTOTASK.
• D. The resources used by the predefined maintenance window can only be adjusted if you create a new resource plan in Resource Manager ...

正解：C

解説：
A .True. Oracle 23ai uses DEFAULT_MAINTENANCE_PLAN with ORA$AUTOTASK subplan for maintenance tasks (e.g., stats gathering). Others are incorrect or speculative.

質問 # 14
In which two ways would you disable timing information collected for wait events and much of the performance monitoring capability of the database?

• A. By executing the PL/SQL procedure DBMS_TIME_STATISTIC.LEVEL(BASIC).
• B. By setting the TIMED_STATISTICS system parameter to FALSE.
• C. By executing the PL/SQL procedure DBMS_TIME_STATISTIC.DISABLE(TRUE).
• D. By setting the TIMED_STATISTICS_LEVEL system parameter to FALSE.
• E. By setting the STATISTICS_LEVEL parameter to BASIC.

正解：B、E

解説：
A .True. TIMED_STATISTICS = FALSE disables timing data collection.
B .False. No such procedure exists.
C .False. No TIMED_STATISTICS_LEVEL parameter exists.
D .True. STATISTICS_LEVEL = BASIC disables most performance monitoring.
E .False. No such procedure exists.

質問 # 15
Which two statements are true about User Authentication in an Oracle Database?

• 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 must be used for system-privileged administrative users.
• D. REMOTE_LOGIN_PASSWORDFILE must be set to EXCLUSIVE to permit password changes for system-privileged administrative users.
• E. Password File authentication is supported for any type of database user.

正解：A、C

解説：
User authentication in Oracle 23ai determines how users (especially administrative ones) connect to the database. Let's analyze each option with extensive detail:
A . Operating System authentication may be used for system-privileged administrative users.
True. OS authentication allows users mapped to OS accounts (e.g., ops$oracle) to connect without a password, often used for administrative users like SYS or SYSTEM. This is configured by creating an externally authenticated user (e.g., CREATE USER "OPS$ORACLE" IDENTIFIED EXTERNALLY) and relies on the OS to verify identity.
Mechanics:When a user logs in via sqlplus / as sysdba, Oracle checks the OS user against the dba group (Unix) or ORA_DBA (Windows). If matched, no password is needed, leveraging OS security.
Practical Use:Common for DBAs managing local instances, reducing password management overhead.
Edge Case:Requires REMOTE_LOGIN_PASSWORDFILE=NONE for exclusive OS auth, but this isn't mandatory if a password file exists alongside.
Historical Note:Introduced in early Oracle versions, this remains a robust option in 23ai for local admin access.
B . Password authentication must be used for system-privileged administrative users.
False. "Must" is incorrect; password authentication (e.g., sqlplus sys/password) is an option, not a requirement. OS authentication or password file authentication can also be used for users like SYS. This option overstates the necessity of password-based login.
Why Incorrect:Oracle's flexibility allows multiple methods, contradicting the absolute phrasing here.
C . Password File authentication is supported for any type of database user.
False. Password file authentication is restricted to users with SYSDBA, SYSOPER, or similar system privileges (e.g., SYSBACKUP). Regular users (e.g., HR) can't use the password file (orapw<sid>); they rely on database authentication (passwords stored in the DB) or external methods.
Mechanics:The password file stores hashed credentials for privileged users, checked during remote AS SYSDBA logins.
Why Incorrect:Extending this to "any user" ignores Oracle's security model limiting password file usage.
D . REMOTE_LOGIN_PASSWORDFILE must be set to EXCLUSIVE to permit password changes for system-privileged administrative users.
False. REMOTE_LOGIN_PASSWORDFILE=EXCLUSIVE allows a dedicated password file for one instance, enabling password changes via ALTER USER SYS IDENTIFIED BY newpass. However, SHARED mode also permits changes for SYS, though not for other users added to the file. The "must" overstates the requirement; it's sufficient, not necessary.
Mechanics:EXCLUSIVE locks the file to one DB, while SHARED allows multiple DBs to use it, with restrictions on non-SYS users.
E . Password File authentication must be used for system-privileged administrative users.
True. For remote administrative access (e.g., sqlplus sys/password@orcl as sysdba), a password file is mandatory when REMOTE_LOGIN_PASSWORDFILE is EXCLUSIVE or SHARED. Local OS authentication is an alternative, but for network-based admin tasks, the password file is required, making this statement true in that context.
Mechanics:Set via orapwd (e.g., orapwd file=orapworcl password=oracle entries=10), enabling remote SYSDBA logins.
Edge Case:If REMOTE_LOGIN_PASSWORDFILE=NONE, only OS auth works locally, but this isn't the default or typical setup.

質問 # 16
Which three tasks are performed by background processes in an Oracle database instance?

• A. Reading database blocks into the buffer cache.
• B. Registering services with Oracle Net listeners.
• C. Writing dirty database block images from the buffer cache.
• D. Creating dedicated server connections.
• E. Reading database blocks into the buffer cache.
• F. Writing redo to log files.

正解：B、C、F

解説：
False. Server processes (foreground) read blocks into the buffer cache during user queries, not background processes.
Explanation:
Background processes manage core database operations. Let's break it down:
A : Creating dedicated server connections.
False. Dedicated server connections are created by the listener, not background processes. The listener hands off the connection to a server process (e.g., ora_s000), which isn't a background process.
B : Registering services with Oracle Net listeners.
True. The LREG process (Listener Registration, formerly PMON's role) registers services with listeners, using parameters like LOCAL_LISTENER.
Mechanics:LREG sends service details (e.g., orcl) to the listener every 60 seconds or on startup.
C : Writing redo to log files.
True. The LGWR (Log Writer) process writes redo entries from the redo log buffer to online redo log files, ensuring transaction durability.
Mechanics:Triggered by commits, log buffer fills, or checkpoints.
D : Writing dirty database block images from the buffer cache.
True. The DBWn (Database Writer) processes write modified (dirty) blocks from the buffer cache to data files, maintaining consistency.
Mechanics:Occurs at checkpoints or when free buffers are needed.

質問 # 17
orcl.dmp contains a full export of the ORCL database. This command is executed to load data from orcl.dmp into the TESTDB database: [oracle@host01 ~] impdp system/oracle SCHEMAS=sh,oe REMAP_SCHEMA=sh:hr DUMPFILE=orcl.dmp EXCLUDE=index TABLE_EXISTS_ACTION=replace LOGFILE=impdp.log Which two statements are true?

• A. It drops and re-creates indexes that exist in both ORCL:SH and TESTDB:HR.
• B. It skips only tables that exist in ORCL:SH and ORCL:OE.
• C. It drops and re-creates tables that exist in both ORCL:SH and TESTDB:HR.
• D. It skips only indexes that exist in both ORCL:SH and TESTDB:HR.
• E. It skips all indexes of ORCL:SH and in both ORCL:SH and TESTDB:HR.

正解：C、E

解説：
A .False. EXCLUDE=index skips all indexes, not re-creates them.
B .False. TABLE_EXISTS_ACTION=replace drops and re-creates tables.
C .True. EXCLUDE=index omits all indexes from import.
D .True. replace drops and re-creates existing tables.
E .False. Skips all indexes, not just overlapping ones.

質問 # 18
Which two statements are true about the UNLIMITED TABLESPACE system privilege and space quota?

• A. It allows a role to have unlimited space in any tablespace in the database.
• B. It allows a user to have unlimited space only in their default permanent tablespace.
• C. It is overridden by a space quota specified for the user.
• D. It allows a user to have unlimited space in any tablespace in the database.
• E. By default, users have no quota on their default permanent tablespace.

正解：C、D

解説：
A .True. Grants unlimited space across all tablespaces.
B .True. Explicit quotas override the privilege.
C .False. Not limited to default tablespace.
D .False. Roles can't have this privilege directly.
E .False. Default is zero quota unless specified.

質問 # 19
Which two statements describe why Database Auditing is a security requirement?

• A. To protect against data theft by a non-authorized user.
• B. To monitor proper usage of the system and data by privileged users.
• C. To protect against data corruption.
• D. To alert DBAs about system issues.
• E. To monitor suspicious activity.

正解：B、E

解説：
A .True. Auditing tracks suspicious actions.
B .False. That's monitoring, not auditing.
C .False. Auditing detects, doesn't prevent.
D .False. Corruption is a reliability issue.
E .True. Ensures privileged user compliance.

質問 # 20
As the DBA, you execute this command: GRANT CREATE VIEW TO usr1 WITH ADMIN OPTION; USR1 then executes: GRANT CREATE VIEW TO usr2 WITH ADMIN OPTION; USR2 then executes: GRANT CREATE VIEW TO usr3; Which statement is true?

• A. When the DBA revokes the CREATE VIEW privilege from USR2, it is revoked from USR3.
• B. When the DBA revokes the CREATE VIEW privilege from USR1, it is revoked from USR2 but not USR3.
• C. The DBA can revoke only ADMIN OPTION from USR1.
• D. USR1 can revoke the CREATE VIEW privilege from USR3.
• E. When the DBA revokes the CREATE VIEW privilege from USR1, it is neither revoked from USR2 nor USR3.

正解：A、E

解説：
A .False. Revoking from USR1 doesn't cascade due to WITH ADMIN OPTION.
B .True. Revoking from USR2 cascades to USR3 because USR2 granted it.
C .False. DBA can revoke the full privilege, not just ADMIN OPTION.
D .False. USR1 can't revoke from USR3 directly; only the grantor (USR2) can.
E .True. WITH ADMIN OPTION breaks the revoke chain from USR1 onward.

質問 # 21
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?

• A. Only in the SPFILE
• B. In the SPFILE, PFILE, and memory
• C. In the SPFILE and memory
• D. In the SPFILE and PFILE
• E. Only in memory

正解：C

解説：
B .True. Without SCOPE, ALTER SYSTEM defaults to BOTH (memory and SPFILE); PFILE isn't updated unless manually recreated.

質問 # 22
Which two are true about shrinking a segment online?

• A. It must be in a tablespace that uses Automatic Segment Space Management (ASSM).
• B. To shrink a table it must have row movement enabled.
• C. To shrink a table it must have a PRIMARY KEY constraint.
• D. To shrink a table it must have a UNIQUE KEY constraint.
• E. It is not possible to shrink either indexes or Index Organized Tables (IOTs).

正解：A、B

解説：
A .True. ROW MOVEMENT must be enabled for SHRINK SPACE.
B .False. Indexes and IOTs can be shrunk with CASCADE.
C .False. No such constraint requirement.
D .True. ASSM is required for online shrinking.
E .False. No primary key requirement.

質問 # 23
Which three statements are true about resumable space allocation in Oracle databases?

• A. Resumable space allocation is only possible with locally managed tablespaces.
• B. A user's session may be suspended even if the user has the UNLIMITED TABLESPACE system privilege.
• C. Resumable space allocation may be enabled for some sessions and not others.
• D. All sessions must have the same timeout value when waiting for resumable space allocations.
• E. The AFTER SUSPEND event trigger can itself be suspended due to space conditions.
• F. A user's session may be suspended and resumed multiple times.

正解：B、C、F

解説：
A .True. Enabled per session with ALTER SESSION ENABLE RESUMABLE.
B .True. Multiple suspensions can occur in one session.
C .False. Works with dictionary-managed tablespaces too.
D .False. Timeout is session-specific.
E .True. Privilege doesn't prevent suspension; quota limits do.
F .False. Triggers execute but can't suspend themselves.

質問 # 24
Script abc.sql must be executed to perform a certain task. User HR with password HR exists in the target database and the account is unlocked. The TNSNAMES.ORA file is up to date. Examine this command attempted by the user: $ sqlplus hr/hr@orcl @abc. What will happen and why?

• A. The command succeeds and HR will be connected to the orcl database instance, and the abc script will be executed.
• B. The command succeeds and HR will be connected to the orcl database instance, and the abc script will be executed.
• C. The command succeeds and HR will be connected to the orcl database and after logging out to the abc database.
• D. The command fails and reports an error because @ is used twice.
• E. The command fails because the script must refer to the full path name.

正解：B

解説：
A .False. "Logging out to the abc database" is nonsensical; abc is a script, not a database.
B .False. SQL*Plus finds abc.sql in the current directory by default; a full path isn't required unless it's elsewhere.
C .False. The first @ specifies the TNS alias (orcl), the second runs the script (@abc); this is valid syntax.
D & E.True (identical options). The command connects to orcl via TNSNAMES.ORA, authenticates HR, and executes abc.sql.
Mechanics:sqlplus hr/hr@orcl resolves orcl to a listener address, connects, and@abc runs the script post-login.

質問 # 25
Which three statements are true about a dedicated server configuration?

• A. A dedicated server process can be spawned by the listener when using local clients.
• B. Each dedicated server process has its own dispatcher process.
• C. The DBA configures the maximum number of dedicated server processes that can share the samedispatcher process.
• D. A dedicated server process communicates directly with a client or middle-tier process once the session is established.
• E. A dedicated server process can be spawned without a listener when using local clients.
• F. A dedicated server process may be reused by a new session after the session using that process terminates.

正解：A、D、E

解説：
A .False. Dispatchers are for shared servers, not dedicated.
B .False. Dedicated processes die with the session.
C .True. Direct client-server communication occurs.
D .False. No dispatchers in dedicated mode.
E .True. Listener spawns for local/remote clients.
F .True. Local logins (e.g., sqlplus /) bypass the listener.

質問 # 26
Which three statements are true about Oracle Managed Files (OMF)?

• A. 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.
• B. If only DB_CREATE_ONLINE_LOG_DEST_1 is specified, only redo logs and control files are Oracle Managed.
• 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 DB_RECOVERY_FILE_DEST is specified, at least two different locations must be specified for DB_CREATE_ONLINE_LOG_DEST_n.
• E. 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.
• F. If only DB_CREATE_FILE_DEST is specified, only data files and temp files are Oracle managed.

正解：A、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.

質問 # 27
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. UNDO_RETENTION specifies for how long Oracle attempts to keep unexpired UNDO.
• D. Active UNDO is always retained.
• E. UNDO_RETENTION specifies how long all types of UNDO are retained.

正解：C、D

解説：
A .True. Active (in-use) UNDO is never overwritten.
B .False. Unexpired UNDO can be reused if space is needed.
C .False. Applies to unexpired, not expired UNDO.
D .False. Only unexpired UNDO is targeted.
E .True. UNDO_RETENTION sets the retention goal for unexpired UNDO.

質問 # 28
What are Optimizer Statistics?

• A. Optimizer Statistics are statistics about data distribution within Oracle Datafiles.
• B. Optimizer Statistics are a set of data distribution statistics collected in real time as data is inserted, deleted, or updated, which are stored in AWR and used for generating SQL execution plans.
• C. Optimizer Statistics are part of system performance statistics stored in AWR required for calculating SQL execution plans.
• D. Optimizer Statistics are table, column, index, and system statistics used for generating efficient SQL execution plans.

正解：D

解説：
A .False. Not real-time; collected periodically.
B .False. Not about datafile distribution.
C .True. Includes table, column, index stats for plan generation.
D .False. Stored in data dictionary, not AWR.

質問 # 29
Which three statements are true about Deferred Segment Creation in Oracle databases?

• A. It is supported for SYS-owned tables contained in locally managed tablespaces.
• B. Sessions may dynamically switch back and forth from DEFERRED to IMMEDIATE segment creation.
• C. It is the default behavior for tables and indexes.
• D. Indexes inherit the DEFERRED or IMMEDIATE segment creation attribute from their parent table.
• E. It is supported for Index Organized Tables (IOTs) contained in locally managed tablespaces.

正解：B、C、D

解説：
A .False. IOTs require immediate segment creation.
B .False. SYS-owned tables don't use deferred creation.
C .True. Default since 11gR2, continued in 23ai.
D .True. Indexes inherit this attribute unless overridden.
E .True. Sessions can alter this via DEFERRED_SEGMENT_CREATION.

質問 # 30
Which two account management capabilities can be configured using Oracle profiles?

• A. The ability to prevent a password from ever being reused.
• 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 number of days for which an account may be inactive before it is locked.
• E. The maximum number of sessions permitted for a user before the password must be changed.

正解：A、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.

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

• A. One instance on one server mounting 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 and opening 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.

質問 # 32
......

究極な準備用ガイド1Z1-182認定試験Oracle Database 23ai：https://jp.fast2test.com/1Z1-182-premium-file.html