Posts

1Z0-026 Oracle8i: Network Administration Part 1

Oracle8i: Network Administration Part 1 Get Full Version on: http://www.getfreedumps.com/ QUESTION 1 When is the request sent to a listener? A. After every call. B. Before every call. C. After name resolution. D. Before name resolution. Correct Answer: C Section: (none) Explanation Explanation/Reference: Explanation: Answer C is correct. In order for Net8 to recognize the connect string you provide as a valid representation for a database somewhere on the network, your connect string must map to a connect descriptor, which is a description of the Oracle service you want to connect to. Net8 then travels the network, looking for the host machine named in the descriptor. Once found, Net8 calls on that machine using the specific port identified in the connect descriptor. A listener process should be running on the server, turned into that particular port, waiting for user processes to call. Incorrect Answers: A: is incorrect; you don't need ...

1Z0-024 Oracle8i: Performance and Tuning Part 3

Oracle8i: Performance and Tuning Part 3 Get Full Version on: http://www.getfreedumps.com/ QUESTION 21 Where can you find the nondefault parameters when the instance is started? A. Alert log B. Online redo log C. Archived redo log D. SYSTEM user's trace file Correct Answer: A Section: (none) Explanation Explanation/Reference: Explanation: You can find non-default parameters for started instance in Alert log file. Incorrect Answers: B: Online redo logs do not contain non-default Oracle parameters for instance. C: Archived redo logs do not contain non-default Oracle parameters for instance, it's just archived version of online redo logs. D: Trace file for SYSTEM user can not be used for this purpose. Oracle 8, DBA Certification Exam Guide, Jason S. Couchman, p. 754-757. Chapter 16: Introducing Database Tuning QUESTION 22 What should be two goals in tuning rollback segments. (Choose two) A. Transactions should never wait for ...