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

what does the no logging option do? Why would we use it?

516

What is the difference between truncate and delete? Can we rollback both? How would a full table scan behave after?

514

List five most important parameter in 9i affecting performance?

506

What is the difference between rman and a traditional hotbackup?

1 1367

How can you tell if an index on particular table is used or not used in 9i?

527

You see a wait on lms process in statspack, what does that mean?

516

What does the no logging option do? Why would we be careful of using it?

551

Tell me about standby database? What are some of the configurations of it?

523

When using oracle export/import what character set concerns might come up? How do you handle them?

535

Which date function is used to find the difference between two dates?

522

How do you install statspack?

638

Tell me about standby database? What are some of the configurations of it? What should we watch out for?

510

How do you analyze table partition using oracle provided package?

475

Explain the process you follow to start looking into performance issue at database level(if the application is running very slow, at what points do you need to go about the database inorder to improve the performance?)

710

What is oracle partial backup?

539

Un-Answered Questions { Databases }

Which is the best free database software?

895

What is full form of xampp?

1089

Can you explain different types of joins?

887

Explain meant by 3-tier architecture?

887

Thanks to some maintenance being done, the sql server on a failover cluster needs to be brought down. How do you bring the sql server down?

894

What the difference between UNION and UNIONALL?

989

What is transactional trigger property?

Can you edit the .rdl code associated with a linked report?

149

1. How many nodes you are using project? 2. What is configuration file? 3. What is modules partition? How it is work in project? 4. What is Environment Variable? How it is use? 5. What is sequence? 6. How do you execute parallel jobs in projects? 7. If you run a job in job sequencer individually without any comments? 8. How many jobs did in your project? 9. How to schedule the job in Data stage 7.5 X2? 10. If you have 10 jobs in PX2, shall you run all jobs at a time? 11. I have 5 jobs (1-5), I connect with each other, but I want to run from 3-5 only how? 12. What is same partition? 13. If you have 40GB hard disk in I have 30GB data how I configure the nodes for partition? 14. Did you write any code for Data stage project? 15. Did you write any code for parallel job execution in your project? 16. Will you schedule all jobs at a time?

1728

What is the maximum number of instances in 32 bit and 64 bit sql server 2012?

926

Does sybase support row level locking?

826

What is sharding in mongodb?

Difference between uniqe index and uniqe constraint?

918

What are the lambda triggers?

857

How can you access different databases temporarily?

For More Un-Answered { Databases } Questions Click Here