Thursday, 24 December 2015

IBPS Specialist Officers - IT Officers Scale I Study Material Quiz 123

IBPS Specialist Officers - IT Officers Scale I Study Material Quiz

Dear experts, Good morning. Today here we are posting a Quiz for IBPS Specialist Officers Professional Knowledge (IT) Computer Knowledge and awareness MCQs. These questions and answers are top most important and expected questions for IBPS IT officer Exam 2015. Read and Practice more for valuable results. 

Q.1. If a computer on the network shares resources for others to use, it is called _____.
(a) Server.(c) Mainframe.
(b) Client.(d) Microcomputer.
Q.2. For large networks _____ topology is used.
(a) Bus(c) star
(b) ring(d) irregular
Q.3. X.25 is an example of __________ network.
(a) Packet switched(c) frame relay
(b) circuit switched(d) ring based
Q.4. What is the maximum length of STP?
(a) 100 ft.(c) 100m.
(b) 200ft.(d) 200m.
Q.5. ISDN is an example of _______ network.
(a) Circuit switched(c) frame relay
(b) Packet switched(d) Ring based
Q.6. ‘AS’ clause is used in SQL for
(a) Selection operation.(c) Join operation.
(b) Rename operation.(d) Projection operation.
Q.7. ODBC stands for
(a) Object Database Connectivity.(c) Oracle Database Connectivity.
(b) Oral Database Connectivity. (d) Open Database Connectivity.
Q.8. Architecture of the database can be viewed as
(a) Two levels.(c) Three levels.
(b) Four levels.(d) One level.
Q.9. In a relational model, relations are termed as
(a) Tuples.(c) Tables.
(b) Attributes(d) Rows.
Q.10. The database schema is written in
(a) HLL(c) DDL
(b) DML(d) DCL
Q.11. Which of the following is record based logical model?
(a) Network Model(c) E-R Model
(b) Object oriented model(d) None of these
Q.12.  A data dictionary is a special file that contains:
(a) The name of all fields in all files.(b) The width of all fields in all files.
(c) The data type of all fields in all files.(d) All of the above.
Q.13. A file manipulation command that extracts some of the records from a file is called
Q.14. The physical location of a record is determined by a mathematical formula that transforms a file key into a record location is:
(a) B-Tree File(c) Indexed File
(b) Hashed File(d) Sequential file.
Q.15. Using Relational Algebra the query that finds customers, who have a balance of over 1000 is
(a) PCustomer_name(s balance >1000(Deposit))(b) s Customer_name(Pbalance >1000(Deposit))
(c) PCustomer_name(s balance >1000(Borrow))(d) s Customer_name(Pbalance >1000(Borrow))
Q.16. In the architecture of a database system external level is the
(A) physical level.(B) logical level.
(C) conceptual level(D) view level.
Q.17. An entity set that does not have sufficient attributes to form a primary key is a
(A) strong entity set.(B) weak entity set.
(C) simple entity set.(D) primary entity set.
Q.18. In a Hierarchical model records are organized as
(A) Graph.(B) List.
(C) Links.(D) Tree.
Q.19. In an E-R diagram attributes are represented by
(A) rectangle.(B) square.
(C) ellipse.(D) triangle.
Q.20. In case of entity integrity, the primary key may be
(A) not Null(B) Null
(C) both Null & not Null.(D) any value.

You also check - Download Pdf file for November Current Affairs 2015 Quiz

other important quiz for IT officer is
  • IBPS I.T.Officer Professional Knowledge Test for 2016 Exam Mock Test Quiz 91

    No comments:

    Post a Comment