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

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

1056

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

1112

what is normalization? : Sql server database administration

1166

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

1021

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

1185

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

1112

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

1091

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

1093

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

1114

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

974

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

911

what are defaults? : Sql server database administration

1165

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

1052

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

1121

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

1015

Un-Answered Questions { Databases }

what is a composite primary key ? : Sql dba

1095

Write a query to create a duplicate table with and without data present?

912

What are the rules to use the rowguidcol property to define a globally unique identifier column?

1079

What does postgresql stand for?

886

What are statistics, under what circumstances they go out of date, how do you update them?

2312

Explain about the process which takes place to execute a stored routine?

794

WHAT IS NEED BY METION DATFMT AND TIMFMT IN H-SEPICITION IN RPGLE?

3016

What is the purpose of the tempdb database?

1050

How to add a new column to an existing table in mysql?

1044

Describe the three levels of data abstraction?

931

What is the max size for access database?

962

How do triggers work?

998

Does db2 use sql?

1011

Is it mandatory for the primary key to be given a value when a new record is inserted?

1255

How to display error message in postgresql?

1064

For More Un-Answered { Databases } Questions Click Here