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

Can you call pl/sql package functions from within a fast formula?

1 1112

Why does %isopen return false for an implicit cursor?

1 1594

Can we want to pass a parameter payroll_id to this external pl/sql function, how do we do it?

1 1141

what are different types of keys in sql?

1 1254

Define overloaded procedure?

1 1155

How do we accept inputs from user during runtime?

1 1145

What does the acronym acid stand for in database management?

1 1112

What is the difference among union, minus and intersect?

1 1065

What are the differences between implicit and explicit cursors?

1 1146

Cite the differences between execution of triggers and stored procedures?

1 1159

What is a recursive stored procedure?

1 1286

Define commit, rollback and savepoint?

1 1107

How can we link a sql database to an existing android app?

1 1100

How can you maintain the integrity of your database on instances where deleting an element in a table result in the deletion of the element(s) within another table?

1 1208

what is error ora-03113: end-of-file on communication channel?

1 1265

Un-Answered Questions { Databases }

Design database draw er diagram for a certain scenario ?

4647

what is collation? : Sql dba

1224

What is oracle latest version?

1170

How do I find query history in sql server?

1018

Hi , any one can help me on the same,this is regarding the Informatica Function doc,i want to know how developer is will develop the mapping. pl forwar the any function doc .just for my references. svlc75@yahoo.co.in

2100

Is primary key clustered index?

1015

How can we solve concurrency problems?

1120

What is a view in sql?

1035

What are the two main functions of queries in databases?

1525

Can we make the the chages By Using the Sql if u know any function or process please inform me Actuall result: BRK1 Break 1 Part 1 00:01:00:00 60 BRK1 Break 1 Part 2 00:01:00:00 60 BRK2 Break 2 Part 1 00:01:00:00 60 BRK2 Break 2 Part 2 00:01:00:00 60 BRK2 Break 2 Part 3 00:01:00:00 60 BRK3 Break 3 Part 1 00:01:00:00 60 BRK3 Break 3 Part 2 00:01:00:00 60 Desired O/P: BRK1 Break 1 Part 1 00:01:00:00 60 Part 2 00:01:00:00 60 BRK2 Break 2 Part 1 00:01:00:00 60 Part 2 00:01:00:00 60 Part 3 00:01:00:00 60

2291

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

1072

1. What is Container? 2. Tell me about your project? 3. Which container you are used in your project? 4. What is Surrogate key? 5. How you are implemented it? 6. Difference between Server job and Parallel job? 7. What is your Target Database? 8. What is Source System? 9. Difference between Join and Lookup? 10. Are you maintaining historical data? What is the logic used to maintained to historical data? 11. Do you have documents for mapping?

1844

what is bcp? When does it used? : Sql dba

1053

What is the difference between for xml raw and for xml auto?

1111

Hi am new to PLSQL & facing problems in writing code like in SP, Functions, so any one having some SP coding with in depth explanation please share with me my Email ID suvarnaatsuvarna@rediffmail.com Or taking tanning on this please do contact me

2088

For More Un-Answered { Databases } Questions Click Here