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

Can a formula column refered to columns in higher group?

1 3919

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

1 4110

when a procedure /package is getting invalidated?

TCS,

4 13645

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

TCS,

9 21013

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

TCS,

4 13140

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 17656

What is the Symbol use for Inner Join

Oracle, TCS,

1 13408

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

Oracle,

2 10640

How do you use trigger to create mutating state of table

TCS,

2 7085

When the procedures or packagess become invalidate

TCS,

3 8584

what is the difference between TRUNCATE and DELETE command in SQL

ICICI, Saama Tech, SkyTech, TCS,

23 66492

HOW SHALL WE DIFFERENTIATE BETWEEN PRIMARY KEY AND FORIEGN KEY?

4 10195

what is meant by Dynamic query?

Satyam,

3 13805

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

3 10601

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

3 10158

Un-Answered Questions { Databases }

Why would you use sql agent?

1265

how to avoid cursors? : Sql server database administration

972

What is sybase used for?

958

What are the different types of indexes?

1119

What is xml datatype?

1075

What are the objectives of rdbms?

908

What is update locks?

888

What is transaction server isolation?

1040

How is a developer added to a trusted publishers list?

839

What is primary key and foreign key?

962

What is the use of access?

858

How to assign values to data fields in record variables?

1035

What are procedures in dbms?

919

In mongodb, how sharding and replication work together?

What does dba stand for database?

601

For More Un-Answered { Databases } Questions Click Here