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 Fragmentation and Defragmentation? For 32GB Table,How can we do the fragmentation?

1 4390

Define Check points and End Points?

1 3752

How to know whether our backup is succesfully taken?

1 4056

What is a Lock and let me know Different types of locks?

2 5003

What is a Trace frag?Where can we use this?

1 3696

How many .ndf files can we create in Sql server 2005?

Wipro,

2 5655

How to Create Login and User through query in Sql server 2005.and also how to delete Login and User through query?

2 5149

What is Schema? and why we use schemas?

4 8908

How do you Implement SSIS Packages in your Project?

1934

Explain Different types of Projects?

1 3872

What is data modeling and Reterminal integrity?

1960

How to restore performance issues and how to check?

2008

Tell about MOM Tool(Microsoft Operator Manager)?

1917

Please tell me some knowledge about Clustering and how to add clustering?

1 3896

How much memory that we are using in Logshipping Concept?

1800

Un-Answered Questions { Databases }

How to concatenate two character strings?

1037

When are stored procedures compiled in sybase?

854

Explain mirroring?

871

In how many ways we can retrieve data in the result set of mysql using php?

1132

What is nvarchar max in sql?

1022

What is the purpose of ms access?

823

Explain the field term used in database.

980

What are all the ddl commands?

1188

What does select 1 mean?

937

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

1116

How to create a stored program unit?

1234

What do you understand by correlated subqueries in dbms?

967

What is the Lock Based Protocol used for?

1085

what are user defined datatypes and when you should go for them? : Sql server database administration

1025

What are the sql commands?

1188

For More Un-Answered { Databases } Questions Click Here