-
编辑 删除
042-122
122. You received complaints about the degradation of SQL query performance. You identified top SQL queries that consume time. What would be your next step to find out recommendations about statistics...
-
编辑 删除
042-120
120. In the PROD database you have granted the RESUMABLE system privilege to the CONNECT role. Resumable space operation has been enabled for all user sessions. You want users NOT to be aware of any k...
-
编辑 删除
042-119
119. View the Exhibit to observe the message received while trying to drop the SL_REP user in Oracle Enterprise Manager. The SL_REP user owns objects and is currently connected to the database instanc...
-
编辑 删除
042-118
118. You notice this warning in the alert log file:ORA-19815: WARNING: db_recovery_file_dest_size of 3221225472 bytes is 100.00% used, and has 0 remaining bytes available.What would you do to reclaim ...
-
编辑 删除
042-117
117. You work in a data warehouse environment that involves the execution of complex queries. The current content of the SQL cache holds the ideal workload for analysis.You want to analyze only few mo...
-
编辑 删除
042-115
115. View the Exhibit to examine the output of the DBA_OUTSTANDING_ALERT view.After 30 minutes, you executed the following command:SQL> SELECT reason,metric_value FROM dba_outstanding_alerts;REASON ME...
-
编辑 删除
042-112
112. A user wants to connect to the database instance from an application that is running on a remote machine. Which tools should the DBA use to establish the required configuration to ensure that the...
-
编辑 删除
042-111
111. Which three statements are correct about temporary tables? (Choose three.)A) Indexes and views can be created on temporary tables.B) Both the data and the structure of temporary tables can be exp...
-
编辑 删除
042-111
111. Which three statements are correct about temporary tables? (Choose three.)A) Indexes and views can be created on temporary tables.B) Both the data and the structure of temporary tables can be exp...
-
编辑 删除
042-110
110. What are the consequences of executing the SHUTDOWN ABORT command? (Choose two.)A) The database files are synchronized.B) Uncommitted changes are not rolled back.C) The database is closed, but th...
-
编辑 删除
042-108
108. In your database, the snapshot interval is set to 10 minutes for the Automatic Workload Repository (AWR). The database instance is running for the past 30 daysView the Exhibit to examine the Auto...
-
编辑 删除
042-106
106. The HR user owns the EMP table. The HR user grants privileges to the SCOTT user by using this command:SQL> GRANT SELECT, INSERT, UPDATE ON emp TO scott WITH GRANT OPTION;The SCOTT user executes t...
-
编辑 删除
042-105
105. Which statement regarding the contents of the V$PARAMETER view is true?A) displays only the list of default valuesB) displays only the list of all basic parametersC) displays the currently in eff...
-
编辑 删除
042-104
104: A constraint in a table is defined with the INITIALLY IMMEDIATE clause. You executed the ALTER TABLE command with the ENABLE VALIDATE option to enable the constraint that was disabled. What are t...
-
编辑 删除
042-100
100. You want to refer the employee personal information stored in operating system(OS) files in EMPLOYEE table. You plan to add a new column to EMPLOYEE table to achieve this.Which data type would yo...
-
编辑 删除
042-98
98. Which two statements about bigfile tablespaces are true? (Choose two.)A) The bigfile tablespace have only one data file.B) The segment space management is automatic.C) The extent management is dic...
-
编辑 删除
042-096
96. Which statement is true when you run the SQL Tuning Advisor with limited scope?A) Access path analysis is not performed for the SQL statements.B) SQL structure analysis is not performed for the SQ...
-
编辑 删除
042-095
95. Your database is functional with peak load for one hour. You want to preserve the performance statistics collected during this period so that they can be used for comparison while analyzing the pe...
-
编辑 删除
042-094
94. The UNDO_RETENTION parameter in your database is set to 1000 and undo retention is not guaranteed.Which statement regarding retention of undo data is correct?A) Undo data becomes obsolete after 1,...
-
编辑 删除
042-093
93. Your database is having two control files, three redo log file groups with two members in each group. Failure of which file would cause an instance to shut down?A) any control fileB) any archive l...
