} int *getproduct() { return Pcode; } }; Q.5. (A) What do you understand by Candidate Keys in a table ? Give a suitable example. 2 (B) Consider the following tables SHOP and SUPPLIER and answer the following questions: TABLE : SHOP TABLE : SUPPLIER Write SQL commands for the following statements i to iv and Output for v to viii (I) To display details of all the items in the shop table in ascending order of 1 Buydate. 1 Mark (II) To display ICODE and INAME of the items with QTY more than 100. 1
} int *getproduct() { return Pcode; } }; Q.5. (A) What do you understand by Candidate Keys in a table ? Give a suitable example. 2 (B) Consider the following tables SHOP and SUPPLIER and answer the following questions: TABLE : SHOP TABLE : SUPPLIER Write SQL commands for the following statements i to iv and Output for v to viii (I) To display details of all the items in the shop table in ascending order of Buydate. 1 Mark 1 (II) To display ICODE and INAME of the items with QTY more than 100. 1
513150762sample_paper_cpp_class_xii.docx