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

Do you know what is replace and stuff function in sql server?

1028

Explain various data region available in ssrs with their use?

947

What are the ways available in sql server to execute sql statements?

1151

Tell me what is the order in which the sql query is executed?

967

Do you know what are various aggregate functions that are available?

1143

What are the restrictions while creating batches in sql server?

1076

Tell me what is fill factor?

971

Explain what is the purpose of sql profiler in sql server?

1091

Explain what is the difference between a local and a global temporary table?

1016

Explain how to integrate the ssrs reports in application?

1028

What are sql dirty pages?

1038

What is transactional replication?

977

Can you explain full-text query in sql server?

1024

Do you know what is openxml in sql server?

1079

Do you know what is normalization of database? What are its benefits?

1136

Un-Answered Questions { Databases }

Can you create a synonym without having a table?

1051

How to present flrehird.log file from filling up the disk partition?

Compare mongodb and cassandra?

Is access a database?

891

Is a server a database?

921

Due to some maintenance being done, the sql server on a failover cluster needs to be brought down. How do you bring the sql server down? : sql server DBA

1041

Can we declare a column having number data type and its scale is larger than pricesionex: column_name number(10,100),column_name numbaer(10,-84)

966

Guideline for sizing db_block_size and db_multi_block_read for an application that does many full table scans?

623

Why we use the openxml clause?

1025

When should you increase copy latches?

650

What is server name sql?

1158

What is the most popular database?

948

What is parameter substitution in sql?

1042

What do you understand by query optimization?

1037

Do you know what is normalization of database? What are its benefits?

1136

For More Un-Answered { Databases } Questions Click Here