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 8497

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

2 18883

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

7 19267

Difference between Cluster and Non-cluster index?

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

32 148279

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

2 9705

Explain DBMS, RDBMS?

6 24103

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

TetraSoft, Wipro,

3 21857

Explain the basic concepts of SQL server architecture?

College School Exams Tests,

2 17254

Explain couple pf features of SQL server

2 6216

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

2940

Explain fundamentals of Data ware housing & OLAP?

2 8550

Explain the new features of SQL server 2000?

1 6395

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 13140

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

CSC,

2 17395

Un-Answered Questions { Databases }

Can a foreign key be null?

1151

What is policy management?

1056

Write a query to include a constraint, to check whether the employee salary is greater than 5000?

1661

What is projection in mongodb?

Explain full-text query in sql server?

1058

How can I speed up sql query?

1013

Can we perform dml in function?

1142

i want to know rdbms certification details and syallabus and for whom i contact for rdbms certification in bangalore i need answer very urgent please mail to aniltelkar50@gmail.com please as soon as possible

2391

Who developed MongoDB and when?

Mention some disadvantages of query?

1037

When was mongodb created?

What are the ddl commands?

1058

Mention the differences between unique key and primary key

1042

Where is the mysql database stored?

963

Explain sql data types?

1147

For More Un-Answered { Databases } Questions Click Here