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

What are the factors causing the reparsing of SQL statements in SGA?

1 4507

how to dispaly a particular row details from a given table

2 6305

What is a transaction and what are ACID properties?

3 7941

Explain different isolation levels?

4 11072

What's the maximum size of a row?

IBM,

4 11957

Explain Active/Active and Active/Passive cluster configurations?

1 5028

Explain the architecture of SQL Server?

ABC, HP, Oracle,

2 37509

What is lock escalation?

1 7216

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

9 19460

Explain the storage models of OLAP?

1 7458

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

Accenture,

2416

What are constraints? Explain different types of constraints?

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

26 140582

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

IBM,

1 4387

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

2312

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

1 5469

Un-Answered Questions { Databases }

What is the cartesian product of table?

1080

What is 2nf normalization?

1096

What is MySQL?

1057

What is in place upgrade in sql server?

1113

how to analyze tables with 'mysqlcheck'? : Sql dba

1073

How to convert character types to numeric types?

1206

How much memory does mongodb need?

Mention what is the function of cache fusion in oracle rac?

What is 'mysqlshow'?

1125

What does the option psql -l of PostgreSQL display?

1521

What are examples of triggers?

1132

How do I show a collection in mongodb?

Claims and Drains are the locks used to control the concurrency between SQL processes and utilities. Referring to the above statement, what is the maximum number of concurrent Claimers for a Subsystem? Choice 1 32 Choice 2 64 Choice 3 128 Choice 4 256 Choice 5 No limit

2352

You see multiple fragments in the system tablespace, what should you check first?

632

what is the difference between cluster and non cluster index? : Sql dba

1083

For More Un-Answered { Databases } Questions Click Here