Multiple choice technology databases

What will happen when Database Instance is up but Listner is not running

  1. you will not be able to connect locally ,but you can be able to connect to DB from remote

  2. you cannot be able to connect to DB either from remote or from local

  3. you cane to connect to DB either from remote or from local

  4. you will not be able to connect remotely ,but you can be able to connect to DB locally
Reveal answer Fill a bubble to check yourself
D Correct answer
Explanation

In Oracle, when the listener is down but the instance is up, local connections using IPC/bequeath protocol still work. Remote connections require the listener to establish the initial connection.

Keep practicing — related questions