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 3979

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

1 4166

when a procedure /package is getting invalidated?

TCS,

4 13816

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

TCS,

9 21259

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

TCS,

4 13274

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 17800

What is the Symbol use for Inner Join

Oracle, TCS,

1 13490

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

Oracle,

2 10745

How do you use trigger to create mutating state of table

TCS,

2 7188

When the procedures or packagess become invalidate

TCS,

3 8723

what is the difference between TRUNCATE and DELETE command in SQL

ICICI, Saama Tech, SkyTech, TCS,

23 67218

HOW SHALL WE DIFFERENTIATE BETWEEN PRIMARY KEY AND FORIEGN KEY?

4 10348

what is meant by Dynamic query?

Satyam,

3 13967

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

3 10751

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

3 10305

Un-Answered Questions { Databases }

How can I tell if sql server is 32 or 64 bit?

1014

What are the steps in creating a database?

979

How many sql databases can you have on one server?

1155

What is database replication?

1210

How can I check that whether automatic statistic update is enabled or not?

1097

What is data sublanguage?

1093

can sql servers linked to other servers like oracle? : Sql dba

1054

How to create software using microsoft access?

1004

what is a cursor? : Sql dba

1066

How to change sql*plus system settings?

1111

what are all the conversion and interfaces in GL,AP,AR,HRMS with example? otherwise send send link for these

2381

In DBMS, what are the two integrity rules used?

995

What is the usage of synonyms?

1219

What is replication with database mirroring? : sql server database administration

1152

Is it possible to declare or create a cursor for update of table? If no tell me why?

1120

For More Un-Answered { Databases } Questions Click Here