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

how can it possibble to see the report output in excel sheet in oracle applications

Oracle, Wipro,

4 10121

what is sql*loader parameters and where we will use it.

Accenture,

1 7466

What is the use of cursor ? how cursor allocate context area for executing the sql statement?

HCL,

4 16640

how to connect sybase to sql server 2005?.

ABC,

1 5692

what is bulk bind

TCS,

4 15133

what is mean by forward declaration and where we'll use it.

TCS,

4 25285

what is the order of pre-defined exceptions.

TCS,

6 16966

Can a table have two primary keys?

HCL, MetaCube,

44 98211

What is the first action to perform a query? Suppose I have four tables and five joins and my query is getting slow day by day.

Hexaware,

4 12315

how to select a field with firstletter as capital and remaining are small letters

11 19416

what is the syntax of update command?

Semantic Space,

3 6674

which clause we are not used in where clause?

Semantic Space,

3 7810

waht is referencial integrity?

Semantic Space,

2 7664

How to write stored procedure to update the data in 10 tables

4 14190

How to write query to Delete the records in child table and corresponding records in parent table

Semantic Space,

11 35370

Un-Answered Questions { Databases }

what are the drivers in mysql? : Sql dba

1064

How do I find sql server instance name?

1010

How can you find out how many users are currently logged into the database?

647

how to show all records starting with the letters 'sonia' and the phone number '9876543210' limit to records 1 through 5.

969

What are the differences between mysql vs sql server?

1138

When using replication, can some members use journaling and others not?

What is bind variable in oracle 11g?

1097

What do you mean by adaptive server enterprise?

1000

Using the relations and the rules set out in the notes under each relation, write statements to create the two sequence generators specified in the notes.

2176

What are the three different part of rdl file explain them?

276

What is the main function of microsoft access?

942

What is ordbms with example?

973

How do you troubleshoot errors in a SQL Server Agent Job?

1117

How does Tuple-oriented relational calculus differ from domain-oriented relational calculus

832

How to update values on multiple rows in oracle?

1082

For More Un-Answered { Databases } Questions Click Here