Solve Your Every Day Technical Problem

1. Basic (Every DBA should answer correctly ALL these questions. This knowledge is just basic for a 3+ year experienced DBA) 1.1 Q- Which are the default passwords of SYSTEM/SYS? A-  MANAGER / CHANGE_ON_INSTALL 1.2 Q- How can you execute a script file in SQLPLUS? A- To execute a script file in SQLPlus, type @ and then the file name. 1.3 Q- Where can you find official Oracle documentation? A- tahiti.oracle.com 1.4 Q- What is the address of the Official Oracle Support? A- metalink.oracle.com or support.oracle.com 1.5 Q- What file will you use to establish Oracle connections from a remote client? A- tnsnames.ora 1.6 Q- How can you check if the database is accepting connections? A- lsnrctl status or lsnrctl services 1.7 Q- Which log would you check if a database has a problem? A- Alert log 1.8 Q- Name three clients to connect with Oracle, for example, SQL Developer: A- SQL Developer, SQL-Plus, TOAD, dbvisualizer, PL/SQL Developer… There are several, but an experienced dba should know...

To stop or start Oracle Restart, run the following command: Start: This option is used to start Oracle Restart Syntax and Options: crsctl start has Stop: This option is used to stop Oracle Restart Syntax and Options: crsctl stop has -- Chears !!!

1. How many report trigger available in Oracle Reports? Answer : Oracle Report has 5 triggers. There are :     1.BEFORE PARAMETER FORM     2. AFTER PARAMETER FORM     3. BEFORE REPORT             4. AFTER REPORT             5. BETWEEN PAGES 2. How many built-in Package available in Oracle Reports? Answer:   Oracle Report has 14 built-in package. There are: Built-in Package: 1. EXEC_SQL 2. SRW 3. OLE2 4. DDE 5. ORA_FFI 6. ORA_PROF 7. ORA_NLS 8. TEXT_IO 9. TOOL_ENV 10. TOOL_RES 11. TOOL_ERR 12. LIST 13. DEBUG 14. STANDARD -- Cheers !!!

Question and Answer(SQL JOINING) 1. View the Exhibit and examine the structure of the EMP and SALGRADE tables. You want to display the names of all employees whose salaries belong to GRADE 5. Which SQL statements give the required output? (Choose all that apply) SELECT ename FROM emp JOIN salgrade USING (sal BETWEEN losal AND hisal) AND grade = 5; SELECT ename FROM emp e JOIN salgrade s ON (e.sal BETWEEN s.losal AND s.hisal AND s.grade = 5); SELECT ename FROM emp e JOIN salgrade s ON (e.sal BETWEEN s.losal AND s.hisal) AND s.grade = 5; SELECT ename FROM emp e JOIN salgrade s ON (e.sal BETWEEN s.losal AND s.hisal) WHERE s.grade=5; SELECT ename FROM emp e JOIN salgrade s WHERE e.sal BETWEEN s.losal AND s.hisal AND s.grade = 5; table "Exhibit"  EMP Name Null? Type ...

                                                  Oracle DBA Interview questions With Answer Question 1: When is a request sent to a listener? A. After every call. B. Before every call. C. After name resolution. D. Before name resolution. Best Oracle Books Question 2: In which file is the information that host naming is enabled stored? A. init.ora B. sqlnet.ora C. tnsnames.ora D. listener.ora Question 3:  Which protocols can oracle Net 11g Use A.TCP B.UDP C.SPX/IPX Question 4: Which of the following statements about listeners is correct? A. A listener can connect you to one instance only. B. A listener can connect you to one service only. C. Multiple listeners can share one network interface card. D. An instanc...