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 4440

overloading of stored procedure is possible in oracle?

Nelco,

3 15832

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

G7 CR Technologies, IBM, Satyam,

1 4344

please explain Nomalization in dbms?

5 8414

interview questions with answer for cts

Cognizant,

2583

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

1 26835

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

Cap Gemini,

5 17376

Un-Answered Questions { Databases }

What is a definer?

884

what is the difference between data migration and production migration.

2346

Explain what is public role in sql server?

1135

How to loop through result set objects using mssql_fetch_array()?

1078

How do you create a module in microsoft access?

956

What is a password file in a database and why is it required when a user can be authenticated using data dictionary tables?

What do you understand by ‘atomicity’ and ‘aggregation’?

902

What are character functions?

1087

What is pragma serially_reusable and why is it used?

866

What are the types of database users?

998

How to use set clause in neo4j?

What is normalization and its types?

1034

HOW TO SAVE UNIVERSES AND DOCUMENTS IN THE REPOSITORY?

2061

What are aggregate functions in sql?

1160

What pl/sql package consists of?

1081

For More Un-Answered { Databases } Questions Click Here