Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

DB Development Interview Questions
Questions Answers Views Company eMail

Which data type cannot be used as a parameter in a udf?

977

In which database can extended stored procedures be added?

906

You are testing the performance of a query the first time you run the query, the performance is slow. the second time you run the query, the performance is fast. why is this?

964

How you can make a parameterized view?

1012

Can an extended stored procedure be called from inside a user-defined function?

1055

How long can an error message be in raiseerror function?

1002

Write the fastest query to find out how many rows exist in a table?

1119

What you can do to remove data from the cache and query plans from memory for testing the performance of a query repeatedly?

1017

On friday, you issued several insert statements using query analyzer. You then verified the data had been correctly entered with a select statement on monday, your users report that the data is not there what happened?

1001

Explain the cube operator?

1010

How would you design a database for an online site, which would average a million hits a day?

1013

What are the constraints on severity level in raiseerror?

986

Why does this query return 0?

1016

Which four data types cannot be used as a return type from a user-defined function?

1024

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

1106


Post New DB Development Questions

Un-Answered Questions { DB Development }

How would you design a database for an online site, which would average a million hits a day?

1013


Explain about the hierarchical model of the database?

1116


Explain about post-relational databases?

1025


To convert IDMS to DB2, how to deal with IDMS occurs and redefined clause?

4008


Which data type cannot be used as a parameter in a udf?

977


Explain the rollup operator?

1077


What is normalization? Explain different levels of normalization?

63115


What is the physical representation for a many-to-many relationship?

1078


Hi my program is accesing data from two db2 databases.what is the bind card for this program to genarate plan? how to specify the two owners and two qualifiers in bind card

2168


How long can an error message be in raiseerror function?

1002


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

2497


How you can make a parameterized view?

1012


Explain about the storage and physical database design?

912


In which table collections errors are stored.

2412


There is a trigger defined for INSERT operations on a table, in an OLTP system. The trigger is written to instantiate a COM object and pass the newly insterted rows to it for some custom processing. What do you think of this implementation? Can this be implemented better?

2421