1Z1-182 無料問題集「Oracle Database 23ai Administration Associate」

（A）Tables with one or more extents in this data file may be queried during the execution of this command.

（B）DML may be performed on tables with one or more extents in this data file during the execution of this command.

（C）The "TO" clause containing the new file name must be specified even if Oracle Managed Files (OMF) is used.

（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）It is only used for Oracle database diagnostic information.

（B）The ADR base is specified in the DIAGNOSTIC_DEST database parameter.

（C）It is held inside an Oracle database schema.

（D）It can be used for the problem diagnosis of a database when that database's instance is down.

（E）It is a file-based repository held outside any database.

（A）The role has the privileges to administer the PDB.

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

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

（D）No privileges are provided with the PDB_DBA role.

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

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

（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.

（A）To shrink a table it must have a PRIMARY KEY constraint.

（B）To shrink a table it must have row movement enabled.

（C）It must be in a tablespace that uses Automatic Segment Space Management (ASSM).

（D）It is not possible to shrink either indexes or Index Organized Tables (IOTs).

（E）To shrink a table it must have a UNIQUE KEY constraint.

（A）ADDM, a server-based expert that reviews database performance statistics captured by Snapshots to identify potential problems before system performance degrades noticeably.

（B）Automatic capture of statistical information from the SGA and storing it in the AWR using Automatic Database Diagnostic.

（C）Automatic Diagnostic Collector used to capture and store database errors and hung analysis.

（D）Automatic Application Tracing used to collect High-Load SQL statements and statistics.

（E）Automatic population of performance views (V$ views) from statistical data stored in AWR repository and using Automatic Database Diagnostic.

（F）Automatic Application Tracing used to collect High-Load SQL statements and statistics.

（A）The Java Pool

（B）The Large Pool

（C）The Streams Pool

（D）The Shared Pool

（A）Change the character set.

（B）Create a template that can be used to clone the database.

（C）Change the server mode from dedicated to shared, and vice versa.

（D）Create nonstandard block size tablespaces.

（E）Create an additional listener.

（A）Only queries are allowed on ORDERS while SHRINK is executing.

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

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

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

（E）Dependent indexes become UNUSABLE.

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

（A）PDB1 is reverted to its default properties, which includes not to automatically open after a CDB restart.

（B）It should be used whenever PDB1 open mode needs to be changed.

（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.