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 a formula column refered to columns in higher group?

1 3981

What are the built_in used to trapping errors in forms 4?

1 4168

when a procedure /package is getting invalidated?

TCS,

4 13821

how to create a primary key with out creating an index?

TCS,

9 21272

how a reference cursor works?what all adnvantages are gained with it..specify the situation?

TCS,

4 13282

what is Hash join?how it is different from inner join?what is the sign used for inner join?(eg: like the (+) sign used for outer join)?

TCS,

3 17808

What is the Symbol use for Inner Join

Oracle, TCS,

1 13498

how instead of triger is helpful for mutating tables errors handlling ?

Oracle,

2 10749

How do you use trigger to create mutating state of table

TCS,

2 7189

When the procedures or packagess become invalidate

TCS,

3 8730

what is the difference between TRUNCATE and DELETE command in SQL

ICICI, Saama Tech, SkyTech, TCS,

23 67233

HOW SHALL WE DIFFERENTIATE BETWEEN PRIMARY KEY AND FORIEGN KEY?

4 10355

what is meant by Dynamic query?

Satyam,

3 13972

How to execute OS(operating system) command from pl/sql?

3 10752

What is the best strategy to use COMMIT in a pl/sql loop?

3 10310

Un-Answered Questions { Databases }

What is the difference between delete and truncate statements?

1131

System tablespace cant be exported from one database and imported into another why?

599

Enlist the advantages of normalizing database.

1089

How to deactivate triggers?

978

What does cursor do in sql?

1067

How do I change mysql password?

1086

Does partitioning improve performance?

1023

Is left join faster than join?

1096

let's assume you have data that resides on sql server 6.5. You have to move it sql server 7.0. How are you going to do it? : Sql server database administration

1022

How insert into statements in sql?

1123

Explain autosys. Why do you need it.

1032

When using replication, can some members use journaling and others not?

How to write a left outer join with the where clause in oracle?

1134

as a technical developer in oracle applications which type errors feced in your experience sofar

2236

What is the usage of when clause in trigger?

1091

For More Un-Answered { Databases } Questions Click Here