Databases Interview Questions, Answers for Freshers and Experienced asked in various Company Job Interviews

Oracle (3253)
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?

1 1069

How can we solve concurrency problems?

1116

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

1108

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

1061

What are wait types?

1235

How to remove duplicate rows from table except one?

1079

Explain raiserror in sql server?

1 1095

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

1493

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

1034

What is table join?

1 1193

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

1 1044

What are points to remember while using the fillfactor argument?

1 1031

What is oltp (online transaction processing)?

1 1072

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

1 1138

What are different types of views?

1 1012

Un-Answered Questions { Databases }

what is the difference between openrowset and openquery?

1186

What are the properties of the transaction?

1069

explain different types of backups avaialabe in sql server? Given a particular scenario, how would you go about choosing a backup plan? : Sql server database administration

1124

Please send me Informatica 8.1 certification dumps, my mail id mona85gupta@gmail.com

1945

what is the Ticketing tool used in Wipro technologies at Bangalore...???

8225

How did mongodb get its name?

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

1034

what is sql server agent? : Sql dba

1174

Can you tell me about your experience with the administration of COTS system..? Also, how do you set up seed data..?

2698

What are the different SQL Server Versions you have worked on?

1075

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

1108

What are the types of database explain each of them briefly?

1049

What is a concurrency problem in dbms?

1049

What is clustered index

1081

What is temporary table in sql server? Why we use temp table?

1008

For More Un-Answered { Databases } Questions Click Here