Confusing Net Admin Real Question

[gtm]

what is pool parameter used for in connection pooling.

1. timeout in ticks for in coming connections
2. timeout in ticks for outgoing connections.
3. timeout in ticks for incoming and outgoing connections.
4. timeout in second for incoming and outgoing connections.

If anybody knows the answer. ( i first checked option 3 and then checnged it to 4). Not sure if it was correct.


Thanks,
gtm

[drak21]

I would go with Ans.#3 because the POOL parameter is never stated in second but in ticks. It is also used for both in and out connections.

[gtm]

You are right. The answer is 3.

There is another question i remember for which i changed the answer :

How would you know that hostnaming method is used ?.

1. sqlnet.ora
2. tnsnames.ora
3. listener.ora
4. init.ora

I changed from 1 to 3.


regards,

[drak21]

Review the details of the question and see if they are asking about client or server. If client, Ans. 1. If server Ans. 3

[gtm]

It was mentioned if it was a client or a server.

[Rookie]

Its number2. Tnsnames is always used for local naming for the sever as well as the client in Net8. If you click on Profile(sqlnet) you will get tnsnames as the method for the client.

[Rookie]

I read your question wrong if its for hostnaming then its definitately sqlnet.ora and not tnsnames (for local naming only)

[Rookie]

Further to my answer being the Sqlnet.ora as opposed to choosing the listener (which would be on the server in hostnaming) is because if you recall what the Sqlnet.ora parameters actually contain. The listener doesn't confirm the method you're using it just gives you the address names, protocol and Sid. Whereas in the Sqlnet.ora file(Names.directory_path=Hostname)shows you the method that you will be using.

[Raminder]

Originally posted by gtm

How would you know that hostnaming method is used ?.

1. sqlnet.ora
2. tnsnames.ora
3. listener.ora
4. init.ora

The answer is 1. SQLNET.ORA

[gtm]

From the previous posts it seems that the answer is sqlnet.ora but the methods mentioned in names.directory_path might not exist, however, they are mentioned in there.

Does it not make sure that the hostnaming method is used, if global_dbname and m/c name is same in listener.ora ?


I passed the exam but the number of wrong questions are the same for which i changed the answers while revising,
so a little curious to know the answers.


thanks,