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

CLR Integration ? what is Notification services ?

HCL, Satyam,

1 5321

what is replication? where do u use Go Keyword?

Satyam,

1 4919

how do u do Performance tunning ?

Infodat Technologies, Satyam,

1 5088

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

3 9332

Write a note on File based system/ Data base system

2 5955

What are the Roles and responsibilities of database administrator?

2496

Define the following terms 19. (i) Database 20. (ii) Database Management System 21. (iii) Data Model 22. (iv) Scheme 23. (v) Data independence

1 3746

Explain the classification of Database Management System?

CSC, Wipro,

4209

Explain the key constraints and constraints on Null Values with examples?

2 4456

What are ACID properties?

Amazon, Cap Gemini,

11 28422

Write about Transaction Management in Oracle 9i?

2125

I want to export the data date to date from oracle database then what can i do?

2606

can any one tell me how i can start database testing mean what should be initial point and how i can write a query for listing page of any item thanks in advance

2553

I want to export only structure of the table from oracle database. In that table to used the some partition. To export the table in general way then compilation error was occured i.e-EXP-00003: no storage definition found for segment(11, 2771). Please tell me the correct export command parameter to export the partitioned table. Thanks in Advance..........

1 12666

how to copy sysdatabase file from c: Drive to D: Drive in SQL Server.

IBM,

6 10407

Un-Answered Questions { Databases }

what is the difference between functional dependecy and multilevel dependency?

2465

What is the difference between mdf and ndf files?

1120

Are subqueries faster than joins?

1022

How to get last inserted id after insert data from a table in mysql?

982

Why schema is used in sql?

1053

How to test values returned by a subquery with the in operator?

1198

Explain the usage of floor function in sql server.

968

What is ole db provider for sql server?

1033

What is a pl/sql block?

1234

List different query types in microsoft access database

916

Explain what are the authentication modes in sql server?

1022

What are the attributes that are found in a cursor?

1079

What is difference between equi join and inner join?

956

You look at your fragmentation report and see that smon has not coalesced any of you tablespaces, even though you know several have large chunks of contiguous free extents. What is the problem?

609

What's the difference between inner join and left join?

1002

For More Un-Answered { Databases } Questions Click Here