Databases Interview Questions
Questions Answers Views Company eMail

What are Nested Tables? How will u delete 5 rows from Nested Tables

IBM,

3 8624

What are Global Temporary tables

IBM, TCS,

3 9635

What are Anti joins

IBM,

1 9057

what is the difference between data migration and production migration.

1813

how can you perform lookup range in lookup stage expalin in detail?

IBM,

1530

what is rcp,if rcp disabled what happen?

Systel,

1717

diff b/w inter process and in process

Aptara, TCS,

1562

how do you do sql tuning?

Systel,

1607

CLI stands for?

IBM,

3 6086

what are wrappers and build ups and what it's use?

TCS,

1703

can u combine pipeline parallelism and partition parallalism? how and whan?

TCS,

1885

what is ad-hoc access? what is the diff b/w managed query and ad-hoc access?

TCS,

1892

how node connect with cpu?

IBM,

1674

sparse lookup and where its options we find in OCI and db2?

TCS,

1748

What is the diff. bwt. primary key and unique key?

4 4945


Un-Answered Questions { Databases }

What is delimiter $$?

502


What are the topics in pl sql?

527


What language is sql server written in?

531


How to provide default values to stored procedure parameters?

579


What is right outer join in sql server joins?

692






Why people hate cursor?

733


What is ole db ado?

557


What are the ways tablespaces can be managed and how do they differ?

1619


How does mongodb store data?

1


Why stored procedures are faster than query?

570


What is order of B+tree?

663


Define inner join? Explain with an example?

517


What is trigger types in sql?

537


What do we mean by record group in oracle forms?

614


What is dbms introduction?

492