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

Explain about builtinadministrator?

1068

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

1112

Tell me what is use of except clause? How it differs from not in clause?

970

Can you please differentiate between a primary key and a unique key?

1020

Explain what is dbcc?

1021

Explain in brief how sql server enhances scalability of the database system?

990

Explain what is row_number function?

1052

Tell me what is difference between clustered and non clustered index?

954

Explain the phases a transaction has to undergo?

1073

What is sql service broker?

995

List down some advantages of sql stored procedure?

976

Do you know what are the properties of the relational tables?

1040

Can you explain various data region available in ssrs with their use?

987

Tell me in brief how sql server enhances scalability of the database system?

1006

Explain what is log shipping?

1154

Un-Answered Questions { Databases }

How do you set a trace flag in sql server?

1047

What is open database communication (odbc) in oracle?

1017

table structure: ---------------- col1 col2 ----- ----- 01-mar-2012 11:12:46 01-mar-2012 11:12:10 01-mar-2012 11:12:46 01-mar-2012 11:11:23 Write a query to display the result as shown below: col1 col2 ----- ----- 01-mar-2012 11:12:46 01-mar-2012 11:12:10

4307

How can you hide the sql server instances?

1029

Explain compound trigger in oracle?

1051

Explain the truncate in oracle?

978

What do you mean by merge in oracle and how can we merge two tables?

1060

What is mongodb cluster?

How to open a cursor variable?

1051

What is a database table in oracle?

1031

How do I connect to pgadmin server?

942

Which database is good for large data?

1000

What is log shipping? Can we do logshipping with SQL Server 7.0 - Logshipping is a new feature of SQL Server 2000. We should have two SQL Server - Enterprise Editions. From Enterprise Manager we can configure the logshipping. In logshipping the transactional log file from one server is automatically updated into the backup database on the other server. If one server fails, the other server will have the same db and we can use this as the DR (disaster recovery) plan.

2775

What causes re-resolution of a stored procedure in sybase?

906

What are the three pl sql block types?

1018

For More Un-Answered { Databases } Questions Click Here