A.The ALTER TABLE command modifies the column successfully.
B.The DDL operation gets higher priority and transaction for user a is rolled back.
C.The ALTER TABLE command waits indefinitely until user a ends the transaction.
D.The ALTER TABLE command fails after waiting for 60 seconds due to the resource being busy.

A.Run the SQL Access Advisor.
B.Run the Memory Advisor for the sga.
C.Run the Memory Advisor for the pga.
D.Run the Memory Advisor for the shared pool.
E.Run the Memory Advisor for the buffer cache.

A.because the DB_CACHE_ADVICE parameter is set to OFF
B.because Automatic Memory Management （AMM） is disabled for the database instance
C.because Automatic Shared Memory Management （ASMM） is enabled for the database instance
D.because the values for the DB_CACHE_SIZE and SHARED_POOL_SIZE parameters were not setinitially

A.The database instance is running with manual PGA management.
B.The database instance is running with manual shared memory management.
C.The database instance has the MEMORY_TARGET value set to a nonzero value.
D.All sessions are connected to the database instance in dedicated mode， and no RMAN or parallelquery operations have been performed.

A.The minimum memory size for the database buffer cache is set to 100 mb.
B.The maximum memory size that can be obtained by the database buffer cache during ASMM is set to100 mb
C.The minimum memory size allocated for a server process in the database buffer cache in dedicatedmode is set to 100 mb.
D.The maximum memory size from the database buffer cache that can be released for dynamicdistribution during ASMM is set to 100 mb

A.Kill the session of the user SCOTT with session ID118.
B.Issue manual checkpoint using the ALTER SYSTEM command.
C.Modify the profile used by user SCOTT to reduce the CONNECT_TIME limit.
D.Flush the Shared Pool to remove the SQL statement causing "wait" in memory.

A.Clearing an alert sends the alert to the alert history.
B.Response actions cannot be specified with server-generated alerts.
C.The nonthreshold alerts appear in the DBA_OUTSTANDING_ALERTS view.
D.Server-generated alerts notify the problems that cannot be resolved automatically and requireadministrators to be notified.

A.An Automatic Workload Repository snapshot has been taken recently.
B.The non-threshold-based alerts are transferred to DBA_ALERT_HISTORY.
C.The threshold alerts conditions are cleared and the alerts are transferred to DBA_ALERT_HISTORY.
D.The threshold alerts related to database metrics are permanently stored in DBA_ALERT_HISTORY but not the threshold alerts related to instance metrics.

A.The statistics collection continues until all objects are processed.
B.The job is terminated and the statistics collected are restored to a time before the job started.
C.This produces an error and the statistics collected are locked until the next time that the maintenancewindow is opened.
D.The job is terminated and the statistics for the remaining objects are collected the next time that themaintenance window is opened.

A.Use the Active Session History report.
B.Use the AWR Compare Periods report.
C.Use an ADDM analysis between 7 PM and 9 PM of the previous day.
D.Use the AWR Compare Period report between 7 PM and 9 PM of the previous day.

A.The ADDM requires at least four AWR snapshots for analysis.
B.The ADDM runs after each AWR snapshot is collected automatically by MMON.
C.The results of the ADDM analysis are stored in the Automatic Workload Repository （AWR）.
D.The ADDM analysis provides only diagnostic information but does not provide recommendations.
E.The ADDM calls other advisors if required， but does not provide recommendations about the advisors.