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

How to find the date and time of last updated table?

Teledata,

6 9774

What types of questions are asked in NIC(Natinal Informatics Centre)'s interview?If any one has any information about this,I would be very thankful to him/her.....

NIC,

1896

If any one has information regarding interview of NIC (National Informatics Centre),it would be of great help...

NIC,

2241

What’re ERD and the main elements of an ERD? Please explain using an ERD example.

3 14398

1.what is the difference between view and cursor? 2.If we do any change in view will it affect the database,similarly when we do changes in cursor will it affect the databse?with certain example?Thanks

5 23924

1.what is the purpose of using alias name in sql server? with certain example? 2.what is cursor?will u plz explain me in detail with certain example?

3 9246

what is the last version,the release date of that version and fix pack of ibm db2 udb?

1991

what is the difference between off-line back up and on-line back up in ibm db2 udb?

Zenith,

2 9065

What value could be assigned to Varchar Type?

3 5949

Would it be a good idea to create an index on a table that always contains 10 records? Why or why not?

3 5551

What types of integrity are enforced by a foreign-key constraint

1 4284

What are the main control-of-flow T-SQL constructs?

1 4837

What are the two virtual tables SQL Server maintains for triggers?

3 8524

What does the INSTEAD OF trigger do?

3 7664

What are explicit and implicit transactions?

BirlaSoft,

4 22160

Un-Answered Questions { Databases }

How many types of functions are there in sql server?

957

Is nosql faster than sql?

1041

What is a proxy class?

1071

What is dense_rank?

940

Explain what is a replica set?

What is rac?

What are the different column comparison operators in mysql?

959

What does information_schema contain?

823

How to check if postgres is running?

916

Is there a way to detect whether fbclient.dll or tbembed.dll is loaded?

What is a ddl command?

1103

What is a checkpoint in dbms and when does it occur?

989

List some of the features of postgresql ?

804

What is a php database?

894

What are the types of database management system?

1067

For More Un-Answered { Databases } Questions Click Here