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

（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）They can be queried, transformed, and joined with other tables without having to load the data first.

（B）The results of a complex join or aggregating function or both can be unloaded to a file for transportation to other systems.

（C）They support UPDATEs, which transparently updates records in the file system as if they were table rows.

（D）They support DELETEs, which transparently deletes records in the file system as if they were table rows.

（E）They can be queried while the database is in the MOUNT state like dynamic performance views.

（A）All sessions must have the same timeout value when waiting for resumable space allocations.

（B）The AFTER SUSPEND event trigger can itself be suspended due to space conditions.

（C）A user's session may be suspended even if the user has the UNLIMITED TABLESPACE system privilege.

（D）Resumable space allocation may be enabled for some sessions and not others.

（E）Resumable space allocation is only possible with locally managed tablespaces.

（F）A user's session may be suspended and resumed multiple times.

（A）It supports diagnostics for Oracle Clusterware.

（B）The ADR base defaults to $ORACLE_HOME/rdbms/admin if neither DIAGNOSTIC_DEST nor ORACLE_BASE is set.

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

（D）It supports diagnostics for Automatic Storage Management (ASM).

（E）The ADR base defaults to $ORACLE_HOME/dbs if the DIAGNOSTIC_DEST parameter and the ORACLE_BASE environment variable are not set.

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

（A）To protect against data theft by a non-authorized user.

（B）To protect against data corruption.

（C）To monitor proper usage of the system and data by privileged users.

（D）To alert DBAs about system issues.

（E）To monitor suspicious activity.

（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 inactive before it is locked.

（D）The maximum number of sessions permitted for a user before the password must be changed.

（E）The number of days for which an account may be logged in to one or more sessions before it is locked.

（A）A RAC database can have instances on separate servers.

（B）A RAC database must have two or more instances.

（C）A RAC database can have one instance.

（D）A RAC database must have three or more instances.

（E）Two RAC databases can share their instances.

（A）All roles granted to a user are set on default when the user logs in.

（B）The SET ROLE statement can disable one or more roles for a session.

（C）Roles must be password protected.

（D）Roles may be granted to other roles.

（E）The SET ROLE statement can enable one or more roles for a session.

（F）Object privileges may not be granted to roles.