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

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

Teledata,

6 10066

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,

1 1946

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

NIC,

1 2312

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

3 14589

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 24122

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 9423

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

2050

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

Zenith,

2 9203

What value could be assigned to Varchar Type?

3 6112

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

3 5691

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

1 4392

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

1 4930

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

3 8678

What does the INSTEAD OF trigger do?

3 7820

What are explicit and implicit transactions?

BirlaSoft,

4 22413

Un-Answered Questions { Databases }

what are the advantages of sql ? : Sql dba

1140

Can we use distinct and group by together?

1133

how to start mysql server? : Sql dba

1265

in oracle BPM composer in part BA model on design model in enterprise model i cannot connection with value chain model work not links in part properties do you can me help me?

1605

Hi , any one can help me on the same,this is regarding the Informatica Function doc,i want to know how developer is will develop the mapping. pl forwar the any function doc .just for my references. svlc75@yahoo.co.in

2100

Who proposed the relational model?

1029

What is the primary use of the model database?

1146

How efficient you are in oracle and SQL server?

1255

When should you use an instead of trigger?

1048

Is it possible to have clustered index on separate drive from original table location?

1037

What is an indexed view?

1021

Why should you use or avoid select * statements?

1108

What are the pros and cons of putting a scalar function in a queries select list or in the where clause?

1295

how to escape special characters in sql statements? : Sql dba

1113

Can we rollback truncate?

1072

For More Un-Answered { Databases } Questions Click Here