CS 11 Final Exam Flashcards
99 Questions
100 Views

CS 11 Final Exam Flashcards

Created by
@JubilantUvarovite

Questions and Answers

What is a web site?

  • A type of database
  • A single web page
  • A collection of related web pages usually belonging to an organization or individual (correct)
  • An internet address
  • What does URL stand for?

    Uniform Resource Locator

    What is a computer?

    A programmable, electronic device that accepts data input, performs processing operations on that data, and outputs and stores the results.

    What is a tablet computer?

    <p>A portable computer about the size of a notebook that is designed to be used with a digital pen, a digital stylus, or touch input.</p> Signup and view all the answers

    What does processing refer to in computer science?

    <p>Performing operations on data that has been input into a computer to convert that input to output.</p> Signup and view all the answers

    What is data storage?

    <p>The operation of saving data, programs, or output for future use.</p> Signup and view all the answers

    What is a supercomputer?

    <p>The fastest, most powerful computer and the most expensive.</p> Signup and view all the answers

    What is software?

    <p>Instructions that tell the computer what to do.</p> Signup and view all the answers

    What is hardware?

    <p>The physical parts of a computer like the mouse, keyboard, monitor, and printer.</p> Signup and view all the answers

    What is the internet?

    <p>The largest network used as a communication tool.</p> Signup and view all the answers

    In a relational database, more than 1 table can be included in the database.

    <p>True</p> Signup and view all the answers

    Normalization is used to minimize data redundancy.

    <p>True</p> Signup and view all the answers

    Using usernames and passwords is a data validation technique.

    <p>False</p> Signup and view all the answers

    A database that stores all data in memory instead of hard drive is called a cloud database.

    <p>False</p> Signup and view all the answers

    Dynamic web pages commonly use databases.

    <p>True</p> Signup and view all the answers

    In a student database, NAME would be considered _______ in the table while all of Jennifer Mitchel's info would be a ________.

    <p>field or column; record or row</p> Signup and view all the answers

    What does data integrity refer to?

    <p>The accuracy of the table.</p> Signup and view all the answers

    When _______ organization is used, a hashing procedure determines where data is stored.

    <p>direct</p> Signup and view all the answers

    The terms front end and back end refer to ________ data base entry.

    <p>client-server</p> Signup and view all the answers

    What is data integrity?

    <p>When an organization has inconsistent duplicated data and doesn't allow the user to enter the number in the phone number field in a database.</p> Signup and view all the answers

    What is data security?

    <p>Requiring user to log into a database system via fingerprint reader.</p> Signup and view all the answers

    What is data definition?

    <p>Assigning a field the property of 'required'.</p> Signup and view all the answers

    What is a database?

    <p>A collection of related data that is stored in a manner enabling information to be retrieved as needed.</p> Signup and view all the answers

    What is a record in a database?

    <p>A collection of related fields, also called a row.</p> Signup and view all the answers

    What is a query?

    <p>A request to see information from a database that matches specific criteria.</p> Signup and view all the answers

    What is an index in a database?

    <p>A small table containing a primary key and the location of the record belonging to that key.</p> Signup and view all the answers

    What is a primary key?

    <p>A specific field in a database table that uniquely identifies the records in that table.</p> Signup and view all the answers

    What is a relational database management system?

    <p>A type of database system in which data is stored in tables related by common fields, the most widely used database model today.</p> Signup and view all the answers

    What is a table in a relational database?

    <p>A collection of related records (rows).</p> Signup and view all the answers

    What is middleware?

    <p>Software used to connect to otherwise separate applications such as a web server and database management system.</p> Signup and view all the answers

    What is a data validation?

    <p>The process of ensuring that data entered into a database matches the data definition.</p> Signup and view all the answers

    What is a data dictionary?

    <p>The repository of all data definitions in a database.</p> Signup and view all the answers

    What is source code?

    <p>A computer program before it is compiled.</p> Signup and view all the answers

    What is a compiler?

    <p>A language translator that converts an entire program into machine language before executing it.</p> Signup and view all the answers

    What is object-oriented programming (OOP)?

    <p>An approach to program design in which a program consists of objects that contain data (attributes) and processors (methods) to be used with those objects.</p> Signup and view all the answers

    What is a software development kit (SDK)?

    <p>A programming package designed for a particular platform that enables programmers to develop applications for that platform quickly and easily.</p> Signup and view all the answers

    What is a markup language?

    <p>A type of language that uses symbols or tags to describe what a document should look like.</p> Signup and view all the answers

    What is a syntax error?

    <p>A programming error that occurs when the programmer has not followed the rules of the programming language.</p> Signup and view all the answers

    What is a flow chart?

    <p>A program design tool that graphically shows step-by-step how a computer program will process data.</p> Signup and view all the answers

    What is object code?

    <p>The machine language version of a computer program generated when the program source code is compiled.</p> Signup and view all the answers

    What is debugging?

    <p>The process of ensuring a program is free of errors.</p> Signup and view all the answers

    What is coding?

    <p>The process of writing the programming language statements to create a computer program.</p> Signup and view all the answers

    What is HTML5?

    <p>A markup language used to create web pages and web applications.</p> Signup and view all the answers

    What is Java?

    <p>A high-level programming language used to write web applications and applets.</p> Signup and view all the answers

    What is assembly language?

    <p>A low-level programming language.</p> Signup and view all the answers

    A systems analyst is an individual who writes the codes for a computer program.

    <p>False</p> Signup and view all the answers

    The terms class and inheritance are associated with the object-oriented programming approach.

    <p>True</p> Signup and view all the answers

    With a do-while structure, the program statement in the loop are always executed at least once.

    <p>True</p> Signup and view all the answers

    Basic is an example of an object-oriented programming language.

    <p>False</p> Signup and view all the answers

    A wireframe is another name for a flow chart.

    <p>False</p> Signup and view all the answers

    A _______ (called an attribute in OOP) in a computer program holds the current value of a data item in that program.

    <p>variable</p> Signup and view all the answers

    A _______ converts the source code of an application program into executable object code (machine language) one line at a time.

    <p>interpreter</p> Signup and view all the answers

    Using an incorrect formula is an example of a ________ error.

    <p>logic</p> Signup and view all the answers

    _________ software development is an approach that uses short development cycles in order to produce small functional pieces of a program on an ongoing basis.

    <p>agile</p> Signup and view all the answers

    List the phases in the program development life cycle (PDLC).

    <p>Problem analysis, Program design, Program coding, Program debugging and testing, Program implementation and maintenance.</p> Signup and view all the answers

    What is a data warehouse?

    <p>A comprehensive collection of data about a company and its customers.</p> Signup and view all the answers

    What is a robot?

    <p>A device controlled by a human operator or a computer that can move and react to sensory input.</p> Signup and view all the answers

    What is computer-aided design (CAD)?

    <p>A general term applied to the use of computer technology to automate design functions.</p> Signup and view all the answers

    What is neural network?

    <p>An expert system in which the human brain's pattern recognition process is emulated by the computer system.</p> Signup and view all the answers

    What is a geographic information system (GIS)?

    <p>An information system that combines geographic information with other types of data to provide better understanding.</p> Signup and view all the answers

    What is a systems analyst?

    <p>A person who studies systems in an organization to determine what work needs to be done.</p> Signup and view all the answers

    What is a transaction processing system (TPS)?

    <p>A type of information system that processes and records data created by an organization's business transactions.</p> Signup and view all the answers

    What is a management information system (MIS)?

    <p>A type of information system that provides decision-makers with pre-selected information for middle management decisions.</p> Signup and view all the answers

    What is the system development life cycle (SDLC)?

    <p>The process consisting of the six phases of system development.</p> Signup and view all the answers

    What is business analytics (BA)?

    <p>The process of analyzing data to evaluate a company's operations.</p> Signup and view all the answers

    Executive managers tend to make highly unstructured decisions.

    <p>True</p> Signup and view all the answers

    A decision support system would most likely be used by a non-management worker.

    <p>False</p> Signup and view all the answers

    An expert system is an example of an office system.

    <p>False</p> Signup and view all the answers

    Assigning business tasks to an external company is referred to as outsourcing.

    <p>True</p> Signup and view all the answers

    Users are only involved in the system development life cycle if the end-user approach is being used.

    <p>False</p> Signup and view all the answers

    The software program used in an expert system in conjunction with the knowledge base to reach decisions is called the _________.

    <p>inference engine</p> Signup and view all the answers

    A _______ is the computer professional who is most involved in the system development process.

    <p>systems analyst</p> Signup and view all the answers

    What is a forum?

    <p>To post a question about a product that you hope other individuals will answer.</p> Signup and view all the answers

    What is a computer network?

    <p>A collection of computers and other hardware devices that are connected together to share hardware, software, and data.</p> Signup and view all the answers

    What is an antenna?

    <p>A device used for receiving or sending radio signals.</p> Signup and view all the answers

    What is a switch?

    <p>The device used to connect multiple devices on a single network.</p> Signup and view all the answers

    What is Bluetooth?

    <p>A networking standard for very short-range wireless connections.</p> Signup and view all the answers

    What is a mesh network?

    <p>A networking layout in which there are multiple connections between devices.</p> Signup and view all the answers

    What is wireless HD (WiHD)?

    <p>A wireless networking standard designed for very fast transfers between home electronic devices.</p> Signup and view all the answers

    What is TCP/IP?

    <p>A networking protocol that uses packet switching to facilitate the transmission of messages.</p> Signup and view all the answers

    What is a global positioning system (GPS)?

    <p>A system that uses satellites and the receiver to determine the exact geographical location of the receiver.</p> Signup and view all the answers

    What is a digital signal?

    <p>A type of signal where the data is represented by 0s and 1s.</p> Signup and view all the answers

    What is Ethernet?

    <p>The most widely used wired LAN network standard.</p> Signup and view all the answers

    GPS systems are used only by the government.

    <p>False</p> Signup and view all the answers

    With serial transmissions, each bit of data is sent individually.

    <p>True</p> Signup and view all the answers

    The internet is an example of a LAN.

    <p>False</p> Signup and view all the answers

    The type of cable used inside most homes for telephone service is twisted pair wire.

    <p>True</p> Signup and view all the answers

    A router is a type of modem.

    <p>False</p> Signup and view all the answers

    With a _________________ network topology, all devices are connected in a line to a central cable.

    <p>bus</p> Signup and view all the answers

    A __________ phone can be used with more than one communication network, such as both cellular and Wi-Fi.

    <p>dual mode</p> Signup and view all the answers

    A small network designed to connect personal devices for an individual (such as via Bluetooth) is called a __________.

    <p>personal area network or PAN</p> Signup and view all the answers

    A __________ is a network that transfers private information securely over the Internet or other public networks.

    <p>virtual private network or VPN</p> Signup and view all the answers

    Benefits that are easy to quantify in dollars are called __________.

    <p>tangible</p> Signup and view all the answers

    A __________ is a model of a system that is built during systems development.

    <p>prototype</p> Signup and view all the answers

    What is business intelligence (BI)?

    <p>A process of gathering, storing, assessing, and analyzing data in order to make better business decisions.</p> Signup and view all the answers

    What is a decision support system (DSS)?

    <p>Used to provide upper managers with the information they need to make decisions.</p> Signup and view all the answers

    What are document management systems (DMSs)?

    <p>Used to store, organize, and retrieve electronic documents.</p> Signup and view all the answers

    What is a firewall?

    <p>The collection of hardware and/or software intended to protect a computer or network from unauthorized access.</p> Signup and view all the answers

    What is a dot-com?

    <p>A fraud or scam carried out through the internet.</p> Signup and view all the answers

    Study Notes

    Web Development and Network Basics

    • A web site is a collection of related web pages, typically associated with an organization or individual.
    • A Uniform Resource Locator (URL) is the internet address identifying a webpage, beginning with http:// or https://.
    • The internet is the largest network, serving as a key communication tool.

    Computer Types and Functions

    • A computer is a programmable device that processes input data and produces output results.
    • A tablet computer is a portable device designed for touch input or digital pen interaction.
    • A supercomputer is the most powerful and fastest type of computer, often the most expensive.

    Data Operations and Management

    • Processing involves operations performed on input data to generate output.
    • Storage refers to saving data and programs for future use.
    • Normalization minimizes data redundancy in databases, ensuring efficient data organization.

    Database Fundamentals

    • A database consists of related data stored to allow information retrieval.
    • Fields (or columns) represent specific data categories, while records (or rows) hold related information.
    • A primary key uniquely identifies records within a database table, essential for data integrity.

    Programming Concepts

    • Software consists of instructions that guide computer operations, while hardware refers to physical components like monitors and keyboards.
    • Debugging involves correcting errors in a program, whereas coding is the action of writing program code.
    • Object-oriented programming (OOP) organizes data and methods into objects, enhancing code reusability and structure.

    Networking Technologies

    • A computer network connects devices for shared resources and communication.
    • Bluetooth facilitates short-range wireless connections between devices.
    • A mesh network allows for multiple paths between devices, enhancing connectivity and reliability.

    Security and Data Integrity

    • Data integrity ensures accuracy within a database, preventing inconsistent or duplicated data.
    • Data security uses authentication methods, like fingerprint logins, to protect database access.
    • A firewall serves as a barrier to protect networks from unauthorized access.

    Data Analysis and Business Intelligence

    • Business analytics (BA) evaluates company operations through data analysis.
    • Decision support systems (DSS) provide upper management with vital information for decision-making.
    • Business intelligence (BI) involves gathering and analyzing data to improve business strategies.

    Development Methodologies

    • Agile software development employs iterative cycles for delivering functional software components rapidly.
    • The system development life cycle (SDLC) outlines phases from preliminary investigation to system maintenance, ensuring structured development.

    Technological Tools and Languages

    • HTML5 is a markup language for creating web pages and applications, while Python is a high-level language suitable for various applications.
    • An interpreter translates source code into machine language line-by-line, allowing for immediate execution.

    Miscellaneous Concepts

    • A data warehouse stores comprehensive datasets about a company and its clientele.
    • A virtual private network (VPN) ensures secure information transfer over public networks.
    • Tangible benefits are quantifiable advantages in dollar terms, while prototypes model systems during their development.

    Studying That Suits You

    Use AI to generate personalized quizzes and flashcards to suit your learning preferences.

    Quiz Team

    Description

    Prepare for your CS 11 final exam with these flashcards that cover essential computer science terms. Each card provides a clear definition to help reinforce your understanding of key concepts like web sites and URLs.

    More Quizzes Like This

    Use Quizgecko on...
    Browser
    Browser