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 4523

overloading of stored procedure is possible in oracle?

Nelco,

3 15971

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

G7 CR Technologies, IBM, Satyam,

1 4434

please explain Nomalization in dbms?

5 8598

interview questions with answer for cts

Cognizant,

2644

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

1 26952

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

Cap Gemini,

5 17624

Un-Answered Questions { Databases }

Explain the purpose of %type and %rowtype data types with the example?

1050

What is the current root password of mysql?

972

What are the six database objects?

963

Is mysql the same as sql server?

1043

What are the column comparisons operators?

1312

What is Database Management System?

1286

Explain the structure of pl/sql in brief.

1145

What is the difference between mongodb and cassandra?

Explain entity type?

1034

What are sub reports?

208

What is the difference between truncate and delete? Why is one faster? Can we rollback both? How would a full table scan behave after?

611

What is bulk compiling in pl/sql.?

1197

WHAT IS THE PURPOSE OF TESTING INTEGRITY OF THE UNIVERSE?

2311

How do I create a collection in mongodb? Write it's syntax

What is crud?

For More Un-Answered { Databases } Questions Click Here