Answer / mahesh

Major indexes are B-tree and Bitmap indexes

When ever we create a primary key, B-tree index will be
created

Answer / sdp

A unique index is created when a primary key is created in
a table.

Answer / suren

while creating primary by default a unique index is created

Answer / manish_patil

There are main two types of indexes,
B-tree index
Bitmap index.

While creating Primary key by default cluster index get
crated.

Answer / thirupathi

default index will be created

how many sql ddl commands are supported by 'mysql'? : Sql dba

0 Answers  

Interchange the value of a column Gender in a table where values are Male and Female. So, where the value is Male, it should changed to Female and Female to Male.

4 Answers   Cap Gemini, IBM,

How do you retrieve the second highest salary from a table?

3 Answers  

Is sql better than excel?

0 Answers  

What are user defined functions?

0 Answers  

Can a foreign key be a duplicate?

0 Answers  

what is the difference between char and varchar data types? : Sql dba

0 Answers  

suppose we have values like 1 5 7 in a colum.Now we want numbers like(2 3 4 6) that exists between 1 5 7.How can we do this using sql query??

5 Answers   Keane India Ltd,

Can we call stored procedure in function?

0 Answers  

I have a small PL/SQL Block assume in this way begin select * from emp where empno=100; exception when others then <Some Messages> when no_data_found then <Some Messages> when too_many_rows then <Some Messages> end; The question which he asked was whether this block will get executed normally or it will throw error ? If errored out then what is the reason for the error ? Could anybody please help me ? Regards Nakul Venkataraman

3 Answers   Satyam,

What are the different parts of a package?

0 Answers  

What is the usage of nvl function?

0 Answers