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 Schema ?

6 9506

What is an Index ? How it is implemented in Oracle Database ?

4 11674

What is clusters ?

2 6647

What is a cluster Key ?

2 11157

What are the basic element of Base configuration of an oracle Database ?

2 5423

What is a deadlock ? Explain .

1 5906

What is SGA ? How it is different from Ver 6.0 and Ver 7.0 ?

TCS,

1 5079

What is a Shared SQL pool ?

2 7205

What is mean by Program Global Area (PGA) ?

Bajaj,

9 22730

What is a data segment ?

1 4891

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

2 5451

What is Database Buffers ?

1 4888

What is dictionary cache ?

2 5606

What is meant by recursive hints ?

1 6407

What is meant by redo log buffer ?

2 7702

Un-Answered Questions { Databases }

Is the primary key column of a table an index in ms sql server?

971

What is 5nf in normalization form?

1007

What options are there to delete rows on the publisher and not on the subscriber? : sql server replication

1229

What are the types of distributed database?

919

Explain what is sql*plus?

1154

What is clustered vs nonclustered index?

960

default triggers available for reports

2226

Do you know what is fill factor and pad index?

1010

What is procedure in database?

1008

You have modified 100 store procedures and want to replicate these changes from development to prodution, and production can have users using the Server/DB, how would you replicate without causing issues?

2160

Have you come across the error ?Failed while printing ?. Why it is happened and How to solve that?

1994

What is the purpose of queries in a database?

1063

What are the basic features of a trigger in ms sql server?

1211

what are the t string functions available in tsql? : Transact sql

1022

How to view existing indexes on an given table using sys.indexes?

1095

For More Un-Answered { Databases } Questions Click Here