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 16125

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

iFlex,

8 27539

Give an example of any procedure.

Accenture, iFlex, Wipro,

5 14865

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 14568

what are the advantages of package?

iFlex,

7 37719

in materialized view the structure will create immediately or not?

iFlex,

2 7949

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

iFlex, INDUS,

2 10089

How will we see framework of a table?

Accenture,

2 10487

what is index?

4 5728

what is a view?

7 7900

what is primary key?

9 10344

what is foreign key?

5 6808

what is unique key?

Amazon, Cap Gemini, Infosys, Wipro,

14 22756

what is the difference between primary key & foreign key?

CTS, Infosys, La Multi, Sparsh, Wipro,

57 122073

write a query to delete similar records in same table

TCS,

13 21239

Un-Answered Questions { Databases }

How do I find the database name in oracle?

592

Can you explain about buffer cash and log cache in sql server?

492

Explain coalesce function?

613

What is mongodb and how it works? Explain

What is meant by mysqli?

487

Is there a pl/sql pragma similar to deterministic, but for the scope of one single sql select?

525

What is max connections in mysql?

481

Explain the use of record option in exp command.

524

How to set up local postgres database?

413

What is end user data?

454

What are the types of database users?

490

What is difference between temp table and cte?

525

How to sort the rows in sql.

591

What is sql server locking?

542

Why do you use stored procedures and state some of its disadvantages?

556

For More Un-Answered { Databases } Questions Click Here