Answer / guest

A.OLTP
B.DSS
C.Where clause has functions
D.Tables that have only one record

Answer / hitendra yadav

If there is very less cardinality (i.e. 1% of total column
values) or distinct values in column then we have to create
BITMAP index for that column like GENDER column will always
have 2 values MALE or FEMALE.

Syntex:-

Create bitmap index index_name on table_name(column_name);

How do you delete a table?

0 Answers  

---

how would you get the current date in mysql? : Sql dba

0 Answers  

---

How do I write a sql query in pgadmin 4?

0 Answers  

---

how to shutdown mysql server? : Sql dba

0 Answers  

---

What is the difference between having clause and where clause?

0 Answers  

---

---

how to drop an existing table in mysql? : Sql dba

0 Answers  

---

Is sql low level language?

0 Answers  

---

What does plvtab enables you to do when you showthe contents of pl/sql tables?

0 Answers  

---

Can you create a table with Primary Key not as the clustered index.

2 Answers   CGI,

---

What is acid property in a database?

0 Answers  

---

What is Pragma EXECPTION_INIT ? Explain the usage ?

2 Answers  

---

Why you are not able to create a table using select command,if it is having a LONG column? for eg:create table test as select * from test1 here test1 containg a column having LONG datatype...

1 Answers  

---