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

（A）ALTER SYSTEM SWITCH LOGFILE

（B）ALTER SYSTEM ENABLE / DISABLE RESTRICTED SESSION

（C）ALTER SYSTEM FLUSH BUFFER_CACHE

（D）ALTER SYSTEM CHECKPOINT

（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）Optimizer Statistics are part of system performance statistics stored in AWR required for calculating SQL execution plans.

（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 table, column, index, and system statistics used for generating efficient SQL execution plans.

（D）Optimizer Statistics are statistics about data distribution within Oracle Datafiles.

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

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

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

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

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

（A）All trace files contain error information that requires contacting Oracle Support.

（B）They can be written by background processes to a file system.

（C）They can be written by server processes to the Fast Recovery Area (FRA).

（D）Trace file names are based on the database name concatenated with a sequential number.

（E）They can be written by server processes to a file system.

（A）The control files are opened.

（B）SYS can access the database.

（C）Memory is allocated for the SGA.

（D）The consistency of the database is checked.

（E）All required background processes are started.

（A）Subsequent instance startup performs media recovery.

（B）Uncommitted transactions are not rolled back by the shutdown.

（C）Data files are closed normally.

（D）A checkpoint is written.

（E）Subsequent instance startup performs instance recovery.

（A）It records checkpoint information in the control file.

（B）It frees unused temporary segments.

（C）It registers database services with all local and remote listeners known to the database instance.

（D）It rolls back transactions when a process fails.

（E）It frees resources held by abnormally terminated processes.

（A）Segments can span multiple tablespaces.

（B）All tablespaces may have one or more data files.

（C）A segment's blocks can be of different sizes.

（D）A segment's blocks can be of different sizes.

（E）A segment might have only one extent.

（F）A segment can span multiple data files in some tablespaces.

（A）UNDO_RETENTION specifies how long all types of UNDO are retained.

（B）Unexpired UNDO is always retained.

（C）UNDO_RETENTION specifies for how long Oracle attempts to keep expired and unconsumed UNDO.

（D）Active UNDO is always retained.

（E）UNDO_RETENTION specifies for how long Oracle attempts to keep unexpired UNDO.