Question 1

Which of the following statements is FALSE?

Accepted Answer

A)  Data redundancy occurs when the same piece of data is stored in more than one place. 
B)  Data redundancy could result in data integrity issues. 
C)  Relational databases use unique IDs and relationships to eliminate data redundancy. 
D)  Relational databases use cardinality and business rules to eliminate data redundancy. 
A)  Data redundancy occurs when the same piece of data is stored in more than one place. 
B)  Data redundancy could result in data integrity issues. 
C)  Relational databases use unique IDs and relationships to eliminate data redundancy. 
D)  Relational databases use cardinality and business rules to eliminate data redundancy.

Question 2

Julian is designing the physical ERD for a new database. What element must Julian include?

Accepted Answer

A)  Tables 
B)  Relationships 
C)  Keys 
D)  All of these answer choices are correct. 
A)  Tables 
B)  Relationships 
C)  Keys 
D)  All of these answer choices are correct.

Question 3

Which role in the SDLC is responsible for identifying business needs and proposing systems to address those needs?

Accepted Answer

A)  IT steering committee 
B)  End users 
C)  Lead systems analyst 
D)  Core application programmers 
A)  IT steering committee 
B)  End users 
C)  Lead systems analyst 
D)  Core application programmers

Question 4

A focus of the Agile software development methodology is

Accepted Answer

A)  encouraging collaboration between stakeholders and programmers. 
B)  using strong leaders on teams. 
C)  creating well-defined requirements that do not need changes during development. 
D)  All of these answer choices are correct. 
A)  encouraging collaboration between stakeholders and programmers. 
B)  using strong leaders on teams. 
C)  creating well-defined requirements that do not need changes during development. 
D)  All of these answer choices are correct.

Question 5

Davidson Equipment Company is working through the SDLC framework in an effort to successfully build and implement a new parts inventory system. Davidson is concerned about how the parts inventory system will work with the existing sales system. What element in the design stage needs to be completed to resolve this issue for Davidson?

Accepted Answer

A)  Conceptual design 
B)  Technical architecture specifications 
C)  Systems model 
D)  Graphical user interface 
A)  Conceptual design 
B)  Technical architecture specifications 
C)  Systems model 
D)  Graphical user interface

Question 6

A simple event database that tracks acts and the events where they perform has an ERD as illustrated. There are acts entered into the database that have not yet performed at any events. If a left outer join were performed to select all data from each table, what values would be displayed for the event fields for acts who have not yet performed at an event.

Accepted Answer

A)  SELECT 
B)  NULL 
C)  The fields would be blank. 
D)  There can be no empty fields. 
A)  SELECT 
B)  NULL 
C)  The fields would be blank. 
D)  There can be no empty fields.

Question 7

Antonio, a product owner for the company's new project, receives suggestions for features from end users each time he presents a new product increment. How should Antonio handle these suggestions?

Accepted Answer

As product owner, Antonio has final auth

Question 8

The diagram shown is a visual representation of which type of join?

Accepted Answer

A)  Inner join 
B)  Left outer join 
C)  Right outer join 
D)  Full outer join 
A)  Inner join 
B)  Left outer join 
C)  Right outer join 
D)  Full outer join

Question 9

You need to write an SQL query to retrieve CustomerFirstName, CustomerLastName, and CustomerEmailAddress from the Customer table for all customers who list "OK" as their state (field name for state is CustomerState). Which SQL statement will yield the results that you need?

Accepted Answer

A)  SELECT CustomerFirstName, CustomerLastName, CustomerEmailAddress FROM Customer
WHEN CustomerState IS 'OK' 
B)  SELECT CustomerFirstName, CustomerLastName, CustomerEmailAddress FROM Customer
WHEN CustomerState = 'OK' 
C)  SELECT CustomerFirstName, CustomerLastName, CustomerEmailAddress FROM Customer
WHERE CustomerState = 'OK' 
D)  SELECT CustomerFirstName, CustomerLastName, CustomerEmailAddress FROM Customer
WHERE CustomerState IS 'OK' 
A)  SELECT CustomerFirstName, CustomerLastName, CustomerEmailAddress FROM Customer
WHEN CustomerState IS 'OK' 
B)  SELECT CustomerFirstName, CustomerLastName, CustomerEmailAddress FROM Customer
WHEN CustomerState = 'OK' 
C)  SELECT CustomerFirstName, CustomerLastName, CustomerEmailAddress FROM Customer
WHERE CustomerState = 'OK' 
D)  SELECT CustomerFirstName, CustomerLastName, CustomerEmailAddress FROM Customer
WHERE CustomerState IS 'OK'

