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?

783

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?

838

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?

758

How can I detect whether a given connection is blocked?

809

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?

807

Explain the rollup operator?

835

Explain about network model?

789

Explain about relational operator join?

808

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

767

Explain about the relational database?

825

Explain about post-relational databases?

772

Explain about a primary key?

765

Explain what a database is?

812

State the acid rules?

908

Explain the process of the user request and data generating?

875


Post New DB Development Questions

Un-Answered Questions { DB Development }

Write short notes on manual refreshes.

2497


What are the constraints on severity level in raiseerror?

767


Explain about the hierarchical model of the database?

809


How can you log an error to the server event log from a stored procedure?

813


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

783


Hi , any one can help me on the same,this is regarding the Informatica Function doc,i want to know how developer is will develop the mapping. pl forwar the any function doc .just for my references. svlc75@yahoo.co.in

1805


When installing the datastage7.5x2 edtion iam getting aproblem i.e the cpu count is 2 but the cpu count in installation is one . how can i install in my p.c (system is dual core).

2016


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?

807


Explain about query and reporting.

1863


Explain the role of indexing in databases?

872


How to read and create .LDC data files which are used by linguatic dictionary.

2283


Explain about the relational database?

825


How to replace not in with not exist?

1698


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?

838


Who are naive users?

784