All Stories
Showing posts with label it officer. Show all posts
Showing posts with label it officer. Show all posts

Thursday 28 January 2016

IBPS IT officer professional knowledge questions(Computer networks)

Here we are sharing second set of professional knowledge questions for IBPS IT officer examination.In this section we have covered the topic 'computer networks'.In case you missed first set read it from here.IBPS IT officer professional knowledge questions(Concept of database design , DBMS and SQL MCQ).

Computer networks multiple choice questions(MCQ)

1. If all devices are connected to a central hub, then topology is called
a) Bus Topology
b) Ring Topology
c) Star Topology
d) Tree Topology
e) None of the above

2. FDDI stands for
a) Fiber Distributed Data Interface
b) Fiber Data Distributed Interface
c) Fiber Dual Distributed Interface
d) Fiber Distributed Data Internet
e) None of these

3.Which of the following communication mode supports two way traffic but in only one direction at a time?
a) Simplex
b) Duplex
c) Half- duplex
d) Full duplex
e) None of these

4.In OSI model ___ layer changes bits into electrical signals
a) Physical
b) Data link
c) Network
d) Session
e) Transport

5.Ethernet system follows which topology?
a) Star
b) Mesh
c) Bus
d) Tree
e) Ring

6.DNS can obtain the ____ of host if its domain name is known and vice versa.
a) Station address
b) Port address
c) Port number
d) IP address
e) All of the above

7.Which of the following is not a layer of TCP/IP model?
a) Application Layer
b) Session Layer
c) Transport Layer
d) Internet Layer
e) All of the above

8.In IPv4 class ___ address is reserved for multicasting.
a) A
b) B
c) C
d) D
e) E

9.Defaullt port for HTTP?
a) 80
b) 25
c) 110
d) 23
e) None of these

10.FTP server listen to connections on ports____ and ____
a) 20,21
b) 22,23
c) 21,22
d) 20,25
e) 21,23

11.The ___ layer is responsible for resolving access to the shared media or resources.
a) Network
b) Physical
c) Application
d) Mac layer(Part of data link layer)
e) None of the above

12. 44.Which of the following is the default mask of a class A IP address?
a) 255.0.0.255
b) 255.255.0.0
c) 255.0.0.0
d) 255.255.255.0
e) None

13. Q. Which of the following protocols is/are defined in Transport Layer?
a) FTP
b) TCP
c) IEEE 3.2
d) None of these
e) All of these

14.FDDI uses which topology?
a) Ring
b) Bus
c) Tree
d) Mesh
e) None of these

15. Repeater operates in which layer of OSI model?
a) Data link layer
b) Network layer
c) Physical layer
d) Session layer
e) None of these

16.Expand ISDN
a) Integrated Service Digital Network
b) Isolated Service Digital Network
c) Integrated Service Data Network
d) Isolated Service Data Network
e) None of these

17.Router is a ____ layer device
a) Network
b) Session
c) Presentation
d) Physical
e) Data link

18. What is the use of Bridge in Networks?
a) Used to separate LANS that use same protocols
b) Used to separate LANS that use different protocol
c) Packet filtering
d) Encoding
e) Decoding

19.SMTP is the protocol for ___
a) Sending e-mails
b) Receiving e-mails
c) File transfer
d) Both a and b
e) None of these

20. The number of bit positions in which the code words differ is called _______ .
a) Hamming distance
b) Code distance
c) Error distance
d) None of these
e) All of the above

21.The address changes temporarily as the application connect to the internet is called ___
a) Static IP address
b) Dynamic IP address
c) Unique IP address
d) Derived IP address
e) None of these

22.Class D IPv4 address ranges from
a) 224.0.0.0 to 239.255.255.255
b) 240.0.0.0 to 255.255.255.254
c) 192.0.0.x to 192.255.255.x
d) 128.0.x.x to 191.255.x.x
e) 1.x.x.x to 126.x.x.x

23.Telnet is used for ___
a) accessing someone else's computer remotely.
b) Sending large files over internet
c) Transfer of file from one computer to another
d) Both a and b
e) Both b and c

24.Length of IPv4 address is ___ and that of IPv6 is ____
a) 32 bit, 128 bit
b) 8 byte , 16 bytes
c) 14 bit ,48 bits
d) 128 bit, 512 bit
e) 64 bit , 128 bit

