I have 2 tables with 1 million rows each. I have updated 1 row in first and 1 million update on second table. Now I commit both the updates. Which one will commit fast and Why?

0 Answers  

---

What are the different types of data tables?

0 Answers  

---

IF Statements BLOCK 1 . IF a >= b THEN do_this …..; ELSE do_that….; END IF BLOCK 2 . IF a < b THEN do_that …..; ELSE do_this….; END IF; • Given any pair of non-NULL values for “a” and”b”, will Block 1 and Block 2 do the same thing? • What if either “a” or”b” (or both) is NULL?

0 Answers  

---

What do you understand by functional dependency?

0 Answers  

---

What is the main purpose of database?

0 Answers  

---

Explain the Logical Schema of Database

0 Answers   HCL,

---

How the SMON process is used to write into LOG files ?

2 Answers   HCL,

---

What is ims software environment?

0 Answers  

---

What is a candidate key in a database?

0 Answers  

---

1)How to check tablespace utilization? 2)what are the RMAN CLONING STEPS? 3)what is standby database? 4)what is difference between standalone database and target database? 5)How to backup the standalone database? 6)tell about the ubgrade steps? 7)How to apply the pathes?

0 Answers   Wipro,

---

How to recreate the index on a firebird table?

0 Answers  

---

What are five advantages of a database?

0 Answers  

---