Ch. 6 Quiz
docx
keyboard_arrow_up
School
University of Houston, Downtown *
*We aren’t endorsed by this school
Course
3304
Subject
Information Systems
Date
Dec 6, 2023
Type
docx
Pages
4
Uploaded by lizzyhernandez24
Ch. 6 Quiz
The diagram shown is a visual representation of which type of join?
A.
Inner join
B.
Left outer join
C.
Right outer join
D.
Full outer join
During the planning phase, a project plan is created that
A.
decides whether to build or buy the system.
B.
determines system requirements.
C.
identifies the scope of the system and project goals.
D.
analyzes the economic factors that will impact the project.
Which type of SQL language grants or removes access from a database user?
A.
Data querying language
B.
Data manipulation language
C.
Data control language
D.
Data definition language
The term associated with a project that evolves during development beyond the original specifications is
A.
scope creep.
B.
timeboxing.
C.
artifact.
D.
sprint.
What is the most popular project management style for implementing Agile methodology?
A.
Waterfall
B.
Scrum
C.
SDLC
D.
All of these answer choices are correct.
Which of the following queries would yield results that include all customers and all receipts for
those customers, only if they have any receipts?
A.
ELECT * FROM Customer INNER JOIN Receipt
ON Customer.CustomerID = Receipt.CustomerID
B.
SELECT * FROM Customer RIGHT OUTER JOIN Receipt
ON Customer.CustomerID = Receipt.CustomerID
C.
SELECT * FROM Customer LEFT OUTER JOIN Receipt
ON Customer.CustomerID = Receipt.CustomerID
D.
SELECT * FROM Customer FULL OUTER JOIN Receipt
ON Customer.CustomerID = Receipt.CustomerID
Risk is created using the Waterfall method when developers do NOT receive feedback until project
completion because of
A.
changes in user expectations.
B.
changes in business processes.
C.
changes in requirements.
D.
All of these answer choices are correct.
At what stage in the SDLC are programmers responsible for testing code?
A.
Analysis stage
B.
Testing stage
C.
Design stage
D.
Development stage
Alice, a recent IT graduate, working in the database department is tasked with implementing the newly
designed database for the company. Which type of ERD does Alice need to complete the task of
database implementation?
A.
Conceptual ERD
B.
Physical ERD
C.
Logical ERD
D.
All of these answer choices are correct.
How do database designers identify the connections between entities?
A.
Database designers write statements of relationships based on business events.
B.
Database designers consult with end users to understand how data is used.
C.
Database designers analyze business events.
D.
All of these answer choices are correct.
Attempt 2:
Testers evaluate systems to ensure that
A.
the system meets requirements.
B.
the systems accomplish their purpose.
C.
the systems work together.
D.
All of these answer choices are correct.
In the diagram below, the shaded row represents a
FirstName
MiddleInitial
LastName
Birthdate
PhoneNumber
Willie
H
Nelson
April 29, 1933
123-456-7890
Waylon
A
Jennings
June 15, 1937
987-654-3210
A.
record.
B.
column.
C.
field.
D.
file.
Dikshya writes a SELECT command to retrieve data from the database. Which type of SQL language is
Dikshya using?
A.
Data control language
B.
Data definition language
C.
Data manipulation language
D.
Data querying language
You need to write a query to retrieve all customer information (table is 'Customer') for customers who
do NOT live in Texas ('TX'). Which of the following SQL statements will work for your query?
A.
SELECT all FROM Customer WHERE State not = 'TX'
B.
SELECT all FROM Customer WHERE State <> 'TX'
C.
SELECT * FROM Customer WHERE State <> 'TX'
D.
SELECT * FROM Customer WHERE State not = 'TX'
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
- Access to all documents
- Unlimited textbook solutions
- 24/7 expert homework help
Entity integrity requires that the
A.
primary key cannot be unique.
B.
primary key cannot be null.
C.
primary key exists as a foreign key in the related table.
D.
foreign key exists as a primary key in the related table.
What is a scrum master?
A.
Someone who ensures focus on Agile principles
B.
Champion of the core development team
C.
Someone who clears obstacles from the core team's path
D.
All of these answer choices are correct.
When a primary key is inserted into another table to create a relationship, the key in the related table is
referred to as a
A.
foreign key.
B.
relationship key.
C.
primary key.
D.
unique key.
What is the term associated with a mockup of the screen that will allow users to interact with the
system?
A.
Architecture model
B.
Graphical user interface
C.
Systems model
D.
Conceptual design
During the analysis stage of the SDLC, business requirements for a project are determined by
A.
systems analysts meeting with end users.
B.
the IT steering committee reviewing the feasibility study.
C.
the lead system analyst reviewing the project plan.
D.
All of these answer choices are correct.