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

Does table partitioning improve performance?

1 1047

How do I open a .db file?

1 1096

Is it important to partition hard disk?

1 1089

What is multiple partition?

1 1042

How do I add a primary key to a table?

1 1102

What is the difference between mdf and ndf files?

1 1184

What is gpt format?

1 1005

What is a system versioned table?

1 1066

What is a temporal table?

1 989

What is mdf ldf and ndf?

1 1081

What is the difference between partition and index?

1 1086

What is an ndf file?

1 1093

How do I create a memory optimized filegroup?

1 1035

Why do we need sharding?

1 1070

What is cold data?

1 1042

Un-Answered Questions { Databases }

Suppose database is running slow, what will you do?

2590

How to export data from database and import into another?

989

What is sql or structured query language?

1220

What versions of clipper does netlib support?

1085

what is the last version,the release date of that version and fix pack of ibm db2 udb?

2046

How can you append an identity column to a temporary table?

1065

What are the risks of storing a hibernate-managed object in a cache? How do you overcome the problems?

1186

Is it possible to have clustered index on separate drive from original table location?

1034

What is the difference between for xml raw and for xml auto?

1108

how to use regular expression in pattern match conditions? : Sql dba

1105

Any work done in oracle workflow builder. Did you customize or build a new workflow?

How do I find the sql server version?

1099

What is your daily office routine?

2340

What are the different subsets of sql?

1646

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

For More Un-Answered { Databases } Questions Click Here