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 19911

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

iFlex,

8 30124

Give an example of any procedure.

Accenture, iFlex, Wipro,

5 16957

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 17068

what are the advantages of package?

iFlex,

7 40151

in materialized view the structure will create immediately or not?

iFlex,

2 8944

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

iFlex, INDUS,

2 11260

How will we see framework of a table?

Accenture,

2 11766

what is index?

4 7979

what is a view?

7 9944

what is primary key?

9 12936

what is foreign key?

5 8469

what is unique key?

Amazon, Cap Gemini, Infosys, Wipro,

14 26871

what is the difference between primary key & foreign key?

CTS, Infosys, La Multi, Sparsh, Wipro,

57 137352

write a query to delete similar records in same table

TCS,

13 25115

Un-Answered Questions { Databases }

Why should I use oracle database?

991

What is cluster control?

830

What is maximum table size in mysql?

948

What is a database? Explain

1110

Is postgresql free for commercial use?

811

What is logs in mysql?

892

Does mysql need a server?

924

Do you know what are various aggregate functions that are available?

1126

What is int identity in sql?

1140

What is the difference between a function and a trigger?

1082

What are various limitations of the views?

1051

What is the difference between count 1 and count (*) in a sql query?

993

Why are stored procedures used?

798

What is difference between foreign key and unique key?

1011

Re: Where can i get informatica certification Exam dumps and details? please forward it to emailid:

2241

For More Un-Answered { Databases } Questions Click Here