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

there are 2 variables called x and y ,x contains 1,2 and y contains 3,4 we have to swap the values from x to y and y to x with out using dummy variables and it can be done only by using a single statement ? how?

Oracle,

12 20033

what is difference between procedure and function, procedure and trigger?

iFlex,

8 30191

Give an example of any procedure.

Accenture, iFlex, Wipro,

5 17007

While inserting 10 rows using procedure, if 3rd entry is having some error, what will be the output? How u will handle that error?

iFlex,

8 17152

what are the advantages of package?

iFlex,

7 40221

in materialized view the structure will create immediately or not?

iFlex,

2 8993

which sql command we can use to get a print out from oracle?

iFlex, INDUS,

2 11299

How will we see framework of a table?

Accenture,

2 11800

what is index?

4 8025

what is a view?

7 9998

what is primary key?

9 13018

what is foreign key?

5 8509

what is unique key?

Amazon, Cap Gemini, Infosys, Wipro,

14 27006

what is the difference between primary key & foreign key?

CTS, Infosys, La Multi, Sparsh, Wipro,

57 137816

write a query to delete similar records in same table

TCS,

13 25229

Un-Answered Questions { Databases }

How do you create a database?

930

what are the differences between char and nchar? : Sql dba

1124

Explain self joins in oracle?

1030

Difference between DELETE and TRUNCATE?

1064

Explain the properties of a relational table?

1044

Why plvtab is considered as the easiest way to access the pl/sql table?

1238

What are the different optimizers that are used to optimize database?

How many types of relationship exist in database designing?

903

What does a database contain?

895

How to stop a loop early with break statements in ms sql server?

1038

What is an agent and What are the types of agents?

644

Define neo4j?

What are the four objects in microsoft access?

923

How do I delete a database in phpmyadmin?

897

How does index help in query performance?

1045

For More Un-Answered { Databases } Questions Click Here