一抹曦阳-Oracle

Life is a journey, not the destination, but the scenery along the should be and the mood at the view

OCP-1Z0-053-200题-187题-610

QUESTION 187 Which of the following advisors is run in every maintenance window by the auto-task system? A. The Memory Advisor B. The SQL Tuning A...

2014-01-31 23:21:34

阅读数:2649

评论数:0

OCP-1Z0-053-200题-188题-369

QUESTION 188 Which of the following identifies and creates an index to minimize the DB time for a particular SQL statement? A. The SGA Tuning Advis...

2014-01-31 22:42:08

阅读数:3619

评论数:0

OCP-1Z0-053-200题-189题-403

QUESTION 189 To view the results of the most recent Automatic SQL Tuning Advisor task, which sequence should you follow? A. EM Database home page, ...

2014-01-31 22:23:27

阅读数:2722

评论数:0

OCP-1Z0-053-200题-190题-405

QUESTION 190 To view the results of a manual SQL Tuning Advisor task, which steps should the DBA take? A. From the Advisor Central home page, selec...

2014-01-31 22:22:10

阅读数:2686

评论数:0

OCP-1Z0-053-200题-191题-406

QUESTION 191 Which of these appropriately describes the results of a manual SQL Tuning Advisor task? A. A list of SQL statements and recommendation...

2014-01-31 22:12:10

阅读数:2865

评论数:0

OCP-1Z0-053-200题-193题-493

QUESTION 193 Which three statements about performance analysis by SQL Performance Analyzer are true? (Choose three.) A. It detects changes in SQL e...

2014-01-31 22:05:21

阅读数:2937

评论数:0

OCP-1Z0-053-200题-195题-255

QUESTION 195 Which two statements about the SQL Management Base (SMB) are true? (Choose two.) A. It contains only SQL profiles generated by SQL Tun...

2014-01-31 11:30:47

阅读数:2691

评论数:0

OCP-1Z0-053-200题-196题-298

QUESTION 196 While tuning a SQL statement, the SQL Tuning Advisor finds an existing SQL profile for the statement that has stale statistics availab...

2014-01-31 11:28:57

阅读数:3059

评论数:0

OCP-1Z0-053-200题-197题-509

QUESTION 197 Which of the following cannot be used as input to the SQL Tuning Advisor? (Choose all that apply.) A. A single SQL statement provided ...

2014-01-31 11:24:44

阅读数:3264

评论数:0

OCP-1Z0-053-200题-198题-44

QUESTION 198 You have a very large table that your users access frequently. Which of the following advisors will recommend any indexes to improve t...

2014-01-31 11:00:14

阅读数:2714

评论数:0

OCP-1Z0-053-200题-199题-159

QUESTION 199 Which package provides API's for the SQL Tuning Advisor? A. DBMS_MONITOR B. DBMS_STATS C. DBMS_SQLTUNE D. DBMS_ADVISOR Answer: C ...

2014-01-30 18:27:38

阅读数:2469

评论数:0

OCP-1Z0-053-200题-204题-255

QUESTION 204 Which two statements about the SQL Management Base (SMB) are true? (Choose two.) A. It contains only SQL profiles generated by SQL Tun...

2014-01-30 18:17:59

阅读数:2653

评论数:0

OCP-1Z0-053-200题-36题-615

QUESTION 36 Before a Flashback Table operation, you execute the following command: ALTER TABLE employees ENABLE ROW MOVEMENT; Why would you need t...

2014-01-28 15:54:25

阅读数:2943

评论数:0

OCP-1Z0-053-200题-35题-614

QUESTION 35 Which three types of files can be automatically placed in the flash recovery area (fast recovery area in 11g Release 2)? (Choose three....

2014-01-27 23:23:46

阅读数:3850

评论数:0

OCP-1Z0-053-200题-33题-612

QUESTION 33 Examine the following command used to perform incremental level 0 backup: RMAN> BACKUP INCREMENTAL LEVEL 0 DATABASE; To enable the ...

2014-01-27 22:35:32

阅读数:4771

评论数:0

OCP-1Z0-053-V13.02-612题

612.Examine the following command used to perform incremental level 0 backup: RMAN> BACKUP INCREMENTAL LEVEL 0 DATABASE; To enable the block c...

2014-01-27 22:33:43

阅读数:7984

评论数:1

OCP-1Z0-053-200题-32题-611

QUESTION 32 To accomplish user-managed backup for the USERS tablespace, you issued the following command to put the database in backup mode: SQL&g...

2014-01-27 21:37:15

阅读数:3833

评论数:0

OCP-1Z0-053-V13.02-611题

611.To accomplish user-managed backup for the USERS tablespace, you issued the following command to put the database in backup mode: SQL> ALTER ...

2014-01-27 21:35:39

阅读数:5233

评论数:0

OCP-1Z0-053-200题-31题-131

QUESTION 31 View the Exhibit to examine the parameter values. You are planning to set the value for the MEMORY_TARGET parameter of your datab...

2014-01-27 15:25:59

阅读数:3611

评论数:0

OCP-1Z0-053-200题-126题-264

QUESTION 126 Using the LIST command in Recovery Manager (RMAN), which two pieces of information in the RMAN repository can be listed? (Choose two.)...

2014-01-27 15:21:59

阅读数:2941

评论数:0

提示
确定要删除当前文章?
取消 删除
关闭
关闭