Computer Fundamentals
Comprehensive test covering computer hardware, software, networking, programming basics, and security concepts
Questions
Which of the following is true?
- Logical design is software-dependent
- In a distributed database, database is stored in one physical location
- Conceptual design translates the logical design into internal model
- Logical design is software independent
- None of these
Transformation of input into output is performed by
- Peripherals
- Memory
- Storage
- The Input-Output unit
- The CPU
Device drivers are
- Tiny power cords for external storage devices
- Experts who know how to maximize the performance of devices
- Small, special-purpose programs
- The innermost part of the operating system
- Substitutes for operating system
Information travels between components on the motherboard through
- Flash memory
- CMOS
- Bays
- Buses
- Peripherals
When you are working on a document on a PC, where is the document temporarily stored?
- RAM
- ROM
- The CPU
- Flash memory
- The CD-ROM
Which of the following can handle most system functions that aren't handled directly by the operating system?
- Vertical-market applications
- Utilities
- Algorithms
- Integrated software
- Compilers
If you receive an e-mail from someone you don't know, what should you do?
- Forward it to the police immediately
- Delete it without opening it
- Open it and respond to them saying you don't know them
- Reply and ask them for their personal information
- Reply and tell them you want to keep in touch with them
A set of instructions telling the computer what to do is called
- Mentor
- Instructor
- Compiler
- Program
- Debugger
Which of the following refers to the memory in your computer?
- RAM
- DSL
- USB
- LAN
- CPU
A collection of programs that controls how your computer system runs and processes information is called
- Operating system
- Computer
- Office
- Compiler
- Interpreter
The blinking symbol on the computer screen is called the
- Mouse
- Logo
- Hand
- Palm
- Cursor
One megabyte equals approximately
- 1,000 bits
- 1,000 bytes
- 1 million bytes
- 1 million bits
- 2,000 bytes
Which error detection method uses one's complement arithmetic?
- Simply parity check
- Checksum
- Two-dimensional parity check
- CRC
- None of these
The network interface card of LAN is related to following layer of OSI Model-
- Transport
- Network
- Data Link
- Physical
- All of these
An applet __________
- is an interpreted program that runs on the client
- tracks the number of visitors to a Website
- is a compiled program that usually runs on the client
- collects data from visitors to a Website
- None of these
Magnetic tape is not practical for applications where data must be quickly recalled because tape is
- A random-access medium
- A sequential-access medium
- A read-only medium
- Fragile and easily damaged
- An expensive storage medium
Which of the following does not describe a data warehouse?
- Subject-oriented
- Integrated
- Time-variant
- Updateable
- None of these
The total set of interlinked hypertext documents worldwide is-
- HTTP
- Browser
- WWW
- B2B
- None of these
A range check _____
- ensures that only the correct data type is entered into a field
- verifies that all required data is present
- determines whether a number is within a specified limit
- tests if the data in two or more associated fields is logical
- None of these
Every computer connected to an intranet or extranet must have a distinct _____
- firewall
- proxy server
- IP address
- domain name
- None of these
The ___.converts digital signals to analog signals for the purpose of transmitting data over telephone lines.
- Modem
- Router
- Gateway
- Bridge
- All of these
Before a package can be used in a java program it must be___.
- executed
- referenced
- imported
- declared
- None of these
With the object-oriented (OO) approach, an object encapsulates, or _____ a programmer.
- carries out, the details of an object for
- hides, the details of an object from
- reveals, the details of an object to
- extends, the details of an object beyond
- None of these
How many values can be represented by a single byte?
- 4
- 16
- 64
- 256
- 512
Choose the correct way to indicate that a line in a C++ program is a comment line, that is, a line the will not be executed as an instruction___.
- begin the line with a # sign
- begin the line with double slashes (/ /)
- begin and end the line with double hyphens (-_-)
- indent the line
- None of these
Programming language built into user programs such as Word and Excel are known as ____
- 4GLs
- macro languages
- object-oriented languages
- visual programming languages
- None of these
Three SQL, DDL, CREATE commands are __.
- Schema, Base and Table
- Base, Table and Schema
- Key, Base and Table
- Schema, Table and View
- None of these
This is a standard way for a Web server to pass a Web user's request to an application program and to receive data back to forward to the user-
- Interrupt request
- Forward DNS lookup
- Data-Link layer
- File Transfer Protocol
- Common gateway interface
The____ directory is mandatory for every disk.
- Root
- Base
- Sub
- Case
- None of these
Firewalls are used to protect against ___.
- Unauthorized Attacks
- Virus Attacks
- Data Driven Attacks
- Fire Attacks
- All of these
Which of the following will not eliminates the ambiguities of a null value?
- Define the attribute as required
- Define subtypes
- Define each attribute as having an initial value that is recognized as blank
- Define supertypes
- None of these
Data are ________ in client/server computing.
- never sent to the client machine
- sent in very large sections to save processing time
- sent only upon the client's request
- sent in complete copies for the client to filter and sort
- sent from the client to the server for processing
This is a group of servers that share work and may be able to back each other up if one server fails.
- Channel bank
- Cluster
- Tiger team
- Serverless backup
- Logical unit
A keyboard is this kind of device
- black
- input
- output
- word Processing
- None of these
When cutting and pasting, the item cut is temporarily stored in
- ROM
- Hard drive
- Diskette
- Dashboard
- Clipboard
IT stands for
- information Technology
- integrated Technology
- intelligent Technology
- interesting Technology
- None of these
Computers connected to a LAN (Local Area Network) can
- Run faster
- Go on line
- Share information and/or share peripheral equipment
- E-mail
- None of these
A _____ sometimes called a boot sector virus, executes when a computer boots up because it resides in the boot sector of a floppy disk or the master boot record of a hard disk.
- system virus
- Trojan horse virus
- file virus
- macro virus
- None of these
A result of a computer virus can not lead to ___.
- Disk Crash
- Mother Board Crash
- Corruption of program
- Deletion of files
- None of these