Which two are true about common objects? (Choose two.)
Which two are true about common objects? (Choose two.)
Common objects can exist in both the CDB$ROOT and an application root, this means that these objects are available at the common level and can be used across multiple pluggable databases (PDBs). However, while they can exist in the CDB$ROOT, users are not allowed to create them there; only Oracle can create such objects in CDB$ROOT. Instead, users are permitted to create common objects within an application root, allowing these objects to be shared among all application PDBs within the application container. This makes options D and F the correct answers.
Which two are true about the Automatic Database Diagnostic Monitor (ADDM)? (Choose two.)
The Automatic Database Diagnostic Monitor (ADDM) runs automatically after each Automatic Workload Repository (AWR) snapshot, which is taken at regular intervals, typically every hour. This ensures that the ADDM continually analyzes recent database activity. Additionally, a DBA has the capability to run ADDM manually, allowing for immediate analysis or coverage of specific time periods beyond the automatic intervals. Therefore, the correct answers are that ADDM runs automatically after each AWR snapshot and that a DBA can run it manually.
Which two are true about server-generated alerts? (Choose two.)
Stateless alerts can be purged manually from the alert history because they do not clear on their own and need to be managed by a database administrator if necessary. Stateless alerts can also be cleared manually, enabling administrators to address specific issues as soon as they are resolved. Stateful alerts are threshold-based and automatically move to the alert history when the triggering condition is resolved.
Which three are located by using environment variables? (Choose three.)
Three correct options for locating by using environment variables are: the Optimal Flexible Architecture (OFA) compliant path to store Oracle software and configuration files, the location of Oracle Net Services configuration files, and the temporary disk space used by Oracle Installer during installation. The Optimal Flexible Architecture involves environment variables such as $ORACLE_BASE and $ORACLE_HOME. Oracle Net Services configuration files location is typically determined by the $TNS_ADMIN environment variable. For temporary disk space used during installation, environment variables like $TMP and $TEMP are used.
Which three are true about opatchauto? (Choose three.)
OPatchAuto is a utility used to automate the patching process for Oracle Grid Infrastructure and Oracle Database home combinations. It must be invoked by a user with root user privileges to perform the necessary system-level operations. During the patching process, OPatchAuto performs a shutdown and then a restart of all processes in both Oracle Grid Infrastructure and Oracle Database home to ensure that the patches are applied correctly. Additionally, OPatchAuto is commonly used to apply interim patches to these Oracle components, making it a critical tool for maintaining and updating Oracle environments efficiently.