Databases Interview Questions, Answers for Freshers and Experienced asked in various Company Job Interviews

Oracle (3253)
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?

2 4492

Define Check points and End Points?

1 3853

How to know whether our backup is succesfully taken?

1 4168

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

2 5140

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

1 3793

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

Wipro,

2 5767

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

2 5311

What is Schema? and why we use schemas?

4 9158

How do you Implement SSIS Packages in your Project?

1 2006

Explain Different types of Projects?

1 3954

What is data modeling and Reterminal integrity?

1 2030

How to restore performance issues and how to check?

1 2080

Tell about MOM Tool(Microsoft Operator Manager)?

1 1984

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

1 4023

How much memory that we are using in Logshipping Concept?

1 1862

Un-Answered Questions { Databases }

what is collation? : Sql dba

1224

what is bcp? When does it used? : Sql dba

1053

Plz send me Oracle Pl/Sql [1z0-147] dumps to this mail? sivakumarr1987@gmail.com

1895

in user parameter property we have list of values.can we write select query for binding? for example:: select empno from emp where deptno=:deptnum :deptnum is first parameter it displays distinct dept nos. if i do like this it is giving error:: bind variables are not allowed in the select statement

2207

List out the different types of locks available in sql server?

1045

Can delete statement be rollbacked?

1050

Have you used lexical parameters in reports?

Can we make the the chages By Using the Sql if u know any function or process please inform me Actuall result: BRK1 Break 1 Part 1 00:01:00:00 60 BRK1 Break 1 Part 2 00:01:00:00 60 BRK2 Break 2 Part 1 00:01:00:00 60 BRK2 Break 2 Part 2 00:01:00:00 60 BRK2 Break 2 Part 3 00:01:00:00 60 BRK3 Break 3 Part 1 00:01:00:00 60 BRK3 Break 3 Part 2 00:01:00:00 60 Desired O/P: BRK1 Break 1 Part 1 00:01:00:00 60 Part 2 00:01:00:00 60 BRK2 Break 2 Part 1 00:01:00:00 60 Part 2 00:01:00:00 60 Part 3 00:01:00:00 60

2291

Can we shrink data file in sql server?

1123

define sql insert statement ? : Sql dba

1094

What are wait types?

1238

How raid can influence database performance?

1110

Equi join and non equi join is possible with sql server?

1126

what is spatial nonclustered index

1054

How to use values from other tables in update statements using oracle?

1147

For More Un-Answered { Databases } Questions Click Here