Computer Operator Questions-Part 17

Here, you can read and text important MCQ of loksewa computer operator.

1. The brain of any computer system is

ALU
Memory
CPU
CU

2. Storage capacity of magnetic disk depends on

tracks per inch of surface
bits per inch of tracks
disk pack in disk surface
All of the above

3. The two kinds of main memory are

Primary and secondary
Random and sequential
RAM and ROM
All of above

4. A storage area used to store data to a compensate for the difference in speed at which the different units can handle data is

Memory
Buffer
Accumulator
Address

5. Computer is free from tiresome and boardoom. We call it

Accuracy
Reliability
Diligence
Versatility

6. Which of the following are TCL commands?

UPDATE and TRUNCATE
SELECT and INSERT
GRANT and REVOKE
ROLLBACK and SAVEPOINT

7. _____ is not a category of SQL command.

TCL
SCL
DCL
DDL

8. If you don't specify ASC or DESC after a SQL ORDER BY clause, the following is used by default

ASC
DESC
Random
None of the above

9. What does DML stand for ?

Different Mode Level
Data Model Language
Data Manipulation Language
Data Mode Language

10. How do you select all the records from a table named "User" where the value of the column "LastName" ends with an 'a'?

SELECT * FROM User WHERE LastName='a'
SELECT * FROM User WHERE LastName LIKE 'a%'
SELECT * FROM User WHERE LastName LIKE '%a'
SELECT * FROM User WHERE LastName LIKE '%a%'

11. Microsoft Office is

Desktop application
Operating system
Command window
None of the above

12. Microsoft Office is an office suite, for the

Microsoft Windows Operating System
Mac OS X operating systems
Both A and B
None of the above

13. Microsoft word, Microsoft Excel and Microsoft PowerPoint are the part of

Microsoft Office SUite
Microsoft Windows
Mac OS X
None of the above

14. The very first version of Microsoft Office was released for

Windows Operating System
Apple Macintosh OS
Unix
None of the above

15. The first version of MS Office to be released for the Microsoft Windows Operating System is

Microsoft Office 3.0
Microsoft Office 2003
Microsoft Office 2007
Microsoft Office XP

16. In MS Powerpoint to add a header of footer to your handout you can use

The title master
The slide master
The handout master
All the above

17. In MS Powerpoint the following will not advance the slides in a slide show view

Esc key
The spacebar
The enter key
The mouse button

18. In MS Powerpoint to select all of the boxes of an organization chart

Clicking and edit and select all
Right click the chart background and then click select all
Press and hold the Shift key and click each box
All of the above

19. In MS Powerpoint what are lines, curve, freeform and scribble

Emphasis effects that can be applied to animations
Types of custom motion paths
Predefined entrance and exit effects
All of the above

20. When using Powerpoint, to play a Powerpoint show for previewing the show, select

View, slide sorter
View, slide
View, slide show
View outline

21. What layer in the TCP/IP stack is equivalent to the Transport layer of the OSI model ?

Application
Host-to-Host
Network Access
Internet

22. Which protocol will you use to implement a mechanism that automates the IP configuration?

SMTP
SNMP
DHCP
ARP

23. Which of the following is private IP address?

12.0.0.5
192.168.24.33
172.15.14.56
168.172.19.41

24. MAC address is of _____ bits.

24
36
42
48

25. A point-to-point protocol over ethernet is a network protocol for

encapsulating PPP frames inside ethernet frames
encapsulating ethernet frames inside PPP frames
for security of ethernet frames
for security of PPP frames