- Which of the following is a sequential circuit?
1)Multiplexer
2)Decoder
3)Counter
4)Full adder
answer is 3
- 8085 microprocessor has _____ hardware interrupts.
1) 2
2) 3
3) 4
4) 5
answer is 4
- Which of the following in 8085 microprocessor performs
HL=HL+DE?
1) DAD D
2) DAD H
3) DAD B
4) DAD SP
answer is 1
- The register that stores all interrupt requests is:
1) Interrupt mask register
2) Interrupt service register
3) Interrupt request register
4) Status register
answer is 3
- The _____ addressing mode is similar to register indirect addressing mode, except that an offset is added to the contents of the register. The offset and register are specified in the instruction.
1)Base indexed
2)Base indexed plus displacement
3)Indexed
4)Displacement
answer is 2
- In ______ method, the word is written to the block in both the cache and main memory, in parallel.
1)Write through
2)Write back
3)Write protected
4) Direct mapping
answer is 1
- Which of the following statements concerning Object-Oriented databases is FALSE?
1) Objects in an object-oriented database conatin not only data but also methods for processing the data
2)Object-oriented databases store computational instructions in the same place as the data.
3)Object-oriented databases are more adapt at handling structured(analytical) data than relational databases.
4)Object-oriented databases store more types of data than relational databases and access that data faster.
answer is 4
- In distributed databases, location transparency allows for database users, programmers and administrators to treat the data as if it is at one location. A SQL query with location transparency needs to specify:
1) Inheritances
2) Fragments
3)Locations
4) Local formats
answer is 2
- Consider the relations R(A,B) and S(B,C) and the following four relational algebra
queries over R and S:
S:
- πA,B(R⋈S)
- R⋈πB(S)
III. R∩(πA(R) Χ πB(S))
- πA,R.B(R Χ S) where R.B refers to the column B in table R.
One can determine that:
One can determine that:
1) I,III and IV are the same query
2) II,III and IV are the same query
3) I,II,IV are the same query
4) I,II and III are the same query
answer is 4
check Explanation: http://targatenet.com/cbse-net-june-2016-answer-keys/
- Which of the following statements is TRUE?
D1: The decomposition of the schema R(A,B,C) into R1(A,B) and R2(A,C) is always lossless.
D2: The decomposition of the schema R(A,B,C,D,E) having AD->B,C->DE,B->AE AND AE->C, into R1(A,B,D) and R2(A,C,D,E) is lossless.
1) Both D1 and D2
2) Neither D1 nor D2
3) Only D1
4) Only D2
answer is 4
check Explanation: http://targatenet.com/cbse-net-june-2016-answer-keys/
- 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,4,5>,<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 DISTINCT 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 returned by SQ2 then
1) M=4,N=2
2) M=5,N=3
3) M=2,N=2
4) M=3,N=3
answer is 2
check Explanation: http://targatenet.com/cbse-net-june-2016-answer-keys/
- Semi-join strategies are techniques for query processing in distributed database system. Which of the following is a semi-join technique?
1) Only the joining attributes 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 the required rows are returned.
3) Only the joining attributes are sent from one site to another and then only required rows are returned
4) All of the attributes are sent from one site to another and then only the requires rows are returned.
answer is 3
- Consider the Breshenham’s circle generation algorithm for plotting a circle with centre(0,0) and radius ‘r’ units in first quadrant. If the current point is (xi,yi) and decision parameter is pi than what will be the next point (xi+1,yi+1) and updated decision parameter pi+1 for pi>=0?
answer is 2
check Explanation: http://targatenet.com/cbse-net-june-2016-answer-keys/
- A point P(5,1)is rotated by 90degree about a pivot point (2,2). What is the coordinate of new transformed P?
1) (3,5)
2) (5,3)
3) (2,4)
4) (1,5)
answer is 1
check Explanation: http://targatenet.com/cbse-net-june-2016-answer-keys/
- Let R be the rectangular window against which the lines are to be clipped using 2D Sutherland-Cohen line clipping algorithm. The rectangular window has lower left-hand corner at (-5,1) and upper right-hand corner at (3,7). Consider the following three lines for clipping with the given end point coordinates:
Line AB:A(-6,2) and B(-1,8)
Line CD:C(-1,5) and D(4,8)
Line EF:E(-2,3) and F(1,2)
Which of the following line(s) is/are candidate for clipping?
1) AB
2) CD
3) EF
4) AB and CD
answer is 4
check Explanation: http://targatenet.com/cbse-net-june-2016-answer-keys/