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 advantages of log shipping?

1043

Why are views required in the sql server or in any other database?

1004

List the different index configurations possible for a table?

986

Where sql server usernames and passwords are stored in a sql server?

1040

List the various tools available for performance tuning?

931

What is a heap?

1087

Can we take the full database backup in log shipping?

999

What are the 2 types of classifications of constraints in the sql server?

1185

What is an execution plan?

1245

What are the different types of columns types constraints in the sql server?

1139

What is the stored procedure?

1055

What are the advantages of the mirroring?

1150

What are the common performance issues in sql server?

976

What are the purposes of using enum and set data types?

980

Describe mysql transaction properties.

1074

Un-Answered Questions { Databases }

What is transaction server explicit transaction?

1093

How to make a copy values from one column to another in sql?

1086

What is difference between ms sql and mysql?

1018

What do you understand by b-trees?

1106

Why is sharding used?

1066

What is normalization 1nf 2nf 3nf?

1118

Explain about relational database management systems?

1019

Is mysql a free database?

995

Mention what is the basic syntax to use index in mongodb?

Where does mongodb store data linux?

What is parameter substitution in sql?

1083

What are Oracle Schema Objects?

1164

How to use "for" statements in oracle?

1126

How do I trace a query in sql server?

1004

What is the osql utility?

1041

For More Un-Answered { Databases } Questions Click Here