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

Can a stored procedure call another stored procedure. If yes what level and can it be controlled?

2 8493

Can a stored procedure call itself(recursive). If yes what level and can it be controlled.?

2 18877

How do you find the number of rows in a table?

7 19257

Difference between Cluster and Non-cluster index?

Accenture, Agility e-Services, eClinicalWorks, HCL, Infosys, Oracle, Satyam, Yardi,

32 148229

What is a table called, if it does not have neither Cluster nor Non-cluster Index?

2 9694

Explain DBMS, RDBMS?

6 24100

Explain basic SQL queries with SELECT from where Order By, Group By-Having?

TetraSoft, Wipro,

3 21846

Explain the basic concepts of SQL server architecture?

College School Exams Tests,

2 17245

Explain couple pf features of SQL server

2 6213

Scalability, Availability, Integration with internet, etc.)?

2940

Explain fundamentals of Data ware housing & OLAP?

2 8546

Explain the new features of SQL server 2000?

1 6389

How do we upgrade from SQL Server 6.5 to 7.0 and 7.0 to 2000?

2054

Explain sp_configure commands, set commands?

3 13128

What is the basic functions for master, msdb, tempdb databases?

CSC,

2 17390

Un-Answered Questions { Databases }

where the dff data will be stored

2543

Explain raiserror in sql server?

1081

Explanation about replication server software?

988

How many types of auditing in Oracle?

1092

HOW TO GET THE ORGANIZATION TO ORGANIZATION DETAILS INFORMATION IN THE INVENTORY MODULE.THE REQUIREMENT IS FROMORG TOORG FROMINV TOINV ..

2568

What are the limitations of mysql?

1107

How is mongodb data stored?

What are analytical functions in sql?

1080

Explain logical operators in sql server?

1184

What are the advantages of using stored procedures?

1008

What is SubQuery in SQL Server 2008

1076

How do I open port 1433?

988

What is the difference between drop table and truncate table?

979

What is enhanced database mirroring in sql server 2008?

1037

How can I get the number of records affected by a stored procedure?

1118

For More Un-Answered { Databases } Questions Click Here