25. ____ is Self-contained packet of data that carries with it the source and destination information for correct routing. ______ travels from a source computer (such as a website server) to a destination computer (client or user computer) via a packet-switched network (such as the internet),independent of any previous or subsequent communication between the two computers.
a) Packet
b) Cell
c) Datagram
d) Database
e) None of these

Answer Key
1.c
2.a
3.c
4.a
5.c
6.d
7.b
8.d
9.a
10.b
11.d
12.c
13.b
14.a
15.c
16.a
17.a
18.a
19.d
20.a
21.b
22.a
23.a
24.a
25.c

If you find this IBPS IT officer professional knowledge questions useful, consider sharing it...
We will post more number of professional knowledge question sets in coming days. Like us on facebook or subscribe to our news letter to stay connected with bankaspire


simon         2 comments:

Wednesday 27 January 2016

IBPS IT officer professional knowledge questions(Concept of database design , DBMS and SQL MCQ)

As you know, in IBPS IT officer written examination professional knowledge section carries 75 marks.This is the most important section of the common written examination(CWE).Thorough preparation of the professorial knowledge section will give you an edge in the written examination as well as in interview process.Here we are sharing first set of professional knowledge questions for IBPS IT officer examination.In this section we have covered the topic 'Concept of database design,DBMS and SQL'.

DBMS and SQL multiple choice questions(MCQ)-Set1

1.In a relational model , cardinality is termed as number of ____
a) Tuples
b) Attributes
c) Tables
d) Constraints
e) None of these

2.A logical data structure with a one-to-many relationship is a____
a) Network
b) Tree
c) Chain
d) relational
e) none of these

3.Which of the following feature belongs to E-R diagrams?
a) An entity is shown as a rectangle
b) The attributes, shown as oval connected to entities by lines
c) A diamond represents relation among a number of entities which are connected to the diamond by a line
d) All of the above
e) None of the above

4.Which of the following is not a property of transactions?
a) Atomicity
b) Isolation
c) Durability
d) Concurrency
e) None of these

5._________ constraint is used to restricts actions that would destroy links between tables?
a) Primary key
b) Foreign key
c) Check
d) Not null
e) None of these

6. A single entry in a table is called a _________.
a) Field
b) Column
c) Record
d) Data
e) None of these

7.Which of the following is not a type of data base?
a) Hierarchical
b) Network
c) Relational
d) Transitional
e) None of these

8.Which of the following is true?
a) Duplicate values are allowed in a primary key
b) Primary keys generally can be changed
c) Foreign keys are generally based on data values and are purely logical, not physical, pointers.
d) You can define foreign key without existing primary key
e) None of these

9.A second normal form does not permit ____ dependency between a non-prime attribute and relation key.
a) Partial
b) Multi
c) Functional
d) Valued
e) None of these

10.In a Third Normal Form relation , every ___ attribute is a non- transitively and fully dependent on every the every candidate key.
a) Prime
b) Non-prime
c) Unique
d) Any of the above
e) None of the above

11.Which of the following is not a type of SQL Statement?
a) Data Manipulation Language(DML)
b) Data Definition Language(DDL)
c) Data Control Language(DCL)
d) Data Standard Language(DSL)
e) All of the above are SQL statements

12.Which of the following not included in Data Manipulation Language(DML)?
a) INSERT
b) UPDATE
c) DELETE
d) CREATE
e) All of these

13.Which of the following statement manages the changes made by DML statements?
a) SELECT
b) UPDATE
c) DELETE
d) COMMIT
e) INSERT

14.TRUNCATE is ___ statement
a) DML
b) DDL
c) DCL
d) All of these
e) None of these

15.Which of the following can be done using SELECT statement?
a) Selection
b) Projection
c) Join
d) All of these
e) Options a and b

16.One can display all columns of a table by following the SELECT keyword with ____
a) +
b) *
c) &
d) $
e) @

17.Select statement can be used to display specific columns of the table by specifying the column names, separated by ___
a) Underscore(_)
b) Space
c) Tab
d) Commas(,)
e) None of these

18.To discard all pending data changes _____
a) COMMIT
b) ROLLBACK
c) SAVEPOINT
d) LOCK
e) None of these

