SQL

Q1. The SQL expression
Select distinct T.branch_name from branch T, branch S
Where T.assets>S.asset and S.branch_city=”BAREILLY”
Finds the name of
a) all branches that have greater assets than some branches located in BAREILLY
b) all branches that have greater assets than all branches located in BAREILLY
c) the branch that has greater assets in BAREILLY
d) any branch that has greatest assets than any branch located in BAREILLY
Q2. In an entity relationship, y is dominant entity and x is a subordinate entity. Then
which of the following is/are correct
a)operationally, if y is deleted, so is x
b) x is existence dependent on y
c) operationally, x is deleted on y
d)operationally, x is deleted, y remains the same
Q3.On a simple paging system with a page table containing 64 entries of 11 bits
(including valid/invalid bit) each, and a page size of 512 bytes, how many bits are in a
physical address.
a)11 b)13 c)15 d)19
Q4. A certain moving arm disk storage with one head has following specifications:
Number of tracks/recording surface=200
Disk rotation speed=2400 rpm.
Track storage capacity=62500bits
The average latency time(assume that head can move from one track to another only
by traversing the entire track) is
a)2.5 s b)2.9s c)3.1s d)3.6s
Q5.if the following program fragment (assume negative numbers are stored in 2’s complement form):
unsigned i=1;
int j=-4;
printf(“%u”,i+j);
prints x, then printf(“%d”,8*sizeof(int));
outputs(log in the answers are to the base two )
a)log(x+3) b)8*log(x+3) c)error d)log 8(x+3)
Q6. the use of macro in the place of functions
a) reduces execution time b)reduce code size
c)increases execution time d)increases code size
Q7. which of the following commands are used in Batch Programs:
a)REM b)Break c)set d)DOS
Q8.pickout odd one
a)SISD b)SIMD c)MIMD d)MISD
Q9. which interrupt is known as giant of interrupts
a)Int 20h b)Int 21h c)Int 22h d)Int 23h
Q10. what is “initrd”
a)Initial Remote Disk b)Initial RAM Disk
c)init Remote Disk d)none of these
Q11. if an appropriate implementation of the priority queue is used, then the round robin algorithm requires operations.
a)O(e log log n) b)O(e log e) c)O(n2) d)O(n log n)
Q12. consider the following grammar:
S->Ax/By
A->By/Cw
B->By/Bw
C->y
Which of the following expressions describes the same set of strings as the grammar?
a) xw*y+xw*yx+ywx b) xwy+xw*xyx+ywx
c) xw*y+xwxyx+ywx d) xwxy+xww*y+ywx
Q13. let G1 and G2 be arbitrary CFG’s and R an arbitrary regular set. Which of the following problems are undecidable.
a)L(G1)≠L(G2) b) L(G2)= L(G1) c) L(G1)=R d) L(G1)≠R
Q14.if R is a relation on A ={1,2,3,4} given by
R={(1,3),(1,4),(3,2),(3,3),(3,4)} then R-1 is given by
a){(3,1),(4,1),(2,3),(3,3),(4,3)} b) {(3,1),(1,2),(2,2),(3,3),(4,3)}
c){(2,3,5)} d)none of these
Q15.In a class of 100 students, 39 play Tennis, 58 play Cricket, 32 play Hockey, 10 play cricket and hockey,11 play hockey and tennis and 13 play tennis and cricket. The number of students who play all three games is
a) 4 b)5 c)6 d)7
Q16. A set of vectors X1,X2,………………Xr if for scalars C1,C2,C3……….Cr in F. the expression C1X1+C2X2+C3X3……………..CrXr=0 is called
a) linearly factor b)linearly dependent
c)linearly independent d)none of these

Q17. An 8 bit converter is driven by a 500KHz clock. What is the average conversion time.
a)0.256ms b)0.142ms c)0.444ms d)0.764ms
Q18.In a micro-computer has a 64 K memory, what are the hexadecimal notation for the first and memory location.
a)0000, EEEE b)0,64 c)0000,FFFF d)0000,9999
Q19. ∑ m(1,2,4,6) is equivalent to
a)∏ M(0,3,5,4,7) b)∏ M(0,3,4,7)
c)∏ M(0,3,6,7) d)∏ M(0,3,5,7)
Q20. Eight 16384 X1bit RAM ICs could be arranged similar to these to form a 16384 X 8 bit read/write memory. This is referred to as a …….. K memory
a.) 2K b)4K c)48K d)16K
Q21. match the following
a)macro definition table l)switch
b)macro name table m)macro call
c)argument list array n)MDT index
d)macro definition level counter o)index member
Q22. Relocation is externally defined symbols is preferred by
a)linker b)loader c)compiler d)assembler
Q23. In FTP, when you ---------- it is copied from the server to the client
a)retrieve a file b)write a file
c)copy a file d) none of these
Q24. which of the following is an application layer services
a)mail service b)process to process delivery
c)remote log in d)none of these
Q25. what is the bandwidth of a signal that ranges from 40KHz to 4MHz
a)360MHz b)36KHz
c)3.96MHz d)none of these


ANSWERS: 1.a,b 2.c 3.d 4.a 5.b 6.b 7.a 8.c 9.b 10.b 11.a 12.c 13.c 14.a 15.b 16.c 17.a 18.c 19.c 20.d 21. a->o,b->n,c->m,d->l 22.a 23.a 24.a 25.c
.