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

Oracle (3259)
SQL Server (4518)
MS Access (429)
MySQL (1402)

Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)

DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)

Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)

Database Management (1411)
Databases AllOther (288)

Databases Interview Questions

Questions Answers Views Company eMail

If there is failure during updation of certain rows, what will be the state?

2 10910

What is the difference between Userdefined function and stored procedure? Explain and give the example also

5 10640

In Oracle 9i what does "i" Stands for?

MBT,

36 60395

What is OQL?

4 11915

what are the disadvantages of hierarchial database over RDBMS?

TCS,

1 13026

Can we create more than one constraint to column ?

6 11169

what is the difference between simple view and complex view?

13 53441

what is the use of rank function?

1 6321

How many different types of indexes we have in oracle?

IBM, TCS,

24 192855

what are pseudocolumns?

4 10982

what is the use of composite key constraint?

2 8576

what is a cartition product?

4 11690

write a procedure to print a statement or number not using "dbms_output.put_line" package.write a procedure instead of it using procdure name as "print" ex:- declare a number:=2; begin print(a); end; /* when U type above procedure 2 have to should be printed*/

iFlex,

2 7427

what is the use of ondelete cascade?

3 8381

what is cartesian product?

2 8210

Un-Answered Questions { Databases }

how you can deploy an ssrs report?

183

What is collation sensitivity?

1083

Does user triggers have entry for trigger with compilation errors?

1047

Does storing of data in stored procedures increase the access time? Explain?

1128

Can we rename database in mysql?

960

What is the difference between sql and postgresql?

921

Is postgresql free for commercial use?

822

WHEN CURSOR MOVES FROM ONE FORM TO ANOTHER FORM, HOW MANY TRIGGER WILL BE FIRED AND WHAT ARE THEIR SEQUENCE?

2326

Is microsoft access an sql database?

903

How to delete a trigger in mysql?

936

How to create a new view in mysql?

932

Versions of softwares change everyday. In what format should I save my database so that different versions of ms access cab open it?

849

When does the auto update index statistics feature in sql server turn itself on?q) what specific conditions database should meet, before you can bulk copy data into it using bcp?

991

What do you know about DBMS?

1042

How many data types are supported?

1094

For More Un-Answered { Databases } Questions Click Here