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 are the types of partitions in oracle?

1078

What is a partition in oracle?

1204

How can I see all tables in oracle?

1060

Is drop table faster than truncate?

1048

How do I truncate a word?

1160

Can we create index on primary key?

1018

Can you join a table to itself?

1222

Is primary key a clustered index?

1009

How does a self join work?

1233

How do you explain an index number?

1185

Where is all the data on the internet stored?

1057

Is left join faster than inner join?

1168

How do you know if a relationship is 2nf?

994

How do you delete data from a table?

1099

How do I find duplicates in the same column?

1170

Un-Answered Questions { Databases }

Why we should not use triggers?

1014

what is a live lock? : Sql server database administration

1019

Write the syntax for stuff function in an sql server?

1074

Why are mongodb data files large in size?

How would you configure your networking files to connect to a database by the name of DSS which resides in domain icallinc.com?

1968

What are transactions in sql?

1136

Suppose a student column has two columns, name and marks. How to get name and marks of the top three students.

1088

Why do you need a sql server?

1171

What is sql profiler. What are the default templates with it? : sql server database administration

1106

What is myisam?

1027

What is pragma in sql?

1127

How much money does a dba make?

626

How can you count the total number of records of any table?

979

what is a relationship and what are they? : Sql dba

1165

What is a longblob?

1002

For More Un-Answered { Databases } Questions Click Here