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

is there a column to which a default can't be bound? : Sql server database administration

1025

explain different types of backups avaialabe in sql server? Given a particular scenario, how would you go about choosing a backup plan? : Sql server database administration

1069

what is normalization? : Sql server database administration

1110

what is a traditional network library for sql servers? : Sql server database administration

966

what are defaults? Is there a column to which a default can't be bound? : Sql server database administration

1149

what are the steps you will take, if you are tasked with securing an sql server? : Sql server database administration

1057

what is a transaction and what are acid properties? : Sql server database administration

1034

what's the information that can be stored inside a bit column? : Sql server database administration

1047

what is an extended stored procedure? : Sql server database administration

1071

what is the different types of backups available in sql server? : Sql server database administration

941

when would you go for denormalization? : Sql server database administration

880

what are defaults? : Sql server database administration

1106

do you know what is a deadlock and what is a live lock? How will you go about resolving deadlocks? : Sql server database administration

997

how do you test proper tcp/ip configuration windows machine? : Sql server database administration

1078

but what if you have to create a database with two filegroups, one on drive c and the other on drive d with log on drive e with an initial size of 600 mb and with a growth factor of 15%? : Sql server database administration

980

Un-Answered Questions { Databases }

What is checkpoint process in the sql server?

1044

What is a data source or ds? : sql server analysis services, ssas

1018

What is the difference between cube operator and roll up operator? : sql server architect

865

What is 'Join' and explain its various types.

1161

Does oracle use sql?

943

What is an Oracle Rollback Segment?

1132

Why are recursive relationships bad? How do you resolve them?

596

what are questions asked in TCS for database tester (sqlserver)for 2-3 exp?

5940

What are the other commands to know the structure of a table using mysql commands except explain command?

1044

How is view stored in database?

966

What are the grouping functions?

947

I create a separate index on each column of a table. What are the advantages and disadvantages of this approach? : Sql server database administration

1105

Mention the different types of dbms.

1034

What is data source document?

1050

Write down the differences between nosql and rdbms?

1021

For More Un-Answered { Databases } Questions Click Here