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 are the factors causing the reparsing of SQL statements in SGA?

1 4432

how to dispaly a particular row details from a given table

2 6199

What is a transaction and what are ACID properties?

3 7764

Explain different isolation levels?

4 10923

What's the maximum size of a row?

IBM,

4 11789

Explain Active/Active and Active/Passive cluster configurations?

1 4943

Explain the architecture of SQL Server?

ABC, HP, Oracle,

2 37369

What is lock escalation?

1 7141

What's the difference between DELETE TABLE and TRUNCATE TABLE commands?

9 19142

Explain the storage models of OLAP?

1 7392

What are the new features introduced in SQL Server 2000? What changed between the previous version of SQL Server and the current version?

Accenture,

2370

What are constraints? Explain different types of constraints?

Emsang, Kendriya Vidyalaya(Kvs), Polaris, Wipro,

26 139718

As a part of your job, what are the DBCC commands that you commonly use for database maintenance?

IBM,

1 4299

What are statistics, under what circumstances they go out of date, how do you update them?

2261

What is RAID and what are different types of RAID configurations?

1 5322

Un-Answered Questions { Databases }

What is update locks?

897

what is the odi console?

640

How many types of data are there?

1011

What is difference between two tier and three tier?

869

What is the difference between dataadapter and datareader?

1024

What is the syntax of update document?

How do users use Report Builder with SQL Server data sources?

160

What is memory table?

911

What's the difference between inner join and left join?

1011

Suppose we have a table "MyTable" containing 10 rows, what query should be executed to update the odd rows "Salary" as 9000?

992

What are wait types?

1129

what does the SET clause is used for in Neo4j?

What are magic tables in sql server?

1144

How to download and install sql server 2005 books online?

1203

Can you tell me about the concept of ER diagrams?

1094

For More Un-Answered { Databases } Questions Click Here