Databases Interview Questions, Answers for Freshers and Experienced asked in various Company Job Interviews

SQL> CREATE TABLE to_table 2 (col1 NUMBER); Table created. SQL> CREATE OR REPLACE TRIGGER statement_trigger 2 AFTER INSERT ON to_table 3 BEGIN 4 DBMS_OUTPUT.PUT_LINE('After Insert Statement Level'); 5 END; 6 / Trigger created. SQL> CREATE OR REPLACE TRIGGER row_trigger 2 AFTER INSERT ON to_table 3 FOR EACH ROW 4 BEGIN 5 DBMS_OUTPUT.PUT_LINE('After Insert Row Level'); 6 END; 7 / Trigger created. SQL> INSERT INTO TO_TABLE VALUES(1); After Insert Row Level After Insert Statement Level 1 row created. SQL> BEGIN 2 INSERT INTO TO_TABLE VALUES(2); 3 INSERT INTO TO_TABLE VALUES(3); 4 INSERT INTO TO_TABLE VALUES(4); 5 INSERT INTO TO_TABLE VALUES(5); 6 INSERT INTO TO_TABLE VALUES(6); 7 INSERT INTO TO_TABLE VALUES(7); 8 INSERT INTO TO_TABLE VALUES(8); 9 INSERT INTO TO_TABLE VALUES(9); 10 INSERT INTO TO_TABLE VALUES(0); 11 END; 12 / WAT LL BE THE O/P??? XPLAIN IT>>>>

Infosys,

1 4532

overloading of stored procedure is possible in oracle?

Nelco,

3 16007

After the SQL installation what are the jobs will you configure?

G7 CR Technologies, IBM, Satyam,

1 4451

please explain Nomalization in dbms?

5 8648

interview questions with answer for cts

Cognizant,

1 2657

What is the difference between alert log file and trace file ?

1 26981

What is meant by Join? What are the different types of Joins available? Explain.

Cap Gemini,

5 17680

Un-Answered Questions { Databases }

What are the different subsets of sql?

1642

What is your daily office routine?

2333

what are all the common sql function? : Sql dba

1121

What is the current version of sql?

1091

What are different types of constraints?

995

List out the different types of locks available in sql server?

1041

please send me oracle pl/sql exp resume. and also faqs...

2564

Hi , any one can help me on the same,this is regarding the Informatica Function doc,i want to know how developer is will develop the mapping. pl forwar the any function doc .just for my references. svlc75@yahoo.co.in

2091

How to provide default values to function parameters?

1242

What is the difference between for xml raw and for xml auto?

1108

how to escape special characters in sql statements? : Sql dba

1108

Design database draw er diagram for a certain scenario ?

4641

Can we rollback truncate?

1070

Is it possible to have clustered index on separate drive from original table location?

1034

How can we solve concurrency problems?

1116

For More Un-Answered { Databases } Questions Click Here