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 4398

Define Check points and End Points?

1 3756

How to know whether our backup is succesfully taken?

1 4062

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

2 5015

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

1 3705

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

Wipro,

2 5661

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

2 5155

What is Schema? and why we use schemas?

4 8920

How do you Implement SSIS Packages in your Project?

1939

Explain Different types of Projects?

1 3877

What is data modeling and Reterminal integrity?

1968

How to restore performance issues and how to check?

2013

Tell about MOM Tool(Microsoft Operator Manager)?

1923

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

1 3900

How much memory that we are using in Logshipping Concept?

1806

Un-Answered Questions { Databases }

How do you create an execution plan?

961

What is n tier architecture in dbms?

939

Is primary key indexed by default?

803

Is postgresql case sensitive?

787

what is a unique key ? : Sql dba

1105

Explain the difference between primary and foreign key?

1057

What is sql engine in oracle?

1001

What happen when an index does not fit into ram?

What are the differences between a primary key and foreign key?

1109

List some advantages and disadvantages of stored procedure?

1020

What is a ctid?

899

What is mssql?

992

What port does postgresql use?

830

Explain the difference between physical and logical data independence?

926

What is the server name in sql server?

1028

For More Un-Answered { Databases } Questions Click Here