Computer Science Capstone Review Questions
Course Introduction
The Computer Science Capstone course is designed to integrate and apply the knowledge and skills students have acquired throughout their undergraduate studies in computer science. Through collaborative or individual projects, students tackle real-world problems, engaging in all phases of project development including research, design, implementation, testing, and presentation. The course emphasizes critical thinking, teamwork, communication, and project management, preparing students for professional careers or advanced study. By the end of the course, students are expected to deliver a comprehensive final product or solution, along with thorough documentation and a formal presentation of their work.
Recommended Textbook
Database Systems Design Implementation and Management 9th Edition by Carlos Coronel
Available Study Resources on Quizplus
15 Chapters
1320 Verified Questions
1320 Flashcards
Source URL: https://quizplus.com/study-set/521 Page 2
Chapter 1: Database Systems
Available Study Resources on Quizplus for this Chatper
70 Verified Questions
70 Flashcards
Source URL: https://quizplus.com/quiz/9760
Sample Questions
Q1) ____________________ exists when different and conflicting versions of the same data appear in different places.
Answer: Data inconsistency
Q2) Accurate,relevant,and timely information is the key to ____.
A) data management
B) good decision making
C) knowledge
D) understanding
Answer: B
Q3) End-user data is ____.
A) raw facts about the end-user
B) raw facts of interest to the end-user
C) data about data
D) accurate,relevant and timely information
Answer: B
Q4) One disadvantage of a database system over previous data management approaches is increased costs.
A)True
B)False
Answer: True
Page 3
To view all questions and flashcards with answers, click on the resource link above.
Chapter 2: Data Models
Available Study Resources on Quizplus for this Chatper
70 Verified Questions
70 Flashcards
Source URL: https://quizplus.com/quiz/9761
Sample Questions
Q1) The relational data model was developed in the ____.
A) 1960s
B) 1970s
C) 1980s
D) 1990s
Answer: B
Q2) What components should an implementation-ready data model contain?
Answer: An implementation-ready data model should contain at least the following components:
A description of the data structure that will store the end-user data.
A set of enforceable rules to guarantee the integrity of the data.
A data manipulation methodology to support the real-world data transformations.
Q3) In the ____ model,each parent can have many children,but each child has only one parent.
A) hierarchical
B) network
C) relational
D) entity relationship
Answer: A
To view all questions and flashcards with answers, click on the resource link above.
Page 4
Chapter 3: The Relational Database Model
Available Study Resources on Quizplus for this Chatper
100 Verified Questions
100 Flashcards
Source URL: https://quizplus.com/quiz/9762
Sample Questions
Q1) The proper use of ____________________ keys is crucial to controlling data redundancy.
Answer: foreign
Q2) Tables must have the same attribute characteristics (the columns and domains must be compatible)to be used in a UNION.
A)True
B)False
Answer: True
Q3) Since it is used to link the tables that originally were related in a M:N relationship,the composite entity structure includes-as foreign keys-at least the ____ keys of the tables that are to be linked.
A) composite
B) super C) primary
D) unique
Answer: C
Q4) ____________________ is the real power behind the relational database,allowing the use of independent tables linked by common attributes. Answer: JOIN
To view all questions and flashcards with answers, click on the resource link above. Page 5
Chapter 4: Entity Relationship (ER)Modeling
Available Study Resources on Quizplus for this Chatper
100 Verified Questions
100 Flashcards
Source URL: https://quizplus.com/quiz/9763
Sample Questions
Q1) A relationship is an association between ____.
A) objects
B) entities
C) databases
D) fields
Q2) All simple attributes are also single-valued.
A)True
B)False
Q3) The term "____" is used to label any condition in which one or more optional relationships exist.
A) participation
B) optionality
C) cardinality
D) connectivity
Q4) In Crow's Foot notation,an optional relationship between entities is shown by drawing a(n)____________________ on the side of the optional entity.
Q5) An ERM is dependent on the database type.
A)True
B)False
To view all questions and flashcards with answers, click on the resource link above. Page 6
Chapter 5: Advanced Data Modeling
Available Study Resources on Quizplus for this Chatper
70 Verified Questions
70 Flashcards
Source URL: https://quizplus.com/quiz/9764
Sample Questions
Q1) An entity cluster is a "virtual" entity type used to represent multiple entities and relationships in the ERD.
A)True
B)False
Q2) Entity supertypes and subtypes are organized in a specialization hierarchy.
A)True
B)False
Q3) In what two cases are composite primary keys particularly useful?
Q4) Overlapping subtypes are subtypes that contain ____ subsets of the supertype entity set.
A) entity
B) subtypes
C) unique
D) nonunique
Q5) To model time-variant data,you must create a new entity in a M:N relationship with the original entity.
A)True
B)False
Q6) Describe specialization and generalization.
To view all questions and flashcards with answers, click on the resource link above. Page 7
Q7) The most common design trap is known as a(n)____________________.
Chapter 6: Normalization of Database Tables
Available Study Resources on Quizplus for this Chatper
100 Verified Questions
100 Flashcards
Source URL: https://quizplus.com/quiz/9765
Sample Questions
Q1) The conflicts between design efficiency,information requirements,and processing speed are often resolved through ____.
A) conversion from 1NF to 2NF
B) conversion from 2NF to 3NF
C) compromises that include denormalization
D) conversion from 3NF to 4NF
Q2) Explain the BCNF.How is it related to other normal forms?
Q3) A table that is in 2NF and contains no transitive dependencies is said to be in ____.
A) 1NF
B) 2NF
C) 3NF
D) 4NF
Q4) A(n)____________________ derives its name from the fact that a group of multiple entries of the same type can exist for any single key attribute occurrence.
Q5) Unnormalized database tables often lead to various data redundancy disasters in production databases.
A)True
B)False
To view all questions and flashcards with answers, click on the resource link above. Page 8
Chapter 7: Introduction to Structured Query Language (SQL)
Available Study Resources on Quizplus for this Chatper
100 Verified Questions
100 Flashcards
Source URL: https://quizplus.com/quiz/9766
Sample Questions
Q1) The COMMIT command does not permanently save all changes.In order to do that,you must use SAVE.
A)True
B)False
Q2) The ANSI prescribes a standard SQL-the current fully approved version is known as SQL-07.
A)True
B)False
Q3) COUNT is designed to tally the number of non-null "values" of an attribute,and is often used in conjunction with the DISTINCT clause.
A)True
B)False
Q4) Any changes made to the contents of a table are not physically saved on disk until you use the SAVE <table name> command.
A)True
B)False
Q5) In a 1:M relationship,you must always create the table for the ____________________ side first.
Q6) ____________________ words are words used by SQL to perform specific functions. Page 9
To view all questions and flashcards with answers, click on the resource link above.
Page 10
Chapter 8: Advanced SQL
Available Study Resources on Quizplus for this Chatper
100 Verified Questions
100 Flashcards
Source URL: https://quizplus.com/quiz/9767
Sample Questions
Q1) The Oracle equivalent to an MS Access AutoNumber is a(n)____.
A) auto-number
B) sequence
C) TO_NUMBER function
D) trigger
Q2) A trigger is procedural SQL code that is automatically invoked by the RDBMS upon the occurrence of a given data manipulation event.
A)True
B)False
Q3) The ____________________ function compares an attribute or expression with a series of values and returns an associated value or a default value if no match is found.
Q4) Cursors are held in a reserved memory area in the client computer.
A)True
B)False
Q5) What are the four different result types that can be returned from a subquery? For each type,explain what it is and when it is used.
Q6) The ____________________ statement combines rows from two or more queries without including duplicate rows.
Page 11
To view all questions and flashcards with answers, click on the resource link above.
Chapter 9: Database Design
Available Study Resources on Quizplus for this Chatper
100 Verified Questions
100 Flashcards
Source URL: https://quizplus.com/quiz/9768
Sample Questions
Q1) The detailed systems design phase includes all the necessary technical specifications for the screens,menus,reports,and other devices used to make the system more efficient.
A)True
B)False
Q2) A system maintenance activity generated in response to changes in the business environment is referred to as corrective maintenance.
A)True
B)False
Q3) Producing the required information flow is part of the ____ phase of the DBLC.
A) database initial study
B) database design
C) operation
D) testing and evaluation
Q4) The traditional SDLC is divided into ____ phases.
A) two
B) three
C) four
D) five
Q5) What are the factors affecting the purchasing decision for DBMS software?
Page 12
To view all questions and flashcards with answers, click on the resource link above.
Chapter 10: Transaction Management and Concurrency Control
Available Study Resources on Quizplus for this Chatper
70 Verified Questions
70 Flashcards
Source URL: https://quizplus.com/quiz/9769
Sample Questions
Q1) To determine the appropriate order of the operations,the scheduler bases its actions on concurrency control algorithms,such as ____________________ or time stamping methods.
Q2) During the ____ phase,a transaction scans the database,executes the needed computations,and makes the updates to a private copy of the database values.
A) read
B) validation
C) write
D) shared
Q3) The transaction recovery write-ahead-log protocol ensures that transaction logs are always written before any database data are actually updated.
A)True
B)False
Q4) When using an optimistic approach,a transaction reads the database,executes the needed computations,and makes the updates to a private copy of the database values.
A)True
B)False
Q5) Explain the transaction log.What is its function?
To view all questions and flashcards with answers, click on the resource link above. Page 13
Chapter 11: Database Performance Tuning and Query
Optimization
Available Study Resources on Quizplus for this Chatper
70 Verified Questions
70 Flashcards
Source URL: https://quizplus.com/quiz/9770
Sample Questions
Q1) Most DBMSs operate in one of two optimization modes: cost-based or rule-based.Others automatically determine the ____ based on whether database statistics are available.
A) data cache
B) SQL cache
C) sort cache
D) optimization mode
Q2) The majority of primary memory resources will be allocated to the ____ cache.
A) data
B) SQL
C) sort
D) optimizer
Q3) All transaction management commands are processed during the parsing and execution phases of query processing.
A)True
B)False
Q4) ____________________ are ordered sets of values that are crucial in speeding up data access.
To view all questions and flashcards with answers, click on the resource link above. Page 14
Q5) The ____________________ analyzes the SQL query and finds the most efficient way to access the data.
Chapter 12: Distributed Database Management Systems
Available Study Resources on Quizplus for this Chatper
70 Verified Questions
70 Flashcards
Source URL: https://quizplus.com/quiz/9771
Sample Questions
Q1) Distributed database systems do not require complex mechanisms to manage transactions and ensure the database's consistency and integrity.
A)True
B)False
Q2) The ____________________ fragment condition indicates that each row is unique,regardless of the fragment in which it is located.
Q3) A transaction processor is the software component residing on each computer that stores and retrieves data located at the site.
A)True
B)False
Q4) What is a disadvantage of client/server applications?
A) There are more people with PC skills than with mainframe skills in the job market.
B) The PC is not well established in the workplace.
C) An increase in the number of users and processing sites often paves the way for security problems.
D) There is a considerable cost disadvantage to offloading applications development from the mainframe to powerful PCs.
To view all questions and flashcards with answers, click on the resource link above.
15
Chapter 13: Business Intelligence and Data Warehouses
Available Study Resources on Quizplus for this Chatper
100 Verified Questions
100 Flashcards
Source URL: https://quizplus.com/quiz/9772
Sample Questions
Q1) ____________________ are qualifying characteristics that provide additional perspectives to a given fact.
Q2) The data ____________________ is a centralized,consolidated database that integrates data derived from the entire organization and from multiple sources with diverse formats.
Q3) Operational data and decision support data serve the same purpose.
A)True
B)False
Q4) To support a(n)____________________ adequately,the DBMS might be required to use advanced hardware,such as multiple disk arrays,and even more importantly,to support multiple-processor technologies,such as a symmetric multiprocessor (SMP)or a massively parallel processor (MPP).
Q5) Periodicity,usually expressed as current year only,previous years,or all years,provides information about the time span of the data stored in the table.
A)True
B)False
Q6) Data ____________________ tools provide advanced visual analysis and techniques to enhance understanding of business data.
To view all questions and flashcards with answers, click on the resource link above. Page 16
Chapter 14: Database Connectivity and Web Technologies
Available Study Resources on Quizplus for this Chatper
100 Verified Questions
100 Flashcards
Source URL: https://quizplus.com/quiz/9773
Sample Questions
Q1) Extensible Hypertext Markup Language (XHTML)is the next generation of ____________________ based on the XML framework.
Q2) What are the components in the basic ODBC architecture?
Q3) Because ____________________ e-commerce integrates business processes among companies,it requires the transfer of business information among different business entities.
Q4) Every XML document has a ____.
A) root element
B) base tag
C) schema
D) DTD
Q5) The XML document reflects a hierarchical ____________________ structure where elements are related in a parent-child relationship; each parent element can have many children elements.
Q6) Which of the following is a well-established Web server API?
A) CGIAPI
B) WSAPI
C) INPAPI
D) MWWAPI
Q7) What are some of the features provided by Web application servers?
To view all questions and flashcards with answers, click on the resource link above. Page 17
Chapter 15: Database Administration and Security
Available Study Resources on Quizplus for this Chatper
100 Verified Questions
100 Flashcards
Source URL: https://quizplus.com/quiz/9774
Sample Questions
Q1) Procedures and standards must be revised at least ____ to keep them up-to-date.
A) weekly
B) monthly
C) every six months
D) annually
Q2) A security ____________________ is a weakness in a system component that could be exploited to allow unauthorized access or cause service disruptions.
Q3) Physical protection of hardware and software must be accomplished by the use of open installations with restricted area access.
A)True
B)False
Q4) Explain user requirements gathering as part of the DBA's end-user support services.
Q5) A(n)________________________________________ provides a framework that includes the use of computerized,automated,and integrated tools such as a DBMS and CASE tools.
Q6) ____________________ focuses on maintaining the data free of inconsistencies and anomalies.
Q7) Describe the DBA's managerial role.
To view all questions and flashcards with answers, click on the resource link above. Page 18