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 6570

How can we schedule the procedure to run automatically ?

3 11128

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

TCS,

4 14148

What are the Restrictions on Cursor Variables?

2 16080

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

3 10740

what is meant by forward declaration in functions?

TCS,

4 16458

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

1 11509

State the difference between implict and explict cursor's?

CTS,

7 23252

State the advatage and disadvantage of Cursor's?

2 9604

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

TCS,

5 16682

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

2 9122

Explain the usage of WHERE CURRENT OF clause in cursors ?

3 11288

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

2232

How well can multiple sessions access the same data simultaneously ?

Oracle,

1 3538

What is Data Concarency and Consistency?

1 6016

Un-Answered Questions { Databases }

Does office 365 business premium include access?

777

Can you explain what are commit and rollback in sql?

954

What are the High-Availability solutions in SQL Server and differentiate them briefly?

1161

What are the essential components of sql server service broker?

1035

How do you get column names only for a table (sql server)?

1179

How to use wildcard characters in like operations in ms sql server?

1157

What are the different authentication modes in sql server?

1138

How to rename an existing table in mysql?

1038

What is the hostname for mysql database?

1039

What are the constraints available in sql?

1063

How to write a query with a full outer join in ms sql server?

1098

What is the command used to recompile the stored procedure at run time?

1095

What is a join?

1080

What is the full form of rdbms?

1011

you need to add parameters to a query in ms access database. How would you do that?

855

For More Un-Answered { Databases } Questions Click Here