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

1 1137

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

1 1197

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

1 1175

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

1 1274

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

1 1374

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

1 1176

Which autogrowth database setting is good? : sql server DBA

1 1292

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

1 1434

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

1 1151

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

1 1282

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

1 1321

What is left outer join in sql server joins?

1 1145

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

1 1202

What is 3nf normalization form?

1 1209

Explain index in sql server?

1 1091

Un-Answered Questions { Databases }

How do I start sql server 2017?

1014

Can you index views?

953

How do I remove duplicates in two columns?

1180

How to convert numeric expression data types using the cast() function?

1145

How to convert character strings into numeric values?

1187

How can I check that whether automatic statistic update is enabled or not?

1110

What is self contained sub query?

1138

Suppose database is running slow, what will you do?

2591

How did mongodb get its name?

what is the difference between openrowset and openquery?

1189

What are the types of database explain each of them briefly?

1058

Why use identity in sql server?

1193

How to connect php with different port numbers?

1182

Have you created fact table and dimension tables?

710

What is the difference between upgrade and migration in sql server?

1181

For More Un-Answered { Databases } Questions Click Here