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 4440

how to dispaly a particular row details from a given table

2 6204

What is a transaction and what are ACID properties?

3 7772

Explain different isolation levels?

4 10931

What's the maximum size of a row?

IBM,

4 11794

Explain Active/Active and Active/Passive cluster configurations?

1 4950

Explain the architecture of SQL Server?

ABC, HP, Oracle,

2 37375

What is lock escalation?

1 7148

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

9 19149

Explain the storage models of OLAP?

1 7396

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

Accenture,

2374

What are constraints? Explain different types of constraints?

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

26 139755

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

IBM,

1 4310

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

2265

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

1 5332

Un-Answered Questions { Databases }

Explain data independence?

1051

What is the function of mysqldump?

1083

what is reindexing?

1694

How do I make a pgadmin server?

901

What are the examples of database?

908

Which database stores information about replication?

1080

What is bcnf standard form in dbms?

1040

What is cursor in ms sql server?

1160

What are the advantages of ms access over ms sql server?

862

How to add new field to existing document in mongodb using java?

How do I show columns in mysql?

943

How many types of database languages are?

947

What is ole db in ssis?

1070

How can you tell the difference between an index and a view?

944

Explain magic tables in sql server?

1071

For More Un-Answered { Databases } Questions Click Here