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 are page splits?

995

What are different types of statements that are supported by sql?

1047

Characterize join and name diverse sorts of joins?

966

Why would you use sql agent?

1263

What are the different types of backups avaialabe in sql server 2005?

1021

What is set nocount on?

939

What are the different types of upgrades that can be performed in sql server?

1177

What does null mean?

984

What is the difference between truncate and delete commands?

1068

What is normalization? What number of normalization shapes are there?

1109

What is collation?

1140

What are the operating modes in which database mirroring runs?

1089

Define self join?

1028

Does transparent data encryption provide encryption when transmitting data across the network?

1047

What are transactions and its controls?

1061

Un-Answered Questions { Databases }

You look at the dba_rollback_segs view and see that you have a large number of wraps is this a problem?

590

How do I write a sql query in pgadmin 4?

982

Why de-normalization required?

1003

What is the disadvantage of User defind function?

2292

Who is the owner of a schema in ms sql server?

1077

How many types of functions are there in sql server?

946

What is the difference between Union and Union all. Which is faster.

1402

What’s the use of custom fields in report?

944

What are the advantages/disadvantages of mysql and php?

959

Describe why operational and informational systems are separate.

950

If you remove a document from database, does mongodb remove it from disk?

Is mariadb faster than mysql?

964

What does postgresql mean?

841

What is the importance of batch source set up in ar? : oracle accounts receivable

1263

Is foreign key should be unique?

767

For More Un-Answered { Databases } Questions Click Here