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

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

1 2107

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

1 1977

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

1 4933

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

2 6451

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

1 5409

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

1 2551

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

1 5592

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

1 4627

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

1 2117

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,

1 2380

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

1 2036

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

1 4465

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.

1 2070

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

1 6823

How does Oracle guarantee data integrity of data changes?

SoftSol,

1 4476

Un-Answered Questions { Databases }

Can we use distinct and group by together?

1129

Where can you add custom error messages to sql server?

1197

Is there some bulk load or other way to import a lot of data fast?

929

What is the difference between case version and decode version?

1102

List the ways in which dynamic sql can be executed?

1079

What is the difference between for xml raw and for xml auto?

1108

What are the kinds of subquery?

1098

Hi , any one can help me on the same,this is regarding the Informatica Function doc,i want to know how developer is will develop the mapping. pl forwar the any function doc .just for my references. svlc75@yahoo.co.in

2097

What is current version of mysql?

1068

please send me oracle pl/sql exp resume. and also faqs...

2566

Is primary key always clustered index?

1090

Is inner join faster than left join?

1273

What is oracle latest version?

1169

What is a concurrency problem in dbms?

1049

Does group by remove duplicates?

1108

For More Un-Answered { Databases } Questions Click Here