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

How do you prevent oracle from giving you informational messages during and after a sql statement execution?

1 674

How can you find all the processes on your system?

1 637

What happens when the default and temp tablespace clauses are left out from create user statements?

1 642

What is pct free/pct used/pct increase parameter in segment? What is growth factor?

1 627

When looking at v$sysstat you see that sorts (disk) is high. Is this bad or good? If bad -how do you correct it?

1 664

What is pct free/pct used/pct increase parameter in segment?

1 636

What does a hard one-to-one relationship mean (one where the relationship on both ends is "must")?

1 664

How can you find out how many users are currently logged into the database? How can you find their operating system id?

1 616

What happens if a tablespace clause is left off of a primary key constraint clause?

1 646

Discuss row chaining, how does it happen?

1 652

You get a call from you backup dba while you are on vacation. He has corrupted all of the control files while playing with the alter database backup controlfile command. What do you do?

1 670

How can you find dead processes?

1 603

I am getting error "no communication channel" after changing the domain name? What is the solution?

1 673

Discuss row chaining, how does it happen? How do you correct it?

1 624

You attempt to add a datafile and get: ora-01118: cannot add anymore datafiles: limit of 40 exceeded. What is the problem and how can you fix it?

1 668

Un-Answered Questions { Databases }

Design database draw er diagram for a certain scenario ?

4647

What are the types of database explain each of them briefly?

1053

What are the risks of storing a hibernate-managed object in a cache? How do you overcome the problems?

1190

what are all the common sql function? : Sql dba

1127

What is an indexed view?

1018

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

Can we do dml on views?

1032

What are the pros and cons of putting a scalar function in a queries select list or in the where clause?

1293

what is the Ticketing tool used in Wipro technologies at Bangalore...???

8225

define sql insert statement ? : Sql dba

1094

what is schema? : Sql dba

1137

Is microsoft getting rid of access?

883

Is there any performance difference between if exists (select null from table) and if exists (select 1 from table)?

1021

Any work done in oracle workflow builder. Did you customize or build a new workflow?

What are the advantages of database?

1009

For More Un-Answered { Databases } Questions Click Here