Computer Operator Questions-Part 16

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

1. Which SQL function is used to count the number of rows in a SQL query?

Count()
Number()
Count(*)
Sum()

2. Which SQL keyword is used to retrieve a maximum value?

MOST
TOP
MAX
UPPER

3. Which of the following SQL clauses is used to DELETE tuples from a database table?

DELETE
REMOVE
DROP
CLEAR

4. ___ removes all rows from a table without logging the individual row deletions.

DELETE
REMOVE
DROP
TRUNCATE

5. Which of the following is not a DDL command?

UPDATE
TRUNCATE
ALTER
None of the above

6. UNIVAC is

Universal Automatic Computer
Universal Array Computer
Unique Automatic Computer
Unvalued Automatic Computer

7. The basic operations performed by a computer are

Arithmetic operation
Logical operation
Storage and relative
All the above

8. The two major types of computer chips are

External memory chip
Primary memory chip
Microprocessor chip
Both b and c

9. Microprocessors as switching devices are for which generation computers

First generation
Second generation
Third generation
Fourth generation

10. ASCII and EBCDIC are the popular character coding systems. What does EBCDIC stand for?

Extended binary coded decimal interchange code
Extended bit code decimal interchange code
Extended bit case decimal interchange
Extended binary coded decimal interchange code

11. If there are multiple recycle bin for a hard disk

You can set different size for each recycle bin
You can choose which recycle bin to use to store your deleted files
You can make any one of them default recycle bin
None of the above

12. Identify the false statement

You can find deleted files in recycle bin
You can restore any files in recycle bin if you ever need
You can increase free space of disk by sending files in recycle bin
You can right click and choose empty recycle bin to clean it at once

13. If the displayed system time and date is wrong, you can reset it using

Write
Calendar
Write file
Control panel

14. You should save your computer from

Viruses
Worms
Time bombs
All the above

15. World wide web is being standard by

World wide corporation
w3c
World wide consortium
World wide web standard

16. In Microsoft word to cut something the following shortcut is used

Ctrl+C
Ctrl+V
Ctrl+X
None of the above

17. In Microsoft word Ctrl+Z is for

Undo something
Delete something
Paste something
None of the above

18. Graphics for word processor

Peripheral
Clip art
Highlight
Execute

19. A program which helps to create written document and lets you go back and make correction as necessary

Home rows keys
Tool bar
Spreadsheet
Word processor

20. What does the Ctrl + I shortcut key accomplish in Ms-Word?

Increase selected text size
Add a line break to a document
Make selected text bold
Make selected text italic

21. In excel default header for a worksheet is

Your name
Date and time
None
Sheet tab name

22. In excel which of the following is not an option in the spelling box

Edit
Ignore
Ignore all
Change

23. Excel uses the ... function when creating a data table

Average
Count
Sum
Table

24. In excel you can copy cell formats from one cell to another by using the

Backspace key
Default font
Format painter
Formatting toolbar

25. In excel accounting style shows negative numbers in

Bold
Brackets
Parentheses
Quotes