[2025年11月] 実際問題を使って1Z1-182無料問題集サンプルと問題と練習テストエンジン
合格させるOracle 1Z1-182試験問題でテスト復刻エンジンとPDF
質問 # 57
Which three statements are true about using SQL*Plus?
- A. It can run scripts passed to it by a shell script.
- B. It has both command-line and graphical user interfaces (GUI).
- C. It can run scripts entered at the SQL prompt.
- D. It has its own commands that are separate from any SQL statements.
- E. It must be downloaded from the Oracle Technology Network (OTN).
- F. It can run Recovery Manager (RMAN) commands.
正解：A、C、D
解説：
A .True. sqlplus @script.sql works from shell scripts.
B .False. RMAN uses its own client, not SQL*Plus.
C .False. Bundled with Oracle DB software.
D .False. Command-line only; no GUI in 23ai.
E .True. @script runs scripts interactively.
F .True. Commands like SHOW PARAMETER are unique.
質問 # 58
Examine this command: ALTER DATABASE MOVE DATAFILE '\u01/sales1.dbf' TO '\u01/sales01.dbf' REUSE; Which two statements are true?
- A. The tablespace containing SALES1.DBF must be altered OFFLINE before executing the command.
- B. The file is renamed and stored in the same location.
- C. If Oracle Managed Files (OMF) is used, then the file is renamed but moved to DB_CREATE_FILE_DEST.
- D. The tablespace containing SALES1.DBF must be altered READ ONLY before executing the command.
- E. DML may be performed on tables with one or more extents in this data file during the execution of this command.
正解：B、E
解説：
This command moves/renames a data file online. Let's evaluate:
A . DML may be performed on tables with one or more extents in this data file during the execution of this command.
True. Introduced in 12c and refined in 23ai, MOVE DATAFILE is an online operation, allowing DML (e.g., INSERT, UPDATE) on tables within the file. Oracle ensures consistency via redo and undo.
Mechanics:The file is copied to the new location/name while tracking changes, then switched atomically.
Practical Use:Minimizes downtime in production systems.
B . If Oracle Managed Files (OMF) is used, then the file is renamed but moved to DB_CREATE_FILE_DEST.
False. With OMF, omitting the TO clause would place the file in DB_CREATE_FILE_DEST, but here, TO '\u01/sales01.dbf' explicitly specifies the target, overriding OMF defaults.
Mechanics:OMF only applies if the destination is unspecified (e.g., MOVE DATAFILE ... without TO).
Why Incorrect:Explicit path trumps OMF behavior.
C . The tablespace containing SALES1.DBF must be altered READ ONLY before executing the command.
False. READ ONLY isn't required; the operation is online and supports active use.
Why Incorrect:Conflicts with Oracle's online move feature.
D . The file is renamed and stored in the same location.
True. The command renames /u01/sales1.dbf to /u01/sales01.dbf (correcting \u01 to /u01 as a Windows/Unix typo), keeping it in /u01/. REUSE allows overwriting if sales01.dbf exists.
Mechanics:File is copied and renamed in-place within the same filesystem directory.
E . The tablespace containing SALES1.DBF must be altered OFFLINE before executing the command.
False. Offline mode isn't needed; the online move handles activetablespaces.
質問 # 59
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. In the SPFILE and PFILE
- B. In the SPFILE and memory
- C. Only in the SPFILE
- D. Only in memory
- E. In the SPFILE, PFILE, and memory
正解：B
解説：
B .True. Without SCOPE, ALTER SYSTEM defaults to BOTH (memory and SPFILE); PFILE isn't updated unless manually recreated.
質問 # 60
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 the AUDIT_ADMIN privilege.
- C. FGA policies can be created by a user having granted the CREATE_FGA_POLICY role.
- D. FGA policies by default can be created by a schema owner on an object in their schema.
- E. FGA policies can be created by a user having EXECUTE privilege on the DBMS_FGA package.
正解：B、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.
質問 # 61
What are Optimizer Statistics?
- A. 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.
- B. Optimizer Statistics are part of system performance statistics stored in AWR required for calculating SQL execution plans.
- C. Optimizer Statistics are statistics about data distribution within Oracle Datafiles.
- 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.
質問 # 62
Which three statements are true about UNDO and REDO?
- A. UNDO is used for some flashback operations.
- B. Both REDO and UNDO can be multiplexed.
- C. REDO is used for read consistency.
- D. REDO is used for instance recovery.
- E. REDO is used for ROLLBACK.
- F. UNDO is used for read consistency.
正解：A、D、F
解説：
A . REDO is used for read consistency.False. Read consistency is achieved using UNDO, which provides a consistent view of data as of a specific point in time. REDO logs changes for recovery, not consistency.
B . UNDO is used for some flashback operations.True. Flashback features like Flashback Query and Flashback Table rely on UNDO to reconstruct past states of data.
C . UNDO is used for read consistency.True. UNDO stores pre-change data, enabling multi-version read consistency for queries.
D . Both REDO and UNDO can be multiplexed.False. REDO logs can be multiplexed (mirrored across multiple destinations), but UNDO is managed within a single UNDO tablespace per instance (though it can have multiple data files).
E . REDO is used for ROLLBACK.False. ROLLBACK uses UNDO to revert changes; REDO logs the changes but isn't used to undo them.
F . REDO is used for instance recovery.True. REDO logs are replayed during instance recovery to reapply committed changes after a crash.
質問 # 63
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?
- A. Analysis of privileges that a user has on their own schema objects.
- B. Analysis of all privileges used by the SYS user.
- C. Analysis of privileges granted indirectly to a role that are then used by a user who has been granted that role.
- D. Analysis of privileges granted directly to a role that are then used by a user who has been granted that role.
- E. Analysis of privileges that a user has on other schemas' objects.
正解：C、D
解説：
A .False. Limited to captured privileges, not all schema objects.
B .False. SYS is excluded from capture.
C .True. Captures indirect role privileges used.
D .True. Captures direct role privileges used.
E .False. Focus is on roles, not self-owned objects broadly.
質問 # 64
Which advisor is used to detect missing or stale object statistics?
- A. SQL Access Advisor
- B. SQL Statistics Advisor
- C. SQL Performance Analyzer
- D. SQL Tuning Advisor
正解：B
解説：
B .True. The SQL Statistics Advisor (new in 23ai) identifies stale or missing statistics. Others focus on tuning, performance analysis, or access paths.
質問 # 65
You execute the SHUTDOWN ABORT command. Which two statements are true?
- A. A checkpoint is written.
- B. Data files are closed normally.
- C. Uncommitted transactions are not rolled back by the shutdown.
- D. Subsequent instance startup performs instance recovery.
- E. Subsequent instance startup performs media recovery.
正解：C、D
解説：
A .False. No checkpoint occurs with ABORT.
B .False. Instance recovery, not media recovery, is needed.
C .True. Crash recovery rolls back uncommitted changes on startup.
D .False. Files aren't closed cleanly with ABORT.
E .True. Shutdown doesn't roll back; recovery does.
質問 # 66
Which two are benefits of external tables?
- A. The results of a complex join or aggregating function or both can be unloaded to a file for transportation to other systems.
- B. They support UPDATEs, which transparently updates records in the file system as if they were table rows.
- C. They support DELETEs, which transparently deletes records in the file system as if they were table rows.
- D. They can be queried while the database is in the MOUNT state like dynamic performance views.
- E. They can be queried, transformed, and joined with other tables without having to load the data first.
正解：A、E
解説：
A .False. External tables are read-only; no DELETE.
B .False. Require OPEN state, unlike V$ views.
C .False. No UPDATE support; read-only.
D .True. Queryable like regular tables without loading.
E .True. Data Pump can unload query results to files.
質問 # 67
Which three 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. Enterprise Manager Cloud Control can be used to centrally configure listeners on any managed database server.
- C. The Oracle Net Configuration Assistant is only used when running the Oracle installer.
- D. Oracle Net Manager can be used to locally configure naming methods on a database server.
- E. Enterprise Manager Cloud Control can be used to centrally configure net service names for any database server target.
- F. The lsnrctl utility requires a listener.ora file to exist before it is started.
正解：B、D、E
解説：
A .False. Net Manager is local, not centralized.
B .False. NetCA can run standalone.
C .True. EMCC manages service names centrally.
D .True. EMCC configures listeners on managed targets.
E .False. lsnrctl starts a default listener if no listener.ora exists.
F .True. Net Manager configures local tnsnames.ora.
質問 # 68
Which of the following statements is true about external tables?
- A. They are read/write tables.
- B. They describe how the external table layer presents data to the server.
- C. They describe data stored in the database.
- D. They describe how data is stored in the external source.
正解：B
解説：
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.
質問 # 69
Which statement is true about database links?
- A. Private database link creation requires the same user to exist in both the local and the remote databases.
- B. A database link can be created only between two Oracle databases.
- C. A public database link can be created only by SYS.
- D. A database link created in a database allows a connection from that database's instance to the target database's instance, but not vice versa.
- E. A public database link can be used by a user connected to the local database instance to connect to any schema in the remote database instance.
正解：D
解説：
Database links enable cross-database queries in Oracle. Let's analyze each option with extensive detail:
A . A public database link can be created only by SYS.
False. Any user with the CREATE PUBLIC DATABASE LINK privilege (not just SYS) can create a public link (e.g., CREATE PUBLIC DATABASE LINK remote_db CONNECT TO scott IDENTIFIED BY tiger USING 'orcl'). While SYS typically has this privilege, it's not exclusive to SYS.
Mechanics:Privilege is granted via GRANT CREATE PUBLIC DATABASE LINK TO user;. Public links are accessible to all users in the local DB.
Why Incorrect:Overly restrictive; Oracle's security model allows delegation.
B . A database link can be created only between two Oracle databases.
False. Database links can connect to non-Oracle databases using Oracle Heterogeneous Services or gateways (e.g., ODBC or JDBC drivers), such as linking to SQL Server. Example: CREATE DATABASE LINK mssql_link USING 'hsodbc';.
Mechanics:Requires configuration of hs_ parameters in init.ora and a gateway listener.
Historical Note:Heterogeneous links were introduced in 8i, expanded in 23ai for cloud integration.
C . A database link created in a database allows a connection from that database's instance to the target database's instance, but not vice versa.
True. A database link is unidirectional; it enables queries from the local instance to the remote instance (e.g., SELECT * FROM emp@remote_db), but the remote instance can't use it to query back unless a separate link is created there.
Mechanics:Stored in DBA_DB_LINKS, the link defines a one-way connection via a TNS alias or connect string.
Practical Use:Ensures controlled access; bidirectional access requires explicit configuration.
Edge Case:Loops are prevented unless explicitly designed with mutual links.
D . A public database link can be used by a user connected to the local database instance to connect to any schema in the remote database instance.
False. Public links allow all local users to use them, but access to remote schemas depends on the link's credentials (e.g., CONNECT TO scott) and the user's remote privileges. "Any schema" overstates it; access is limited to what the link's user can see.
Why Incorrect:Misrepresents privilege scope; remote schema access isn't universal.
E . Private database link creation requires the same user to exist in both the local and the remote databases.
False. A private link (e.g., CREATE DATABASE LINK my_linkCONNECT TO scott IDENTIFIED BY tiger USING 'orcl') requires the remote user (scott) to exist, but the local creator (e.g., HR) need not match. The link is owned locally and authenticated remotely.
Mechanics:Only the CREATE DATABASE LINK privilege is needed locally.
質問 # 70
Which three statements are true about Automatic Diagnostic Repository (ADR)?
- A. It is only used for Oracle database diagnostic information.
- B. It is held inside an Oracle database schema.
- C. It is a file-based repository held outside any database.
- D. It can be used for the problem diagnosis of a database when that database's instance is down.
- E. The ADR base is specified in the DIAGNOSTIC_DEST database parameter.
正解：C、D、E
解説：
A .True. ADR is a file system directory structure (e.g., /u01/app/oracle/diag), external to the database.
B .False. ADR also stores diagnostics for non-database components (e.g., ASM, listener).
C .False. It's file-based, not schema-based.
D .True. ADR logs (e.g., alert logs, trace files) are accessible even if the instance is down.
E .True. DIAGNOSTIC_DEST sets the ADR base directory.
質問 # 71
Which statement is true about database links?
- A. Private database link creation requires the same user to exist in both the local and the remote databases.
- B. A public database link can be used by any user allowing remote database instance connection for selecting schema data.
- C. A database link created in a database allows a connection from that database's instance to the target database's instance for selecting schema data.
- D. A database link can be created only between two Oracle databases.
- E. A public database link can be created only by SYS.
正解：C
解説：
A .False. Links can connect to non-Oracle DBs via gateways.
B .False. No such user requirement; authentication is separate.
C .False. Any user with CREATE PUBLIC DATABASE LINK can create one.
D .True. Links enable remote schema access (e.g., SELECT * FROM emp@remote).
E .False. Public links allow access, but privileges on remote objects are needed.
質問 # 72
What is the result of the following command? ALTER PLUGGABLE DATABASE PDB1 DISCARD STATE;
- A. It should be used whenever PDB1 open mode needs to be changed.
- B. PDB1 is reverted to its default properties, which includes not to automatically open after a CDB restart.
- C. PDB1 is reverted to its default properties, which includes automatic opening after a CDB restart.
- D. It is unnecessary if the PDB is in the process of being upgraded.
正解：B
解説：
A .False. DISCARD STATE isn't tied to upgrades; it resets PDB startup behavior.
B .True. Discards saved state, reverting PDB1 to manual open mode (not auto-open) after CDB restart.
C .False. Default is not auto-open; it's manual unless explicitly saved as OPEN.
D .False. Used for state management, not general mode changes (e.g., OPEN READ WRITE).
質問 # 73
Which of the following is true about the status of a PDB that has been unplugged from a CDB?
- A. The STATUS column in CDB_PDBS of the unplugged PDB will be UNAVAILABLE.
- B. The STATUS column in CDB_PDBS of the unplugged PDB will be DISABLED.
- C. The STATUS column in CDB_PDBS of the unplugged PDB will be UNPLUGGED.
- D. The STATUS column in CDB_PDBS of the unplugged PDB will be REMOVED.
正解：C
解説：
A .True. After ALTER PLUGGABLE DATABASE ... UNPLUG, CDB_PDBS.STATUS shows UNPLUGGED.
B .False. UNAVAILABLE isn't a valid status here.
C .False. REMOVED isn't used; UNPLUGGED persists until dropped.
D .False. DISABLED isn't a PDB state in this context.
質問 # 74
Which two statements are true about database instances and Real Application Clusters (RAC)?
- A. A RAC database must have two or more instances.
- B. A RAC database must have three or more instances.
- C. Two RAC databases can share their instances.
- D. A RAC database can have instances on separate servers.
- E. A RAC database can have one instance.
正解：D、E
解説：
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.
質問 # 75
Which three statements are true about the Oracle Database server during and immediately after SHUTDOWN TRANSACTIONAL?
- A. New connection requests made to the database instance are refused.
- B. Uncommitted transactions are allowed to continue to the next ROLLBACK.
- C. Sessions remain connected even if they are not running a transaction.
- D. Instance recovery occurs automatically during the shutdown.
- E. Uncommitted transactions are allowed to continue to the next COMMIT.
正解：A、C、E
解説：
A .False. Recovery happens on startup, not shutdown.
B .False. TRANSACTIONAL waits for commits or rollbacks, then disconnects.
C .True. New connections are blocked during shutdown.
D .True. Inactive sessions persist until shutdown completes.
E .True. Active transactions can commit before disconnection.
質問 # 76
Which two statements are true about views used for viewing tablespace and datafile information?
- A. A datafile can be renamed when the database is in MOUNT state and the new file name is displayed when querying DBA_DATA_FILES after the database is opened.
- B. V$TABLESPACE displays information about tablespaces contained in the data dictionary.
- C. Tablespace free space can be viewed in DBA_TABLESPACES.
- D. V$TABLESPACE displays information that is contained in the control file about tablespaces.
- E. Tablespace free space can be viewed in V$TABLESPACE.
正解：A、D
解説：
A .False. V$TABLESPACE doesn't show free space directly.
B .False. It's from the control file, not the data dictionary.
C .True. Renaming in MOUNT state updates DBA_DATA_FILES post-open.
D .False. DBA_TABLESPACES shows attributes, not free space directly (use DBA_FREE_SPACE).
E .True. V$TABLESPACE reflects control file data.
質問 # 77
Which two statements are true concerning logical and physical database structures?
- A. A segment's blocks can be of different sizes.
- B. A segment's blocks can be of different sizes.
- C. A segment might have only one extent.
- D. A segment can span multiple data files in some tablespaces.
- E. Segments can span multiple tablespaces.
- F. All tablespaces may have one or more data files.
正解：C、D
解説：
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.
質問 # 78
Which three Oracle database space management features will work with both Dictionary and Locally managed tablespaces?
- A. Online index segment shrink.
- B. Oracle Managed Files (OMF).
- C. Capacity planning growth reports based on historical data in the Automatic Workload Repository (AWR).
- D. Automatic data file extension (AUTOEXTEND).
- E. Online table segment shrink.
正解：B、C、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.
質問 # 79
......
あなたを合格させる1Z1-182お手軽に試験合格リアル1Z1-182練習問題集で更新されたのは2025年11月09日：https://www.passtest.jp/Oracle/1Z1-182-shiken.html
2025年最新の実際に出ると確認されたOracle 1Z1-182無料試験問題：https://drive.google.com/open?id=1viwrb5NH28WOeDs2joqN938fFrMXSHXx