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

Explain system rowset functions?

1014

How can we solve concurrency problems?

1068

How can I check that whether automatic statistic update is enabled or not?

1056

If any stored procedure is encrypted, then can we see its definition in activity monitor?

1005

What are wait types?

1135

How to remove duplicate rows from table except one?

1021

Explain raiserror in sql server?

1038

What kind of problems occurs if we do not implement proper locking strategy?

1419

Is it possible to have clustered index on separate drive from original table location?

980

What is table join?

1131

What is difference between table aliases and column aliases? Do they affect performance?

980

What are points to remember while using the fillfactor argument?

980

What is oltp (online transaction processing)?

1026

Which tcp/ip port does the sql server run on? How can it be changed?

1072

What are different types of views?

961

Un-Answered Questions { Databases }

What is difference between 2 tier and 3 tier architecture?

796

What is mysql and mysqli?

939

What is root password?

926

Do prepared statements prevent sql injection?

960

Why packages are used in oracle?

1088

Explain the microsoft sql server delete command? : sql server architect

814

What is scan table/view and seek table/view when its occurs? : sql server database administration

1071

How to rename an existing column in a table?

1071

What is the exist operator?

Why do we need view in sql?

994

What is join view in sql?

955

What is foreign key in java?

849

In mongodb how do you use $set to update a nested value?

What data types does sybase support?

903

Is there a free version of mysql?

953

For More Un-Answered { Databases } Questions Click Here