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 10056

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 1943

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

NIC,

1 2309

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

3 14584

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 24120

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 9421

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

2046

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

Zenith,

2 9201

What value could be assigned to Varchar Type?

3 6109

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

3 5689

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

1 4391

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

1 4928

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

3 8674

What does the INSTEAD OF trigger do?

3 7818

What are explicit and implicit transactions?

BirlaSoft,

4 22404

Un-Answered Questions { Databases }

What is normalization and what are the advantages of it?

1054

Any work done in oracle workflow builder. Did you customize or build a new workflow?

How to export data from database and import into another?

993

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

1111

How to select all columns of all rows from a table in oracle?

1124

Where can you add custom error messages to sql server?

1204

what ASIS BUSINESS PROCESS IN ORACLE FINANCE

2349

Equi join and non equi join is possible with sql server?

1130

what is collation? : Sql dba

1228

How can I check that whether automatic statistic update is enabled or not?

1109

What is a scheduled job or what is a scheduled task?

1033

Can sql servers link to other servers like oracle?

913

How to Change a users password from unix shell.

1214

What are the different types of subquery?

1232

What is clustered index

1083

For More Un-Answered { Databases } Questions Click Here