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 8418

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

2 18800

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

7 19058

Difference between Cluster and Non-cluster index?

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

32 147299

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

2 9570

Explain DBMS, RDBMS?

6 23936

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

TetraSoft, Wipro,

3 21762

Explain the basic concepts of SQL server architecture?

College School Exams Tests,

2 17142

Explain couple pf features of SQL server

2 6150

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

2890

Explain fundamentals of Data ware housing & OLAP?

2 8474

Explain the new features of SQL server 2000?

1 6334

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

2010

Explain sp_configure commands, set commands?

3 13013

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

CSC,

2 17281

Un-Answered Questions { Databases }

What is a database in computer?

963

What is data types in database?

989

What is the rdbms concept in sql?

1000

How to get the current date in mysql?

1068

Which parameters are optional in init.ora parameter file?

2225

Explain the three Level Architecture of the Database System

962

How do you link a spreadsheet to a website?

935

Explain what is lock escalation and what is its purpose?

950

What is the purpose of sql profiler in sql server? : sql server database administration

1118

Explain the term entity in dbms?

907

Is sql a backend language?

1104

Can we create database in oracle using command line ?

1098

What kind of database is postgres?

813

How to grant create session privilege to a user in oracle?

1022

Which is faster count (*) or count 1?

1049

For More Un-Answered { Databases } Questions Click Here