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

What are the options available to refresh snapshots ?

2 6106

what is snapshot log ?

2 7738

When will the data in the snapshot log be used ?

2 5432

What are the benefits of distributed options in databases ?

1 4559

what is inline view?

15 42435

what is the difference between implicit conversions and explicit conversions?

2 9338

what is primary key,unique key, foreign key? can u teach me in simple language?

Banking, CMC, CTS, HCL, Infosys, Keggfarms, SkyEss, Sunrise, TCS, Web Synergies, Wipro,

44 189063

Write a Select Query to display title for each group of records, which are collected with Compute Clause? Like titlefield column-A column-B ..... ..... ..... Sum ... titlefield column-A column-B ..... ..... ..... Sum ...

Crown Solutions,

2072

What are the type of Indexes? which one is best, why?

6 9893

How to work on DTS?what is the main requirement?

Getit, ivan,

1 5847

Whatz the main diff between Subquery and a Join

Oracle, Zeta Interactive,

14 33946

Let?s say you have 100,000 records and you want to delete 95,000 at a time and keep only 5 thousand. But in local memory you don?t have enough space for 95,000 records. What do you do in this case? How do you delete without any problem with time and performance?

eBay,

3 10159

I need data on eBay customers in Chicago who can did bid on certain item? I dont have access to eBay database directly. How I get the information?

eBay, Google,

1 8212

With DTS packaging I can store tables in Excel and convert them back to SQL. But once I copied tables to Excel I want to modify some info. How you do that without editing the Excel file?

eBay,

2634

What is cursor and where do you use them?

eBay,

2 8672

Un-Answered Questions { Databases }

Suppose you want to implement the one-to-many relationships while designing tables. How would you do it?

1005

How to drop an index?

1015

What is a read write transaction in oracle?

1134

How would you check the long running transaction?

976

What file will give you oracle instance status information? Where is it located?

661

What is a stretch database?

990

What is a dead tuple?

849

What is rank dense_rank and partition in sql?

1087

what is the difference between cluster and non cluster index? : Sql dba

1080

Explain the difference between triggers and constraints?

1025

How is a PL/SQL code compiled?

1283

What is difference between mysql and mongodb?

PostgreSql Disadvantages

1979

What are Row versions of DataRow?

1083

What is difference between pdo and mysqli?

1038

For More Un-Answered { Databases } Questions Click Here