Question 1

A subschema expresses
A)the logical view.
B)the physical view.
C)the external view.
D)all of the above

Accepted Answer

A subschema expresses the external view, which is how the database appears to a particular group of users, focusing on their specific requirements and hiding the rest of the database to simplify their interactions.

Question 2

Count function in SQL returns the number of
A)values.
B)distinct values.
C)groups.
D)columns.

Accepted Answer

The COUNT function in SQL is used to return the number of values (rows) in a specific column, including duplicates and NULL values if specified with COUNT(*). It does not inherently count distinct values, groups, or columns without specific syntax directing it to do so.

Question 3

First generation computer systems used
A)transistors
B)vacuum tubes
C)magnetic cores
D)silicon chips

Accepted Answer

First generation computer systems, which were developed in the mid-20th century, primarily used vacuum tubes for circuitry and magnetic drums for memory. Vacuum tubes were the key technology for electronic circuits before transistors and silicon chips were developed.

Question 4

.Which one of the following is a stored program machine?
A)micro-processor
B)calculator
C)analog-computer
D)micro-computer

Accepted Answer

A stored-program computer is a computer that can store and execute a set of instructions, or a program. Microcomputers are stored-program computers.

Question 5

Computers can be classified in which of the following hierarchical orders?
A)pc, large, super micro, super computer
B)super micro, pc, large, super computer
C)pc, super micro, large, super computer
D)large, super micro, super computer, pc

Accepted Answer

Computers are typically classified based on their power and size, starting from the smallest and least powerful to the largest and most powerful. The correct hierarchical order from least to most powerful is: Personal Computers (PCs), which are the most common and least powerful; Super Micro Computers, which are more powerful and can serve more users simultaneously; Large Computers, which are even more powerful and can handle more complex tasks; and Super Computers, which are the most powerful type of computers, capable of processing vast amounts of data and performing complex calculations at the highest speeds.

Question 6

The unit of hardware, which an operator uses to monitor computer processing, is the
A)card reader
B)cpu
C)line printer
D)console

Accepted Answer

The console is the device through which an operator can monitor and interact with the computer's processing activities. It typically includes a display screen and input devices like a keyboard or mouse.

Question 7

Which one of the following a file?
A)floppy disk
B)magnetic drum
C)magnetic tape
D)none of these

Accepted Answer

A file is a digital document stored on a computer or other device, not a physical storage medium like a floppy disk, magnetic drum, or magnetic tape. These options are types of storage devices or media, not files.

Question 8

An I/O device which provides photographic outputs for printing galleys, is the
A)camera printer
B)automatic typesetter
C)radix printer
D)all of these

Accepted Answer

The answer of An I/O device which provides photographic outputs...

Question 9

A term used interchangeably with diskette is
A)disk cartridge
B)disk pack
C)floppy disk
D)packette disk4

Accepted Answer

Floppy disk is another term for diskette, referring to the same storage device that is flexible and encased in a square or rectangular plastic shell.

Question 10

Which is a type of Electrically-Erasable Programmable Read-Only Memory?
A)flash
B)flange
C)fury
D)fram

Accepted Answer

Flash memory is a type of Electrically-Erasable Programmable Read-Only Memory (EEPROM) that allows multiple memory locations to be erased or written in one programming operation.

Question 11

When you insert an Excel file into a Word document, the data are
A)hyperlinked
B)placed in a word table
C)linked
D)embedded

Accepted Answer

The answer of When you insert an Excel file into...

Question 12

'.MPG' extension refers usually to what kind of file?
A)wordperfect document file
B)ms office document
C)animation/movie file
D)imagefile

Accepted Answer

The '.MPG' extension is commonly used for MPEG video files, which are a type of animation/movie file.

Question 13

Who wrote the book 'Computer Liberation and Dream Machine', the first book on personal computers?
A)john mccarthy
B)ted nelson
C)niklaus wirth
D)karl capek

Accepted Answer

Ted Nelson is credited with writing 'Computer Lib/Dream Machines', which is widely recognized as the first book on personal computers. It was influential in popularizing the concept of personal computing.

Question 14

Charles Babbage invented
A)eniac
B)difference engine
C)electronic computer
D)punched card

Accepted Answer

Charles Babbage is credited with inventing the Difference Engine, which is considered an early mechanical computer designed to automatically compute tables of numbers.

Question 15

A computer programmer
A)enters data into computer
B)writes programs
C)changes flow chart into instructions
D)does total planning and thinking for a computer

Accepted Answer

The answer of A computer programmer
A)enters data into computer
B)writes programs
C)changes...

Question 16

Terminal is a
A)device used to give supply to a computer
B)point at which data may leave or enter the computer
C)point where wires are interconnected
D)an input/output device

Accepted Answer

A terminal is a point at which data may leave or enter the computer, often used for input/output operations.

Question 17

Errors in computer results could be due to
A)encoding of data
B)transmission of data
C)manipulation of data
D)all of the above

Accepted Answer

Errors in computer results can occur at various stages, including encoding, transmission, and manipulation of data, making all the options potential sources of error.

Question 18

Register is a
A)set of capacitors used to register input instructions in a digital computer
B)set of paper tapes and cards put in a file
C)temporary storage unit within the cpu having dedicated or general purpose use
D)part of the auxiliary memory

Accepted Answer

Registers are temporary storage units within the CPU that can be used for a variety of purposes, including holding data, instructions, and addresses temporarily during the execution of programs. They are not made of capacitors, paper tapes, cards, or part of the auxiliary memory.

Question 19

WAN means -
A)wide area network
B)wine area network
C)woll area network
D)wide allen network

Accepted Answer

WAN stands for Wide Area Network, which is a telecommunications network that extends over a large geographical area for the primary purpose of computer networking.

Question 20

Which of the following refers to the fastest, biggest and most expensive computers?
A)personal computers
B)supercomputers
C)laptops
D)notebooks

Accepted Answer

Supercomputers are the fastest, biggest, and most expensive computers, designed to perform complex calculations and simulations at high speeds.

Quiz 3: Computer and Technology

A subschema expresses

Count function in SQL returns the number of

First generation computer systems used

.Which one of the following is a stored program machine?

Computers can be classified in which of the following hierarchical orders?

The unit of hardware, which an operator uses to monitor computer processing, is the

Which one of the following a file?

An I/O device which provides photographic outputs for printing galleys, is the

A term used interchangeably with diskette is

Which is a type of Electrically-Erasable Programmable Read-Only Memory?

When you insert an Excel file into a Word document, the data are

'.MPG' extension refers usually to what kind of file?

Who wrote the book 'Computer Liberation and Dream Machine', the first book on personal computers?

Charles Babbage invented

A computer programmer

Terminal is a

Errors in computer results could be due to

Register is a

WAN means -

Which of the following refers to the fastest, biggest and most expensive computers?