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 to define the name and server for a new dsn?

1137

How to create a trigger for insert only?

1055

How to delete a login name in ms sql server?

1085

What are the differences between decimal and float in ms sql server?

1264

How to replace given values with null using nullif()?

1000

How to insert new line characters into strings?

1005

How to sort query output in descending order in ms sql server?

950

How to start and end transact-sql statements?

1045

What is sqlservr.exe - process - sql server (sqlex?press)?

1125

How to get a list of all tables with "sys.tables" view in ms sql server?

1046

How to attach adventureworkslt physical files to the server?

1120

How to download and install microsoft sql server management studio express?

1049

Does the unique constraint create an index?

1074

How to use column default values in insert statements in ms sql server?

1056

How to get a list of columns using the "sys.columns" view in ms sql server?

965

Un-Answered Questions { Databases }

What operating systems are supported by oracle database 10g xe?

1048

What is implicit cursor in dbms?

1030

How do I show users in mysql?

1077

What is the difference between primary key and candidate key?

1031

What is union and union all keyword in sql?

1060

Explain the creation and execution of a user-defined function in the sql server?

1059

What is snow flake schema design in database? What's the difference between star and snow flake schema?

879

What is a string in database?

964

What is difference between microsoft sql and mysql?

1008

List the different index configurations possible for a table?

940

Why do we use sql limitations? Which constraints can we use while making a database in sql?

1088

What is query image?

987

What is the difference between natural join and equi join?

943

What is the drawbacks of normalization?

977

How does a trigger work?

1099

For More Un-Answered { Databases } Questions Click Here