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 is an extended stored procedure?

1 5802

Can you instantiate a COM object by using T-SQL?

1 4454

What is the system function to get the current user's user id?

4 8274

What are triggers? How many triggers you can have on a table?

Ramco,

2 8630

There is a trigger defined for INSERT operations on a table, in an OLTP system. The trigger is written to instantiate a COM object and pass the newly insterted rows to it for some custom processing. What do you think of this implementation? Can this be implemented better?

2470

What is a self join? Explain it with an example?

TCS,

16 61723

Given an employee table, how would you find out the second highest salary?

9 14842

What is normalization? Explain different levels of normalization?

CG-VAK, Choice Solutions, College School Exams Tests, IBM, Wipro,

8 63432

What is denormalization and when would you go for it?

NBP,

9 39749

How do you implement one-to-one, one-to-many and many-to- many relationships while designing tables?

Flextronics, Hexaware, SQL Star,

1 10054

Define candidate key, alternate key, composite key?

IAS, IBM,

30 146624

What are defaults? Is there a column to which a default can't be bound?

2 7791

What is bit datatype and what's the information that can be stored inside a bit column?

2 8564

Can you create a updatecascade, Deletecascade relation in Ms-Access? If yes, give an example?

2 9306

What is a 'instead of trigger'?

Eenadu, TCS,

3 13098

Un-Answered Questions { Databases }

How to compute database fragmentation in sybase?

949

Is microsoft access in the cloud?

919

Find columns used in stored procedure?

1041

What are the benefits of pl/sql packages?

1166

How to check table values in sql server?

1012

Does inner join remove duplicates?

1006

1. How many nodes you are using project? 2. What is configuration file? 3. What is modules partition? How it is work in project? 4. What is Environment Variable? How it is use? 5. What is sequence? 6. How do you execute parallel jobs in projects? 7. If you run a job in job sequencer individually without any comments? 8. How many jobs did in your project? 9. How to schedule the job in Data stage 7.5 X2? 10. If you have 10 jobs in PX2, shall you run all jobs at a time? 11. I have 5 jobs (1-5), I connect with each other, but I want to run from 3-5 only how? 12. What is same partition? 13. If you have 40GB hard disk in I have 30GB data how I configure the nodes for partition? 14. Did you write any code for Data stage project? 15. Did you write any code for parallel job execution in your project? 16. Will you schedule all jobs at a time?

1829

How adventureworkslt tables are related?

984

What is a table catalog?

824

What is sql profiler in oracle?

1163

What is indexing a document?

1094

How sql query is executed?

1189

How do I switch users in mysql?

1016

What are the attributes that are found in a cursor?

1124

definition of cluster and non-clustered index?

3112

For More Un-Answered { Databases } Questions Click Here