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

What is the difference between is null & is not null?

1006

How to validate email addresses in mysql?

1140

How we can get distinct columns values in mysql?

1093

Write a query to display even rows in student table using mysql?

905

How to write optimized query in mysql?

1004

How to display odd rows in student table in mysql?

1022

What is the difference between myisam dynamic and myisam static in mysql?

1019

List some comparisons operators used in mysql?

997

How do I import database through command line?

1021

What is the difference between the primary and unique key in mysql?

996

What is the difference between having and where clause in mysql? Explain

1028

Explain the difference between primary key and candidate key in mysql?

976

How to control the max size of a heap table?

1009

How to display top 10 rows in mysql?

1043

Is mysql case-sensitive?

904

Un-Answered Questions { Databases }

How exception handling is done in advance pl/sql?

989

Explain how many normalization forms?

1046

What is tuple in dbms?

887

How will you add a dimension to cube? : sql server analysis services, ssas

1110

Why is databases important in healthcare?

971

Why do we study dbms?

956

what is database replicaion? : Sql server database administration

1209

How to list all triggers in the database with sys.triggers in ms sql server?

1101

Can function return multiple values in sql?

1067

How we can do multi-join query in ms access?

838

How do you rename a table?

1007

What is Virtual Private Database in Oracle?

1105

Explain inner and outer joins with examples.

1193

What does a dba stand for?

587

How to delete all rows with truncate table statement in ms sql server?

1012

For More Un-Answered { Databases } Questions Click Here