How to omit columns with default values in insert statement in oracle?

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 define an explicit cursor in oracle?

0 Answers  

---

diff between DELETE and TRUNCATE?.

14 Answers   HCL, Yalamanchili Software,

---

src name sex a,male b,female c,male d,female Required output : male female a,b c,d tried pivot but was not successfull select * from src pivot (max(name) for sex in ('MALE','FEMALE'));

0 Answers   IBM,

---

If youre unsure in which script a sys or system-owned object is created, but you know its in a script from a specific directory, what UNIX command from that directory structure can you run to find your answer?

0 Answers  

---

Q1:code to connect to sql server(database) through jdbc application. Q2:code to connect to Mysql(database) through jdbc application. Q3:code to connect to oracle(database) through jdbc application.

1 Answers  

---

What are the different types of database objects?

0 Answers  

---

how to find find & delete duplicate rows from two different tables?

3 Answers   Accenture, TCS,

---

What is the Difference between 1) ER MODEL and Relational Model 2) Dense Index and Sparse Index

1 Answers  

---

What are the type of Synonyms?

1 Answers  

---

Assuming today is Monday, how would you use the DBMS_JOB package to schedule the execution of a given procedure owned by SCOTT to start Wednesday at 9AM and to run subsequently every other day at 2AM.

0 Answers  

---