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

Oracle (3253)
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 11011

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

5 10817

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

MBT,

36 61383

What is OQL?

4 12071

what are the disadvantages of hierarchial database over RDBMS?

TCS,

1 13108

Can we create more than one constraint to column ?

6 11345

what is the difference between simple view and complex view?

13 53842

what is the use of rank function?

1 6410

How many different types of indexes we have in oracle?

IBM, TCS,

24 193595

what are pseudocolumns?

4 11152

what is the use of composite key constraint?

2 8648

what is a cartition product?

4 11857

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 7535

what is the use of ondelete cascade?

3 8487

what is cartesian product?

2 8302

Un-Answered Questions { Databases }

What are different types of tables in sql?

1056

How do I import a csv file into postgres?

963

What is rds instance?

863

How to run sql functions in pl/sql?

1132

What is difference between ms sql and mysql?

1027

How do you display the list of all collections of current database?

How can you find dead processes?

590

How do you know if a relationship is 2nf?

1002

What is a correlated sub-query? : sql server DBA

1165

How do I start mysql in ubuntu?

1106

What is difference between view and materialized view?

989

Explain what is use of dbcc commands?

1148

How to call a stored function with parameters?

1106

What are the advantages of manual database?

1020

How to save space when inserting rows monotonically?

956

For More Un-Answered { Databases } Questions Click Here