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 i use Commit inside the Trigger? Suppose i use commit what will be happy (it's complied /executed/work)

6 15092

What is pl/sql tables?

TCS,

7 12679

What is a mutating table

TCS, Tech Mahindra,

5 11440

Can i possible to see Table Details ? Ex : Table Name Date Time User Emp May/18/2010 12:59pm Scott

3 6487

How to handle errors in Stored Procedures.

Accenture,

2 8796

what is the Default Libraries for Oracle Report 6i

IBM,

2338

What is the Diff b/w Constraints and Trigeer

HCL,

4 12865

If the base table structure is changed what will happen to join index????

2 6729

what is the difference between procedure and function.

Thomson,

4 9021

What are data segments?

3 7115

how to find the fifth highest salary?

IBM, Infosys,

8 13024

Hi all, i have a table as follows empid empname mgrid deptid 1 a 3 4 2 b 1 5 3 c 2 3 4 d 3 6 5 e 4 7 i want the output as empname mgrname a c b a c b d c e d

4 8566

what is the different between unique+not null & primary key,

4 7979

What are Magic Tables?

TCS,

4 11980

Security Question- SQL DBA exparts, need your help...

3 5854

Un-Answered Questions { Databases }

What is acid mean in sql server?

1228

What is normalization and what are the advantages of it?

1050

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

1051

What is current version of mysql?

1057

What is the current version of sql?

1089

How many concurrent programs you have customized, can you name some of them?

What is the latest version of postgresql?

946

Does any body has ORACLE Certification Dumps or Materials on 9i DBA, 10G DBA, Internet Application Developer, OCP 8i to 10g DBA Upgrade, Oracle 11i if any body have it, please kindly drop an email to: taruni_2k8@yahoo.com

2174

List out the different types of locks available in sql server?

1041

What is an indexed view?

1016

If a cursor is open, how can we find in a pl/sql block?

1233

How do I find query history in sql server?

1018

Have you created fact table and dimension tables?

696

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

1099

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?

1901

For More Un-Answered { Databases } Questions Click Here