When the SYSTEM TABLESPACE can be made off-line ?

2 Answers  

---

1. Difference between Lookup and join? 2. Difference between funnel and join? 3. What type of load you have used in your project? 4. What type of data warehouse schema you have fallowed in you project? 5. How many fact tables and dimension tables is their in project? 6. How do you kill the job process using windows environment? 7. Difference between sequence file and dataset? 8. What is delta load and subsequent load? 9. By using which stages you have implemented the SCD

0 Answers   Wipro,

---

where a Database Procedure is stored ?

1 Answers  

---

Which database is best for storing images?

0 Answers  

---

What are dml and ddl statements?

0 Answers  

---

---

What is difference between database and spreadsheet?

0 Answers  

---

What is instance in dbms?

0 Answers  

---

is it sufficient to normalize a database up to 3NF?

4 Answers  

---

Briefly describe the three types of sql commands.

0 Answers  

---

What are the advantages of rdbms?

0 Answers  

---

What is stored procedure in database?

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  

---