CSCI- 0010
Which of the following are the standard symbols for arithmetic operations in an Excel Spreadsheet
/, *, +, -
Which of the following represents an invalid reference to a cell in a spreadsheet?
15B
If a program is loaded into memory beginning at address 555555, what is the physical address of relative address 333333?
888888
Visual representation of data can be done using which of the following?
? not: Data visualization
What is the third law of robotics?
A robot must protect its own existence.
In Batch Processing, what is a Batch?
A set of jobs that needed the same or similar resources.
Which of the following begins at the root and specifies each step down the tree until it reaches the desired file or directory?
Absolute path
A mapping from a logical...
Address Binding (Memory Management)
Wrote a paper entitled "Can Machines Think?"
Alan Turing
Which of the follow is a built in Function in Excel Spreadsheet
All of the answers
Programs that help us solve real world problems
Application Software
Attempts to mimic the actions of the neural networks of the human body
Artificial Neural Network
Where can you find the Root Directory?
At the highest level of the Directory Tree
What type of file will have a file extention of wav or mp4
Audio File
Which of the following best describes a partitioning approach that uses the base register to store the beginning address of the current partition
Both dynamic and Fixed partitions
Searching across levels of a tree prior to searching down specific paths
Breadth-First Approach
Using letters to specify the column and numbers to specify the row
Cell Reference
A reference that can never be resolved because the result of one formula is ultimately based on the other, and vise versa
Circular Reference
These can never be resolved in a Excel Spreadsheet and should be avoided.
Circular Reference
Which of the following describes the act of storing register values for the currently executing process and loading the register values for the process taking over the CPU?
Context Switch
Magnetic disks are organized as a stack of platters, and each platter is divided into tracks and sectors. What are the corresponding tracks on all platters called?
Cylinder? (not sector)
What is the original PC operating system called?
DOS
What tool did President Obama use to help secure his re-election to a second term?
Data Mining
A structured set of data
Database
Software and data made up of the physical database, the database engine, and the database schema
Database Management System (DBMS)
Searching down the paths of the tree prior to searching across levels
Depth-First Approach
In an Operating System, what is the function of CPU scheduling
Determines which process in memory is given access to the CPU
Which of the following is conceptually divided into logical records?
Direct access file
The act of deciding which outstanding requests for disk 1/0 to satisfy first
Disk Scheduling
Where partitions are...
Dynamic partition technique
What are two of the most popular general application information systems?
Electronic Spreadsheets and e-Commerce
Which of the following is a popular technique for designing relational databases?
Entity-relationship modeling
A software system based on human experts
Expert System
Which is a software system based on the knowledge of human experts?
Expert System
A computer has never beaten a human at chess in master-level play.
False
A file's extension dictates what type of data it contains.
False
A high effective weight simulates an inhibited biological neuron.
False
A logical address specifies an actual location in main memory.
False
A relative path is relative to the root of the directory hierarchy.
False
A spreadsheet cell can contain data, but not a formula.
False
A spreadsheet function is a program that the user writes to compute a value.
False
A spreadsheet is organized into a grid of labeled tables.
False
A spreadsheet is unable to perform complex what-if analysis.
False
An absolute path and a relative path will always be the same length
False
An operating system uses nonpreemptive CPU scheduling when a process moves from the waiting state to the ready state.
False
CPU scheduling determines which programs are in memory.
False
If information is stored in a semantic network, it is easy to answer questions about it.
False
Sequential access and direct access take about the same amount of time to retrieve data.
False
The bounds register contains the last address of a partition.
False
The current file pointer indicates the end of a file.
False
The first-come, first-served disk-scheduling algorithm moves the heads the minimum amount it can to satisfy a pending request.
False
The first-come, first-served scheduling algorithm is provably optimal.
False
The working directory is the directory into which all temporary files are stored.
False
Voice synthesis is the most difficult part of natural language processing.
False
What-if analysis can only affect one value at a time in a spreadsheet.
False
Which of the following is the last part of the file name that gives an indication of what kind of data the file contains?
File Extention
Which of the following is the logical view provided by the operating system to help users manage secondary memory?
File system
Which statement(s) about files is/are TRUE?
Filenames have two parts, the file name and file extension
Processes requests in the order they arrive, without regard to the current position of the heads.
First Come, First Served (FCFS) Disk Scheduling
Which of the following is a CPU scheduling algorithm that allocates processes to the CPU in the order in which they arrive?
First-come, first-served
Where the main memory is...
Fixed Partition technique
Wrote papers on the simulation of human thinking, problem solving, and verbal learning, marked the beginning of the field of artificial intelligence
Herbert A. Simon
The software that processes rules to draw conclusions
Inference Engine
Which of the following uniquely identifies a particular record within a database table?
Key
System software that embodies a specific set of information, extracting and processing particular pieces
Knowledge-Based System
Which is a software system that embodies and uses a specific set of information, extracting and processing particular pieces.
Knowledge-Based System
A popular AI programming language
LISP
The additional time it takes the platter to rotate into the proper position so that the data can be read.
Latency
Which of the following describes the additional time it takes the platter to rotate into the proper position so that the data can be read?
Latency
What type of ambiguity does the following statement suffer from? "I saw bats outside."
Lexical
Which of the following can occur when words have multiple meanings?
Lexical ambiguity
Who organized the first formal instantiation of the Turing test?
Loebner
A reference to a stored...
Logical Address (Memory Management)
What type file uses a doc or docx file extension?
MS Word
Apple Computer Operating System
MacOS
Originally, timesharing systems were usually a single computer called what?
Mainframe
Which is the operating system for Apple Computers?
MasOS
Which of the following describes a language, like English, that humans use to communicate with each other?
Natural language
Which of the following is the area of study dealing with a computer's ability to interpret and respond to human speech?
Natural language processing
The Loebner Prize Grand Prize of $100,000 and a solid gold medal for the first computer whose responses are indistinguishable from a human's has been awarded how many times so far?
Never
When a process is being created
New State
What error can you see in the following Directory Path? "C:\Program Files\MSOffice\WinWord.exe"
None of the answers
Which is not a valid Cardinality Constraint?
One-to-None
Programs that manage computer resources and provide an interface for other programs
Operating System
Programs that manage computer resources and provide an interface for other programs.
Operating System
A memory management technique in which processes are divided into fixed-size pages and stored in memory frames when loaded.
Paged Memory Technique
An actual address in the...
Physical Address (Memory Management)
What type file uses a ppt or pptx file extension?
Powerpoint
In an Operating System, what is a program in execution called?
Process
The specific states a process moves through
Process State
A request to retrieve data from a database
Query
Which of the following is used to specify a set of adjacent elements in a spreadsheet?
Range
can specify an area of a column, row, or a rectangular block of cells
Range
To which state does the currently executing process return when it is interrupted by the operating system?
Ready
Not waiting for an event to occur or data to be brought in
Ready State
Which of the following database elements is composed of a set of related data items, such as a person's name, address, and ID number?
Record
Which of the following can occur with the use of pronouns?
Referential ambiguity
Where data and the relationships among them are organized into tables
Relational Model
Which of the following is the topmost directory, in which all others are contained?
Root directory
Which of the following describes a CPU scheduling algorithm in which each process is given a small amount of time to use the CPU before being forced to wait until its turn comes around again?
Round robin
A software system based on a set of if-then rules
Rule-Based System
Which is a software system based on a set of if-then rules?
Rule-Based System
In which state is a process that is currently being executed by the CPU?
Running
Currently being executed
Running State
where the read/write heads move in towards the spindle, then out toward the platter edge.
SCAN Disk Scheduling
Which of the following is not a valid Spreadsheet function?
SIGN(angle)
Which of the following statements about SQL is true?
SQL keywords, table names and attributes are not case sensitive
A logical view of data is provided by which of the following?
Schema
A specification of the logical structure of data in a database
Schema
A structure that represents alternatives in adversarial situations, such as playing games
Search Tree
Which of the following represents all possible moves of a game?
Search tree
The amount of time it takes for the heads to reach the appropriate cylinder.
Seek Time
A knowledge representation technique that represents the relationship among objects
Semantic Network
Which of the following is a knowledge representation technique that represents the relationships among objects?
Semantic network
moves the heads by the minimum amount necessary to satisfy any pending request.
Shortest-Seek-Time-First (SSTF) Disk Scheduling
Which of the following is a disk-scheduling algorithm that moves disks heads by the minimum amount necessary to satisfy any pending request?
Shortest-seek-time-first
Who wrote papers on the simulation of human thinking, problem solving, and verbal learning that marked the beginning of the field of artificial intelligence.
Simon
How long have Spreadsheets and database management systems been around?
Since the 1970s
Where an entire application...
Single contiguous Memory Management
A program that allows the user to organize and analyze data using a grid of cells
Spreadsheet
An element of a spreadsheet that can contain data or a formula
Spreadsheet Cell
Built into the software and often operate on a set of contiguous cells
Spreadsheet Functions
Which refers to the equality of two systems based on their results and the process by which they arrive at those results?
Strong equivalence
What type of ambiguity does the following statement suffer from? "Call me a cab."
Syntactic
Which of the following can occur when sentences can be constructed in various ways?
Syntactic ambiguity
Programs that manage a computer system and interact with hardware
System Software
A collection of database records
Table
Completed its execution
Terminated State
The .txt file extension is generally used for which of the following?
Text data file
What is the key difference between the E. U. Directive and the CAN-SPAM Act?
The CAN-SPAM allows direct marketing until you Opt-Out
What error can you see in the following Directory Path? "C:\Program Files\MSOffice\WinWord.ex"
The file name is incorrect
Which of the following is NOT true about the Key Field of a record?
There may be only one
Which of the following is the amount of time given to each process in a round-robin CPU scheduling algorithm?
Time slice
Splitting CPU time between multiple users.
Timesharing
Magnetic disk drives are divided, from largest to smallest, by:
Track, Sector, Block
A computer system that can pass the Turing test is considered to be intelligent.
True
A database engine is software that supports access to the database contents.
True
A database engine often interacts with a particular language for accessing and modifying the database.
True
A dumb terminal is an I/0 device that connects to a mainframe computer.
True
A human being does some tasks much better than a computer.
True
A low effective weight simulates an inhibited biological neuron.
True
A program written in a high-level language is stored in a text file that is also called a source file.
True
A query is a request to a database for information.
True
A robot may follow the sense-plan-act approach to control its movements.
True
A semantic network is a representation of the relationships among objects.
True
A spreadsheet cell can contain a data value or a formula.
True
A spreadsheet is useful for performing what-if analysis.
True
An address in a single contiguous memory management system is made up of a page and an offset.
True
An expert system is software based on the knowledge of human experts in a particular domain.
True
An inference engine is part of a rule-based expert system.
True
An operating system is responsible for managing access to the disk drive
True
Application software is written to solve problems in the real world
True
At any point in time, a user is "in" the current working directory within the file system.
True
Batch Processing is still used today to process large jobs.
True
Computers can perform arithmetic calculations quickly and easily.
True
E-commerce provides the consumer with several advantages over in-store shopping.
True
Each element in an artificial neural net is affected by a numeric weight.
True
First-come, first-served disk scheduling is relatively easy to implement, but is not the most efficient approach.
True
Herbert A. Simon, one of the earliest pioneers in artificial intelligence, was a "renaissance man" with interests in computer science, psychology, and philosophy; a Ph.D. in political science; a Nobel Prize in economics; and a Turing Award.
True
In a relational database, a table can represent a collection of relationships among objects.
True
In preemptive CPU scheduling, a process may be forced to wait even though all its necessary resources are available.
True
In single contiguous memory management, an entire application program is loaded into one chunk of memory.
True
In the 1960s and 1970s, a human operator would organize similar computer jobs into batches to be run.
True
Isaac Asimov created three fundamental laws of robotics.
True
Multiprogramming is the technique of using multiple CPUs to run programs.
True
Natural languages are those that humans use to communicate, such as English or Arabic.
True
Response Time is the delay between receiving a stimulus and producing a response.
True
Sequal, an early database language, was developed by IBM.
True
Spreadsheets are particularly helpful when performing what-if analysis.
True
The "\" is used to separate the names in a path in a Windows environment.
True
The SCAN disk-scheduling algorithm is similar to the algorithm used to manage elevators.
True
The dot-com collapse promoted electronic commerce.
True
The engine of a database management system (DBMS) consists of the software that allows the user to access and modify the database contents.
True
The human brain contains billions of neurons connected into a network.
True
The process life cycle describes the conceptual states through which a process moves as it is managed by the operating system
True
The relational database model organizes data and relationships into tables.
True
The results of a query can be structured in many ways.
True
The seek time is the amount of time it takes for the heads of a disk to reach a particular cylinder.
True
The type of a file determines which kinds of operations can be performed on it.
True
The values in a spreadsheet can be formatted in a variety of ways.
True
Two files in a directory system can have the same name if they are in different directories.
True
UNIX file permissions allow a group of users to access a file in various ways.
True
Who asked the question "Can machines think"?
Turing
In CPU Scheduling, this is a metric that measures the elapsed time between a process's arrival in the ready state and its ultimate completion.
Turnaround Time
Historically, which is the operating system of choice for serious programmers?
Unix
The operating system of choice for serious programmers
Unix
Which SQL statement modifies a database value(s) in one or more records?
Update
Waiting for resources
Waiting State
Which of the following describes the equality of two systems based solely on their results?
Weak equivalence
Which of the following represents the type of analysis that spreadsheets are particularly good at performing?
What-if
Most widely used operating system on PCs
Windows
All of the following were important aspects contributing to the success of e-commerce, except:
traditional "bricks and mortar" businesses declining to develop a competitive online presence.
In memory management, address binding is the mapping from a logical address to a physical address
true
