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

what is definer rights invoke rights?

1 6545

How can we schedule the procedure to run automatically ?

3 11094

How toimport .dmp file in lower version of oracle from higher version ?

TCS,

4 14103

What are the Restrictions on Cursor Variables?

2 16058

In a Distributed Database System Can we execute two queries simultaneously ? Justify ?

3 10704

what is meant by forward declaration in functions?

TCS,

4 16413

what is difference between stored procedures and application procedures,stored function and application function?

1 11481

State the difference between implict and explict cursor's?

CTS,

7 23183

State the advatage and disadvantage of Cursor's?

2 9571

How to trace the errors in pl/sql block code?

TCS,

5 16635

How to display the contents of a current record fetched in a reference cursor?

2 9096

Explain the usage of WHERE CURRENT OF clause in cursors ?

3 11257

How consistent is the view of the data between and within multiple sessions, transactions or statements ?

2221

How well can multiple sessions access the same data simultaneously ?

Oracle,

1 3510

What is Data Concarency and Consistency?

1 6000

Un-Answered Questions { Databases }

How do I create a mysql database?

924

How do I become a database administrator?

572

Can you please differentiate between a primary key and a unique key?

1009

How to create a stored function in oracle?

1105

When should you consider denormalization?

976

What are procedures in mysql? Explain

977

What are triggers? How do you invoke a trigger on demand?

1318

How to include text values in sql statements?

1037

What are sparse columns?

1013

How to get the definition of a trigger back?

1002

Write a query to display current date and time?

924

What are the indexing methods?

1048

What is multi-statement table-value user-defined function?

994

What options are there to delete rows on the publisher and not on the subscriber? : sql server replication

1216

Do you know what are the steps to process a single select statement?

973

For More Un-Answered { Databases } Questions Click Here