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

What are the options available to refresh snapshots ?

2 6004

what is snapshot log ?

2 7649

When will the data in the snapshot log be used ?

2 5338

What are the benefits of distributed options in databases ?

1 4475

what is inline view?

15 42004

what is the difference between implicit conversions and explicit conversions?

2 9235

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 187825

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,

2037

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

6 9698

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

Getit, ivan,

1 5778

Whatz the main diff between Subquery and a Join

Oracle, Zeta Interactive,

14 33527

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 10025

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 8120

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,

2571

What is cursor and where do you use them?

eBay,

2 8530

Un-Answered Questions { Databases }

What are the differences between interval year to month and interval day to second?

1028

How to use group functions in the select clause in ms sql server?

1058

What is access on a computer?

805

Is microsoft discontinuing access?

840

What are sql*plus environment variables?

1098

What is mongodb tutorial?

How to create sub reports?

245

Can you pass expressions to function parameters?

1103

What is Data Storage - Definition Language?

887

What are the reasons for selecting lamp (linux, apache, mysql, php) instead of combination of other software programs, servers and operating systems?

1011

how to implement data validations?

595

What is error ora-12154: tns:could not resolve the connect identifier specified?

1081

What is the password of mysql?

968

what is the dual table in oracle?

993

What are the limitations of microsoft access?

897

For More Un-Answered { Databases } Questions Click Here