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

How many types of normalization are there?

960

How do you write an index?

965

Is clustered index a primary key?

949

How do I delete a trigger?

965

How do you delete a table?

1074

How do I remove duplicates in two columns?

1065

How do I find duplicates in two columns?

1167

How can I delete duplicate rows?

1014

How do rank () and dense_rank () differ?

1044

Are stored procedures faster than queries?

945

What schema means?

888

Is delete faster than truncate?

1002

Can we use rowid as primary key?

988

How do you remove duplicate records from a table?

939

How do you truncate?

906

Un-Answered Questions { Databases }

How can I learn oracle dba?

563

how to dynamically change the page size of d2k reports?

State all possible different index configurations a table can possibly have?

998

1.how to fetch a value and Execute store procudure in mysql(INNODB) using phpMyAdmin? 2.can i wright a package in mysql database(INNODB)?

2509

What is the difference between a check constraint and a rule?

1249

What do you understand by a database object? Can you list a few of them?

1018

How do you truncate?

906

How to start sybase database in windows?

1149

Explain different types of lock modes in sql server 2000?

931

What are the drawback of rdbms?

939

What are the two characteristics of a primary key?

974

when MSQL8.0 is in market

2076

How do you create access?

886

What are the 3 modes of parameter?

1154

What are set operators?

1082

For More Un-Answered { Databases } Questions Click Here