Sample Question For IBPS Specialist Officer (IT) Examination 2014 (Part :1)

1. Which of the following is not an advantage of magnetic disk storage?

(A)The access time of magnetic disk is much less than that of magnetic tape

(B)Disk storage is longer lasting than magnetic tape

(C)Disk storage is less expensive than tape storage

(D)All of the above

(E) None of these

ANSWER: (D)

2. A prefix for billion which is equal to _____is called as billi.

(A) 100

(B) 10000

(C) 1000

(D) 10

(E) None of these

ANSWER: (A)

3. One kilobyte -byte

(A) 1250

(B) 2088

(C) 1024

(D) 1000

(E) None of these

ANSWER: (C)

4. To move the cursor to the end of the document

press

(A) Ctrl + Esc

(B) Ctrl + End

(C) Ctrl + B

(D) Ctrl + C

(E) None of these

ANSWER: (B)

5. The shortcut key to print documents is

(A) Ctrl + A

(B) Ctrl + B

(C) Ctrl + P

(D) Ctrl + C

(E) None of these

ANSWER: (C)

6. In MICR, C stands for

(A) Code

(B) Colour

(C) Computer

(D) Character

(E) None of these

ANSWER: (D)

7. The simultaneous processing of two or more Programs by multiple processors is

(A) Multiprogramming

(B) Multitasking

(C) Time-sharing

(D) Multiprocessing

(E) None of these

ANSWER: (D)

8. First layer in the OSI reference model is

(A) Data link

(B) Network

(C) Physical

(D) Application

(E) None of these

ANSWER: (C)

9. Viruses, Trojan horses and worms are

(A) Able to harm computer system

(B) Unable to detect if affected on computer

(C) User-friendly applications

(D) Harmless applications resident on computer

(E) None of these

ANSWER: (A)

10. Failure of passwords security due to exposure can result from

(A) Electronic monitoring

(B) Visual

(C) Both ‘A’ and ‘B’

(D) Light

(E) None of these

ANSWER: (C)

11. Data security threats include

(A) Hardware failure

(B) Privacy invasion

(C) Fraudulent manipulation of data

(D) All of the above

(E) None of these

ANSWER (B)

12. Graphical pictures that represent an object like file, folder etc. are

(A) Task bar

(B) Windows

(C) Desktop

(D) Icons

(E) None of these

ANSWER (D)

13. Accessing records from a file directly without searching from the beginning of the file is

(A) Time sharing

(B) Random

(C) Direct access

(D) Access time

(E) None of these

ANSWER (C)

14. Database redesign is not terribly difficult if the

(A) Database is structured

(B) Database is well-designed

(C) Database has no data

(D) Database is relatively small

(E) None of these

ANSWER (C)

15. Which of the following SQL statements are helpful in database redesign?

(A) Correlated sub queries only

(B) EXISTS/ NOT EXISTS expressions only

(C) Both of the above are helpful

(D) Creating the database are helpful

(E) None of these

ANSWER (C)

16. The EXISTS keyword will be true if

(A)Any row in the sub query meets the condition only

(B)All rows in the sub query fail the condition only

(C)Both of these two conditions are met

(D)Neither of these two conditions is met

(E) None of these

ANSWER (A)

17. How can you find rows that do not match some specified condition ?

(A) EXISTS

(B) Double use of NOT EXISTS

(C) NOT EXISTS

(D) ROWS EXIT

(E) None of these

ANSWER (C)

18. The process of reading a database schema and producing a data model from that schema is

known as

(A) Data modelling

(B) Database design

(C) Reverse engineering

(D) Inverse engineering

(E) None of these

ANSWER (C)

19. Which SQL-92 standard SQL command can be used to change a table name ?

(A) RENAME TABLE

(B) CHANGE TABLE

(C) ALTER TABLE

(D) All of the above

(E) None of these

ANSWER (A)

20. What SQL command can be used to delete columns from a table?

(A) MODIFY TABLE Name DROP COLUMN Name

(B) MODIFY TABLE Name DROP Column Name

(C) ALTER TABLE Name DROP Column Name

(D) All of the above

(E) None of these

ANSWER (C)

21. Which of the following modifications may not succeed?

(A) Changing a column data type from char to date

(B) Changing a column data type from numeric to char

(C) Both of the above actions should succeed

(D) Neither of the above actions will succeed

(E) None of these

ANSWER ((A)

22. Changing cardinalities in a database is

(A) A common database design task

(B) A rare database design task, but does occur

(C) A database design task that never occurs

(D) Is impossible to do, so a new database must be constructed and the data moved into it

(E) None of these

ANSWER (A)

23. A regular sub query can be processed

(A)From the top down

(B)From the bottom up

(C)By nesting

(D)From the right up

(E) None of these

ANSWER ((B)

24. How many copies of the database schema are typically used in the redesign process?

(A)One

(B)Two

(C)Three

(D)Four

(E) None of these

ANSWER (C)

25. Through which device the main components of the computer communicate with each other?

(A). Keyboard

(B). System Bus

(C). Monitor

(D). Memory

(E) None of these

ANSWER (B)