Search Here

IT SPECIALIST OFFICER | EXPECTED QUESTIONS (SOLVED) | SET 9


1. When a computer is turned on or re started, a special type of absolute loader called…..is executed.

A.      Boot loader
B.      Compile and Go loader
C.      Bootstrap loader
D.      None

2. Which of the following OS is better for implementing client- server network?

A.      MS DOS
B.      Windows 95
C.      Windows 2000
D.      Windows 98

3. Which file keeps commands to execute automatically when OS is started?

A.      Command.com
B.      Autoexec.bat
C.      Config.sys
D.      None

4. The compiled form of the definition is known as……….

A.      Data dictionary
B.      Directory
C.      System catalog
D.      All the above

5. which of the following closely resembles create view?

A.      Create table…..like
B.      Create table…..as
C.      Create view as
D.      All the above

6. Which statement we should involve in structure programming

A.      SWITCH
B.      IF ELSE
C.      GO TO
D.      WHILE DO

7. Which is the first program run on a computer when the computer boots up?

A.      System software
B.      Operating system
C.      System operations
D.      None

8. The view of total database content is……….?

A.      Conceptual
B.      Internal
C.      External
D.      Physical

9.In SQL which command is used to make permanent changes made by statements issue since the beginning of a transaction?

A.      ZIP
B.      COMMIT
C.      SAVE
D.      PACK

10….is primarily used for mapping host names and email destinations to IP address but can also be used for other purposes

A.      TCP
B.      SNMP
C.      DNS
D.      None

11……….is virus that inserts itself into a systems memory. Then it takes number of actions when an infected file is executed.

A.      Macro virus
B.      Boot sector virus
C.      Polymorphic virus
D.      Resident virus.

12. The …………remain operative until the software is required

A.      Spiral model
B.      Prototyping model
C.      Waterfall model
D.      Incrementing model

13. An important application of cryptography used in computerized commercial and financial transaction……..

A.      Media coverage
B.      Data warehousing
C.      Digital signature
D.      Data mining

14. From what location are the first computer instructions available on boot up?

A.      CPU
B.      Config.sys
C.      ROM BIOS
D.      Boot.ini

15. In ER diagrams the term cardinality is a synonym for the term……….

A.      Attribute
B.      Degree
C.      Entities
D.      Cartesian

16. What does microprocessor speed depends on?

A.      Clock
B.      Data Bus width
C.      Address bus width
D.      All of these

17. In queues, the items deleted at one end is called?

A.      Rear
B.      Front
C.      Top
D.      Base

18. The clause in SQL that specifies that the query result should be sorted in ascending or descending order based on the values of one or more columns is……

A.      View
B.      Order by
C.      Group by
D.      Ascending

19. According to the levels of abstraction, the schema at the intermediate level is called

A.      Logical schema
B.      Physical schema
C.      Conceptual schema
D.      Super schema

20. Fifth normal form is concerned with

A.      Functional dependency
B.      Multivalued dependency
C.      Join dependency
D.      Domain key


http://www.braingeek.in/p/it-specialist-officer.html


READ PREVIOUS EXPECTED QUESTIONS (SOLVED)


Related Posts Plugin for WordPress, Blogger...