Answer / nithya

Decode
1.It’s a function
2.can compare only discrete values
3.pl/sql standards
4.cannot process null

Case
1.It's an Expression
2.can handle range values
3.ANSI Standards
4.Processing time is faster when compared to Decode
5.can process null

Answer / dev

Decode is widely used

The count() function always returns a int value type what should you do if you need to count rows from a query which you know will return a value that is too large for an int value type?

0 Answers  

---

Define candidate key, alternate key, composite key?

30 Answers   IAS, IBM,

---

Write short notes on manual refreshes.

0 Answers  

---

how to find the first two highest salaries in deptno in emp table

2 Answers  

---

Explain about query and reporting.

0 Answers  

---

What are the main phases of database development?

0 Answers  

---

What is normalization? Explain different levels of normalization?

8 Answers   CG-VAK, Choice Solutions, College School Exams Tests, IBM, Wipro,

---

You have two tables with a one to many join based on a field named id. You need to find records in the parent table that are not represented in the child table. how would you accomplish this?

0 Answers  

---

How to create an external table.

1 Answers  

---

On friday, you issued several insert statements using query analyzer. You then verified the data had been correctly entered with a select statement on monday, your users report that the data is not there what happened?

0 Answers  

---

How can you log an error to the server event log from a stored procedure?

0 Answers  

---

What is bit datatype and what's the information that can be stored inside a bit column?

2 Answers  

---