IMPORTANT DBA INTERVIEW QUESTIONS....
What are
the things you check before you install an oracle database on unix or linux or
windows platforms ?
How do you identify the pre-req os patches required for an oracle installation on HP or solaris or Linux platforms ?
How do you identify if the oracle software version you are installing is certified on the platform you are installing ?
What is emulator on unix and why do you need it ? What is xterm ?
What is XAUTHORITY env settings ?
What is root.sh ?
What is the importance of /etc/oraInst.loc or /var/opt/oracle/oraInst.loc ?
Why do you need environment file ? Does this get created automatically ? What the environment settings which are needed in environment file ?
What is oraenv,dbshut,dbstart,dbhome files ? Where can you find these ? Explain me about these files ?
What is the importance of /etc/oratab or /var/opt/oracle/oratab ?
What are the various kernel settings which you setup in oracle install on linux/unix ?
Why environment file is not needed in windows ?
What is oradim ? Why do you need this tool in windows ?
When do you need tnsnames.ora listener.ora and sqlnet.ora ? How do you configure these files ?
What is Net8 or SQL*Net means ? How do you get this software ?
What are the different sql net naming methods ?
What is onames or OID ?
What is semaphore ? How do you handle the instance crash ?
How do you run the o/s commands from oracle ?
What is mutating trigger ?
Can we use commit inside a trigger ?
How do you identify the pre-req os patches required for an oracle installation on HP or solaris or Linux platforms ?
How do you identify if the oracle software version you are installing is certified on the platform you are installing ?
What is emulator on unix and why do you need it ? What is xterm ?
What is XAUTHORITY env settings ?
What is root.sh ?
What is the importance of /etc/oraInst.loc or /var/opt/oracle/oraInst.loc ?
Why do you need environment file ? Does this get created automatically ? What the environment settings which are needed in environment file ?
What is oraenv,dbshut,dbstart,dbhome files ? Where can you find these ? Explain me about these files ?
What is the importance of /etc/oratab or /var/opt/oracle/oratab ?
What are the various kernel settings which you setup in oracle install on linux/unix ?
Why environment file is not needed in windows ?
What is oradim ? Why do you need this tool in windows ?
When do you need tnsnames.ora listener.ora and sqlnet.ora ? How do you configure these files ?
What is Net8 or SQL*Net means ? How do you get this software ?
What are the different sql net naming methods ?
What is onames or OID ?
What is semaphore ? How do you handle the instance crash ?
How do you run the o/s commands from oracle ?
What is mutating trigger ?
Can we use commit inside a trigger ?
How to enable the auditing in oracle ?
How do you send an email from oracle db ?
How can you schedule the monitoring from the database ?
Give me the detail steps for creating the database manually ?
Give me the detail steps for creating the database using DBCA ?
How to identify the version of the rdbms ?
How to identify the database components and their statuses ?
How to identify if I am using 64 bit oracle or 32 bit oracle ?
How do you approach a new database implementation for a dw or oltp project ? Tell me about key things which you take into consideration ?
Tell me about various RAID levels ?
Explain me about oracle memory structures and background processes ?
What is oracle instance ? What is Oracle SGA ? What are the various components exist in Oracle SGA ?
What is PGA ? Tell about the responsibilities of background processes such as pmon,smon,arc,rec,lck,qmn,aq,lgwr,dbwr ?
Which process retrieves the data from disk into memory ?
What is advanced queuing ? How do you enable this ?
Tell me about checkpoint process in oracle and SCN numbers in oracle.
What is the difference between dedicated and shared servers processes ?
In what kind of configuration, you see oracle dispatcher process ?
Explain me about the instance recovery processes such as rollforward and rollback ?
Explain me about library cache and data dictionary cache ?
Tell me the difference between startup restrict and startup ?
Explain me about the various stages of oracle startup process ?
Explain me about the oracle instance recovery ?
Explain me about the difference between shutdown transactional and shutdown normal ?
What are the various shutdown options which can be used and explain me about those ?
What are the various startup options which can be used and explain me about those ?
How do you identify the oracle alert log file ? controlfile ? trace file ? tns file ? listener file ?
How do you identify the software location(oracle_home) for a running database ?
List at least 25 famous unix commands which are needed for daily day-to-day dba work ?
How do you drop user tablespace and users ?
Explain me the database views which you look at to identify the physical structures of the database ?
Explain me the database views which you look at to identify the logical structures of the database ?
How do you calculate/identify the total database current size ?
How do you calculate/identify the table current size ?
How do you calculate/identify the tablespace current size ?
How do you calculate/identify the freespace in the database ?
How do you move the table from one tablespace to another tablespace ?
How do you resize the logfiles of the database ?
How do you add the log groups to the database ?
How do you drop the redog log groups ?
How do you rename/move the redo log members from one disk to another disk ?
How do you identify the user default tablespace ?
How do you change the user default tablespace ?
How do you specify the tablespace name when you create the table ? What is the syntax ?
How do you add the datafiles to the existing tablespace ?
Give me the syntax for creating the dictionary managed and locally managed tablespaces ?
Give me the syntax for resizing the datafile ?
How do you rename the database tablespaces ?
How do you rename the database datafiles ?
How do you relocate the datafiles for system tablespace ?
How do you relocate the datafiles for normal tablespace ?
How do you make the tablespace offline. What is the advantage. ?
How do you make the tablespace readonly. What is the advantage. ?
What is difference between readonly/offline ?
How do you identify the datafile associated with a table ? How do you know how big the table size is. ?
How do you add,rename the temp datafiles ?
How do you identify the archive logs location ?
How do you change the archive log location ?
How do you change the archive log format ?
How do you enable the archive log, disable the archive log ? Explain in detail about database instance ?
How do you identify if the database is running in archive log mode or no-archive log mode ?
What is export import ? How do you change the db char set or db block size ?
Give me the syntax to export the entire database. ?
Give me the syntax to import the entire database. ?
Give me the syntax to export one schema in the database ?
Give me the syntax to export one table in the database ?
What is data pump ?
Tell me about transportable tablespaces ?
Tell me about your experience with automation of startup shutdown in unix and windows ?
Did you ever heard of rc.d ? Tell me about what do you know about this ?
Tell me about your experience with using data pump ?
Tell me about flash back recovery feature of 10g ?
Tell me about your experience with DBMS_STATS ?
How do you collect the dictionary stats in 9i and 10g ?
How do you speed up the export/import process of entire database ? What approach/settings u use ?
What is external tables ? Give me the steps to set this up ?
Give me the steps to recover a drop table in 10g ?
What is table purge vs table truncate in 10g ?
How do you rewind the database in 10g ? Give me the steps ?
Give me the steps to recover the deleted rows using flashback query in 10g ?
No comments:
Post a Comment