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 16958

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 40152

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 7980

what is a view?

7 9947

what is primary key?

9 12937

what is foreign key?

5 8469

what is unique key?

Amazon, Cap Gemini, Infosys, Wipro,

14 26872

what is the difference between primary key & foreign key?

CTS, Infosys, La Multi, Sparsh, Wipro,

57 137356

write a query to delete similar records in same table

TCS,

13 25118

Un-Answered Questions { Databases }

What are different categories of sql commands?

1133

How would you best determine why your MVIEW couldn't FAST REFRESH?

2360

You want to be sure that queries in a database always execute at the maximum possible speed. To achieve this goal you have created various indexes on tables which other statement will keep the database in good condition?

1073

What is a user exit program in oracle reports?

1028

What is oracle d2k?

What is the meaning of database backup?

626

How does mysql store binary data?

961

How do I clear a mysql database?

955

Explain what role entity and relationship play in an ER diagram.

1071

What is pl sql in dbms?

949

What is transaction server distributed transaction?

1054

What are triggers in mysql?

928

What are the features of Embedded SQL

1129

what is a major difference between sql server 6.5 and 7.0 platform wise? : Sql server database administration

908

List the different types of joins?

1007

For More Un-Answered { Databases } Questions Click Here