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

create index a on employee(dno) In this,which index was created?

2 4796

How will u get 5 years back record?

5 9647

What is a materialized view?

3 8518

Any sample or model question of punjab national bank for deputy manger IT or any sample of PNB.any1 plz do send on

2217

What is MSDE?

2 4929

How can you see what type of locks used?

1 4885

What is transcation?Plz give One example?

2 5109

Plz tell about backup&recovery?

3 5354

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

3 17637

If a table column has is UNIQUE and has NOT NULL, is it equivalent to a PRIMARY KEY column?

IBM,

8 12280

what is difference between table and view? where to use views? thanks in advance!

1 4826

What is WITH CHECK OPTION

Karur Vysya Bank KVB,

3 10092

what means of sybase ?? and how i can use sybase data base on my computer Iam the first use it >> any help please !

3 7692

With out using count() function. How to the find total number of rows in a table?

6 12985

why should required nested tables, Object types, partition tables and varying arrays. what is the difference between these are all. give me example with explanation.

2 6720

Un-Answered Questions { Databases }

What is the partitioning method?

1033

What is difference between stored procedure and trigger?

1181

How can you know if the row fetched from cursor is still valid in underlying table?

1010

Define concurrency control. : Transact sql

1195

How to delete duplicate rows in sql server?

1120

What is ims software environment?

921

Can we have multiple index on a table?

921

Explain the use of table functions.

2499

What is the plv (pl/vision) package offers?

1063

Where is my database stored on the hard disk in ms sql server?

1073

Can mongodb store binary data?

define primary key index, bitmap index, hash index,virtual indwx

3329

What is blocking and how would you troubleshoot it? : sql server database administration

1063

What is sqlcommand?

1036

Explain the method to debug errors in an oracle application.

For More Un-Answered { Databases } Questions Click Here