Oracle Database 23ai Administration Associate - 1Z0-182 Exam Practice Test

A. If only DB_CREATE_FILE_DEST is specified, only data files and temp files are Oracle managed.

B. If DB_RECOVERY_FILE_DEST is specified, at least two different locations must be specified for DB_CREATE_ONLINE_LOG_DEST_n.

C. If only DB_CREATE_ONLINE_LOG_DEST_1 is specified, only redo logs and control files are Oracle Managed.

D. If DB_CREATE_FILE_DEST is specified but DB_CREATE_ONLINE_LOG_DEST_n is not, new redo logs and control files are stored in DB_CREATE_FILE_DEST by default.

E. If DB_CREATE_ONLINE_LOG_DEST_1 is specified but DB_CREATE_FILE_DEST is not, new data files and temp files are stored in DB_CREATE_ONLINE_LOG_DEST_1 by default.

F. If DB_RECOVERY_FILE_DEST is specified but DB_CREATE_ONLINE_LOG_DEST_n is not, the redo logs and control files are placed in DB_RECOVERY_FILE_DEST by default.

A. Use DBMS_AUDIT_MGMT.DELETE_AUDIT_RECORDS('POLICY_NAME') as a privileged user to manually purge audit records of a specified Unified Policy.

B. Only viewed audit records can be purged from Unified Audits.

C. Use DBMS_AUDIT_MGMT.DELETE_AUDIT_RECORDS('POLICY_NAME') as a privileged user to manually purge audit records of a specified Unified Policy.

D. Use DBMS_AUDIT_MGMT.CREATE_PURGE_JOB as a privileged user to schedule an automatic purge job.

E. Use DBMS_AUDIT_MGMT.CLEAN_AUDIT_TRAIL as a privileged user to manually purge audit records.

F. Only the owner of a Unified Audit Policy can purge audit records by resetting the policy.

A. They are owned by the SYSTEM user.

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

C. Read consistency is not guaranteed.

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

E. They can be queried only when the database is open.

A. A public database link can be created only by SYS.

B. A public database link can be used by a user connected to the local database instance to connect to any schema in the remote database instance.

C. A database link created in a database allows a connection from that database's instance to the target database's instance, but not vice versa.

D. A database link can be created only between two Oracle databases.

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

A. Oracle Net Manager can be used to locally configure naming methods on a database server.

B. The Oracle Net Configuration Assistant is only used when running the Oracle installer.

C. The lsnrctl utility requires a listener.ora file to exist before it is started.

D. Enterprise Manager Cloud Control can be used to centrally configure net service names for any database server target.

E. Oracle Net Manager can be used to centrally configure listeners on any database server target.

A. Oracle Database Metrics are a set of statistics built in Oracle Enterprise Manager Cloud Control and used for automation.

B. Oracle Database Metrics are part of Oracle Enterprise Manager Cloud Control's Notification system used to email alerts.

C. Oracle Database Metrics are a set of measured statistics per unit of time (per second), transaction, or sessions that are used to evaluate performance.

D. Oracle Database Metrics monitor performance using thresholds to generate alerts.

E. Oracle Database Metrics are part of the Oracle Database Notification system to email information about major database events.

A. Registering services with Oracle Net listeners.

B. Reading database blocks into the buffer cache.

C. Writing dirty database block images from the buffer cache.

D. Writing redo to log files.

E. Creating dedicated server connections.

F. Reading database blocks into the buffer cache.

A. The predefined maintenance window starts automatically with 20% of the system resources ...

B. The resources used by the predefined maintenance window can only be adjusted if you create a new resource plan in Resource Manager ...

C. By default, all predefined maintenance windows use the DEFAULT_MAINTENANCE_PLANresource plan, and automated maintenance tasks run under subplan called ORA$AUTOTASK.

D. The SYS_GROUP consumer resource group policies define the resources assigned ...

A. The high-water mark (HWM) of ORDERS is adjusted.

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

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

D. Queries and DML statements are allowed on ORDERS while the SHRINK is executing.

E. Dependent indexes become UNUSABLE.

F. Only queries are allowed on ORDERS while SHRINK is executing.

A. Dynamic service registration cannot be used for this database instance.

B. The definition for LISTENER_1 requires a CONNECT_DATA section to enable dynamic service registration.

C. LISTENER_1 must also be defined in the LISTENER.ORA file to enable dynamic service registration.

D. The LREG process registers services dynamically with the LISTENER_1 listener.

E. There are two listeners named LISTENER and LISTENER_1 running simultaneously using port 1521 on the same host as the database in LISTENERS.