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?

901

How do you write an index?

915

Is clustered index a primary key?

885

How do I delete a trigger?

916

How do you delete a table?

1001

How do I remove duplicates in two columns?

977

How do I find duplicates in two columns?

1060

How can I delete duplicate rows?

966

How do rank () and dense_rank () differ?

978

Are stored procedures faster than queries?

901

What schema means?

847

Is delete faster than truncate?

960

Can we use rowid as primary key?

944

How do you remove duplicate records from a table?

887

How do you truncate?

855

Un-Answered Questions { Databases }

How to create a trigger in mysql?

890

How can we create the complete backup of data in the oracle.

2094

Will you be able to store pictures in the database?explain.

931

What is the filtered index?

978

What is tabulation?

899

You need to add a notnull column in a table by using alter command (without using default command). How would you do that?

868

Does unique constraint create index postgres?

715

What is merge?

935

Does mysql case matter?

861

How to remove row affected and dashes?

834

What normalization means?

907

what are the different type of normalization? : Sql dba

974

How do you name a table?

835

What you need to do is issue an ase kill command on the connection then un-suspend the db?

893

What is the difference RDBMS and Graph Database?

1006

For More Un-Answered { Databases } Questions Click Here