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

what is analyze command ? what kind of statistics does it generate?

2 5032

how do u know the total no of rows in a table?

6 9147

what are archived logs?

2211

what are bitmap indexes? How does they work?

2269

what are the database links ?

2 4806

does the query needs a hint to access a materialized view?

1 3881

what are different types of locks?

6 8661

master table and child table performances and comparisons in Oracle ?

2148

what are the different types of cursors? explain?

4 10274

what are different types of deletes?

1 3795

can a view be updated?

3 9798

what is pragma?

2 6794

can you write commit in triggers?

4 10917

can u call user defined functions in select statements

2 5375

can you call insert/update/delete in select statements. If yes how? If no what is the other way?

2 7021

Un-Answered Questions { Databases }

What is oracle sql called?

934

How do I install postgresql?

898

Is ssrs support other database except ms sql server?

142

How do I set up postgresql?

884

What is 'mysqladmin' in mysql?

1049

What is pl sql in dbms?

961

What is the use of the Service Knowledge module?

603

i have a question here... As of my knowledge, when we apply an index (b-tree)on a column, internally it arranges the data in b-tree format and do the fetching process correspondingly... and my quetion is... How a bit-map index arranges the data internally when applied on a column?IS it in b-tree format or whatelse?

1970

Which are the third-party tools used in sql server and why would you use them?

927

What are different types of constraints?

940

How can we implement rollback or commit statement in a trigger?

1045

What is transport network substrate (tns) in oracle?

1064

How view is different from a table?

1050

What does the on update no action do?

1036

Explain the storage engines in mysql?

1015

For More Un-Answered { Databases } Questions Click Here