What are named parameters?

0 Answers  

---

How can we manage the gap in a primary key column created by a sequence? Ex:a company has empno as primary key generated by a sequence and some employees leaves in between.What is the best way to manage this gap?

2 Answers   Infosys,

---

Give the various rollback segment states.

0 Answers  

---

1. How actually index will work ? 2. Why do people prefer mostly bitmap index and btree index in datawarehouse ? 3. If I use the column in aggrigate functions like max,min,count and avg and if I have a index created on that column, will it increases the performance ?

1 Answers   IBM,

---

How to get a list of all tables in the database?

1 Answers  

---

How to define an oracle cursor variable?

0 Answers  

---

From the database level, how can you tell under which time zone a database is operating?

1 Answers  

---

write a sql query following source looking like below column1 column2 101,102,103 abc,def,ghi 1001,1002,1003 a,b,c i want the output column1 column1 101 abc 102 def 103 ghi 1001 a 1002 b 1003 c

1 Answers   KPIT,

---

Is oracle a relational database?

0 Answers  

---

How to get execution statistics reports on query statements?

0 Answers  

---

19. Display all clients whose name begins with the letter J or contains the letter M anywhere or contains E as the third letter.

2 Answers   Wipro,

---

Can group functions be mixed with non-group selection fields?

0 Answers  

---