READ Free Dumps For
Warning: Undefined variable $vendor in /home1/bandbozu/getfreedumps.com/quiz.php on line 141
-
Warning: Undefined variable $exam_number in /home1/bandbozu/getfreedumps.com/quiz.php on line 141
| Question ID 20780 | 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?
|
| Option A | Statistics collection is not done for the CUSTOMERS table when schema stats are gathered.
|
| Option B | Statistics collection is not done for the CUSTOMERS table when database stats are gathered.
|
| Option C | Any existing statistics for the CUSTOMERS table are still available to the optimizer at parse time.
|
| Option D | Statistics gathered on the CUSTOMERS table when schema stats are gathered are stored as pending statistics.
|
| Option E | Statistics gathered on the CUSTOMERS table when database stats are gathered are stored as pending statistics.
|
| Correct Answer | C,D,E |
Explanation * SET_TABLE_PREFS Procedure This procedure is used to set the statistics preferences of the specified table in the specified schema. * Example: Using Pending Statistics Assume many modifications have been made to the employees table since the last time statistics were gathered. To ensure that the cost-based optimizer is still picking the best plan, statistics should be gathered once again; however, the user is concerned that new statistics will cause the optimizer to choose bad plans when the current ones are acceptable. The user can do the following: EXEC DBMS_STATS.SET_TABLE_PREFS('hr', 'employees', 'PUBLISH', 'false'); By setting the employees tables publish preference to FALSE, any statistics gather from now on will not be automatically published. The newly gathered statistics will be marked as pending.
| Question ID 21363 | Which feature needs to be configured in Connection Manager to enable your system to scale to a large number
of users?
|
| Option A | Connection Pooling
|
| Option B | Network access control
|
| Option C | Connection concentration
|
| Option D | Multiple protocol interchange
|
| Correct Answer | C |
Explanation Explanation: Answer C is correct. Connection Manager takes an additional approach to scalability by providing you with the ability to concentrate many logical client sessions through a single transport connection to the Oracle multithreaded server. With multiple Connection Managers, you can connect thousands of clients to a server concurrently by minimizing the network bandwidth used by Oracle clients. Connection concentration reduces the need to maintain connections between two processes. Since you maintain fewer connection end points for incoming requests, you increase the sessions a server can handle. Incorrect Answers: A is incorrect; connection pooling can be used to maximize the number of physical connections that can be made to the Oracle database. B is incorrect; network access control feature in Connection Manager is used to regulate access between two different networks using Net8 as a firewall. D is incorrect; multiple protocol interchange feature helps to listen on more than one address for connections from different network protocols.