Question 1

You need to write a SQL command to undo all pending transactions that have NOT yet been saved to the database. Which command would you choose?

Accepted Answer

A)  DELETE 
B)  TRUNCATE 
C)  ROLLBACK 
D)  REVOKE 
A)  DELETE 
B)  TRUNCATE 
C)  ROLLBACK 
D)  REVOKE

Question 2

You need to write a command to update the price in the products table. Which type of SQL language do you need to use?

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 3

Which role in the SDLC includes representatives from multiple business areas and is responsible for approval and prioritization of projects?

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

Explain why all companies would not choose the lowest cost implementation method, direct cutover?

Accepted Answer

The direct cutover method is the lowest

Question 5

Testers evaluate systems to ensure that

Accepted Answer

A)  the system meets requirements. 
B)  the systems work together. 
C)  the systems accomplish their purpose. 
D)  All of these answer choices are correct. 
A)  the system meets requirements. 
B)  the systems work together. 
C)  the systems accomplish their purpose. 
D)  All of these answer choices are correct.

Question 6

What type of operator allows a SELECT query to retrieve data from more than one related table in the database in one query?

Accepted Answer

A)  ALTER 
B)  JOIN 
C)  TRUNCATE 
D)  WHERE 
A)  ALTER 
B)  JOIN 
C)  TRUNCATE 
D)  WHERE

Question 7

The new system moves to production and goes live for company use in the

Accepted Answer

A)  development stage. 
B)  implementation stage. 
C)  design stage. 
D)  maintenance stage. 
A)  development stage. 
B)  implementation stage. 
C)  design stage. 
D)  maintenance stage.

Question 8

Why have other development methodologies increased in popularity over the Waterfall method in recent years?

Accepted Answer

A)  The linear nature of the Waterfall method makes it difficult to respond to risks and changes. 
B)  Companies tend to avoid traditional methods in favor of newer methodologies. 
C)  Waterfall is ineffective as a SDLC methodology and was only used in the past because it was the only option. 
D)  Waterfall is ineffective because it cannot be customized for the specific project. 
A)  The linear nature of the Waterfall method makes it difficult to respond to risks and changes. 
B)  Companies tend to avoid traditional methods in favor of newer methodologies. 
C)  Waterfall is ineffective as a SDLC methodology and was only used in the past because it was the only option. 
D)  Waterfall is ineffective because it cannot be customized for the specific project.

Question 9

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 10

Which of the following queries would yield results that include all customers and all receipts for those customers, only if they have any receipts?

Accepted Answer

A)  SELECT * FROM Customer RIGHT OUTER JOIN Receipt
ON Customer.CustomerID = Receipt.CustomerID 
B)  SELECT * FROM Customer LEFT OUTER JOIN Receipt
ON Customer.CustomerID = Receipt.CustomerID 
C)  SELECT * FROM Customer INNER JOIN Receipt
ON Customer.CustomerID = Receipt.CustomerID 
D)  SELECT * FROM Customer FULL OUTER JOIN Receipt
ON Customer.CustomerID = Receipt.CustomerID 
A)  SELECT * FROM Customer RIGHT OUTER JOIN Receipt
ON Customer.CustomerID = Receipt.CustomerID 
B)  SELECT * FROM Customer LEFT OUTER JOIN Receipt
ON Customer.CustomerID = Receipt.CustomerID 
C)  SELECT * FROM Customer INNER JOIN Receipt
ON Customer.CustomerID = Receipt.CustomerID 
D)  SELECT * FROM Customer FULL OUTER JOIN Receipt
ON Customer.CustomerID = Receipt.CustomerID

Question 11

You need to write a SQL command to delete all the records in a table but NOT remove the table. Which command would you choose?

Accepted Answer

A)  DELETE 
B)  TRUNCATE 
C)  DROP 
D)  ALTER 
A)  DELETE 
B)  TRUNCATE 
C)  DROP 
D)  ALTER

Question 12

Which of the following statements about scrum is TRUE?

Accepted Answer

A)  Scrum is a set of project management practices that focus on long-term planning. 
B)  Scrum breaks down a systems development project into short cycles of work. 
C)  Scrum development teams are led by the business product owner. 
D)  All of these answer choices are correct. 
A)  Scrum is a set of project management practices that focus on long-term planning. 
B)  Scrum breaks down a systems development project into short cycles of work. 
C)  Scrum development teams are led by the business product owner. 
D)  All of these answer choices are correct.

