Database. You want to know what caused this performance difference.
Which method or feature should you use?
Database Replay
Automatic Database Diagnostic Monitor (ADDM) Compare Period report
Active Session History (ASH) report
SQL Performance Analyzer
OE_ADMIN roles exist and are granted system privileges. You execute the
Command:
SQL>CREATE AUDIT POLICY table_aud PRIVILEGES CREATE ANY TABLE, DROP ANY TABLE ROLES hr_admin,oe_admin;
Which statement is True?
It succeeds and needs to be enabled to capture all SQL statements that
Require either the specified privileges or any privilege granted to the HR_ADMIN
Or OE_ADMIN role.
It fails because the command does not specify when the unified audit policy
Should be enforced.
It succeeds and starts capturing only successful SQL statements for all users
Who have either the specified privileges or roles granted to them.
It fails because system privileges cannot be granted with roles in the same Audit policy.
You use RMAN with a recovery catalog to back up your database to media and the
Database is uniquely identified in the recovery catalog.
You want to create a test database from the production database and allow the production database to remain open during the duplicate process.
You restore the database backups to a new host with the same directory structure as the production database and want to use the recovery catalog for future backups after the database is successfully restored to the new host.
How would you achieve this? choose one
by using the RMAN switch command to set the new location for the data files
by using the RMAN duplicate command with nofilenamecheck to recover the
Database to the new host
by using the RMAN duplicate command with dbid and set new name for
Tablespace to recover the database to the new host
by creating a new database in the new host, and then using the RMAN recover
Command
Media management interface (MMI).
Which two are true about the use of
The RMAN MMI?
You can use it to create proxy copies for database files.
You can use it to create proxy copies for entire file systems.
You can use it to create image copies for entire file systems.
You can use it to create image copies for database files.
Database. You want to know which change caused this performance
Difference. Which method or feature should you use?
Compare Period ADDM report
AWR Compare Period report
Active Session History (ASH) report
Taking a new snapshot and comparing it with a preserved snapshot.
Database has significantly degraded. Sometimes you are not able to connect
To the instance because it hangs. You do not want to restart the database
Instance. How can you detect the cause of the degraded performance?
Enable Memory Access Mode, which reads performance data from SGA.
Use emergency monitoring to fetch data directly from SGA for analysis.
Run Automatic Database Diagnostic Monitor (ADDM) to fetch information
From the latest Automatic Workload Repository (AWR) snapshots.
Use Active Session History (ASH) data and hang analysis in regular
Performance monitoring,
Use Flashback Database. Which two features or parameters manage space
Availability in the fast recovery area?
我来回答:
