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 19923

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

iFlex,

8 30145

Give an example of any procedure.

Accenture, iFlex, Wipro,

5 16969

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 17091

what are the advantages of package?

iFlex,

7 40165

in materialized view the structure will create immediately or not?

iFlex,

2 8950

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

iFlex, INDUS,

2 11264

How will we see framework of a table?

Accenture,

2 11769

what is index?

4 7991

what is a view?

7 9971

what is primary key?

9 12957

what is foreign key?

5 8486

what is unique key?

Amazon, Cap Gemini, Infosys, Wipro,

14 26900

what is the difference between primary key & foreign key?

CTS, Infosys, La Multi, Sparsh, Wipro,

57 137466

write a query to delete similar records in same table

TCS,

13 25140

Un-Answered Questions { Databases }

What is trigger in flip flop?

1007

Explain the use of Merge statement in oracle 11g

1029

How to use select statement to count the number of rows in oracle?

1046

What do you do in data exploration

997

What is advantage of dbms?

1013

what is grd?

1101

What is varchar used for?

1083

What are parameter files? Where do we use them?

Which tcp/ip port does sql server run on? How can it be changed? : Sql dba

1003

Write a query for primary key constraint with identity key word?

1031

Describe how to use linked server?

1021

How is clustered database important in oracle rac architecture?

What's the latest version of mysql?

990

What are the benefits of mongodb?

What is the option that can be used in PostgreSQL to find out how the query optimizer is evaluating the query given?

1320

For More Un-Answered { Databases } Questions Click Here