Friday , October 20 2017
Home / Oracle DBA Interview Questions / ORACLE NETWORKING INTERVIEW QUESTIONS

ORACLE NETWORKING INTERVIEW QUESTIONS

NETWORKING INTERVIEW QUESTIONS
  1. What is the importance of SQLNET.ORA file?
    1. It helps in choosing the type of connection to be established from client to server
  1. What is the difference between TNSNAMES.ORA and SQLNET.ORA file?
    1. Tnsnames.ora will specify the entries on to which database to connect where as sqlnet.ora will tell which type of connection can be established
  1. How to ensure users are connecting to shared server architecture?
    1. By specifying SERVER=SHARED in TNS entry
  1. While user trying to connect as sysdba on windows machine, he is getting “insufficient privileges” error. What could be the reason?
    1. The OS username is not added to ORA_DBA group
      5.In a server, we have 12 oracle 10g databases. How many listeners will be created by default?
    1. Only one. But it is always preferred to have separate listeners
  1. How to check listener status at OS level?
    a.ps –ef | grep tns
  1. What are the troubleshoot steps you follow when user complains about database connectivity problem?
    1. Checking tns entry
    2. Checking listener status
    3. Do tnsping from client
    4. Based on the above results, we can analyze where the problem is
 
  1. 100 users connected to the database. At that time DBA stopped listener, what happens to those connections?
    1. Nothing will happen as they are already connected
  1. How will you check if a port number can be used or not while configuring a listener?
    1. Netstat
  1. What is database link and what is its use?
    1. It is a object used to pull remote database’s data to local database
  1. What is the difference between snapshot and materialized views?
    1. Snapshot won’t have log mechanism by which refresh time will increase day by day which is avoided inmaterialized views
  1. What is the difference between normal view and materialized view?
    1. Normal view is just a stored query and it doesn’t contain any data. Materialized view will store the data
  1. If a user complains that MV refresh is running slow, how you will react to that problem?
    1. First we will check if MV log size is more than the table. If so, we need to drop and recreate only MV log
    2. Sometimes it may happen due to many materialized views on a single table, in such case we need to identify which are not in use
  1. Which background process helps in MV refresh?
    1. Job queue cordinator (CJQ)
  1. What is distributed database management system?
    1. Having data in multiple databases and combining them into a pool is called DDMS
  1. What is two phase commit? Which env will use it?
    1. It is used in DDMS by which a transaction should be commited on both the databases, if not transaction will be rolled back
  1. When to use database triggers?
    1. In case we want to track some changes in the database

USER MANAGEMENT INTERVIEW QUESTIONS

Read More:
ORACLE INSTALLATION INTERVIEW QUESTIONS
ORACLE ARCHITECTURE INTERVIEW QUESTIONS
ORACLE BACKUP & RECOVERY

Comments

comments

Check Also

ORACLE BACKUP and RECOVERY INTERVIEW QUESTIONS

BACKUP & RECOVERY INTERVIEW QUESTIONS 1.What is the difference between cold and hot backup? a.COLD …

Leave a Reply

Your email address will not be published. Required fields are marked *