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