1) The view of Database Content is:
a)Conceptual View b)Internal View c)External View d)Physical view
2) DML is provided for:
a)Description of Logical structure Database b) Addition of new structure
c)Manipulation and Processing of Database d) a & b
3)Relation ship in E-R Diagram is represented by :
a)Rectangle box b)Oral shape c)Diamond box d)Parallel lines
4)Sliding Window is
a)Flow control Method b) Error Detection Method c)Connection establishing d)Shortest Path finding
5)Ethernet uses a _____ physical address that is imprinted on the Network Interface Card
a)64Bit b)64Byte c)6Bit d)6Byte
6)Flip Flop has only
a)One state b)Two state c)Four state d)Eight state
7)Which clause in SQL uses to check pattern in database
a)Distinct b)Like c)Between d)In
8)which data structure can be used to convert one number system into another.
a)Stack b)Queue c)Tree d)Graph
9)Which is not a state of Thread?
a)Running b)Runnable c)Transition d)Blocked
10)In color Monitor we have
a)Three Pixel b)One Dot Pixel c)Two Dot Pixel d) 2*3 million Pixel
11)Which layer 4 Protocol is used for a Telnet Connection
a)IP b)TCP c)TCP/IP d)UDP
12)ODBC stands for
a)Object Database Connectivity b)Oral Database Connectivity
c)Open Database Connectivity d)Objective Data Base Connectivity
13)Which of the Following Protocol uses both TCP and UDP?
a)FTP b)TELNET c)SMTP d) DNS
14)Count function in SQL returns
a)Total no of Values b)Total no of Distinct Values
c)Count of Groups d)Count & Max no of Columns
15)Its is better to use files than DBMS where
a)Stringent Real time Requirements b)Multiple User requirment
c)Complex relationship exits d)All of the above
For Strategy and Analysis : Click Me
For Previous Year CutOff : Click Me
For Model Questions 2+ Previous Year Paper: Click Me
Ans: 1) a 2)c 3)c 4)a5)d 6)b 7)b 8)a 9)c 10)a 11)b 12)c 13)d 14)a 15)b
a)Conceptual View b)Internal View c)External View d)Physical view
2) DML is provided for:
a)Description of Logical structure Database b) Addition of new structure
c)Manipulation and Processing of Database d) a & b
3)Relation ship in E-R Diagram is represented by :
a)Rectangle box b)Oral shape c)Diamond box d)Parallel lines
4)Sliding Window is
a)Flow control Method b) Error Detection Method c)Connection establishing d)Shortest Path finding
5)Ethernet uses a _____ physical address that is imprinted on the Network Interface Card
a)64Bit b)64Byte c)6Bit d)6Byte
6)Flip Flop has only
a)One state b)Two state c)Four state d)Eight state
7)Which clause in SQL uses to check pattern in database
a)Distinct b)Like c)Between d)In
8)which data structure can be used to convert one number system into another.
a)Stack b)Queue c)Tree d)Graph
9)Which is not a state of Thread?
a)Running b)Runnable c)Transition d)Blocked
10)In color Monitor we have
a)Three Pixel b)One Dot Pixel c)Two Dot Pixel d) 2*3 million Pixel
11)Which layer 4 Protocol is used for a Telnet Connection
a)IP b)TCP c)TCP/IP d)UDP
12)ODBC stands for
a)Object Database Connectivity b)Oral Database Connectivity
c)Open Database Connectivity d)Objective Data Base Connectivity
13)Which of the Following Protocol uses both TCP and UDP?
a)FTP b)TELNET c)SMTP d) DNS
14)Count function in SQL returns
a)Total no of Values b)Total no of Distinct Values
c)Count of Groups d)Count & Max no of Columns
15)Its is better to use files than DBMS where
a)Stringent Real time Requirements b)Multiple User requirment
c)Complex relationship exits d)All of the above
For Strategy and Analysis : Click Me
For Previous Year CutOff : Click Me
For Model Questions 2+ Previous Year Paper: Click Me
Ans: 1) a 2)c 3)c 4)a5)d 6)b 7)b 8)a 9)c 10)a 11)b 12)c 13)d 14)a 15)b
@Animesh: Thanks for the blogs regarding the exam.They have been helpful.
ReplyDeleteCan you please confirm if the above questions are for IT officer scale 1 or scale 2 ot for both of them.
Its for Both..
Delete