CISS 311 Final Prep - CH5-CH8

Which of the following SQL statements will delete all data in a table?

DELETE FROM TableName;

In .NET, to allow a ComboBox to access the data in a DataTable object, the object is assigned to the ______ property of the ComboBox.

Data

The _____ control of Windows Forms can display the data in tabular format and allow the users to freely make changes to the data.

DataGridView

A ______ object can be used to store a row of DataTable.

DataRow

In .NET, a ______ object can be used to store a table of in-memory data.

DataTable

Which of the following classes can be used to create an in-memory object to hold data retrieved from the database?

DataTable

Which method of SqlCommand class can execute an SQL INSERT statement?

ExecuteOnQuery

If a company's employee turnover rate is low, it is relatively easy to make changes to the culture.

False

Which of the following is NOT a strategy to tackle technical debt?

Hire experienced programmers to handle the technical debt

When all elements in an array are grouped, how can elements be displayed by groups?

It can be displayed with two foreach loops, one nested in the other.

The _______ is an attempt to have one query language for all types of data sources.

LINQ

The _____ is a technique that accomplishes the same task as an anonymous method but simpler.

Lambda expression

Using analysis software tools to identify hidden debt in the code or design and reporting to the whole team is the " ___ " strategy to tackle technical debt.

Make technical debt visible and explicit to the whole team

Technical debt is often the result of the balance between software quality and the business reality. This describes the " ____ " strategy to tackle technical debt.

Manage the expectations of the managers

Which SQL statement correctly join two tables together?

SELECT* FROM Table1 JOIN Table2 ON Table1.CommomColumn = Table2.CommonColumn;

To connect a Windows Form Application to a data source, a connection string is necessary. Name the location where the string is saved.

Settings.settings

One way to execute SQL statements from the C# application to the SQL Server is by using an instance of ______ class.

SqlDataAdapter

Which of the following is a factor that influences what to document?

Stakeholders' needs

What are the two meanings of "what to document"?

Type of document and how detailed

One drawback of documentation at the beginning of the project is ____.

Uncertainty

In .NET, use a ComboBox's ______ property for values communicated between the application and data source.

ValueMember

When taking out a loan to buy a house, you have to pay back the bank ___ you took out.

a larger amount than

One of the purposes for documentation is for _______ sharing and avoiding _______ loss in an organization.

knowledge, knowledge

All extension methods must be inside a(n) ____ class.

static

Suppose there is a DataTable object called studentTable. Which of the following shows the first row of the table?

studentTable.Rows[0]

In relational database structure, a database is made up of one or more _______.

tables

When setting up a connection for a local SQL Server, the server name for local SQL Server is

(localdb)\MSSQLLocalDB

One way to issue SQL statements from the C# application to the SQL Server is by using the _____ class.

Command

"You don't want to eliminate all technical debt at all costs" is an example of the " ____ " strategy to tackle technical debt.

Conduct a risk analysis

If you want to retrieve data from a database called "AdvisingDB," you need to get the ____ property of the AdvisingDB database.

ConnectionString

In .NET, a SqlDataAdapter has a ______ method that can be used to populate data retrieved from the database into a DataTable object.

Fill

The data source used in this chapter is

Microsoft SQL Server

Which of the following properties can return the number of rows in a DataTable object?

Rows.Count

When setting up a connection between the Windows Form application and the SQL Server database, the ______ package provides all necessary types for handling configuration data.

System.Data.SqlClient

One drawback for citing documents at the end of the project is that ____.

Team members may not recall what they did, and some members are not the same as when the project started

Which of the following is NOT an aspect of agile culture?

team velocity

Which of the following systems may require more detailed documentation?

A difficult-to-use system

In some cases, when declaring a local variable, you don't have to explicitly use a data type. Instead, ____ keyword can be used for data type.

var

Which of the following is the correct way to group an array of students by gender using LINQ?

var query = from student in students group by student.Gender;

Suppose a table in the database is called Student. The table has two columns: an ID column and a FirstName column. Write an SQL statement that will change a student's first name from Brown to Lynn. We also know that the student ID is 3.

UPDATE Student SET FirstName ="Lynn" WHERE ID = 3;

Suppose there is a DataRow object called dr and the table has a column called firstName. Which of the following shows the first name of the student in the row?

dr["firstName"].ToString()

The _____ dimension of technical debt focuses on the technology change over time.

evolution

Technical debt can be understood along two dimensions: _____.

evolution and quality

