PHP Associative Array

An associative array is little bit different from regular array as in c and many language.

An array is a collection of similar data type which can be read by index

i.e. ar[8] here 8 is an index

In Associative array a key is used instead of index for getting array element. Key must be unique otherwise you can’t get all elements uniquely following code implement this logic

Collection in C Sharp

/ Create a list of strings.
            var ob = new List<string>();
            ob.Add("Girfa");
            ob.Add("Student");
            ob.Add("Help");
            ob.Add("Blogger");

Indexers C Charp

class IndexeCls
    {
        private string[] namelist = new string[size];
        static public int size = 3;
        public IndexeCls()
        {
            for (int i = 0; i < size; i++)
                namelist[i] = "N. A.";
        }

UGC Net Computer Science Paper 3 July-16 Page 2

UGC Net Computer Science Paper 3 July-16 Page 2

11. Consider the following ORACLE relations :
R {A,B,C}={<1,2,3>,<1,2,0>,<1,3,1>,<6,2,3>,<1,4,2>,<3,1,4>}
S (B,C,D)= {<2,3,7>,<1,2,3>,<2,3,4>,<3,1,4}
Consider the following two SQL queries SQ1 and SQ2:
SQ1 : SELECT R.B,AVG(S.B) FROM R,S
WHERE R.A=S.C AND S.D<7
GROUP BY R.B :
SQ2 : SELECT DISTICT S.B, MIN (S.C)
FROM S
GROUP BY S.B
HAVING COUNT (DISTINCT S.D)>1 :
If M is the number of tuples returned by SQ1 and N is the number of tuples return by SQ2 then
(1) M=4,N=2
(2) M=5,N=3
(3) M=2,N=2
(4) M=3,N=3
Answer : 1

12. Semi join strategies are technique for query processing in distributed database system.
(1) Only the joining attribute are sent from one site to another and then all of the rows are returned.
(2) All of the attributes are sent from one site to another and then only require rows are
Returned.
(3) Only the joining attribute are sent from one site to another and then only the required rows are returned.
(4) All of the attribute are sent from one site to another and then only the required rows are returned.
Answer : 4