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

How does propagation differ between Advanced Replication and Snapshot Replication (read-only)?

2050

Which dictionary view(s) would you first look at to understand or get a high-level idea of a given Advanced Replication environment?

1912

How would you begin to troubleshoot an ORA-3113 error?

1 4827

Which dictionary tables and/or views would you look at to diagnose a locking issue?

2 6312

An automatic job running via DBMS_JOB has failed. Knowing only that "it's failed", how do you approach troubleshooting this issue?

1 5255

How would you extract DDL of a table without using a GUI tool?

2492

You're getting high "busy buffer waits" - how can you find what's causing it?

1 5483

What query tells you how much space a tablespace named "test" is taking up, and how much space is remaining?

1 4521

Database is hung. Old and new user connections alike hang on impact. What do you do? Your SYS SQLPLUS session IS able to connect.

2048

Database crashes. Corruption is found scattered among the file system neither of your doing nor of Oracle's. What database recovery options are available? Database is in archive log mode.

Infosys,

2286

Illustrate how to determine the amount of physical CPUs a Unix Box possesses (LINUX and/or Solaris).

1979

How do you increase the OS limitation for open files (LINUX and/or Solaris)?

1 4353

Provide an example of a shell script which logs into SQLPLUS as SYS, determines the current date, changes the date format to include minutes & seconds, issues a drop table command, displays the date again, and finally exits.

2000

Explain how you would restore a database using RMAN to Point in Time?

1 6713

How does Oracle guarantee data integrity of data changes?

SoftSol,

1 4374

Un-Answered Questions { Databases }

Why main is user defined function?

1017

types of receipts and detail desription about recipts and tables effected by receipts?

2076

What will be the maximum number of index per table?

1012

What is work_mem in postgresql?

870

How do you limit the number of result returned?

What does select * from mean in sql?

3249

What are codd rules?

971

what are the differences between get and post methods in form submitting. Give the case where we can use get and we can use post methods? : Sql dba

1139

How do I connect to postgresql access?

1028

Scalability, Availability, Integration with internet, etc.)?

2885

What is raw datatype?

1145

How do I start mongodb?

What is maximum table size in mysql?

951

What is the syntax and use of the coalesce function?

1178

What is the stuff and how does it differ from the replace function?

1140

For More Un-Answered { Databases } Questions Click Here