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

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

2 8407

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

2 18792

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

7 19029

Difference between Cluster and Non-cluster index?

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

32 147200

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

2 9553

Explain DBMS, RDBMS?

6 23923

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

TetraSoft, Wipro,

3 21751

Explain the basic concepts of SQL server architecture?

College School Exams Tests,

2 17138

Explain couple pf features of SQL server

2 6138

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

2887

Explain fundamentals of Data ware housing & OLAP?

2 8463

Explain the new features of SQL server 2000?

1 6329

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

2005

Explain sp_configure commands, set commands?

3 13011

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

CSC,

2 17269

Un-Answered Questions { Databases }

What is in place upgrade in sql server?

1054

What is an identity column in insert statements?

1033

What is oracle join syntax?

1006

What is the difference between a stored procedure and a query?

1099

Do you know spatial data types - geometry and geography in sql server 2008?

1048

Differentiate between pre-select and pre-query?

1116

Why is neo4j used?

Is mysql query case sensitive?

979

What does null mean?

994

What is indexed view? How to create it?

1023

What is an Oracle SYSTEM tablespace and when is it Created?

1119

Tell me when is the update_statistics command used?

1125

How to disable a login name in ms sql server?

1140

explain about mysql and its features. : Sql dba

1021

What is data type for image in mysql?

876

For More Un-Answered { Databases } Questions Click Here