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 functions in the sql server?

1221

Define union, union all, minus, intersect?

980

What do you mean by authentication modes in sql server?

1084

What are the advantages of having an index on the sql server?

925

What command is used to create a database in the sql server and how?

1181

What are different backups available in sql server?

1073

What are the various editions of sql server 2017 that are available in the market?

892

What is the recovery model? List the types of recovery model available in sql server?

906

Which is the latest version of sql server and when it is released?

1112

What is a trigger and types of a trigger?

983

What is the sql profiler?

942

what is a check constraint?

1125

What is tcl in sql server?

1126

What is a performance monitor?

976

What is the recovery model?

992

Un-Answered Questions { Databases }

Is java required for oracle client?

1001

What is computer end?

924

Does mongodb support primary-key, foreign-key relationship?

How do you view log files in sybase?

940

What is MySQL?

1001

What is ims software environment?

907

How dts is used to extract, transform and consolidate data?

1075

An index is reaching a limitation on the number of pages it has, can you explain why this limitation exists and what work you would do to get around it?

What are the differences between number and binary_float in oracle?

1101

What is mongodb replica set?

Where is localdb stored?

943

how can you select rexcord(rows) from table A which is not present in Table B . Id being the FK in Table B referencing to ID Table A

1683

Will truncate release space?

951

How to get the ddl of a table in postgresql?

870

Are truncate and delete commands same? If so why?

1156

For More Un-Answered { Databases } Questions Click Here