Computer Science Fundamentals
Chapter Exam Questions
Course Introduction
Computer Science Fundamentals introduces students to the foundational concepts and principles of computer science. This course covers essential topics such as computer systems, algorithms, programming basics, data structures, software development, and the role of computing in society. Emphasis is placed on logical problem-solving, computational thinking, and hands-on programming exercises designed to build proficiency in coding and algorithm design. By the end of the course, students will gain a solid understanding of core computer science topics and be prepared for more advanced study in the field.
Recommended Textbook
Database Principles Fundamentals of Design Implementation and Management international 10th
Available Study Resources on Quizplus
15 Chapters
1320 Verified Questions
1320 Flashcards
Source URL: https://quizplus.com/study-set/1336
Page 2
Chapter 1: The Database Approach
Available Study Resources on Quizplus for this Chatper
70 Verified Questions
70 Flashcards
Source URL: https://quizplus.com/quiz/26651
Sample Questions
Q1) The only way to access the data in a database is through the DBMS.
A)True
B)False
Answer: True
Q2) Historically, a manual file system was composed of a system of file folders and filing cabinets.
A)True
B)False
Answer: True
Q3) A query language is a procedural language.
A)True
B)False
Answer: False
Q4) A(n) ____ database supports a relatively small number of users (usually fewer than 50) or a specific department within an organization.
A) desktop
B) workgroup
C) enterprise
D) transactional
Answer: B
Page 3
To view all questions and flashcards with answers, click on the resource link above.
Chapter 2: Database Development Process
Available Study Resources on Quizplus for this Chatper
100 Verified Questions
100 Flashcards
Source URL: https://quizplus.com/quiz/26652
Sample Questions
Q1) The advent of very sophisticated application generators and ____________________ tools has substantially decreased coding and testing time.
Answer: debugging
Q2) The SDLC is most important to the ____.
A) programmer
B) manager
C) system designer
D) database administrator
Answer: C
Q3) Because every request for structural changes requires retracing the SDLC steps, the system is always at some stage of the SDLC.
A)True
B)False
Answer: True
Q4) Data integrity is enforced by the DBMS through the proper use of primary and foreign key rules.
A)True
B)False
Answer: True
To view all questions and flashcards with answers, click on the resource link above. Page 4
Chapter 3: Data Models
Available Study Resources on Quizplus for this Chatper
70 Verified Questions
70 Flashcards
Source URL: https://quizplus.com/quiz/26653
Sample Questions
Q1) A verb associating two nouns in a business rule translates to a(n) ____ in the data model.
A) entity
B) attribute
C) relationship
D) constraint
Answer: C
Q2) In an SQL-based relational database, rows in different tables are related based on common values in common attributes.
A)True
B)False
Answer: True
Q3) What do business rules require to be effective?
Answer: To be effective, business rules must be easy to understand and widely disseminated to ensure that every person in the organization shares a common interpretation of the rules. Business rules describe, in simple language, the main and distinguishing characteristics of the data as viewed by the company.
Q4) Each column in a relation represents a(n) ____________________. Answer: attribute
To view all questions and flashcards with answers, click on the resource link above. Page 5
Chapter 4: Relational Model Characteristics
Available Study Resources on Quizplus for this Chatper
100 Verified Questions
100 Flashcards
Source URL: https://quizplus.com/quiz/26654
Sample Questions
Q1) The relational database model enables you to view data ____ rather than ____.
A) relationally, hierarchically
B) hierarchically, relationally
C) physically, logically
D) logically, physically
Q2) Proper data ____________________ design requires carefully defined and controlled data redundancies to function properly.
Q3) Any attribute that is part of a key is known as a ____.
A) key attribute
B) logical attribute
C) key determiner
D) selector
Q4) Codd's Rule of ____ states: If the system supports low-level access to the data, users must not be allowed to bypass the integrity rules of the database
A) Nonsubversion
B) Logical Data Independence
C) Comprehensive Data Sublanguage
D) Integrity Independence
Q5) Describe the use of the UNION operator.
To view all questions and flashcards with answers, click on the resource link above. Page 6
Chapter 5: Beginning Structured Query Language Sql
Available Study Resources on Quizplus for this Chatper
100 Verified Questions
100 Flashcards
Source URL: https://quizplus.com/quiz/26655
Sample Questions
Q1) To list the contents of a table, you must use the DISPLAY command.
A)True
B)False
Q2) In Oracle, the ____ command is used to change the display for a column, for example, to place a $ in front of a numeric value.
A) DISPLAY
B) FORMAT
C) CHAR
D) CONVERT
Q3) You cannot insert a row containing a null attribute value using SQL.
A)True
B)False
Q4) A(n) ____________________ character is a symbol that can be used as a general substitute for other characters or commands.
Q5) Data type selection is usually dictated by the nature of the data and by the intended use.
A)True
B)False
Q6) The basic SQL vocabulary has fewer than ____________________ words.
Page 7
To view all questions and flashcards with answers, click on the resource link above.
Chapter 6: Procedural Language Sql and Advanced Sql
Available Study Resources on Quizplus for this Chatper
100 Verified Questions
100 Flashcards
Source URL: https://quizplus.com/quiz/26656
Sample Questions
Q1) When using the Oracle TO_NUMBER function to convert a character string into a number, ____ represents a digit.
A) 0
B) 9
C) $
D) #
Q2) The ____________________ join is the traditional join in which only rows that meet a given criteria are selected.
Q3) A trigger is executed as part of the transaction that triggered it.
A)True
B)False
Q4) The Oracle string concatenation function is ____.
A) CONCAT
B) +
C) ||
D) &&
Q5) Every PL/SQL block must be given a name.
A)True
B)False
Q6) The IN subquery uses a(n) ____________________ operator.
Page 8
To view all questions and flashcards with answers, click on the resource link above.
Chapter 7: Data Modeling With Entity Relationship
Diagrams
Available Study Resources on Quizplus for this Chatper
100 Verified Questions
100 Flashcards
Source URL: https://quizplus.com/quiz/26657
Sample Questions
Q1) A ____ identifier is composed of more than one attribute. A) primary
B) foreign C) composite D) domain
Q2) When the PK of one entity does not contain the PK of a related entity, the relationship is ____.
A) missing
B) weak
C) strong
D) neutral
Q3) ____________________ are characteristics of entities.
Q4) Explain the difference between simple and composite attributes. Provide at least one example of each.
Q5) The Crow's Foot notation depicts the strong relationship with a(n) ____________________ line between the entities.
Q6) When indicating cardinality, the first value represents the ____________________ number of associated entities.
Q7) The Crow's Foot model is more ____________________-oriented than the Chen model. Page 9
To view all questions and flashcards with answers, click on the resource link above.
Page 10
Chapter 8: Data Modeling Advanced Concepts
Available Study Resources on Quizplus for this Chatper
70 Verified Questions
70 Flashcards
Source URL: https://quizplus.com/quiz/26658
Sample Questions
Q1) At the implementation level, the supertype and its subtype(s) depicted in the specialization hierarchy maintain a(n) ____ relationship.
A) self-referencing
B) 1:1
C) 1:M
D) M:N
Q2) Surrogate primary keys are especially helpful when there is no ____ key.
A) primary
B) natural
C) foreign
D) composite
Q3) Explain the "no change over time" characteristic of a good primary key.
Q4) Entity subtypes do not inherit the relationships in which the supertype entity participates.
A)True
B)False
Q5) What do specialization hierarchies do?
Q6) Describe specialization and generalization.
Q7) In what two cases are composite primary keys particularly useful?
Q8) What is an entity cluster?
To view all questions and flashcards with answers, click on the resource link above. Page 11
Chapter 9: Normalizing Database Designs
Available Study Resources on Quizplus for this Chatper
100 Verified Questions
100 Flashcards
Source URL: https://quizplus.com/quiz/26659
Sample Questions
Q1) A ____ derives its name from the fact that a group of multiple entries of the same type can exist for any single key attribute occurrence.
A) partial dependency
B) transitive dependency
C) repeating group
D) primary key
Q2) A table that is in 2NF and contains no transitive dependencies is said to be in ____.
A) 1NF
B) 2NF
C) 3NF
D) 4NF
Q3) 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.
Q4) Normalization purity is easy to sustain in the modern database environment.
A)True
B)False
Q5) A relational table must not contain ____________________ groups.
Q6) What steps are involved in the conversion to third normal form?
To view all questions and flashcards with answers, click on the resource link above. Page 12
Chapter 10: Distributed Databases
Available Study Resources on Quizplus for this Chatper
70 Verified Questions
70 Flashcards
Source URL: https://quizplus.com/quiz/26660
Sample Questions
Q1) Explain the difference between homogeneous and heterogeneous distributed database systems.
Q2) ____ is a disadvantage of a DDBMS.
A) Data is located near the "greatest demand" site
B) Growth facilitation
C) Danger of a single-point failure
D) Lack of standards
Q3) ____ are an advantage of a DDBMS.
A) Reduced operating costs
B) Simplicity of management and control
C) Decreased storage requirements
D) Decreased training costs
Q4) Both distributed processing and distributed databases require a network to connect all components.
A)True
B)False
Q5) A DDBMS must be communications-media-dependent.
A)True
B)False
Q6) Describe performance transparency and heterogeneity transparency.
Page 13
To view all questions and flashcards with answers, click on the resource link above.
Chapter 11: Interacting With Databases Through the Web
Available Study Resources on Quizplus for this Chatper
100 Verified Questions
100 Flashcards
Source URL: https://quizplus.com/quiz/26661
Sample Questions
Q1) The Web browser's job is to ____ the HTML code that it receives from the Web server.
A) analyze
B) interpret
C) transform
D) save
Q2) ______________________________ provides a unified interface to access data from any programming language that uses the underlying OLE-DB objects.
Q3) Usually, the native database connectivity interface provided by the vendor is not the only way to connect to a database; most current DBMS products support other database connectivity standards, the most common being ODBC.
A)True
B)False
Q4) The only time the client and server computers communicate is when the client requests a page -when the user clicks a link- and the server sends the requested page to the client.
A)True
B)False
Q5) What is JavaScript?
To view all questions and flashcards with answers, click on the resource link above. Page 14
Chapter 12: Database Administration and Security
Available Study Resources on Quizplus for this Chatper
100 Verified Questions
100 Flashcards
Source URL: https://quizplus.com/quiz/26662
Sample Questions
Q1) Most of today's successful organizations depend on the ____________________ database to provide support for all of their operations-from design to implementation, from sales to services, and from daily decision making to strategic planning.
Q2) The general coordinator of all DBAs is sometimes known as the ____________________ administrator.
Q3) The DBMS must provide tools that give each level of management a different view of the data and support the required level of decision-making.
A)True
B)False
Q4) The security, privacy, and integrity of the data in the database are of minimal concern to DBAs who manage current DBMS installations. A)True
B)False
Q5) A security ____________________ is a weakness in a system component that could be exploited to allow unauthorized access or cause service disruptions.
Q6) Explain conflict and problem resolution as part of the DBA's end-user support services.
To view all questions and flashcards with answers, click on the resource link above. Page 15
Chapter 13: Managing Transactions and Concurrency
Available Study Resources on Quizplus for this Chatper
70 Verified Questions
70 Flashcards
Source URL: https://quizplus.com/quiz/26663
Sample Questions
Q1) ____ requires that all operations of a transaction be completed.
A) Specificity
B) Atomicity
C) Durability
D) Time stamping
Q2) ANSI defines four events that signal the end of a transaction. Of the following events, which is defined by ANSI as being equivalent to a ROLLBACK?
A) Five SQL statements are executed.
B) The end of a program is successfully reached.
C) The program is abnormally terminated.
D) The database is shut down for maintenance.
Q3) A ____ lock locks the entire table preventing access to any row by a transaction while another transaction is using the table.
A) database-level
B) table-level
C) page-level
D) row-level
Q4) How does a shared/exclusive lock schema increase the lock manager's overhead?
Q5) What are the three basic techniques to control deadlocks?
To view all questions and flashcards with answers, click on the resource link above. Page 16
Chapter 14: Managing Database and Sql Performance
Available Study Resources on Quizplus for this Chatper
70 Verified Questions
70 Flashcards
Source URL: https://quizplus.com/quiz/26664
Sample Questions
Q1) If there is no index, the DBMS will perform a ____ scan.
A) loop
B) range
C) row ID table access
D) full table
Q2) The ____ must be set large enough to permit as many data requests to be serviced from cache as possible.
A) data cache
B) SQL cache
C) sort cache
D) optimizer mode
Q3) The data cache or ____ is a shared, reserved memory area that stores the most recently accessed data blocks in RAM.
A) buffer cache
B) procedure cache
C) SQL cache
D) permanent storage
Q4) The ____________________ analyzes the SQL query and finds the most efficient way to access the data.
Q5) List and describe some typical DBMS processes.
Page 17
To view all questions and flashcards with answers, click on the resource link above.
Chapter 15: Databases for Decision Support
Available Study Resources on Quizplus for this Chatper
100 Verified Questions
100 Flashcards
Source URL: https://quizplus.com/quiz/26665
Sample Questions
Q1) There are 12 rules that define a(n) ____.
A) data warehouse
B) multidimensional cube
C) OLAP tool
D) star schema
Q2) BusinessObjects is a(n) ____ tool.
A) OLAP
B) data visualization
C) data mining
D) data warehouse
Q3) OLAP systems share three main characteristics. What are they?
Q4) ____________________ makes a copy of a table and places it in a different location to improve access time.
Q5) ____'s main goal is to provide a comprehensive and consistent definition of all data within an organization.
A) DBMS
B) OLAP
C) Data warehousing
D) MDM
Q6) What is a data cube?
Page 18
To view all questions and flashcards with answers, click on the resource link above.