Tuesday, 9 August 2016

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

Monday, 8 August 2016

UGC Net Computer Science Paper 3 Page 1

1. Which of the following is a sequential circuit?
(1)  Multiplexer
(2) Decoder
(3) Counter
(4) Full Adder
Answer : 2

2. 8085 microprocessor has_______ hardware interrupts.
(1) 2
(2) 3
(3) 4
(4) 5
Answer : 1