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

what is definer rights invoke rights?

1 6633

How can we schedule the procedure to run automatically ?

3 11217

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

TCS,

4 14276

What are the Restrictions on Cursor Variables?

2 16164

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

3 10832

what is meant by forward declaration in functions?

TCS,

4 16575

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

1 11564

State the difference between implict and explict cursor's?

CTS,

7 23427

State the advatage and disadvantage of Cursor's?

2 9673

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

TCS,

5 16822

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

2 9190

Explain the usage of WHERE CURRENT OF clause in cursors ?

3 11394

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

2272

How well can multiple sessions access the same data simultaneously ?

Oracle,

1 3612

What is Data Concarency and Consistency?

1 6064

Un-Answered Questions { Databases }

Can we check locks in database? If so, how can we do this lock check?

989

How do I select a database in mysql?

1127

How does pgadmin connect to remote database?

1034

Is it possible to center an object horizontally in a repeating frame that has a variable horizontal size ?

2423

Why dbms is used?

980

What are the advantages of ms access over ms sql server?

903

What is difference between getdate and sysdatetime in sql server 2008?

1099

What are truncate options available in sql server? : sql server database administration

1088

What is the importance of primary key in ms access?

976

Delete duplicate rows without using rowid.

1591

What is the Difference Primary key and Unique Key

1049

Explain atomicity and aggregation?

1069

How do you check sql server is up and running?

1057

hiding item in report how like that properly,thats manually but at runtime i want to do

3330

What is clause in sql?

1178

For More Un-Answered { Databases } Questions Click Here