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 6132

what is snapshot log ?

2 7774

When will the data in the snapshot log be used ?

2 5464

What are the benefits of distributed options in databases ?

1 4593

what is inline view?

15 42535

what is the difference between implicit conversions and explicit conversions?

2 9372

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 189600

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,

1 2089

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

6 9947

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

Getit, ivan,

1 5876

Whatz the main diff between Subquery and a Join

Oracle, Zeta Interactive,

14 34055

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 10196

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 8241

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,

1 2646

What is cursor and where do you use them?

eBay,

2 8710

Un-Answered Questions { Databases }

What is the primary use of the model database?

1141

What is current version of mysql?

1057

Have you written applications to retrieve stored images in a table?

1076

What are the source of constraints?

998

Can you tell me about your experience with the administration of COTS system..? Also, how do you set up seed data..?

2694

Explain “row_number()” in sql server with an example?

1062

Is microsoft getting rid of access?

877

What are the different subsets of sql?

1635

How to put more than 1000 values into an oracle in clause?

1098

Where can you add custom error messages to sql server?

1190

How to select all columns of all rows from a table in oracle?

1108

How can you append an identity column to a temporary table?

1054

How to Change a users password from unix shell.

1196

How to use values from other tables in update statements using oracle?

1141

8. Sort, Lookup What kind of technique (partition) is used? 9. How can you handle exceptions in job sequencer? 10. How do you apply custom conditions an exceptions (How do you trigger exceptions in job sequence?) 11. I have a job with 3 possibilities? Finish with ok…..Abort…….Warning} How do you handle these in Job sequencer 12. How do you connect both OK and Warning can we? 13. How to find which process is running currently? 14. How do you find the disk usage in UNIX? 15. How do you combine 2 sequential files having same metadata of same file names? 16. How do you implement SCD in Ds? 17. Explain the situation where you have applied? 18. How do you apply new changes to? 19. Difference between change capture and Change apply? 20. Explain Compare Stage? 21. What is Surrogate key? 22. How to solve the problem of null values?

1901

For More Un-Answered { Databases } Questions Click Here