19.Which of the following is not a valid data type in SQL?
a) CHAR
b) FLOAT
c) CLOB
d) DATE
e) None of the above

20.’AS’ clause is used in SQL for___
a) Join
b) Projection
c) Selection
d) Rename
e) Drop table

21.Which of the following SQL statement is used to delete a column from a table?
a) DELETE column-name from table-name
b) ALTER table table-name DROP COLUMN column-name
c) DROP column-name from table-name
d) Any of the above
e) None of the above

22.ODBC stand for ___ Data Base Connectivity.
a) Object oriented
b) Object
c) Open
d) Oracle
e) None of these

23.DROP is a ___ statement in SQL
a) DDL
b) DCL
c) Query
d) TCL
e) DML

24.In SQL the word ‘natural’ can be used with ___
a) Full outer join
b) Inner join
c) Right outer join
d) Left outer join
e) None of these

25.Count function in SQL returns the number of ___
a) Distinct values
b) Not null values
c) Groups
d) Columns
e) None of these

Answer key
1.a
2.b
3.d
4.d
5.b
6.c
7.d
8.c
9.a
10.b
11.d
12.d
13.d
14.b
15.d
16.b
17.d
18.b
19.b
20.d
21.c
22.c
23.a
24.b
25.b
Click here to read IBPS IT officer professional knowledge questions set-2(Computer networks)
If you find this IBPS IT officer professional knowledge questions useful, consider sharing it...
We will post more number of professional knowledge question sets in coming days. Like us on facebook or subscribe to our news letter to stay connected with bankaspire

simon         No comments:

Thursday 14 January 2016

IBPS IT officer model question paper ebook


IBPS Specialist officer(IT officer) model question paper pdf download: IBPS has released call letter for specialist officer common written examination (CWE-V).Exam will be conducted across various centres across India on 14th of February.To asses yourselves, practice/mock test is the best.By attending practice test ,identify your area of strength and weakness. You can plan your time table according to that.Here we are sharing model question paper for IBPS IT officer professional knowledge. Quantitative , Reasoning and English syllabus of IT officer is same as that of IBPS PO.Most of the questions in this model paper is picked from IBPS Specialist officer (IT) previous year papers.We are sure that this IT officer professional knowledge question set will help you in IBPS and SBI IT officer exams.


ibps it officer model question paper

IBPS Specialist officer (IT) exam pattern
Sr. No
Name of the Tests
Number of questions
Maximum Marks
Total Time
1
Reasoning
50
50


120 minutes
2
English Language
50
25
3
Quantitative
50
50
4
Professional Knowledge
50
75
Total
200
200

Before going into IBPS IT officer sample question paper you may like to read detailed syllabus of IBPS Specialist officer(IT)

IBPS IT officer Professional knowledge model paper with answer key eBook

We are providing this model paper in eBook and pdf format.After reading you can download IBPS Specialist officer(IT officer ) model question paper with answer in pdf format.
Click here to read and download IBPS IT officer Model question paper(Professional knowledge)
Quantitative and Reasoning questions will be in similar pattern as that of IBPS PO.So you can download quantitative and reasoning practice questions from here.
-IBPS Specialist officer 2016 notification

If you find this IBPS IT officer professional knowledge practice set useful, then share it with your friend.We will post more set of professional knowledge practice questions with answer key in coming days.Like us on facebook for getting updates or subscribe to our newsletter for getting model papers in your inbox.

[Related tags:ibps specialist officer model question paper,ibps specialist officer model question paper pdf,ibps it officer question paper pdf free download,ibps it officer previous year question paper pdf,ibps specialist officer previous year question paper 2013 pdf,ibps specialist officer previous year question paper 2014 pdf,ibps specialist officer question paper with answers pdf free download,ibps it officer previous year solved question paper]
simon         2 comments:

Tuesday 12 January 2016

IBPS Specialist officer (SO) CWE call letter download(IT officer , law officer, marketing officer, HR officer and Rajbhasha Adikari CWE Call letter) :IBPS has released call letter for Specialist officer Common Written Examination(CWE-V).You can download call letter by entering registration number and password/date of birth.
You can also directly download your call letter from here or by clicking the link given below.
Note:Agriculture  officer call letter will be issued only after February 3.
simon         No comments:

Contact Form

Name

Email *

Message *