A(n) ____ method allows you to add a method to an existing type without modifying its source code.

extension

Organizations with which of the following cultural factors will use agile software development methodology for more projects?

feedback and learning

In a simple LINQ query, the data source is located in which clause?

from

According to the four values of the Agile Manifesto, documentation is ____.

good for organizational knowledge

In C#, if a local variable is declared like this: var a; The variable a will _____.

have a compiler error

The purpose of a(n) _____ method is that when an instance of a delegate is declared, a method can be assigned immediately.

anonymous

The ______ is a convenient way to create an object with a set of read-only properties without having to explicitly define the class.

anonymous type

One problem with a query language such as SQL is that _____.

applications are tightly coupled with the structure of the data

A SqlCommandBuilder class can be used to ______.

automatically generate SQL command for SQL Server

Which of the following is NOT an action of a LINQ query operation?

close the connection.

Examples of ___ include lines of code, code duplication, number of parameters and dependencies.

code complexity

In agile practice, an open office layout enhances _____.

communication

One of the major differences between agile software development and the waterfall approach is the

culture

The leadership, belief, value, and knowledge of a group of people that influence the behavior and actions of the group or its environment defines _____.

culture

Agile ___ and agile ___ are closely related to each other.

culture, values

A method can be created without a name if it is assigned to an instance of a(n) ___ immediately.

delegate

Organizations with which of the following cultural factors will use agile software development methodology for more projects?

democratic leadership style

Time tracking among stakeholders with different backgrounds is difficult without appropriate _____.

documentation

Which of the following is NOT a cause of technical debt?

inadequate lines of code

If a local variable is declared like this: var a = 5 ; The variable a will be compiled as ___ type.

int

Organizations with which of the following cultural factors will use agile software development methodology for more projects?

managers are like facilitators and mentors

If the team has members across the globe, ____ documentation is needed compared to a team located in the same room.

more

Many waterfall project managers like documentation at the beginning of the project, which makes them feel ____.

more secure

In .NET, the Parameter property of SqlCommand class has a _____ method that can be used to fill the parameter value in the SQL statement.

AddWithValue

Why can inadequate documentation cause technical debt?

BOTH Because it can cause trouble if the main developer leaves the team while the project is still in progress. AND Because the code can be hard to understand at the maintenance time.

The ______ software is used to handle databases much like a word processor is used to handle your term paper.

DBMS (Database Management System)

Which SQL statement is used to delete a record (not all records) in a table?

DELETE FROM TableName WHERE condition;

In .NET, use a ComboBox's ______ property to show a value to the user.

DisplayMember

Which of the following is the most popular time for writing documents for an Agile team?

Document as we go

Which of the following is a concern for too much documentation in an Agile team?

Documentation may easily get lost.

Compare a system for a bank and a website for a small business. Which one requires more documentation?

The bank

One advantage of documenting at the end of the project is that ____.

The team can focus on the software development throughout the project

In _____ culture, people work more like craftsmen where each person is trusted to do whatever he or she believes is good for the project.

agile

Write a Lambda expression to pick multiple of fives from a list collection called numbers and store them in a variable called num.

num = numbers.where(x => x % 5 == 0);

Which of the statements is correct about the following LINQ query? var numQuery = from num in numbers where (num % 2) == 0 select num;

numQuery is just a query without any numbers.

When joining two data sources into one data source based on certain conditions, the conditions should be in the ______ clause.

on

The result of the LINQ query can be sorted with _____ clause.

orderby

Technical debt is like financial debt that you have to pay back with a larger amount: _____.

principal plus interests

The ____ dimension of technical debt is about the code.

quality

In relational database structure, a table is made up of _____.

rows and columns

If you want to have certain fields from the LINQ join result data source, you can use _____ clause.

select

Which of the following is NOT a cause of technical debt?

simple architecture

Which of the following is NOT a key success factor for implementing agile software development?

standard

A _____ is the way the development team chooses to develop the software that may cause problems later on in order to meet the deadline or for other reasons.

technical debt

A defect in a small piece of software that is not fully tested can cause major problems in the larger component later on is an example of _____.

technical test debt

Culture is something that takes _____ and _____ to build and change.

time, efforts

In the ______ culture, people follow management science principles where each person's work is well defined and the person should follow the standardized process.

traditional

Organizations with which of the following cultural factors will use agile software development methodology for more projects?

trustful social interactions

When data from two tables are needed, ______ .

two tables should be JOINED into one table