Question 286
Which two statements are true about Oracle Data Pump export and import operations? (Choose two.)
Question 287
Which set of statements is true about data dictionary views?
1. They are stored in the SYSTEM tablespace.
2. They are based on virtual tables.
3. They are owned by the SYS user.
4. They can be queried by a normal user only if the 07_DICTIONARY_ACCESSIBILITY parameter is set to TRUE.
5. The V$FIXED_TABLE view can be queried to list the names of these views.
6. They are owned by the SYSTEM user.
1. They are stored in the SYSTEM tablespace.
2. They are based on virtual tables.
3. They are owned by the SYS user.
4. They can be queried by a normal user only if the 07_DICTIONARY_ACCESSIBILITY parameter is set to TRUE.
5. The V$FIXED_TABLE view can be queried to list the names of these views.
6. They are owned by the SYSTEM user.
Question 288
Identify three scenarios in which you would recommend the use of SQL Performance Analyzer to analyze impact on the performance of SQL statements. (Choose three.)
Question 289
Examine the resources consumed by a database instance whose current Resource Manager plan is displayed.
Which two statements are true?
Which two statements are true?
Question 290
Examine this command:
SQL > exec DBMS_STATS.SET_TABLE_PREFS ('SH', 'CUSTOMERS', 'PUBLISH', 'false'); Which three statements are true about the effect of this command? (Choose three.)
SQL > exec DBMS_STATS.SET_TABLE_PREFS ('SH', 'CUSTOMERS', 'PUBLISH', 'false'); Which three statements are true about the effect of this command? (Choose three.)