A.It transfers statistics from memory to disk at regular intervals.
B.It coordinates the rebalance activity for disk groups when ASM is used.
C.It communicates with the Automatic Storage Management (ASM) instance on behalf of the databaseinstance.
D.It performs dynamic memory management when Automatic Shared Memory Management is enabledfor the database instance.
您可能感兴趣的试卷
你可能感兴趣的试题
Your database is functional with a peak load for the last one hour. You want to preserve theperformance statistics collected during this period to be used for comparison when you analyze theperformance of the database in the future.
What action would you take to achieve this task()
A.Insert finding directives for ADDM tasks in the future.
B.Create a baseline on a pair of snapshots spanning the peak-load period.
C.Decrease the snapshot interval in the AWR to collect more snapshots during the peak-load period.
D.Set the snapshot retention period in the Automatic Workload Repository (AWR) to zero to avoid automatic purging of snapshots.
In your database instance, the STATISTICS_LEVEL initialization parameter is set to BASIC.
What isthe impact of this setting()
A.Optimizer statistics are collected automatically.
B.Only timed operating system (OS) statistics and plan execution statistics are collected.
C.The snapshots for the Automatic Workload Repository (AWR) are not generated automatically.
D.Snapshots cannot be collected manually by using the DBMS_WORKLOAD_REPOSITORY package.
E.The Oracle server dynamically generates the necessary statistics on tables as part of query optimization.
Examine the command:
SQL> DBMS_STATS.SET_TABLE_PREFS(’SH’, ’CUSTOMERS’, ’PUBLISH’, ’false’); Which statement describes the effect of the above command()
A.Automatic statistics collection is stopped for the CUSTOMERS table.
B.Statistics for the CUSTOMERS table are locked and cannot be overwritten.
C.Existing statistics for the CUSTOMERS table become unusable for the query optimizer.
D.Subsequently, statistics gathered on the CUSTOMERS table are stored as pending statistics.
A.DDL statements can be audited.
B.Statements that refer to stand-alone procedure can be audited.
C.Operations by the users logged on as SYSDBA cannot be audited.
D.Only one audit record is ever created for a session per audited statement even though it is executedmore than once.
To make audit information more productive, the DBA executes the following command before startingan audit operation:
SQL> ALTER SYSTEM SET AUDIT_TRAIL=DB,EXTENDED SCOPE=SPFILE;
Which statement is true regarding the audit record generated when auditing starts after restarting thedatabase()
A.It contains only the plan for the SQL statement executed by the user.
B.It contains the SQL text executed by the user and the bind variables used with it.
C.It contains the plan and statistics associated with the SQL statement executed by the user.
D.It contains the plan for the SQL statement executed by the user and the bind variables used with it.
You execute the following command toauditdatabase activities:
SQL>AUDITDROP ANY TABLE BY scott BY SESSION WHENEVER SUCCESSFUL;
What is the effect of this command()
A.Oneauditrecord is created for every successful DROP TABLE command executed in the session ofSCOTT.
B.Oneauditrecord is generated for the session when SCOTT grants the DROP ANY TABLE privilege toother users.
C.One audit record is created for the whole session if user SCOTT successfully drops one or more tablesin his session.
D.One audit record is created for every session of any other user in which a table owned by SCOTT isdropped successfully.
E.One audit record is created for every successful DROP TABLE command executed by any user to droptables owned by SCOTT.
In your production database, data manipulation language (DML) operations are executed on theSALES table. You have noticed some dubious values in the SALES table during the last few days. Youare able to track users, actions taken, and the time of the action for this particular period but the changesin data are not tracked. You decide to keep track of both the old data and new data in the table along withthe user information.
What action would you take to achieve this task()
A.Apply fine-grained auditing.
B.Implement value-based auditing.
C.Impose standard database auditing to auditobject privileges.
D.Impose standard databaseauditing to audit SQL statements.
ou executed the command to create a password file in the database server: $ orapwd file=orapworcl entries=5 ignorecase=N
Which statement describes the purpose of the above password file()
A.It records usernames and passwords of users when granted the DBA role.
B.It contains usernames and passwords of users for whom auditing is enabled.
C.It is used by Oracle to authenticate users for remote database administration.
D.It records usernames and passwords of all users when they are added to OSDBA or OSOPER operating system groups.
Your database instance is running with full workload after database creation. You have decided to useafixed-sizeundo tablespace. You want to use the Undo Advisor to estimate the capacity of the undotablespace.
Which two factors must you consider before using the Undo Advisor to estimate the capacity of the undotablespace()
A.the retention period to support flashback
B.the expected length of the longest-running query
C.the number of undo tablespaces in the database
D.the size of the Flash Recovery Area for the database instance
A.It is the time period after which the undo data becomes obsolete.
B.It is the time period after which the committed undo data would be transferred to a temporarytablespace.
C.It is the minimum time period up to which the committed undo data would be retained if free undo spaceis available.
D.It is the time period after which the undo data is transferred to the Flash Recovery Area to provide readconsistency.
最新试题
View the Exhibit and examine the attributes of an undo tablespace. In an OLTP system, the user SCOTT hasstarted a query on a large table in the peak transactional hour that performs bulk inserts. The query runs formore than 15 minutes and then SCOTT receives the following error:ORA-01555: snapshot too oldWhat could be the reason for this error()
Which statements are true regarding listeners()
Which kinds of failures make the Data Recovery Advisor (DRA) generate a manual checklist?()
You want to configure and schedule offline database backups to run automatically. Which tool or utility wouldyou use to achieve this()
You are working on a database that must be functioning 24 hours a day, 7 days a week. The database isconfigured in ARCHIVELOG mode. Which two options do you have for performing user-managed backups()
In which situation is the UNDO_RETENTION parameter be ignored, even if it is set to a value()
After performing a clean shut down of the database instance for maintenance, you mount the database andthen execute a command to open the database:SQL> ALTER DATABASE OPEN;Which two statements are true()
You are managing an Oracle Database 11g database. You configured the database to run in ARCHIVELOGmode. Which two statements are true in this scenario()
Which statements regarding the server parameter file (SPFILE) are true()
Why does performance degrade when many UPDATE, INSERT, or DELETE statements are issued on a tablethat has an associated Bitmap index()