Question 10

What is the term associated with a mockup of the screen that will allow users to interact with the system?

Accepted Answer

A)  Systems model 
B)  Conceptual design 
C)  Graphical user interface 
D)  Architecture model 
A)  Systems model 
B)  Conceptual design 
C)  Graphical user interface 
D)  Architecture model

Question 11

Attributes of an object in an object-oriented database are referred to as

Accepted Answer

A)  classes. 
B)  records. 
C)  variables. 
D)  files. 
A)  classes. 
B)  records. 
C)  variables. 
D)  files.

Question 12

Entity integrity requires that the

Accepted Answer

A)  foreign key exists as a primary key in the related table. 
B)  primary key exists as a foreign key in the related table. 
C)  primary key cannot be null. 
D)  primary key cannot be unique. 
A)  foreign key exists as a primary key in the related table. 
B)  primary key exists as a foreign key in the related table. 
C)  primary key cannot be null. 
D)  primary key cannot be unique.

Question 13

How do database designers identify the connections between entities?

Accepted Answer

A)  Database designers consult with end users to understand how data is used. 
B)  Database designers analyze business events. 
C)  Database designers write statements of relationships based on business events. 
D)  All of these answer choices are correct. 
A)  Database designers consult with end users to understand how data is used. 
B)  Database designers analyze business events. 
C)  Database designers write statements of relationships based on business events. 
D)  All of these answer choices are correct.

Question 14

When a primary key is inserted into another table to create a relationship, the key in the related table is referred to as a

Accepted Answer

A)  primary key. 
B)  foreign key. 
C)  relationship key. 
D)  unique key. 
A)  primary key. 
B)  foreign key. 
C)  relationship key. 
D)  unique key.

Question 15

Which type of SQL language grants or removes access from a database user?

Accepted Answer

A)  Data definition language 
B)  Data manipulation language 
C)  Data control language 
D)  Data querying language 
A)  Data definition language 
B)  Data manipulation language 
C)  Data control language 
D)  Data querying language

Question 16

The first stage of a SDLC is the

Accepted Answer

A)  planning stage. 
B)  analysis stage. 
C)  design stage. 
D)  development stage. 
A)  planning stage. 
B)  analysis stage. 
C)  design stage. 
D)  development stage.

Question 17

In the diagram below, the shaded row represents a $\begin{array}{|l|l|l|l|l|}
\hline \text{FirstName} & \text{MiddleInitial} &\text{ LastName }&\text{ Birthdate} & \text{PhoneNumber} \
\hline\text{ Willie }&\mathrm{H}  & \text{Nelson} &\text{ April 29, 1933} & 123-456-7890  \
\hline\text{ Waylon }&\text{ A }&\text{ Jennings} & \text{June 15, 1937 }&  987-654-3210  \
\hline
\end{array}$

Accepted Answer

A)  field. 
B)  record. 
C)  column. 
D)  file. 
A)  field. 
B)  record. 
C)  column. 
D)  file.

Question 18

Which kind of cardinality constraint identifies whether the relationship is optional or mandatory?

Accepted Answer

A)  Plurality 
B)  Optionality 
C)  Referentiality 
D)  All of these answer choices are correct. 
A)  Plurality 
B)  Optionality 
C)  Referentiality 
D)  All of these answer choices are correct.

Question 19

Which type of JOIN operation retrieves record data with a join column value present only in the first table of the join and the results of the inner join?

Accepted Answer

A)  Inner join 
B)  Left outer join 
C)  Right outer join 
D)  Full outer join 
A)  Inner join 
B)  Left outer join 
C)  Right outer join 
D)  Full outer join

Question 20

