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

Can i use Commit inside the Trigger? Suppose i use commit what will be happy (it's complied /executed/work)

6 15031

What is pl/sql tables?

TCS,

7 12614

What is a mutating table

TCS, Tech Mahindra,

5 11382

Can i possible to see Table Details ? Ex : Table Name Date Time User Emp May/18/2010 12:59pm Scott

3 6445

How to handle errors in Stored Procedures.

Accenture,

2 8771

what is the Default Libraries for Oracle Report 6i

IBM,

2328

What is the Diff b/w Constraints and Trigeer

HCL,

4 12812

If the base table structure is changed what will happen to join index????

2 6715

what is the difference between procedure and function.

Thomson,

4 8977

What are data segments?

3 7074

how to find the fifth highest salary?

IBM, Infosys,

8 12966

Hi all, i have a table as follows empid empname mgrid deptid 1 a 3 4 2 b 1 5 3 c 2 3 4 d 3 6 5 e 4 7 i want the output as empname mgrname a c b a c b d c e d

4 8531

what is the different between unique+not null & primary key,

4 7916

What are Magic Tables?

TCS,

4 11943

Security Question- SQL DBA exparts, need your help...

3 5821

Un-Answered Questions { Databases }

What are pessimistic lock and optimistic lock?

1147

How does sharding work with replication?

What is updatable resultset?

1079

Can a View based on another View in Oracle?

1075

What are record groups ? Explain the types of record group.

What is the difference between row level and statement level trigger?

1073

How can I see the connections which you used in mongos?

If you see a pin hit ratio of less than 0.8 in the estat library cache report is this a problem? If so, how do you fix it?

1237

how to clone 9i Database on to 10g Database.

2388

What is difference between postgresql and mysql?

985

How many types of dimensions are there and what are they? : sql server analysis services, ssas

1129

what are all different types of collation sensitivity? : Sql dba

1034

Explain a data segment?

1112

Explain what are the type of synonyms?

1191

Is a foreign key always unique?

986

For More Un-Answered { Databases } Questions Click Here