View the Exhibit and examine the parameters.
User A executes the following command to update the TRANS table： SQL> UPDATE B.trans SET tr_amt=tr_amt+500 WHERE c_code=’C005’；
Before user A issues a COMMIT or ROLLBACK command， user B executes the following command onthe TRANS table：
SQL> ALTER TABLE trans MODIFY （tr_type VARCHAR2（3））；
What would happen in this scenario（）
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.
您可能感兴趣的试卷
你可能感兴趣的试题
Automatic Shared Memory Management is disabled for your database instance. You realize that thereare cases of SQL statements performing poorly because of repeated parsing activity， resulting indegradation of performance.
What would be your next step to improve performance？ （）
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.
View Exhibit1 and Exhibit2 to examine the current memory allocation and parameter settings，respectively.
Why are advisors not available for the shared pool and 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
View the Exhibit to examine the output produced by the following query at three different times sincethe database instance started and has experienced workloads of different capacities：
SQL> SELECT substr（component， 0， 10） COMP， current_size CS，user_specified_size USFROM v$memory_dynamic_componentsWHERE current_size!=0；
What do you infer from this（）
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.
Automatic Shared Memory Management （ASMM） has been enabled for your database instance.
Theinitialization parameters for the components that are managed by ASMM are not set. After observing theeffects of ASSM， you executed the following command： SQL> ALTER SYSTEM SET DB_CACHE_SIZE = 100M；
Which statement is true in this scenario（）
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
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 theirtransactions（）
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.
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 METRIC_VALUE
------------------------------------------------------------ ------------
Tablespace [TEST] is [28 percent]full 28.125
What could be the reason for the elimination of the other rows in the output（）
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.
The job to gather optimizer statistics for objects runs as part of the automatic maintenance window inyour database instance. At a certain point of time， the maintenance window closes before the statisticsare gathered for all objects.
Which statement is true in this scenario（）
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.
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 of theprevious day.
Choose two actions any of which can be referred to first to diagnose the problem. （）
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.
最新试题
You have two database servers SEMP and SACCT. The database in the SEMP server maintains the employeeinformation and the database in the SACCT server maintains the accounts payable information. The employeessubmit the expense reports to the accounts payable department. A user of the accounts payable databasewants to extract the employee information from the database in the SEMP server for cross-verification. Whichschema object enables the user to access the information from the remote database（）
In which situation is the UNDO_RETENTION parameter be ignored， even if it is set to a value（）
Your database instance is running with full workload after database creation. You have decided to use a fixed-size undo tablespace. You want to use the Undo Advisor to estimate the capacity of the undo tablespace.Which two factors must you consider before using the Undo Advisor to estimate the capacity of the undotablespace（）
You configured the Flash Recovery Area （FRA） for your database. The database instance is running inARCHIVELOG mode. The default location for the archived redo log files is the Flash Recovery Area. Which twofiles are removed automatically if the space is required in the FRA as per the retention policy（）
Your database is functional with a peak load for the last one hour. You want to preserve the performancestatistics collected during this period to be used for comparison when you analyze the performance of thedatabase in the future. What action would you take to achieve this task（）
Which statement is true about loading data using the conventional path of SQL*Loader（）
Which statements regarding the server parameter file （SPFILE） are true（）
View the Exhibit and examine the privileges granted to the SL_REP user. The EMP table is owned by theSCOTT user. The SL_REP user executes the following command：SQL> GRANT SELECT ON scott.emp TO hr；Which statement describes the outcome of the command（）
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（）
The user HR receives the following error while inserting data into the TTK table：ERROR at line 1：ORA-01653： unable to extend table HR.TTK by 128 in tablespace SMD Upon investigation， you find that SMDis a small file tablespace.Which three action would allow the user to insert data（）