Answer / bijaylaxmi

sql>create bitmap index <bitmap index name>
on tablename(column name);
e.g-create bitmap index empbitmapjob on emp(job);
This is the syntax for bitmap index.

Explain what are commit and rollback in sql?

0 Answers  

---

What is statement level trigger?

0 Answers  

---

What do you understand by check constraint in sql server?

0 Answers  

---

i have a table like this Eno ename 1 a 2 b 3 c i want to display ename and bossname from table hint boss is also an employee

3 Answers   NIIT,

---

What stored by the master? : sql server database administration

0 Answers  

---

One table Test with single column. These are the values in the table a b c d e f g h I need a query (without using any variable) with output as - a b c d e f g h

1 Answers  

---

How much is a sql server license?

0 Answers  

---

What is @@error in sql?

0 Answers  

---

What do u mean by orphan users, how will u list them in the DB

2 Answers   IBM,

---

How maney row would be print after join if A table have 100 rows and B table have 50 rows...

9 Answers   Hewitt,

---

Why can there be only one clustered index and not more than one?

0 Answers  

---

What is a field name?

0 Answers  

---