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

What is the difference between the 2 operating modes of database mirroring?

1111

Is it possible in sql table to have more than one foreign key?

1033

How to compose an inquiry to demonstrate the points of interest of an understudy from students table whose name begins with k?

1089

What are number line correlation administrators will use while working with a subquery?

1177

What is view in sql?

904

What purpose does the model database server?

1098

Once setting replication, can you have distributor on sql server 2005, publisher of sql server 2008?

951

What is a primary key?

952

What is the difference function and stored procedure?

1057

How do you trace the traffic hitting a sql server?

1141

What is an identity?

1018

What do we have to check in database testing?

1019

Why would you call update statistics?

1018

Once setting replication, is it potential to own a publisher as sixty four bit sql server and distributor or subscribers as a thirty two bit sql server?

1010

How many types of triggers are there?

1064

Un-Answered Questions { Databases }

How to invoke a trigger on demand?

1092

what is database white box testing? : Mysql dba

998

System requirements for sql server 2005 express edition?

1018

Do you know what is similarity and difference between truncate and delete in sql?

1007

What are the functions of administration?

555

What are the types of sql server?

1052

How many types of knowledge Modules? Where are used in km?

621

Is pl sql a programming language?

990

What is triggers and its types?

1009

What are the different types of cursor?

1096

How to use sum function in where clause in mysql?

964

1.how to find the dead lock in sql server? 2.How to fine the memory leaks in sql server? 3.suppose transaction log file increasing what action will take ?

2027

Why mysql is used with php?

975

Explain four layers of abstraction microsoft architectured?

147

Oracle client is not able to connect to Oracle server although tnsnames.ora file has valid enteries. Oracle error message is “ cannot resolve net service name”. Mention any three reasons.

2568

For More Un-Answered { Databases } Questions Click Here