![](https://img-blog.csdnimg.cn/20201014180756918.png?x-oss-process=image/resize,m_fixed,h_64,w_64)
1z0-052
文章平均质量分 55
今年我18
娃哈哈
展开
-
1.View the Exhibit and examine the attributes of an undo tablespace.
1.View the Exhibit and examine the attributes of an undo tablespace.原创 2016-04-14 11:57:28 · 1188 阅读 · 0 评论 -
45.Which statement is true about the Manageability Monitor (MMON) background process?
45.Which statement is true about the Manageability Monitor (MMON) background process?原创 2016-07-22 14:44:27 · 1325 阅读 · 0 评论 -
46.Which two statements are true about the Automatic Database Diagnostic Monitor (ADDM)? (Choose two
46.Which two statements are true about the Automatic Database Diagnostic Monitor (ADDM)? (Choose two.)原创 2016-07-22 14:50:51 · 1475 阅读 · 0 评论 -
47.Your database instance is functional for the past one month. The Automatic Workload Repository (A
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 toTYPICAL.You receive a complaint about the poor performance o原创 2016-07-22 15:52:49 · 806 阅读 · 0 评论 -
48.The job t gather optimizer statistics for objects runs as part of the automatic maintenance windo
48.The job t 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.原创 2016-07-22 16:49:21 · 817 阅读 · 0 评论 -
49.View the Exhibit to examine the output of the DBA_OUTSTANDING_ALERTS view.
49.View the Exhibit to examine the output of the DBA_OUTSTANDING_ALERTS view.原创 2016-07-22 17:15:52 · 1027 阅读 · 0 评论 -
50.Which two statements are true about alerts? (Choose two.)
50.Which two statements are true about alerts? (Choose two.)原创 2016-07-22 18:25:22 · 1447 阅读 · 0 评论 -
51.In a system, large online transaction processing (OLTP) jobs run during the daytime that require
51.In a system, large online transaction processing (OLTP) jobs run during the daytime that require alarge database buffer cache. In the night, the system supports batch jobs that require a higher value to beset for the large pool. You must simultaneousl原创 2016-07-22 23:13:54 · 1107 阅读 · 0 评论 -
52.View the Exhibits and examine lock waits. Users HR and SH complain that their transactions on one
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 forresponse.Which action would you take to release the lock and enable users HR and SH to continue with their原创 2016-07-23 07:13:04 · 955 阅读 · 0 评论 -
53.You set the following parameters in the parameter file and restarted the database: MEMORY_MAX_TAR
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 restar原创 2016-07-23 13:01:28 · 2623 阅读 · 0 评论 -
54.Automatic Shared Memory Management (ASMM) has been enabled for your database instance. The initia
54.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> A原创 2016-07-23 22:03:57 · 823 阅读 · 0 评论 -
55.View the Exhibit to examine the output produced by the following query at three different times s
55.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_s原创 2016-07-23 22:17:52 · 1034 阅读 · 0 评论 -
56.View Exhibit1 and Exhibit2 to examine the current memory allocation and parameter settings, respe
56.View Exhibit1 and Exhibit2 to examine the current memory allocation and parameter settings,respectively.原创 2016-07-23 22:37:22 · 877 阅读 · 0 评论 -
57.Automatic Shared Memory Management is disabled for your database instance. You realize that there
57.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 indegraation of performance.What would be your next step to原创 2016-07-23 23:30:03 · 995 阅读 · 0 评论 -
58.View the Exhibit and examine the parameters.
58.View the Exhibit and examine the parameters.原创 2016-07-24 00:25:46 · 807 阅读 · 0 评论 -
59.In your database, the current status of a PL/SQL procedure has become INVALID. Which action woul
59.In your database, the current status of a PL/SQL procedure has become INVALID. Which action would fix the problem and make the PL/SQL procedure usable?原创 2016-07-24 00:29:56 · 504 阅读 · 0 评论 -
60.In which of the scenarios will the DBA perform recovery? (Choose all that apply.)
60.In which of the scenarios will the DBA perform recovery? (Choose all that apply.)原创 2016-07-24 15:57:56 · 760 阅读 · 0 评论 -
61.Given below is a list of scenarios: 1) A user terminates his session abnormally. 2) The connectio
61.Given below is a list of scenarios:1) A user terminates his session abnormally.2) The connection between the server and the client application terminates because of a network failure.3) A schema is accidentally dropped.4) The tablespace is accidenta原创 2016-07-24 16:30:23 · 597 阅读 · 0 评论 -
62.You are in the middle of a transaction updating a very important table. The machine on which a da
62.You are in the middle of a transaction updating a very important table. The machine on which adatabase was running reboots because of power outage. This caused a database instance failure.Which statement is true in this situation?原创 2016-07-24 19:42:58 · 1194 阅读 · 0 评论 -
63.Examine the values for the following initialization parameters: FAST_START_MTTR_TARGET = 0 LOG_CH
63.Examine the values for the following initialization parameters:FAST_START_MTTR_TARGET = 0LOG_CHECKPOINT_INTERVAL = 0Which two will be the implications of these values in your database? (Choose two.)原创 2016-07-25 11:48:18 · 1212 阅读 · 0 评论 -
64.Which two statements are true about setting the FAST_START_MTTR_TARGET initialization parameter t
64.Which two statements are true about setting the FAST_START_MTTR_TARGET initializationparameter to a nonzero value? (Choose two.)原创 2016-07-25 11:54:29 · 1443 阅读 · 0 评论 -
65.Which two statements are true about checkpointing? (Choose two.)
65.Which two statements are true about checkpointing? (Choose two.)原创 2016-07-25 15:27:27 · 1483 阅读 · 0 评论 -
66.You notice that the performance of the database has degraded because of frequent checkpoints. Whi
66.You notice that the performance of the database has degraded because of frequent checkpoints.Which two actions resolve the issue? (Choose two.)原创 2016-07-25 15:48:36 · 1051 阅读 · 0 评论 -
67.The instance abnormally terminates because of a power outage. Which statement is true about redo
67.The instance abnormally terminates because of a power outage. Which statement is true about redolog files during instance recovery?原创 2016-07-25 15:56:36 · 1374 阅读 · 0 评论 -
68.You are managing an Oracle Database 11g database. You want to ensure the recovery of the database
68.You are managing an Oracle Database 11g database. You want to ensure the recovery of thedatabase to the point of failure. Which configuration will you do to accomplish the task?原创 2016-07-25 16:19:25 · 958 阅读 · 0 评论 -
6.Note the following points describing various utilities in Oracle Database 11g:
6.Note the following points describing various utilities in Oracle Database 11g:原创 2016-07-14 18:15:51 · 1251 阅读 · 0 评论 -
5.The database instance is currently using SPFILE. View the Exhibit and examine the error that you
5.The database instance is currently using SPFILE. View the Exhibit and examine the error that you原创 2016-07-14 17:53:57 · 1018 阅读 · 0 评论 -
7.You have issued a SHUTDOWN ABORT command to bring down your database instance. Considerthe steps t
the steps that will be performed later when you open the database:原创 2016-07-15 11:40:14 · 546 阅读 · 0 评论 -
8.Observe the information in the columns:
8.Observe the information in the columns:原创 2016-07-15 15:45:22 · 490 阅读 · 0 评论 -
69.You are working on an instance started using the SPFILE. You want to move the Flash Recovery Area
69.You are working on an instance started using the SPFILE. You want to move the Flash Recovery Areaof your database to a new location. You want the Flashback log files to be stored in the new location.Given below are the steps to accomplish the task in原创 2016-07-26 16:07:31 · 20983 阅读 · 0 评论 -
70.You configured the Flash Recovery Area (FRA) for your database. The database instance is running
70.You configured the Flash Recovery Area (FRA) for your database. The database instance is runningin ARCHIVELOG mode. The default location for the archived redo log files is the Flash Recovery Area.Which two files are removed automatically if the space原创 2016-07-26 17:58:25 · 1499 阅读 · 0 评论 -
71.You configured the Flash Recovery Area for your database. The database instance has been started
71.You configured the Flash Recovery Area for your database. The database instance has been startedin ARCHIVELOG mode and the LOG_ARCHIVE_DEST_1 parameter is not set.What will be the implications on the archiving and the location of archive redo log file原创 2016-07-26 18:13:42 · 1495 阅读 · 0 评论 -
72.You want to enable archiving on your database. Presently, the database is running in NOARCHIVELOG
72.You want to enable archiving on your database. Presently, the database is running inNOARCHIVELOG mode. Given below are the steps to accomplish the task in random order:1: Shut down the instance.2: Execute the ALTER DATABASE ARCHIVELOG command.3: Sta原创 2016-07-26 18:21:56 · 942 阅读 · 0 评论 -
73.You are managing an Oracle Database 11g database. You configured the database to run in ARCHIVELO
73.You are managing an Oracle Database 11g database. You configured the database to run inARCHIVELOG mode. Which two statements are true in this scenario? (Choose two.)原创 2016-07-26 18:35:58 · 766 阅读 · 0 评论 -
9.View the Exhibit and examine the privileges granted to the SL_REP user.
9.View the Exhibit and examine the privileges granted to the SL_REP user.原创 2016-07-15 16:26:19 · 1612 阅读 · 0 评论 -
10.Examine the following statement that is used to modify the constraint on the SALES table:
10.Examine the following statement that is used to modify the constraint on the SALES table:原创 2016-07-15 17:18:00 · 882 阅读 · 0 评论 -
11.Identify the memory component from which memory may be allocated for:
11.Identify the memory component from which memory may be allocated for:原创 2016-07-15 17:38:42 · 954 阅读 · 0 评论 -
74.The database is running in ARCHIVELOG mode. Examine the initialization parameters and their value
74.The database is running in ARCHIVELOG mode. Examine the initialization parameters and theirvalues set to enable archiving on your database server:原创 2016-07-26 21:18:05 · 1809 阅读 · 0 评论 -
75.Your test database is configured to run in NOARCHIVELOG mode. One of the data files in the USERS
75.Your test database is configured to run in NOARCHIVELOG mode. One of the data files in the USERStablespace is lost due to a media failure. You notice that all the online redo logs have been overwrittensince the last backup.What would you do to recove原创 2016-07-26 21:24:51 · 836 阅读 · 0 评论 -
76.Which statement is true about a whole consistent database backup on a database running in ARCHIVE
76.Which statement is true about a whole consistent database backup on a database running inARCHIVELOG mode?原创 2016-07-26 21:30:41 · 1472 阅读 · 0 评论