DB Development Interview Questions
Questions Answers Views Company eMail

If a column is an image value type, how you can compare column values? How can you use this column in join clause?

803

You have two tables with a one to many join based on a field named id. You need to find records in the parent table that are not represented in the child table. how would you accomplish this?

849

You have a table with three columns: amount1, amount2, and amount3 in a single row only one of these three columns will have a value and the other two will be null. Write a sql query to retrieve the values from these columns?

772

How can I detect whether a given connection is blocked?

825

The count() function always returns a int value type what should you do if you need to count rows from a query which you know will return a value that is too large for an int value type?

819

Explain the rollup operator?

848

Explain about network model?

806

Explain about relational operator join?

828

What are the three basic rules which are to be followed for the relational model of the database?

783

Explain about the relational database?

839

Explain about post-relational databases?

790

Explain about a primary key?

781

Explain what a database is?

824

State the acid rules?

924

Explain the process of the user request and data generating?

886


Post New DB Development Questions

Un-Answered Questions { DB Development }

How is data stored in dbms?

724


What is DB Development software?

1834


What are data modelling techniques?

749


What is a database development?

735


What is normalization? Explain different levels of normalization?

61373


Explain the rollup operator?

848


Explain the role of indexing in databases?

893


What are the constraints on severity level in raiseerror?

779


Does QTP Support the Propjects which are running in Dot Net? As we are starting with new project in Dot net need to use automation tool?Please advice & let me know what would be the best.

1830


State the acid rules?

924


You have two tables with a one to many join based on a field named id. You need to find records in the parent table that are not represented in the child table. how would you accomplish this?

849


fact table and dimension table containg one to many relationship or many to one relastionship

2284


How can I detect whether a given connection is blocked?

825


Explain about relational database management systems?

769


What are the key features of dbms?

789