Databases Interview Questions
Questions Answers Views Company eMail

What is the use of custom fields in report?

552

What is bit data type?

610

What is recursion? Is it possible for a stored procedure to call itself or recursive stored procedure? How many levels of sp nesting is possible?

479

How sql server enhances scalability of the database system?

579

What is partitioned view?

515

Define compound operators?

527

What are the filtered indexes?

594

Explain transaction server consistency?

516

What is it unwise to create wide clustered index keys?

575

Explain transaction server implicit?

513

Define inner join? Explain with an example?

503

Explain the difference between function and stored procedure?

510

Explain the architecture of ms sql reporting service?

524

What is lock escalation and what is its purpose?

548

Explain syntax for dropping triggers?

507


Un-Answered Questions { Databases }

Is oracle faster than sql server?

548


what are candidate key, alternate key and composite key? : Sql server database administration

487


Explain the use of dde package in d2k.

1


What are sql constraints?

557


Does pl/sql support create command?

570






Is like operator in sql case sensitive?

501


Ms sql server index?

526


How does stored procedure reduce network traffic?

531


Mention what are the file storage options provided by oracle database for oracle rac?

1


How to create tables for odbc connection testing?

485


what are properties of a transaction? : Sql dba

551


explain normalization concept? : Sql dba

579


Can we use rowid as primary key?

535


what are tables and fields? : Sql dba

569


Explain some stored procedure creating best practices or guidelines?

510