DESCO ASSISTANT ENGINEER (CSE) -2016
EXAM CONDUCT BY: BUET
Written Part
[Note: Questions serial may not match]
Q1. (i) Which type of JOIN is used to find not matched data
from table?
SELECT pk, c1
FROM
(
SELECT t1.pk, t1.c1
FROM t1
UNION ALL
SELECT t2.pk, t2.c1
FROM t2
) t
GROUP BY pk, c1
HAVING COUNT(*) = 1
ORDER BY pk
(ii) In which keyword is used for retrieving data from table
without duplicate row data?
SELECT DISTINCT
column1, column2, ...
FROM
table1;
example:
SELECT DISTINCT
(SELECT
min(ti.Country_id)
FROM
tbl_countries ti
WHERE
t.country_title = ti.country_title) As Country_id
,
country_title
FROM
tbl_countries
t
(iii) What is the output of the following query –
SELECT *
FROM myTbale
WHERE id>0
ORDER BY id DESC, NAME DESC
(iv) Why
indexing is used in database? How hash table works?
indexing is used in
database:
Indexes are used to quickly locate data without having to search every row in a database table every time a database table is accessed. Indexes can be created using one or more columns of a database table, providing the basis for both rapid random lookups and efficient access of ordered records.
How hash table works
A hash table is a data structure that is used to store keys/value pairs. It uses a hash function to compute an index into an array in which an element will be inserted or searched. By using a good hash function, hashing can work well.
Q2. Java Programming: Write a class named Bicycle and create a
constructor of its and initialize the class member names cadense as Integer,
gear as Integer speed as Integer. Write another class MountainBike and create
also a constructor of its and add this field seatHeight as Integer and a
method to set its from this class and extend Bicycle class.
public class Bicycle { // the Bicycle class has three fields
public int cadence;
public int gear;
public int speed; // the Bicycle class has one constructor
public Bicycle(int startCadence, int startSpeed, int
startGear) {
gear =
startGear;
cadence =
startCadence;
speed =
startSpeed;
} //
the Bicycle class has four methods
public void setCadence(int newValue) {
cadence = newValue;
}
public void setGear(int newValue) {
gear = newValue;
}
public void
applyBrake(int decrement) {
speed -=
decrement;
}
public void speedUp(int increment) {
speed +=
increment;
}
}
public class MountainBike extends Bicycle { // the MountainBike
subclass has one field
public int seatHeight; // the MountainBike subclass has one
constructor
public MountainBike(int startHeight, int startCadence, int
startSpeed, int
startGear) {
super(startCadence, startSpeed, startGear);
seatHeight =
startHeight;
} // the
MountainBike subclass has one method
public void setHeight(int newValue) {
seatHeight = newValue;
}
}
Q3. Write the output of the
following program
#define MAX(A,B) ((A)>(B)) ? A:B
void main(){
int i=1;
int j=2;
int val=max(++i,++j);
printf(“%d”,val);
}
Output: 3
[Note: My written variable may not match]
Q4. Write a program in any programming language to find
maximum number from given three numbers.
Using if-else statement
to find the largest number.
#include <stdio.h>
int main()
{
int A, B, C;
printf("Enter three
numbers: ");
scanf("%d %d %d",
&A, &B, &C);
if (A >= B) {
if (A >= C)
printf("%d is the
largest number.", A);
else
printf("%d is the
largest number.", C);
}
else {
if (B >= C)
printf("%d is the
largest number.", B);
else
printf("%d is the
largest number.", C);
}
return 0;
}
Using nested if-else
statements to find the largest number.
#include <stdio.h>
int main()
{
int A, B, C;
printf("Enter three
numbers: ");
scanf("%d %d %d",
&A, &B, &C);
if (A >= B && A
>= C)
printf("%d is the
largest number.", A);
else if (B >= A && B
>= C)
printf("%d is the
largest number.", B);
else
printf("%d is the
largest number.", C);
return 0;
}
Using
ternary(conditional) operator
#include <stdio.h>
int main()
{
int A, B, C, largest;
printf("Enter three numbers:
");
scanf("%d %d %d",
&A, &B, &C);
largest = A > B ? (A > C
? A : C) : (B > C ? B : C);
printf("%d is the largest
number.", largest);
return 0;
}
OUTPUT:
Enter the numbers A, B and C: 2 8 1
8 is the largest number.
Q5. Write the output of the following program
int sum(int
val){
static int myResult=0;
myResult += val;
return myResult;
}
void main(){
int i, value;
for(i=1;i<10;i++)
value=sum(i);
printf(“%d”,value);
}
Q6. (i) Divide
and Conquer method is used in
(a) Merge Sort
(b) Bubble Sort
(c) Quick Sort
(d) Both a & c
(ii) Dynamic programming
approach is used to solve
(a) Dijkstra algorithm
(b) Kruskal’s Algoritm
(c) Prim’s Algorithm
(d) None of these
(iii) Binary
search worst time complexity is
(a)
O(n)
(b)
O(1)
(c) O(log n)
(d)
O(n^2)
Q7. A company have a web based survey system where visitor
browse the website login page. Only authorized visitor can access this survey
system by using username and password. After login, visitor get a survey form
and submit by filling the required information.
Now draw the use-case diagram of this web based survey system.
Q8. Drawing interface from following diagram
Q10. Program analyzing and writing output
Q11. Fill out the table from given circuit
Q12. Describe different part of given microprocessor block diagram
Q13. Write the device name according to the given criteria. (This
question is related with Router, Switch, Hub, Gateway)
MCQ Part : 60 Questions
[Note: Questions serial will not match.
I
just write up those here what I remembered]
Q1. Which countries prime minister has resigned after “Panama Papers”
fallout?
(a) Belgium
(b) Korea
(c) Iceland
(d)
Ireland
Q2. G-7 countries are UK, USA, Japan, France and
(a) Canada, Netherlands, Iceland
(b) Canada,Italy,
Germany
(c) Italy, Netherlands, Chaina
(d) Germany, Italy, Netherlands
Q3. আরণ্যক কার লেখা ?
(a) শহীদুল্লাহ কায়সার
(b) বিভূতিভূষণ বন্দোপ্যাধায়
(c) শরৎচন্দ্র চট্টোপাধ্যায়
(d) আহসান হাবীব
Q4. বেগম রোকেয়া রচিত
(a) শেষের কবিতা
(b) সুলতানার স্বপ্ন
(c) জীবনের গান
(d)
কোনটিই নয়
Q5. সঠিক বানান কোনটি
(a) মুমূর্ষু
(b)মূমূসূ
(c) মুমূর্ষূ
Q6. আঞ্চলিক ভাষার আপর নাম
(a) উপভাষা
(b) চলিত ভাষা
(c) সাধু ভাষা
(d) কথ্য ভাষা
Q7. বাক্যে কমা অপেক্ষা বেশি থামার প্রয়োজন হলে কোনটি ব্যবহার করতে হয় ?
(a) সেমিকোলন
(b) কোলন
(c) হাইপেন
(d) দাঁড়ি
Q8. যে নারীর হাসি সুন্দর
(a) সূচিস্মিতা
(b) সুচিস্মীতা
(c) সুচিস্মিতা
(d) সুচীস্মিতা
Q9. Which is the faster Memory?
(a) RAM
(b) Secondary Memory
(c) DRAM
(d) Cache
Q10. Which is not a application software?
(a) Redhat
Linux
(b) MS Office
(c) Open Office
(d) Adobe illustrator
Q11. Microprocessor is used first in which generation
computers?
(a) Second Generation
(b) Third Generation
(c) Fourth
Generation
(d) Fifth Generation
Q12. When we browse internet, browser store some data in
the computer. We are talking about
(a) Session
(b) File
(c) Memory
(d) Cookie
Q13. In client-server system what does the client program?
(a) Share data with other computer
(b) Serve information to others computer
(c) Control others connected computers
(d) Asked
for information
Q14. What is the opposite word of accept
(a) Approve
(b) Boisterous
(c) Reject
(d) Elated
Q15. Who is the current president of FIFA?
(a) Daniel Burley Woolfall
(b) Rodolphe Seeldrayers
(c) Giovanni Infantino
(d) Sepp Blatter
 -2016){kind=link}
0 মন্তব্যসমূহ