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

Oracle (3253)
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 20347

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

iFlex,

8 30486

Give an example of any procedure.

Accenture, iFlex, Wipro,

5 17195

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 17373

what are the advantages of package?

iFlex,

7 40396

in materialized view the structure will create immediately or not?

iFlex,

2 9086

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

iFlex, INDUS,

2 11388

How will we see framework of a table?

Accenture,

2 11897

what is index?

4 8157

what is a view?

7 10178

what is primary key?

9 13239

what is foreign key?

5 8643

what is unique key?

Amazon, Cap Gemini, Infosys, Wipro,

14 27298

what is the difference between primary key & foreign key?

CTS, Infosys, La Multi, Sparsh, Wipro,

57 139256

write a query to delete similar records in same table

TCS,

13 25515

Un-Answered Questions { Databases }

explain advantages of myisam over innodb? : Sql dba

1120

How do I upgrade sql?

1051

What is an execution plan?

1246

What are the various features present in ms access?

899

How to count rows with the count(*) function in ms sql server?

1069

Which are the storage engines used by mongodb?

Define the SGA and: How you would configure SGA for a mid-sized OLTP environment? What is involved in tuning the SGA?

3812

What is sql in dbms?

1067

Does mongodb need a lot of ram?

How does left join work in sql?

1055

What are indexes in postgresql?

924

What is write ahead logging in DBMS?

1146

how you can configure a running aggregate in SSRS?

199

PURCHASE ORDER TO PAYABLES WHAT ENTREIS WILL HAVE

2288

What does select * from mean in sql?

3345

For More Un-Answered { Databases } Questions Click Here