Title K-2415 (Paper III) (Computer Science and applications).pdf ✅

Paper III 2 K-2415 Total Number of Pages : 16 1. A computer uses 8 digit mantissa and 2 digit exponent. If a = 0.052 and b = 28E + 11, then b + a – b will (A) Result in an overflow error (B) Result in an underflow error (C) Be 0 (D) Be 5.28E + 11 2. A multiplexer with a 4 bit data select input is a (A) 4 : 1 multiplexer (B) 2 : 1 multiplexer (C) 16 : 1 multiplexer (D) 8 : 1 multiplexer 3. After Executing the following code the status be MVI A, 39H ADI 97 H DAA (A) A = 0011 1001, CY = 0 (B) A = 0011 0110, CY = 1 (C) A = 0101 1011, CY = 0 (D) A = 0001 0110, CY = 1 4. What degree of resolution can be obtained using an eight bit optical encoder ? (A) 1.4 degree (B) 2.8 degree (C) 4.2 degree (D) 6.4 degree 5. If a clock with time period “T” is used with n stages shift register, then output of final stage will be delayed by T (A) nTsec (B) (n – 1)T sec (C) n|T sec (D) (2n – 1)T sec 6. Which one of the following is correct ? (A) All relationships may be converted to binary relationship (B) All relationships may be converted to 1:1 relationship (C) All relationship’s attributes may be attached to one of the participating entities (D) All relationships may be represented by a table in a database COMPUTER SCIENCE AND APPLICATIONS PAPER – III Note : This paper contains seventy-five (75) objective type questions. Each question carries two (2) marks. All questions are compulsory.
K-2415 3 Paper III Total Number of Pages : 16 7. Which one of the following is not correct ? (A) A restriction selects one or more rows of a relation (B) A projection selects one or more columns of a relation (C) A join glues each row of one relation with all the rows of the other (D) A difference gives all the rows in the first relation that are not in the second 8. Which one of the following data definition command is not an SQL command ? (A) CREATE TABLE (B) DROP TABLE (C) MODIFY TABLE (D) DROP DOMAIN 9. Consider the query. ‘Find the names of all players from India who have made a century In cricket’. The query involves a selection, a join and a projection. The relation Player and Batting have both been fragmented into six fragments and have been replace twice. Which of the operations require the most data communication ? (A) Selection (B) Projection (C) Join (D) Each is about same 10. Which one of the following privileges may not be granted using SQL ? (A) GRANT SELECT (B) GRANT DELETE (C) REVOKE SELECT (D) REVOKE VIEW 11. Let the maximum number of pixels in a line be M. The number of subdivision at most necessary using the mid-point subdivision method of clipping is (A) N = log2 M (B) N = 2M (C) N = 2 M (D) None of the above 12. Oblique projection with an angle of 45 degree to the horizontal plane is called as (A) Cabinet projection (B) Isometric projection (C) Cavalier projection (D) None of the above