61. Consider the following three SQL queries (Assume the data in the people table) :
(a) Select Name from people where Age>21;
(b) Select Name from people where Height>180;
(c) Select Name from people where (Age>21) or (Height>180);
If the SQL queries (a) and (b) above, return 10 rows and 7 rows in the result set respectively, then what is one possible number of rows returned by the SQL query (c) ? (A) 3 (B) 7
(C) 10 (D) 21
Answer: C
- The distributed system is a collection of (P) and communication is achieved in distributed system by (Q) , where (P) and (Q) are :
(A) Loosely coupled hardware on tightly coupled software and disk sharing, respectively.
(B) Tightly coupled hardware on loosely coupled software and shared memory, respectively.
(C) Tightly coupled software on loosely coupled hardware and message passing,
respectively.
(D) Loosely coupled software on tightly coupled hardware and file sharing, respectively.
Answer: C
- Consider the following three tables R, S and T. In this question, all the join operations are natural joins (⨝). (π) is the projection operation of a relation :
Possible answer tables for this question are also given as below :
What is the resulting table of πA,B(R⨝T) ⨝ πB,C(S⨝T) ?
(A) (a) (B) (b)
(C) (c) (D) (d)
Answer: A
- Consider the two class classification task that consists of the following points :
Class C1: [-1, -1], [-1, 1], [1, -1]
Class C2: [1, 1]
The decision boundary between the two classes C1 and C2 using single perceptron is given by :
(A) x1-x2-0.5=0 (B) -x1+x2-0.5=0
(C) 0.5(x1+x2)-1.5=0 (D) x1+x2-0.5=0
Answer: D
- Consider a standard additive model consisting of rules of the form of
If x is Ai AND y is Bi THEN z is Ci.
Given crisp inputs x=x0, y=y0, the output of the model is :
Answer: C
- A bell-shaped membership function is specified by three parameters (a, b, c) as follows:
Answer: B
Explanation:
The generalized bell function depends on three parameters a, b, and c as given by
where the parameter b is usually positive. The parameter c locates the center of the curve. Enter the parameter vector params, the second argument for gbellmf, as the vector whose entries are a, b, and c, respectively.
- Which of the following is/are the principle components of a memory-tube display ?
(a) Flooding gun (b) Collector
(c) Phosphorus grains (d) Ground
Codes :
(A) (a) and (b) (B) (c) only
(C) (d) only (D) All the above
Answer: D
- Which of the following steps is/are not required for analog to digital conversion ?
(a) Sensing (b) Conversion (c) Amplification
(d) Conditioning (e) Quantization
Codes :
(A) (a) and (b) (B) (c) and (d)
(C) (a), (b) and (e) (D) None of the above
Answer: D
- Which raster locations would be chosen by Bresenham’s algorithm when scan converting a line from (1, 1) to (8, 5) ?
Answer: C
Explanation:
|
dx=x2-x1 = 8-1 = 7
dy=y2-y1 = 5-1 =4 d = 2dy-dx= 2*4 – 7=1 Using step by step Bresenham’s algorithm we get the following … x y d 1 1 1 2 2 -5 3 2 3 4 3 -3 5 3 5 6 4 -1 7 4 7 8 5 1 |
- Consider a unit square centred at origin. The coordinates of the square are translated by a factor (1/2, 1) and rotated by an angle of 90o. What shall be the coordinates of the new
square ?
(A) (-1/2, 0), (-1/2, 1), (-3/2, 1), (-3/2, 0)
(B) (-1/2, 0), (1/2, 1), (3/2, 1), (3/2, 0)
(C) (-1/2, 0), (1/2, 0), (-3/2, 1), (-3/2, 0)
(D) (-1/2, 0), (1/2, 1), (-3/2, 1), (-3/2, 0)
Answer: A
Explanation:
click on image:
71. Which of the following is/are the components of a CRT ?
(a) Electron Gun
(b) Control Electrode
(c) Focusing Electrode
(d) Phosphor Coated Screen
Codes :
(A) (a) and (d) (B) (a), (b) and (d)
(C) (a), (b), (c) and (d) (D) (a), (c) and (d)
Answer: C
- Which one of the following statements is incorrect ?
(A) Pareto analysis is a statistical method used for analyzing causes, and is one of the
primary tools for quality management.
(B) Reliability of a software specifies the probability of failure-free operation of that software for a given time duration.
(C) The reliability of a system can also be specified as the Mean Time To Failure (MTTF).
(D) In white-box testing, the test cases are decided from the specifications or the
requirements.
Answer: D
- Consider a language A defined over the alphabet ∑={0, 1} as A = {0[n/2] 1n: n >= 0} .
The expression [n/2] means the floor of n/2, or what you get by rounding n/2 down to the nearest integer.
Which of the following is not an example of a string in A ?
(A) 011 (B) 0111
(C) 0011 (D) 001111
Answer: c
Explanation:
ANSWER IS (C)
if n=2
[n/2] = [1] = 1 i.e. Language is : 011
if n=3
[n/2] = [1.5] = 1 i.e. Language is : 0111
if n=4
[n/2] = [2] = 2 i.e. Language is : 001111
Hence option A is possible, B is possible, D is possible but C is not possible.
- Which one of the following statements, related to the requirements phase in Software
Engineering, is incorrect ?
(A) “Requirement validation” is one of the activities in the requirements phase.
(B) “Prototyping” is one of the methods for requirement analysis.
(C) “Modelling-oriented approach” is one of the methods for specifying the functional
specifications.
(D) “Function points” is one of the most commonly used size metric for requirements.
Answer: C
- …………… tag is an extension to HTML that can enclose any number of Javascript statements.
(A)< SCRIPT> (B)< BODY>
(C)< HEAD> (D) <TITLE>
Answer: A