Software Engineering Exam Bank
Course
Introduction
Software Engineering is a comprehensive course that explores the principles, methods, and tools used in the professional development of large-scale software systems. It covers the entire software development lifecycle, including requirements analysis, system design, implementation, testing, maintenance, and project management. Emphasis is placed on software process models, documentation, team collaboration, software quality assurance, and ethical considerations, equipping students with practical skills and theoretical knowledge to build reliable, maintainable, and scalable software solutions in a real-world context.
Recommended Textbook
Database Systems Design Implementation and Management 11th Edition by Carlos Coronel
Available Study Resources on Quizplus
15 Chapters
1318 Verified Questions
1318 Flashcards
Source URL: https://quizplus.com/study-set/1460
Page 2
Chapter 1: Database Systems
Available Study Resources on Quizplus for this Chatper
76 Verified Questions
76 Flashcards
Source URL: https://quizplus.com/quiz/29009
Sample Questions
Q1) relates to the activities that make the database execute transactions more efficiently in terms of storage and access speed.
A) Performance tuning
B) Database design
C) Query access
D) Database management
Answer: A
Q2) data exist in a format that does not lend itself to processing that yields information.
A) Structured
B) Semistructured
C) Unstructured
D) Historical
Answer: C
Q3) One advantage of a database system over previous data management approaches is that the database system is considerably less complex.
A)True
B)False
Answer: False
To view all questions and flashcards with answers, click on the resource link above. Page 3
Chapter 2: Data Models
Available Study Resources on Quizplus for this Chatper
75 Verified Questions
75 Flashcards
Source URL: https://quizplus.com/quiz/29016
Sample Questions
Q1) 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.
Q2) Each row in the relational table is known as a(n) .
Answer: entity instance
Q3) 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
Q4) The network model has structural level dependence.
A)True
B)False
Answer: True
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
75 Verified Questions
75 Flashcards
Source URL: https://quizplus.com/quiz/29017
Sample Questions
Q1) returns only the attributes requested, in the order in which they are requested.
A) PROJECT
B) SELECT
C) UNION
D) DIFFERENCE
Answer: A
Q2) In the relational model, are important because they are used to ensure that each row in a table is uniquely identifiable.
A) relations
B) keys
C) indexes
D) logical structures
Answer: B
Q3) PRODUCT yields all possible pairs of rows from two tables, also known as the product.
Answer: Cartesian
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
75 Verified Questions
75 Flashcards
Source URL: https://quizplus.com/quiz/29018
Sample Questions
Q1) A(n) relationship is also known as an identifying relationship.
Q2) Unary relationships are common in manufacturing industries.
A)True
B)False
Q3) The conceptual model can handle relationships and multivalued attributes.
A) 1:1
B) M:N
C) 1:M
D) 1:N
Q4) In Chen notation, there is no way to represent cardinality.
A)True
B)False
Q5) The Chen notation identifies a weak entity by using a double-walled entity .
Q6) The existence of a(n) entity indicates that its minimum cardinality is zero.
A) ternary
B) optional
C) strong
D) weak
Q7) Explain mandatory participation in an entity relationship.
Q8) A(n) process is based on repetition of processes and procedures.
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
85 Verified Questions
85 Flashcards
Source URL: https://quizplus.com/quiz/29019
Sample Questions
Q1) Specialization is the top-down process of identifying lower-level, more specific entity subtypes from a higher-level entity supertype.
A)True
B)False
Q2) Usually, a data modeler uses a natural identifier as the of the entity being modeled, assuming that the entity has a natural identifier.
Q3) Composite keys are useful as identifiers of weak entities, where the weak entity has a strong relationship with the parent entity.
Q4) The " " characteristic of a primary key states that the primary key should not have embedded semantic meaning.
A) unique values
B) nonintelligent
C) preferably single-attribute
D) security-compliant
Q5) Unique values can be better managed when they are , because the database can use internal routines to implement a counter-style attribute that automatically increments values with the addition of each new row.
Q6) Disjoint subtypes are also known as subtypes.
To view all questions and flashcards with answers, click on the resource link above. Page 7
Chapter 6: Normalization of Database Tables
Available Study Resources on Quizplus for this Chatper
110 Verified Questions
110 Flashcards
Source URL: https://quizplus.com/quiz/29020
Sample Questions
Q1) is a process to help reduce the likelihood of data anomalies.
Q2) A good relational DBMS excels at managing denormalized relations.
A)True
B)False
Q3) From a system functionality point of view, attribute values can be calculated when they are needed to write reports or invoices.
A) derived
B) atomic
C) granular
D) historical
Q4) The is central to a discussion of normalization.
Q5) In a real-world environment, changing granularity requirements might dictate changes in primary key selection, and those changes might ultimately require the use of keys.
Q6) The most likely data type for a surrogate key is .
A) character
B) date
C) logical
D) numeric
Q7) A dependency based on only a part of a composite primary key is called a .
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
111 Verified Questions
111 Flashcards
Source URL: https://quizplus.com/quiz/29021
Sample Questions
Q1) The query to join the P_DESCRIPT and P_PRICE fields from the PRODUCT table and the V_NAME, V_AREACODE, V_PHONE, and V_CONTACT fields from the VENDOR table where the values of V_CODE match is .
A) SELECT P_DESCRIPT, P_PRICE, V_NAME, V_CONTACT, V_AREACODE, V_PHONE FROM PRODUCT, VENDOR WHERE PRODUCT.V_CODE <> VENDOR.V_CODE;
B) SELECT P_DESCRIPT, P_PRICE, V_NAME, V_CONTACT, V_AREACODE, V_PHONE FROM PRODUCT, VENDOR WHERE PRODUCT.V_CODE = VENDOR.V_CODE;
C) SELECT P_DESCRIPT, P_PRICE, V_NAME, V_CONTACT, V_AREACODE, V_PHONE FROM PRODUCT, VENDOR WHERE PRODUCT.V_CODE <= VENDOR.V_CODE;
D) SELECT P_DESCRIPT, P_PRICE, V_NAME, V_CONTACT, V_AREACODE, V_PHONE FROM PRODUCT, VENDOR WHERE PRODUCT.V_CODE => VENDOR.V_CODE;
Q2) The COUNT function 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
Q3) The SQL data type DATE stores date in the date format.
Q4) In a 1:M relationship, a user must always create the table for the side first.
To view all questions and flashcards with answers, click on the resource link above.
9
Chapter 8: Advanced Sql
Available Study Resources on Quizplus for this Chatper
109 Verified Questions
109 Flashcards
Source URL: https://quizplus.com/quiz/29022
Sample Questions
Q1) The syntax for a left outer join is .
A) SELECT column-list FROM table1 OUTER JOIN table2 LEFT WHERE join-condition
B) SELECT column-list FROM table1 LEFT [OUTER] JOIN table2 ON join-condition
C) SELECT column-list WHERE LEFT table1 = table 2
D) SELECT column-list FROM table1 LEFT table2 [JOIN] WHERE join-condition
Q2) The IN subquery uses a(n) operator.
Q3) PL/SQL blocks have a section used to declare variables.
A)True
B)False
Q4) A(n) view is a view that can be used to update attributes in the base table(s) that are used in the view.
Q5) Describe the important features and applications of SQL functions
Q6) The data type is compatible with NUMBER.
A) VARCHAR(15)
B) SMALLINT
C) DATE
D) CHAR(10)
Q7) MySQL allows multiple triggering conditions per trigger.
A)True
B)False
To view all questions and flashcards with answers, click on the resource link above. Page 10
Chapter 9: Database Design
Available Study Resources on Quizplus for this Chatper
103 Verified Questions
103 Flashcards
Source URL: https://quizplus.com/quiz/29023
Sample Questions
Q1) can render data useless to unauthorized users who might have violated some of the database security layers.
A) Data encryption
B) Access rights
C) Physical security
D) Password security
Q2) In the Systems Development Life Cycle(SDLC), the design of the system's processes begins in the detailed systems design phase.
A)True
B)False
Q3) The database contents might be loaded interactively or in batch mode using a variety of methods and devices including customized user programs.
A)True
B)False
Q4) The proposed system is subject to limits known as , which are external to the system.
Q5) The term describes the extent to which modules are independent of one another.
Q6) Explain the differences between a centralized and decentralized approach to database design.
To view all questions and flashcards with answers, click on the resource link above. Page 11
Chapter 10: Transaction Management and Concurrency
Control
Available Study Resources on Quizplus for this Chatper
85 Verified Questions
85 Flashcards
Source URL: https://quizplus.com/quiz/29010
Sample Questions
Q1) If a(n) is issued before the termination of a transaction, the DBMS will restore the database only for that particular transaction, rather than for all transactions, in order to maintain the durability of the previous transactions.
Q2) Serializability means that data used during the execution of a transaction cannot be used by a second transaction until the first one is completed.
A)True
B)False
Q3) Although the DBMS is designed to recover a database to a previous consistent state when an interruption prevents the completion of a required set of transactions, the transactions themselves are defined by the end user or programmer and must be semantically correct.
A)True
B)False
Q4) Database transaction restores a database from an inconsistent state to a previously consistent state.
Q5) ensure that a disk physical failure will not impair the DBMS's ability to recover data.
Q6) The interleaves the execution of database operations to ensure serializability.
Page 12
To view all questions and flashcards with answers, click on the resource link above.
Chapter 11: Database Performance Tuning and Query
Optimization
Available Study Resources on Quizplus for this Chatper
85 Verified Questions
85 Flashcards
Source URL: https://quizplus.com/quiz/29011
Sample Questions
Q1) In standard SQL, the optimizer hint FIRST_ROWS is generally used for mode processes.
A) batch
B) interactive
C) transaction
D) real-time
Q2) A data file can contain rows from a single table alone.
A)True
B)False
Q3) If there is no index, the DBMS will perform a scan.
A) loop
B) range
C) row ID table access
D) full table
Q4) All transaction management commands are processed during the parsing and execution phases of query processing.
A)True
B)False
Q5) is evaluated based on client perspective.
Q6) is an index based on a specific SQL function or expression.
To view all questions and flashcards with answers, click on the resource link above. Page 13
Chapter 12: Distributed Database Management Systems
Available Study Resources on Quizplus for this Chatper
83 Verified Questions
83 Flashcards
Source URL: https://quizplus.com/quiz/29012
Sample Questions
Q1) In a distributed database management system (DDBMS), query is used to find the best access strategy.
Q2) In theory, a(n) can be an independent centralized database management system with proper interfaces to support remote access from other independent database management systems in the network.
A) transaction processor
B) application processor
C) transaction manager
D) data processor
Q3) transparency exists when the end user or programmer must specify both the fragment names and their locations.
A) Local mapping
B) Location
C) Performance
D) Fragmentation
Q4) A user-friendly is one advantage of a distributed database management system (DDBMS) .
Q5) The protocol is used by a DP to roll transactions back and forward with the help of the system's transaction log entries.
To view all questions and flashcards with answers, click on the resource link above. Page 14
Chapter 13: Business Intelligence and Data Warehouses
Available Study Resources on Quizplus for this Chatper
75 Verified Questions
75 Flashcards
Source URL: https://quizplus.com/quiz/29013
Sample Questions
Q1) Business intelligence (BI) architecture is composed of data, people, processes, technology, and the management of such components.
A)True
B)False
Q2) _____ splits a table into subsets of rows or columns and places the subsets close to the client computer to improve data access time.
A) Normalization
B) Meta modeling
C) Replication
D) Partitioning
Q3) The data warehouse development life cycle differs from classical systems development.
A)True
B)False
Q4) A index is based on 0 and 1 bits to represent a given condition.
A) logical
B) multidimensional
C) normal
D) bitmapped
To view all questions and flashcards with answers, click on the resource link above. Page 15
Chapter 14: Database Connectivity and Web Technologies
Available Study Resources on Quizplus for this Chatper
85 Verified Questions
85 Flashcards
Source URL: https://quizplus.com/quiz/29014
Sample Questions
Q1) What are the main types of objects in the OLE-DB model? Explain.
Q2) Among client-side extensions, is a Microsoft specification for writing programs that run inside the Internet Explorer browser.
A) COBOL
B) ActiveX
C) JavaScript
D) Visor.Net
Q3) The benefits of the web as a data access platform arise from its cross-platform functionality and the simplicity of its interface.
A)True
B)False
Q4) cloud is a type of cloud infrastructure that is built by a third-party organization to sell cloud services to the general public.
A) Community
B) Public
C) Exclusive
D) Private
Q5) What is a server-side extension? Explain.
Q6) What are the components in the basic ODBC architecture?
Page 16
To view all questions and flashcards with answers, click on the resource link above.
Chapter 15: Database Administration and Security
Available Study Resources on Quizplus for this Chatper
86 Verified Questions
86 Flashcards
Source URL: https://quizplus.com/quiz/29015
Sample Questions
Q1) Which of the following is a reason why a DBMS's daily operations must be clearly documented?
A) Documentation of the daily operations help a company set its long-term goals.
B) Documentation of the daily operations help manage the manual data resources of a company.
C) Documentation of the daily operations help pinpoint causes and solutions of database problems.
D) Documentation of the daily operations help free the DBA from many lower-level technology-oriented tasks.
Q2) A data administrator is also known as a(n) .
A) data security officer
B) systems administrator
C) information resource manager
D) information engineering officer
Q3) Protecting the security and integrity of a database is a function of authorization management.
A)True
B)False
Q4) Describe the need for convenient and safe backup storage.
To view all questions and flashcards with answers, click on the resource link above. Page 17