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 dropping a database and taking a database offline? : sql server DBA

1082

How do you troubleshoot errors in a sql server agent job? : sql server DBA

1138

What are the commands used in dcl? : sql server DBA

1089

What are the operating modes in which database mirroring runs? : sql server DBA

1203

What is a system database and what is a user database? : sql server DBA

1255

How do you open a cluster administrator? : sql server DBA

1124

Which autogrowth database setting is good? : sql server DBA

1184

List out some of the requirements to setup a sql server failover cluster.? : sql server DBA

1305

Where do you find the default index fill factor and how to change it? : sql server DBA

1087

How many files can a database contain in sql server?how many types of data files exists in sql server? How many of those files can exist for a single database? : sql server DBA

1211

What are the different types of indexes available in sql server? : sql server DBA

1223

What is left outer join in sql server joins?

1062

Can you please explain the difference between primary keys and foreign keys?

1134

What is 3nf normalization form?

1131

Explain index in sql server?

1037

Un-Answered Questions { Databases }

How to assign data of the deleted row to variables?

1088

Source File: Target EMPNO, SAL Empno, Format 101, 1000 101, 1000 101, 1100 101, 1000, 1100 101, 1000 101, 1000, 1100, 1000 101, 10000 101, 1000, 1100, 1000, 10000 102, 1100 102, 1100 102, 1300 102, 1100, 1300 102, 1200 102, 1100, 1300, 1200 102, 1500 102, 1100, 1300, 1200, 1500 How can i get that output using datastage(ETL) tool

1858

how to write date and time literals? : Sql dba

979

Can you index views?

911

What is sql rowcount?

1042

List the different index configurations possible for a table?

949

How to delete duplicate rows in sql server?

1120

What is a domain in microsoft access?

885

How do I start pgadmin 4 on windows?

900

Explain syntax for viewing trigger?

941

Can we create clustered index on composite key?

1105

What is a dirty read sql?

1182

What is the difference between db-lib and ct-lib in sybase?

851

How to get a list all databases on the sql server?

1121

What is user defined functions?

1001

For More Un-Answered { Databases } Questions Click Here