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 6547

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 14104

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 23185

State the advatage and disadvantage of Cursor's?

2 9573

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

TCS,

5 16638

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

2 9097

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 3512

What is Data Concarency and Consistency?

1 6000

Un-Answered Questions { Databases }

Which function is used to return remainder in a division operator in sql?

1139

how to use in conditions? : Sql dba

1013

how to display nth highest salary from a table in a mysql query? : Mysql dba

1065

How do I add a sybase driver to sql developer?

866

What is the difference between now() and current_date()?

982

What is special about postgresql?

816

How to return query output in xml format?

1034

How do I install microsoft access 2010?

933

What the different types of replication and why are they used? : sql server DBA

1178

How to extract metadata for the entire database?

1076

What is function of CUBE ?

1046

What are all ddl commands?

1085

Can you get second highest salary from the table?

966

What is a scalar value in sql?

1070

Is primary key an index?

991

For More Un-Answered { Databases } Questions Click Here