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

What is a trigger?

4 8349

What is a view?

6 9446

What is an Index?

Yardi Software,

3 9718

What are the types of indexes available with SQL Server?

Standard Bank,

2 8064

What is the basic difference between clustered and a non-clustered index?

Infogain,

9 38240

What are cursors?

8 11246

When do we use the UPDATE_STATISTICS command?

Deutsche Telekom AG,

4 18930

Which TCP/IP port does SQL Server run on?

2 9998

From where can you change the default port?

3 7017

Can you tell me the difference between DELETE & TRUNCATE commands?

15 25253

Can we use Truncate command on a table which is referenced by FOREIGN KEY?

Shriram,

2 10292

What is the use of DBCC commands?

NA,

4 9353

Can you give me some DBCC command options?(Database consistency check) - DBCC CHECKDB - Ensures that tables in the db and the indexes are correctly linked.and DBCC CHECKALLOC - To check that all pages in a db are correctly allocated. DBCC SQLPERF - It gives report on current usage of transaction log in percentage. DBCC CHECKFILEGROUP - Checks all tables file group for any damage.

iSoft,

2535

Well sometimes sp_reanmedb may not work you know because if some one is using the db it will not accept this command so what do you think you can do in such cases?

2 4763

What is the difference between a HAVING CLAUSE and a WHERE CLAUSE?

World Tech, Yardi Software,

11 29736

Un-Answered Questions { Databases }

What is query image?

986

What is percent sign in sql?

1301

Explain how you can configure a running aggregate in SSRS?

167

What do you mean by field in sql?

1097

What is bulk collect in pl sql?

1109

What is a heap table?

972

Do you know what are different types of replication in sql server?

1112

Define implicit and explicit cursors.

1150

What is the command syntax that tells you whether you are on the master server or not? And how many master does mongodb allow?

Select all the employees who were hired in last 2 years and who works in dept where max managers are working.

2983

Are stored procedures precompiled?

997

How to convert character strings to dates?

1099

What are the advantages of using Query Strings?

1073

What is a ctid?

902

What is clustered vs nonclustered index?

963

For More Un-Answered { Databases } Questions Click Here