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 10907

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

5 10632

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

MBT,

36 60337

What is OQL?

4 11911

what are the disadvantages of hierarchial database over RDBMS?

TCS,

1 13018

Can we create more than one constraint to column ?

6 11150

what is the difference between simple view and complex view?

13 53433

what is the use of rank function?

1 6317

How many different types of indexes we have in oracle?

IBM, TCS,

24 192810

what are pseudocolumns?

4 10976

what is the use of composite key constraint?

2 8566

what is a cartition product?

4 11683

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 7419

what is the use of ondelete cascade?

3 8370

what is cartesian product?

2 8206

Un-Answered Questions { Databases }

What do you mean by catalog?

870

What are a scheduled jobs?

964

What are the steps to follow to configure SQL*Net?

1052

How do I connect to postgresql on windows?

927

how can you get actual data change values from previous transactions in oracle?

1098

What is the difference between for trigger and after trigger?

1120

What are the various kinds of interactions catered by dbms?

2135

How do you bind variables in pl sql?

1107

What is the security principal at the database level that represents your session?

952

What are the different types of nosql databases? Give some examples.

What is my identity burn factor vulnerability right now in sybase?

904

How do I manually create a database?

1211

What does a database contain?

889

Why oracle is used?

1066

How many companies are using mongodb?

For More Un-Answered { Databases } Questions Click Here