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

1038

What is the maximum size of column in sql server?

892

How to find table changes in sql server?

1119

Where views are stored in sql server?

985

How to find related tables in sql server?

944

How to check if a table is being used in sql server?

962

How to edit table in sql server 2017?

926

What is history table in sql server?

971

Why functions are used in sql server?

960

How to link tables in sql server?

933

What are temporal tables in sql server 2016?

883

What is change tracking in sql server?

1025

Where are stored procedures in sql server?

1065

What is the use of partition by in sql server?

933

How to check table values in sql server?

954

Un-Answered Questions { Databases }

how would you improve etl (extract, transform, load) throughput?

1026

How do you login to MySql using Unix shell?

1173

Is mysql relational database?

902

What is trigger and different types of Triggers?

1143

How to retrive a student with height marks,second height and third height from MS access database what wil be the query for this purpuse?

993

in oracle 10g sw after compiling procedure how to pass parameter values ,if we (v_empid out number)how to give empid after successful compilation program.This site exact suitable for 10g with respect to question & answer same format , im trying sql browser & sql command prompt using exec procedure name & respective parameters.

2083

What is the difference between instance recovery and crash recovery?

What are information schema views?

986

Why does couchdb not use mnesia?

How would you go about verifying the network name that the local_listener is currently using?

3216

How do you configure to cache size for mmapv1 in mongodb?

What are the steps to follow to configure SQL*Net?

1039

Can pl sql procedure have a return statement?

1030

what is the use of anchoring object? what r the difference between anchoring object & enclosing object? can any one tell me all the details?

2486

How to set database to be single_user in ms sql server?

1029

For More Un-Answered { Databases } Questions Click Here