Databases Interview Questions, Answers for Freshers and Experienced asked in various Company Job Interviews

Oracle (3239)
SQL Server (4518)
MS Access (429)
MySQL (1402)

Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)

DB Development (113)
SQL PLSQL (3312)
MongoDB (502)
IBM Informix (50)

Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)

Database Management (1391)
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 16174

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

iFlex,

8 27576

Give an example of any procedure.

Accenture, iFlex, Wipro,

5 14899

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 14582

what are the advantages of package?

iFlex,

7 37728

in materialized view the structure will create immediately or not?

iFlex,

2 7958

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

iFlex, INDUS,

2 10108

How will we see framework of a table?

Accenture,

2 10503

what is index?

4 5764

what is a view?

7 7944

what is primary key?

9 10378

what is foreign key?

5 6841

what is unique key?

Amazon, Cap Gemini, Infosys, Wipro,

14 22794

what is the difference between primary key & foreign key?

CTS, Infosys, La Multi, Sparsh, Wipro,

57 122213

write a query to delete similar records in same table

TCS,

13 21319

Un-Answered Questions { Databases }

What are the advantages of dbms?

494

Define transaction and transaction isolation levels?

542

Explain a checkpoint?

532

What are variables in pl sql?

560

How do I delete a sql server database?

543

Is mongodb publicly traded?

What is the difference between microsoft access and excel?

405

How does propagation differ between Advanced Replication and Snapshot Replication (read-only)?

1827

What is sql stored procedure?

599

What is pragma exception?

537

Write a SQL query in order to merge two different columns into single column?

622

What is merge in oracle?

557

What is mapping schema?

576

How to fix a munged log in sybase?

479

What is an identity column in insert statements?

581

For More Un-Answered { Databases } Questions Click Here