Answer Posted / krishna prasad a

For this Answer 1 is incorrect.

CREATE TABLE candytest
(kidId char(2),
candycolor varchar(10)
)
GO

INSERT INTO candytest SELECT 'K1', 'Yellow'
INSERT INTO candytest SELECT 'K1', 'Red'
INSERT INTO candytest SELECT 'K2', 'Red'
INSERT INTO candytest SELECT 'K2', 'Blue'
INSERT INTO candytest SELECT 'K3', 'White'
INSERT INTO candytest SELECT 'K3', 'Red'
INSERT INTO candytest SELECT 'K3', 'Yellow'
Go
--Now to find those kidid's which has both yellow and red
colored candies, we can write query as:

Select c1.candytest from
candytest c1,candytest c2
where c1.candycolor=c2.candycolor
and c1.kidid=c2.kidid

Explain about the hierarchical model of the database?

1106

---

What is dbms and its application?

996

---

Can an extended stored procedure be called from inside a user-defined function?

1046

---

How is data stored in dbms?

948

---

What are the three basic rules which are to be followed for the relational model of the database?

1009

---

How to combine two function together?

2120

---

Where is dbms used?

1069

---

How to replace not in with not exist?

2073

---

How to generate OIDS

2242

---

What are data modelling techniques?

952

---

Hi my program is accesing data from two db2 databases.what is the bind card for this program to genarate plan? how to specify the two owners and two qualifiers in bind card

2154

---

What are the key features of dbms?

983

---

Write the fastest query to find out how many rows exist in a table?

1105

---

When installing the datastage7.5x2 edtion iam getting aproblem i.e the cpu count is 2 but the cpu count in installation is one . how can i install in my p.c (system is dual core).

2206

---

Write short notes on manual refreshes.

2725

---