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

（A）Any data files added to the tablespace must have a size of 5 gigabytes.

（B）It is a locally managed tablespace.

（C）Free space is managed using freelists.

（D）It must be smaller than the smallest BIGFILE tablespace.

（E）It uses the database default block size.

（A）It allows a user to have unlimited space only in their default permanent tablespace.

（B）It allows a role to have unlimited space in any tablespace in the database.

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

（A）Tablespace free space can be viewed in V$TABLESPACE.

（B）Tablespace free space can be viewed in DBA_TABLESPACES.

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

（D）V$TABLESPACE displays information about tablespaces contained in the data dictionary.

（E）V$TABLESPACE displays information that is contained in the control file about tablespaces.

（A）COMMON Unified Audit Policies can only be created at CDB level to monitor DBA operation at any level.

（B）At the PDB level if the policy is created by a COMMON user.

（C）At the CDB level.

（D）At any level by using the COMMON option in the policy.

（E）At the Application Root level of an Application Container.

（A）A public database link can be used by any user allowing remote database instance connection for selecting schema data.

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

（C）A public database link can be created only by SYS.

（D）Private database link creation requires the same user to exist in both the local and the remote databases.

（E）A database link can be created only between two Oracle databases.

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

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

（A）Automatic data file extension (AUTOEXTEND).

（B）Online segment shrink.

（C）Server-generated tablespace space alerts.

（D）Free space management with bitmaps.

（E）Oracle Managed Files (OMF).

（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）They are owned by the SYSTEM user.

（B）Read consistency is not guaranteed.

（C）They can be queried only when the database is open.

（D）V$FIXED_TABLE can be queried to display the names of all dynamic performance views.

（E）Data displayed by querying dynamic performance views is derived from metadata in the data dictionary.