Answer / Satti Devi

A table partition in SQL refers to dividing a large table into smaller, more manageable parts (or partitions) based on one or more columns. This improves performance by reducing the amount of data accessed during queries, index creation, and maintenance operations.

What is a join?

1 Answers  

---

How do we accept inputs from user during runtime?

1 Answers  

---

Inline the values in PL/SQL, what does it mean.?

1 Answers   MCN Solutions,

---

What are the string functions in sql?

1 Answers  

---

table name: prod there are three fields in the table that are 1.proddate 2.prodQty 3.model Day wise prodQty is stored in the table prod write a query to display total prodqty in the year 2004 april.

2 Answers   Maruti Suzuki,

---

What is cold data?

1 Answers  

---

What language is oracle sql developer?

1 Answers  

---

Which is faster count (*) or count 1?

1 Answers  

---

write a pl/sql function if enter a value=0 then output value=1 and vise verse with out using if and case statements.

3 Answers   Zensar,

---

What is the diff between Truncate table / delete <table name> purge

3 Answers   TCS,

---

What does trigger mean in slang?

1 Answers  

---

what is d diff between grant,commit,rollback n savepoint

1 Answers  

---