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

How do we return a record set from a Stored Procedure in SQl server 2000?

3 6712

What are the magic tables in SQL Server 2000?

Infogain, Merrill Lynch,

7 25477

How do we get current date in SQL Server 2000, Oracle, MS Access?

13 52857

What are the differences between stored procedure and functions in SQL Server 2000?

College School Exams Tests, HCL, Infosys, TCS,

25 112951

What is lexical parameter ?

Zensar,

2 11403

what is a package n what r the packages availbla in report

Convergys,

2096

how can u store a picture file in oracle database? explain the path/command?

GE, Satyam,

1 5569

What are all the system Parameters available in ORACLE Reports

GE,

1 19220

What is the sequence the Report triggers will fires while running a report ?

FCS, GE,

1 13721

Where we can use the placeholder columns?

GE,

1 4870

Can you convert a bit-mapped report to ASCII (character-mode) Report ? How ?

GE,

2287

How can you create Lexical parameter n Bind parameter in Reports ?

GE, SVSS,

1 6192

What is summary column in Oracle Reports ?

GE,

5 17333

What is the use of Validation triggers in Reports?

GE,

2 12077

What is the use of Printer Definition file (PRT) in Reports ?

Epson, GE,

1 5942

Un-Answered Questions { Databases }

Is sql a scripting language?

1010

What is sql server used for?

1048

What is the easiest database to learn?

893

List the different index configurations possible for a table?

934

Explain bcnf (boyce-codd normal form)?

1017

Explain having clause and where clause?

1055

How to sort output in descending order in oracle?

1045

How can you determine if an oracle instance is up from the operating system level?

559

What is the difference between indexing and hashing?

1169

What are the 7 disadvantages to a manual system?

983

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?

1774

Why is oracle database so popular?

1001

What is the difference between a "where" clause and a "having" clause?

1160

Does insert statement lock the table?

946

What are the two main functions of queries in databases?

1441

For More Un-Answered { Databases } Questions Click Here