Question 13

Which type of SQL language changes the structure of the database?

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 14

Which of the following statements about scrum timeboxing is correct?

Accepted Answer

A)  Everything is subject to change in an Agile project except the timeboxing. 
B)  Timeboxing includes the use of sprints to complete multiple iterations on a single SDLC stage in two weeks. 
C)  Timeboxing prevents scope creep by not addressing end-user suggestions until the end of the SDLC. 
D)  All of these answer choices are correct. 
A)  Everything is subject to change in an Agile project except the timeboxing. 
B)  Timeboxing includes the use of sprints to complete multiple iterations on a single SDLC stage in two weeks. 
C)  Timeboxing prevents scope creep by not addressing end-user suggestions until the end of the SDLC. 
D)  All of these answer choices are correct.

Question 15

Write a SQL statement to retrieve all of the records from the Acts table that have an ActGenre of 'Rock'.

Accepted Answer

SELECT * F

Question 16

Which relational database term is associated with a group of related fields that describe an individual instance of an entity?

Accepted Answer

A)  Field name 
B)  Record 
C)  File 
D)  Database 
A)  Field name 
B)  Record 
C)  File 
D)  Database

Question 17

Which type of SQL language interacts with data manipulation language when transactions are processed within the database and saved or undoes pending transactions?

Accepted Answer

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

Question 18

Select the term that refers to the numeric relationship between data in one table and data in another table.

Accepted Answer

A)  Primary key 
B)  Foreign key 
C)  Referential integrity 
D)  Cardinality 
A)  Primary key 
B)  Foreign key 
C)  Referential integrity 
D)  Cardinality

You need to write a SQL command to undo all pending transactions that have NOT yet been saved to the database. Which command would you choose?

You need to write a command to update the price in the products table. Which type of SQL language do you need to use?

Which role in the SDLC includes representatives from multiple business areas and is responsible for approval and prioritization of projects?

Explain why all companies would not choose the lowest cost implementation method, direct cutover?

Testers evaluate systems to ensure that

What type of operator allows a SELECT query to retrieve data from more than one related table in the database in one query?

The new system moves to production and goes live for company use in the

Why have other development methodologies increased in popularity over the Waterfall method in recent years?

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

Which of the following queries would yield results that include all customers and all receipts for those customers, only if they have any receipts?

You need to write a SQL command to delete all the records in a table but NOT remove the table. Which command would you choose?

Which of the following statements about scrum is TRUE?

Which type of SQL language changes the structure of the database?

Which of the following statements about scrum timeboxing is correct?

Write a SQL statement to retrieve all of the records from the Acts table that have an ActGenre of 'Rock'.

Which relational database term is associated with a group of related fields that describe an individual instance of an entity?

Which type of SQL language interacts with data manipulation language when transactions are processed within the database and saved or undoes pending transactions?

Select the term that refers to the numeric relationship between data in one table and data in another table.

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

You need to write a SQL command to undo all pending transactions that have NOT yet been saved to the database. Which command would you choose?

You need to write a command to update the price in the products table. Which type of SQL language do you need to use?

Which role in the SDLC includes representatives from multiple business areas and is responsible for approval and prioritization of projects?

Explain why all companies would not choose the lowest cost implementation method, direct cutover?

Testers evaluate systems to ensure that

What type of operator allows a SELECT query to retrieve data from more than one related table in the database in one query?

The new system moves to production and goes live for company use in the

Why have other development methodologies increased in popularity over the Waterfall method in recent years?

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

Which of the following queries would yield results that include all customers and all receipts for those customers, only if they have any receipts?

You need to write a SQL command to delete all the records in a table but NOT remove the table. Which command would you choose?

Which of the following statements about scrum is TRUE?

Which type of SQL language changes the structure of the database?

Which of the following statements about scrum timeboxing is correct?

Write a SQL statement to retrieve all of the records from the Acts table that have an ActGenre of 'Rock'.

Which relational database term is associated with a group of related fields that describe an individual instance of an entity?

Which type of SQL language interacts with data manipulation language when transactions are processed within the database and saved or undoes pending transactions?

Select the term that refers to the numeric relationship between data in one table and data in another table.

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