Introduction to Computer Science
Exam Answer Key
Course Introduction
Introduction to Computer Science provides a broad overview of the fundamental concepts and principles underlying the field of computing. Topics include the history and evolution of computers, the basics of hardware and software, algorithms, programming languages, data structures, operating systems, databases, and networks. Students will gain hands-on experience with problem-solving techniques, logic, and basic programming skills, establishing a strong foundation for further study in computer science and related disciplines. The course also introduces ethical, societal, and professional issues in computing.
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) A ____ is a character or group of characters that has a specific meaning.
A) database
B) field
C) record
D) file
Answer: B
Q2) ____ is a set of tools that work together to provide an advanced data analysis environment for retrieving, processing, and modeling data from the data warehouse.
A) Online analytical processing
B) Semistructured processing
C) Enterprise processing
D) XML processing
Answer: A
Q3) One disadvantage of the DBMS is that it increases the risk of data security breaches.
A)True
B)False
Answer: False
To view all questions and flashcards with answers, click on the resource link above.
Page 3
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 last step in the DBLC is ____.
A) maintenance and evolution
B) operation
C) testing and evaluation
D) implementation and loading
Answer: A
Q2) ____ allow(s) physical access to areas by authorized personnel only.
A) Physical security
B) Password security
C) Access rights
D) Data encryption
Answer: A
Q3) The traditional SDLC phases are ____________________, analysis, detailed systems design, implementation, and maintenance.
Answer: planning
Q4) The SDLC's planning phase yields a general overview of the company and its objectives.
A)True
B)False
Answer: True
Page 4
To view all questions and flashcards with answers, click on the resource link above.
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) In the ____ model, the user perceives the database as a collection of records in 1:M relationships, where each record can have more than one parent.
A) hierarchical
B) network
C) object-oriented
D) entity relationship
Answer: B
Q2) A(n) ____'s main function is to help you understand the complexities of the real-world environment.
A) constraint
B) entity
C) model
D) database
Answer: C
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.
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) A(n) ____________________ index is an index in which the index key can have only one pointer value (row) associated with it.
Q2) A(n) ____________________ key can be described as a superkey without unnecessary attributes.
Q3) The proper use of ____________________ keys is crucial to controlling data redundancy.
Q4) To be considered minimally relational, the DBMS must support the key relational operators ____, PROJECT, and JOIN.
A) INTERSECT
B) UNION
C) DIFFERENCE
D) SELECT
Q5) Only a single attribute, not multiple attributes, can define functional dependence.
A)True
B)False
Q6) What is the system catalog?
Q7) ____________________ is the real power behind the relational database, allowing the use of independent tables linked by common attributes.
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) SQL requires the use of the ADD command to enter data into a table.
A)True
B)False
Q2) A(n) ____________________ is a logical group of database objects, such as tables and indexes, that are related to each other.
Q3) In a 1:M relationship, you must always create the table for the ____________________ side first.
Q4) With the exception of the database ____________________ process, most RDBMS vendors use SQL that deviates little from the ANSI standard SQL.
Q5) A common practice is to create a(n) ____________________ on any field that is used as a search key, in comparison operations in a conditional expression, or when you want to list rows in a specific order.
Q6) To list the contents of a table, you must use the DISPLAY command.
A)True B)False
Q7) Most SQL implementations yield case-insensitive searches.
A)True B)False
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) Just like database triggers, stored procedures are stored in the database.
A)True
B)False
Q2) When using a subquery, the output of a(n) ____________________ query is used as the input for the outer query.
Q3) Oracle recommends ____ for creating audit logs.
A) triggers
B) stored procedures
C) stored functions
D) tables
Q4) Each statement inside the PL/SQL code must end with a period (".").
A)True
B)False
Q5) One of the major advantages of stored procedures is that they can be used to encapsulate and represent business transactions.
A)True
B)False
Q6) Stored procedures are executed using the EXEC command.
A)True
B)False
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) An ERM is dependent on the database type.
A)True
B)False
Q2) The Crow's Foot model is less implementation-oriented than the Chen model.
A)True
B)False
Q3) A relationship is an association between ____.
A) objects
B) entities
C) databases
D) fields
Q4) Attributes may share a ____.
A) name
B) domain
C) location
D) table
Q5) The ER diagram represents the conceptual database as viewed by the end user.
A)True
B)False
Page 9
Q6) ____________________ are underlined in an ER diagram.
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) One important inheritance characteristic is that all entity subtypes inherit their primary key attribute from their supertype.
A)True
B)False
Q2) Disjoint subtypes are subtypes that contain nonunique subsets of the supertype entity set.
A)True
B)False
Q3) An entity supertype can have disjoint or overlapping entity subtypes.
A)True
B)False
Q4) Overlapping subtypes are subtypes that contain a unique subset of the supertype entity set.
A)True
B)False
Q5) From a data modeling point of view, ____________________ data refer to data whose values change over time and for which you must keep a history of the data changes.
Q6) Describe specialization and generalization.
Q7) In what two cases are composite primary keys particularly useful?
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) According to naming conventions described in Chapter 2, ____ would be the best name for a column representing the charges per hour in a table named JOB.
A) JOB_CHG_HOUR
B) CHARGES_PER_HOUR_FOR_JOB
C) CHARGES_PER_HOUR
D) CHG_HR
Q2) In a real-world environment, we must strike a balance between design integrity and ____.
A) robustness
B) flexibility
C) uniqueness
D) ease of use
Q3) Granularity refers to ____.
A) the size of a table
B) the level of detail represented by the values stored in a table's row
C) the number of attributes in a table
D) the number of rows in a table
Q4) In order to meet ____________________ requirements, you may have to denormalize some portion of the database.
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) A DBMS must have validation, transformation, and mapping functions, as well as other functions, in order to be classified as distributed.
A)True
B)False
Q2) ____ is a disadvantage of a DDBMS.
A) Processor independence
B) The graphical user interface
C) Security
D) Data access that is too rapid
Q3) ____ fragmentation allows you to break a single object into two or more segments or fragments.
A) Horizontal
B) Vertical
C) Data
D) Mixed
Q4) One of the advantages of a DDBMS is processor ____________________.
Q5) A transaction processor is also known as the ____________________ processor.
Q6) What is transaction transparency? What are some of the basic concepts that you should know to understand how transactions are managed in a DDBMS?
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) Every XML document has a ____.
A) root element
B) base tag
C) schema
D) DTD
Q2) There are currently ____ well-defined Web-server interfaces.
A) one
B) two
C) five
D) ten
Q3) A Web ____________________ server is a middleware application that expands the functionality of Web servers by linking them to a wide range of services.
Q4) What is a feature of a Web application server?
A) It is Microsoft's implementation of a superset of the SQL Access Group CLI standard for database access.
B) It is automatically invoked by the browser when needed.
C) It runs on the client machine, freeing server resources.
D) It provides an integrated development environment with session management and support for persistent application variables.
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) Disaster management includes all the end-user activities designed to secure data availability following a physical disaster or a database integrity failure.
A)True
B)False
Q2) There is a growing trend toward ____ in the data-management function.
A) cross-training
B) encapsulation
C) specialization
D) centralization
Q3) ____ allows for the translation of the company's strategic goals into the data and applications that will help the company achieve those goals.
A) Access Management
B) Business Intelligence
C) Information engineering (IE)
D) MOLAP
Q4) ____________________ decisions are short term and affect only daily operations; for example, deciding to change the price of a product to clear it from inventory.
Q5) A(n) ____________________ physically stores the database's data.
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) 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.
Q2) Most real-world database transactions are formed by only one database request. A)True
B)False
Q3) In the optimistic approach, during the ____ phase, changes are permanently applied to the database.
A) read
B) validation
C) write
D) shared
Q4) If T1 has not unlocked data item Y, T2 cannot begin; if T2 has not unlocked data item X, T1 cannot continue. Consequently, T1 and T2 each wait for the other to unlock the required data item. Such a deadlock is also known as a(n) ____________________.
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) All transaction management commands are processed during the parsing and execution phases of query processing.
A)True
B)False
Q2) How should storage volumes be allocated for indexes, system, and high-usage tables?
Q3) A system table space, a user data table space, an index table space, and a temporary table space are examples of ____.
A) procedure caches
B) file groups
C) data files
D) extends
Q4) 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
Q5) Describe query optimization and the modes that an optimizer can operate in.
To view all questions and flashcards with answers, click on the resource link above. Page 17
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) The ____________________ hierarchy provides the capability to perform drill-down and roll-up searches in a data warehouse.
Q2) Data ____ implies that all business entities, data elements, data characteristics, and business metrics are described in the same way throughout the enterprise. A) volatility
B) time-variation
C) subject-orientation D) integration
Q3) Decision support data tend to be non-normalized, ____, and pre-aggregated. A) unique B) duplicated C) relational D) sorted
Q4) Describe the use of SQL in relation to ROLAP.
Q5) A(n) ______________________________ is an arrangement of computerized tools used to assist managerial decision making within a business.
Q6) In a typical ____________________ schema, each dimension record is related to thousands of fact records.
To view all questions and flashcards with answers, click on the resource link above. Page 18