Answer / guest

Defaults are used to assign some defalut values to
columns . These values are used if user doen to specify a
column value.
Timestamp canot have default clause attached to it

Answer / leena

A default is a value that will be used by a column, if no
value is supplied to that column while inserting data.
IDENTITY columns and timestamp columns can't have defaults
bound to them

What is denormalization and when would you go for it?

9 Answers   NBP,

---

Explain the cube operator?

0 Answers  

---

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

0 Answers  

---

can you give me the syntax of named procedure??

2 Answers  

---

How do you implement one-to-one, one-to-many and many-to- many relationships while designing tables?

1 Answers   Flextronics, Hexaware, SQL Star,

---

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?

0 Answers  

---

What are the key features of dbms?

0 Answers  

---

agregator gives one to many records or many to one record

1 Answers   IBM,

---

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

0 Answers  

---

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?

0 Answers  

---

What are defaults? Is there a column to which a default can't be bound?

2 Answers  

---

Explain about a primary key?

0 Answers  

---