The term associated with a project that evolves during development beyond the original specifications is

Accepted Answer

A)  timeboxing. 
B)  sprint. 
C)  scope creep. 
D)  artifact. 
A)  timeboxing. 
B)  sprint. 
C)  scope creep. 
D)  artifact.

Which of the following statements is FALSE?

Julian is designing the physical ERD for a new database. What element must Julian include?

Which role in the SDLC is responsible for identifying business needs and proposing systems to address those needs?

A focus of the Agile software development methodology is

Antonio, a product owner for the company's new project, receives suggestions for features from end users each time he presents a new product increment. How should Antonio handle these suggestions?

The diagram shown is a visual representation of which type of join?

You need to write an SQL query to retrieve CustomerFirstName, CustomerLastName, and CustomerEmailAddress from the Customer table for all customers who list "OK" as their state (field name for state is CustomerState). Which SQL statement will yield the results that you need?

What is the term associated with a mockup of the screen that will allow users to interact with the system?

Attributes of an object in an object-oriented database are referred to as

Entity integrity requires that the

How do database designers identify the connections between entities?

When a primary key is inserted into another table to create a relationship, the key in the related table is referred to as a

Which type of SQL language grants or removes access from a database user?

The first stage of a SDLC is the

In the diagram below, the shaded row represents a FirstName MiddleInitial LastName Birthdate PhoneNumber Willie Nelson April 29, 1933 123-456-7890 Waylon A Jennings June 15, 1937 987-654-3210

Which kind of cardinality constraint identifies whether the relationship is optional or mandatory?

Which type of JOIN operation retrieves record data with a join column value present only in the first table of the join and the results of the inner join?

The term associated with a project that evolves during development beyond the original specifications is

Accounting As Information

Risks and Risk Assessments

Risk Management and Internal Controls

Software and Systems

Data Storage and Analysis

Emerging and Disruptive Technologies

Documenting Systems and Processes

Human Resources and Payroll Processes

Purchasing and Payments Process

Conversion Processes

Marketing, Sales, and Collection Processes

Financial Reporting Processes

Information Systems and Controls

Fraud

Cybersecurity

Data Analytics

Data Visualization

Audit Assurance

Filters

Exam 6: Systems and Database Design

Which of the following statements is FALSE?

Julian is designing the physical ERD for a new database. What element must Julian include?

Which role in the SDLC is responsible for identifying business needs and proposing systems to address those needs?

A focus of the Agile software development methodology is

Antonio, a product owner for the company's new project, receives suggestions for features from end users each time he presents a new product increment. How should Antonio handle these suggestions?

The diagram shown is a visual representation of which type of join?

You need to write an SQL query to retrieve CustomerFirstName, CustomerLastName, and CustomerEmailAddress from the Customer table for all customers who list "OK" as their state (field name for state is CustomerState). Which SQL statement will yield the results that you need?

What is the term associated with a mockup of the screen that will allow users to interact with the system?

Attributes of an object in an object-oriented database are referred to as

Entity integrity requires that the

How do database designers identify the connections between entities?

When a primary key is inserted into another table to create a relationship, the key in the related table is referred to as a

Which type of SQL language grants or removes access from a database user?

The first stage of a SDLC is the

In the diagram below, the shaded row represents a FirstName MiddleInitial LastName Birthdate PhoneNumber Willie Nelson April 29, 1933 123-456-7890 Waylon A Jennings June 15, 1937 987-654-3210

Which kind of cardinality constraint identifies whether the relationship is optional or mandatory?

Which type of JOIN operation retrieves record data with a join column value present only in the first table of the join and the results of the inner join?

The term associated with a project that evolves during development beyond the original specifications is

Accounting As Information

Risks and Risk Assessments

Risk Management and Internal Controls

Software and Systems

Data Storage and Analysis

Emerging and Disruptive Technologies

Documenting Systems and Processes

Human Resources and Payroll Processes

Purchasing and Payments Process

Conversion Processes

Marketing, Sales, and Collection Processes

Financial Reporting Processes

Information Systems and Controls

Fraud

Cybersecurity

Data Analytics

Data Visualization

Audit Assurance

Filters