Databases Interview Questions, Answers for Freshers and Experienced asked in various Company Job Interviews

Oracle (3239)
SQL Server (4518)
MS Access (429)
MySQL (1402)

Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)

DB Development (113)
SQL PLSQL (3312)
MongoDB (502)
IBM Informix (50)

Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)

Database Management (1391)
Databases AllOther (288)

Databases Interview Questions

Questions Answers Views Company eMail

what is definer rights invoke rights?

1 5913

How can we schedule the procedure to run automatically ?

3 9867

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

TCS,

4 12563

What are the Restrictions on Cursor Variables?

2 15022

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

3 9604

what is meant by forward declaration in functions?

TCS,

4 14848

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

1 10740

State the difference between implict and explict cursor's?

CTS,

7 20791

State the advatage and disadvantage of Cursor's?

2 8510

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

TCS,

5 14844

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

2 8045

Explain the usage of WHERE CURRENT OF clause in cursors ?

3 9881

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

1728

How well can multiple sessions access the same data simultaneously ?

Oracle,

1 2690

What is Data Concarency and Consistency?

1 5283

Un-Answered Questions { Databases }

can we call primary key a 'address'????

1964

How to insert and update data into a table with "insert" and "update" statements?

524

Working with TLogs

1465

Which operations lock the database in mongodb?

What is update locks?

524

You want to generate a report that is formatted as a chart. Can you use the report wizard to create such a report?

How to drop a stored procedure in oracle?

604

What is the most restrictive isolation level? : Transact sql

586

How do I edit a procedure in sql server?

562

How can an index be declared in mysql?

474

What is replication server? What is its role in sybase?

543

Explain what is a column in a table?

588

How to look at the current sql*plus system settings?

619

What is difference between logical standby database and physical standby database?

299

What is sql server english query?

558

For More Un-Answered { Databases } Questions Click Here