ITPub博客

（53）You set the following parameters in the parameter file and restarted the database:MEMORY_MAX_TARGET=0MEMORY_TARGET=500MPGA_AGGREGATE_TARGET=90MSGA_TARGET=270MWhich two statements are true about these parameters after the database instance is restarted? (Choose two.)A.The...

（52）View the Exhibits and examine lock waits.Users HR and SH complain that their transactions on one of the application tables, EMP, are waiting for response.Which action would you take to release the lock and enable users HR and SH to continue with their transactions?A.Kill the sessio...

（51）In a system, large online transaction processing (OLTP) jobs run during the daytime that require a large database buffer cache.In the night, the system supports batch jobs that require a higher value to be set for the large pool.You must simultaneously configure the memory components to...

（50）Which two statements are true about alerts? (Choose two.)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 not...

（49）View the Exhibit to examine the output of the DBA_OUTSTANDING_ALERTS view.After 30 minutes, you executed the following command:SQL> SELECT reason,metric_value FROM dba_outstanding_alerts;REASON                &...

（48）The job to gather optimizer statistics for objects runs as part of the automatic maintenance window in your database instance.At a certain point of time, the maintenance window closes before the statistics are gathered for all objects.Which statement is true in this scenario?A.The s...

（47）Your database instance is functional for the past one month.The Automatic Workload Repository (AWR) snapshot retention is set to 7 and the STATISTICS_LEVEL initialization parameter is set to TYPICAL.You receive a complaint about the poor performance of the database between 7 PM and 9 PM...

（46）Which two statements are true about the Automatic Database Diagnostic Monitor (ADDM)? (Choose two.)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...

（45）Which statement is true about the Manageability Monitor (MMON) background process?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 (AS...

（44）Your database is functional with a peak load for the last one hour.You want to preserve the performance statistics collected during this period to be used for comparison when you analyze the performance of the database in the future.What action would you take to achieve this task?A....

（43）In your database instance, the STATISTICS_LEVEL initialization parameter is set to BASIC. What is the 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 f...

（42）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...

（49）View the Exhibit to examine the output of the DBA_OUTSTANDING_ALERTS view.After 30 minutes, you executed the following command:SQL> SELECT reason,metric_value FROM dba_outstanding_alerts;REASON                ...

（40）You have statistics collected for some selected tables.Your requirement is that the statistics for the tables and all dependent indexes must not be overwritten by further statistics collection until a certain point of time.How would you achieve this?A. Lock statistics for the tables...

（39）Which two statements are true about standard database auditing? (Choose two.)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 fo...

（38）To make audit information more productive, the DBA executes the following command before starting an 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 the database...

（37）You execute the following command to audit database activities:SQL> AUDIT DROP ANY TABLE BY scott BY SESSION WHENEVER SUCCESSFUL;What is the effect of this command?A.One audit record is created for every successful DROP TABLE command executed in the session of SCOTT.B.One audit ...

（36）In your production database, data manipulation language (DML) operations are executed on the SALES table.You have noticed some dubious values in the SALES table during the last few days.You are able to track users, actions taken, and the time of the action for this particular period but...

（35）You executed the command to create a password file in the database server:$ orapwd file=orapworcl entries=5 ignorecase=NWhich 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 username...

（34）A user, who is authenticated externally, logs in to a remote machine and connects to the database instance.What action would you take to ensure that a user cannot connect to the database instance by merely logging in to a remote machine?A.Set REMOTE_OS_ROLES to FALSE.B.Set the OS_RO...