spelman college computer science olympiad mid-atlantic regional 2007 hardware and software...
TRANSCRIPT
Spelman College Computer Science OlympiadMid-Atlantic Regional 2007
Hardware and SoftwareIntegration
Event
Jeopardy-style Competition
The first team to buzz in will answer the question: 1 point for the correct answer -1 point for the wrong answer
In the case of a wrong answer, other teams may attempt the question
If no correct answer within 60 seconds, move on to the next question
Trivia questions: 2 points for the correct answer -1 point for the wrong answer
HARDWARE/SOFTWARE
What is the main program that controls how your computer system functions? It manages the computer’s hardware, including the CPU, memory, and storage devices, as well as peripheral devices.
INTERNET
What is the bolded red portion of the following URL called?
URL http:// www.nytimes.com/Pages/cartoons/
HARDWARE/SOFTWARE
RAM has limited capacity. When there isn’t enough room in RAM for the OS to store the required data and instructions, it borrows room from the hard drive. What is this borrowed hard drive space called?
INTERNET
What are the text files stored on client computers when visiting Web sites? These files are used on return visits to Web sites.
PROGRAMMING
What is name of the OOD concept in which a new class of objects is derived by absorbing characteristics of existing classes?
NETWORKS
A core Internet protocol, this connection-less protocol is commonly used for streaming media applications and VoIP. What is its name?
PROGRAMMING
According to the flowchart given below, what will be displayed?
Begin
End
(NOT ((3 <> 5) OR (5> 3)))False True
Output:"OVER"
Output:"NOT YET"
TRIVIA
How did Alan M. Turing, the father of artificial intelligence, die?
DATABASE
What is the name of this type of diagram?
PROGRAMMING
What is the output of a programming language translator such as compiler or interpreter?
NETWORKS
Devices like the one shown in this picture, that help make data flow possible, are called _______ .
INTERNET
Name three popular web browsers.
DATABASE
When designing a database, the procedure that successively changes a given collection of relations to some more desirable form is called _____
PROGRAMMING
What is the set of written words and symbols that allows the programmer or user to communicate with the computer?
INTERNET
In a(n) _________________ transmission, the Web server begins playing multimedia data before the entire content is completely transferred.
TRIVIA
Who created the first compiler, which was known as A-0?
INTERNET
IETF RFC 2616 specifies the Hypertext Transfer Protocol HTTP/1.1. What does RFC stand for?
PROGRAMMING
Not a computer program, but a step-by-step method of solving a problem that can be developed into a computer program. What is this called?
HARDWARE/SOFTWARE
What is the red, bolded part in the following file path?
d: \Sample\mysample.txt
DATABASE
A pre-set action that will be taken only when certain database event occurs, is called a ______ .
PROGRAMMING
With C++, the rich collection of existing classes and functions are available in ___________.
INTERNET
The item marked 3 in the figure above is the ____ button on the Firefox Navigation toolbar.
PROGRAMMING
What is the boolean operator that returns a value of true only when both of its operands are true?
TRIVIA
A Bluetooth network is one example of a PAN. What does PAN stand for?
INTERNET
The MPEG format’s audio track is called ____ .
HARDWARE/SOFTWARE
The hardware component pointed to by the ? is
?
PROGRAMMING
In OOD, programmers create their own user-defined types called _____.
DATABASE
What is the most commonly used language to manipulate and retrieve data in a relational database?
PROGRAMMING
What does the following code snippet do? for (i=0, j=strlen(s)-1; i<j; i++, j--){ temp = s[i];
s[i] = s[j];s[j] = temp;
}
NETWORKS
The Internet directory service where human-readable computer hostnames are translated into IP addresses is called ____ .
PROGRAMMING
In a computer program, what represents a memory cell whose contents may change or vary as the program executes?
TRIVIA
What is the origin of the word algorithm?
PROGRAMMING
What is the informal language that helps programmers represent an algorithmic solution without having to worry about the strict details of real programming language syntax?
What does LCD stand for?
HARDWARE/SOFTWARE
PROGRAMMING
Java programs are portable across hardware platforms because they are not executed by the OS, they are interpreted by the _________ .
NETWORKS
Software or hardware which interacts with a server, usually over a communications link, is called ______ .
NETWORKS
What is the IEEE standard for wireless LAN?
HARDWARE/SOFTWARE
The file extension .pdf stands for ______.
HARDWARE/SOFTWARE
What is the name of the program which loads the computer operating system?
TRIVIA
What was the name of the first officially incorporated computer company?
DATABASE
To ensure the value of an attribute in a relation R2 matches one of the primary key values of another relation R, you can declare the attribute in R2 as a __________ .
HARDWARE/SOFTWARE
To fix/resolve software errors, what can be downloaded for free from the software company’s website?
The kind of network architecture illustrated by the figure on the right is called ____ .
NETWORKS
DATABASE
The data type of a field/attribute in the relational model is also known as the _________.
NETWORKS
Software or hardware designed to close logical ports to invaders is called ____ .
DATABASE
In a relational database system, _____ and user privileges are used to shield one part of a database table from some users, but still make the other part of the table accessible to all users.
HARDWARE/SOFTWARE
The computer system hardware parts shown below are _________.
NETWORKS
The connection-oriented protocol used in the Internet which provides some guarantees of delivery and ordering of data is called _____ .
TRIVIA
Name the computer designer who adopted the Binary Number System and built the first binary digital computer in the world.
DATABASE
The immunity of applications to changes in storage structure and access technique is referred to as ______ .
NETWORKS
A network entity that satisfies HTTP requests on the behalf of an origin Web Server is called ______.
DATABASE
What type of join selects all the records of one table and just the records with matching values in the joined field from the other table?
HARDWARE/SOFTWARE
The type of portable computers with handwriting recognition and speech recognition capability is called
NETWORKS
A type of LAN that uses IP and is maintained by a private business or organization is called ____ .
NETWORKS
Malicious code that comes disguised as a legitimate program file is called ______.
HARDWARE/SOFTWARE
What is the portable storage that keeps data as tiny pits that are burned into a disk by a high-speed laser? These pits are less than 1 micron in diameter. Data is read off the storage by a laser beam, with the pits and nonpits translating into the 1’s and 0’s.
HARDWARE/SOFTWARE
The small amount of memory located on the CPU chip or near it, that stores recent or frequently used instructions and data for quick access by the CPU is called _____ .
TRIVIA
Electrical pathway used to move data between components is called ____ .
HARDWARE/SOFTWARE
What is the component that manages the switches inside the CPU?
PROGRAMMING
Which of the three basic control structures (not the specific statement) represents the decision making ability of the computer.
HARDWARE/SOFTWARE
What’s the hardware component pointed to by the ? ?
DATABASE
If an index has been created on attribute a of relation R, what kind of search will be used by a RDBMS for the following query?
SELECT a FROM R;
INTERNET
The top level domain name mil usually represents what kind of organization that hosts the web site?
PROGRAMMING
What is the name of the translator program that converts assembly-language programs to machine language?
HARDWARE/SOFTWARE
Name an example of a non-impact printer.
The End!
Hardware and SoftwareIntegration
Event