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

Where the procedures are stored in database?

1 918

Explain about the implementation of stored procedures?

1 955

Does storing of data in stored procedures increase the access time? Explain?

1 1197

Explain about the difficulties faced by the database developer in implementing pre compiled statements?

1 801

How can we call stored procedures inside store procedures?

1 909

State about the security aspects of stored procedures?

1 1053

Explain the benefits of running stored procedure on a database engine?

1 1009

How one call ddl statement using stored procedures in oracle?

1 869

State the different extensions for stored procedures?

1 890

How many types of stored procedure?

1 927

What is the difference between "is" and "as" while creating procedure?

1 886

What is the difference between stored procedures and stored functions in oracle?

1 1048

How you can import data from other sources into access database?

1 1088

Explain how we can do multi-join query in ms access?

1 948

Between different data’s, what are the types of relationship can be formed?

1 1113

Un-Answered Questions { Databases }

what ASIS BUSINESS PROCESS IN ORACLE FINANCE

2348

What is self contained sub query?

1138

1. Tell me about your self? 2. Latest Project Introduction? 3. Difference between server jobs and parallel jobs? 4. Seq-Seq Explain its behavior and execution mode and which parallelism technique is used? 5. What is padding characters? 6. Seq-Seq, Seq-Copy-Seq which one is the best and efficient? 7. How many reject links do we have to a transformer? 8. How many reject links to join stage? 9. Difference between join and lookup? 10. How to design PX routine? 11. How can we call job in another job? 12. Difference between batch and sequencer? 13. Which Database is used? 14. What is change capture? Give briefing of that? 15. What is change Code? Explain? 16. How you call UNIX in Ds? 17. How do you call JCL in UNIX? 18. How do you pass the job status of one job to another job? Have designed any job sequencer? 19. How do you find a file in existed directory? 20. How can you call parallel jobs in transformer? 21. Execution of jobs in command line? 22. Tuning of sql queries? 23. What is orchestrating metadata? 24. What are junk dimension? 25. What are the third party tools you are used? 26. What are the system variables you have used?

1907

Why and when do stored procedure recompile?

1052

What are different types of constraints?

995

Can sql servers link to other servers like oracle?

910

What are the different subsets of sql?

1646

Why we use the openxml clause?

1072

Were you involved in any data conversion, which one?

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

What are the different types of subquery?

1228

What is standby servers? Explain types of standby servers.

1075

what is sql server agent? : Sql dba

1179

Have you used lexical parameters in reports?

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

1149

For More Un-Answered { Databases } Questions Click Here