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 6023

what is snapshot log ?

2 7666

When will the data in the snapshot log be used ?

2 5355

What are the benefits of distributed options in databases ?

1 4495

what is inline view?

15 42054

what is the difference between implicit conversions and explicit conversions?

2 9249

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 188123

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,

2044

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

6 9731

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

Getit, ivan,

1 5794

Whatz the main diff between Subquery and a Join

Oracle, Zeta Interactive,

14 33589

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 10056

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 8141

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,

2584

What is cursor and where do you use them?

eBay,

2 8561

Un-Answered Questions { Databases }

What are the built in functions in sql server?

997

How do I start mongodb on windows?

What is executive plan?

930

How to get last inserted id after insert data from a table in mysql?

994

How to generate create table script on an existing table in ms sql server?

1159

Why it is recommended to avoid referencing a floating point column in the where clause?

976

What are the restrictions that views have to follow?

989

Can we save images in a database and if yes, how?

1081

What are the types of sql server?

1065

What do you mean by aggregate and scalar functions in dbms?

943

What are the commands used in dcl? : sql server DBA

1085

What is the difference between primary key and secondary key?

979

Ms sql server index?

1072

How much money does a dba make?

588

What is sql lookup?

938

For More Un-Answered { Databases } Questions Click Here