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 significance of null value and why should we avoid permitting null values?

1003

Explain what is the use of custom fields in report?

938

Do you know what is bit data type and whats the information that can be stored inside a bit column?

967

Can you explain what are various ways to enhance the ssrs report?

1012

What is sql collation?

1224

Tell me what do you understand by a view? What does the with check option clause for a view do?

1030

Tell me what is the significance of null value and why should we avoid permitting null values?

1000

What is use of dbcc commands?

1084

What is analysis service repository?

1037

What is snapshot replication?

1066

What is the purpose of sql profiler in sql server?

1037

Explain the concepts and capabilities of sql server?

986

What do you understand by a view?

1010

Tell me what is the difference between locking and multi-versioning?

1044

What is user defined datatypes and when you should go for them?

1033

Un-Answered Questions { Databases }

How does rowid help in running a query faster?

1428

In a property booking section want a query to check that property is booked from StartDate to EndDate.Booking Table field are given id proerty_id start_date checkout_date no_of_visitor booking date status Waiting yours answer.. Thanks In Advance...

3211

Is ssrs support other database except ms sql server?

142

Explain mutating table error.

1214

Is mongodb free for commercial use?

Explain indexing and what are the advantages of it?

1044

Is mongodb orm?

How i can handle exception in large code like 1000 line without distrubing the code or without exception handler sction?

3213

How to import one table back from a dump file?

1038

What is the use of default key?

1176

What are sql azure firewall rules?

106

How is super key different from a candidate key?

914

What is substitution variable?

1062

Explain the process you follow to start looking into performance issue at database level(if the application is running very slow, at what points do you need to go about the database inorder to improve the performance?)

770

how can you test for null values in a database? : Mysql dba

947

For More Un-Answered { Databases } Questions Click Here