Q&A Hero

Q: A class containsor, in OOP terms, it ____all of the attributes and behaviors of the object it instantiates. a. encapsulates b. exposes c. collapses d. implements

Q: ____ are the actions to which an object can respond. a. Actions b. Behaviors c. Events d. Instances

Q: ____ are the operations (actions) that the object is capable of performing. a. Instances b. Behaviors c. Events d. Methods

Q: Every object has ____, which are the characteristics that describe the object. a. properties b. attributes c. parts d. elements

Q: Every object used in an object-oriented program is created from a ____, which is a pattern that the computer uses to create the object. a. class b. basic type c. structure d. template

Q: The real advantage of object-oriented programming is the ability to reuse a classfor example, use it in a different way or in a different application.

Q: The ____ operator returns the smallest value in the group. a. Max b. Smallest c. Min d. Minimum

Q: The ____ operator returns the total of the values in the group. a. Total b. Sum c. Calc d. Add

Q: The LINQ ____ operator returns a single value from a group of values. a. collect b. collapse c. integrate d. aggregate

Q: The basic syntax for assigning a LINQ variable's contents to a BindingSource object is ____. a. DataSource.bindingSource = AsDataView.variableName b. DataSource.bindingSource = variableName.AsDataView c. bindingSource.DataSource = AsDataView.variableName d. bindingSource.DataSource = variableName.AsDataView

Q: The basic syntax to use the LINQ to select and arrange records in a data set is ____. a. Dim variableName = In dataset.table From elementName b. Dim variableName = From elementName In dataset.table c. Dim In dataset.table From elementName = variableName d. Dim From elementName In dataset.table = variableName

Q: In a query, the ____ clause is used to sort the records in either ascending (the default) or descending order by one or more fields. a. Order By b. Select c. From d. Where

Q: Similar to the condition in If"¦Then"¦Else and Do"¦Loop statements, the ____ clause specifies a requirement that must be met for a record to be selected. a. Select b. Where c. From d. Order By

Q: In a query, the ____ clause is used to specify the records you want to select in the dataset. a. Select b. From c. Where d. Order

Q: You can create a query in Visual Basic 2012 using a language feature called ____. a. Integrated Language Query b. Language Query c. Structured Language d. Language Integrated Query

Q: You use a(n) ____ to specify both the records to select in a dataset and the order in which to arrange the records. a. query b. question c. inquiry d. access

Q: The Total operator returns the sum of the values in the group.

Q: The only calculations that are performed using the LINQ aggregate methods are Average and Count.

Q: In addition to using LINQ to sort and select the records in a dataset, you also can use it to perform arithmetic calculations on the fields in the records.

Q: The LINQ statement merely selects the records but does not assign them to the records variable.

Q: If you are sorting records in ascending order, you need to include the keyword Ascending in the Order By clause.

Q: The following syntax selects all of the records in the dataset: Dim records = From employee In EmployeesDataSet.tblEmploy Select employee

Q: In a query, the Where and Order By clauses are optional parts of the syntax.

Q: The syntax for LINQ requires you to specify the variable's data type.

Q: A dataset is stored in the computer's internal memory while the application is running.

Q: A dataset is a copy of the fields and records the application can access from a database.

Q: You can use the BindingSource object's ____ methods to move the record pointer to the first, last, next, or previous record in the dataset. a. Move b. Point c. MoveRecord d. Pointer

Q: The BindingSource object stores the position of the record pointer in the object's ____ property. a. PlaceHolder b. RecordPosition c. RecordPointer d. Position

Q: The way Visual Basic saves changes to a local database file is determined by the file's ____ property. a. Output Section b. Copy to Production c. Output Directory d. Copy to Output Directory

Q: You can use the ____ statement to handle exceptions that occur while an application is running. a.Error…Catchb.Try…Catch c.Error…Blockd.Try…Block

Q: An error that occurs while an application is running is called a(n) ____. a. bug b. runtime upset c. exception d. inception

Q: A form's ____ event procedure uses the TableAdapter object's Fill method to retrieve the data from the database and store it in the DataSet object. a. Show b. Load c. Displayed d. OnScreen

Q: The ____ property determine the way the column widths are sized in the DataGridView control. a. AutoSizeColumns b. AutoResizeMode c. AutoSizeColumnsMode d. AutoResizeColumns

Q: The ____ stores objects that do not appear in the user interface while an application is running. a. component tray b. task list c. menu tray d. object tray

Q: Connecting an object to a control is called ____. a. attaching b. bonding c. binding d. attachment

Q: In most tables, one of the fields that uniquely identifies each record and is called the ____. a. primary key b. secondary key c. indexed key d. key value

Q: A group of related records is called a ____. a. relation b. table c. collection d. related entity

Q: A(n) ____ is a group of related fields that contain all of the necessary data about a specific person, place, or thing. a. file b. entity c. record d. field

Q: A(n) ____ is a single item of information about a person, place, or thing. a. file b. entity c. record d. field

Q: A ____ stores information in tables composed of columns and rows, similar to the format used in a spreadsheet. a. relational database b. relational computer c. relational base d. relational data

Q: A ____ is an electronic file that contains an organized collection of related information. a. computer list b. computer database c. computer record d. computer sheet

Q: You cannot bind an object in a dataset to an existing control on the form.

Q:

Q: When an exception occurs in the Catch block's code, the computer processes the code contained in the Try block.

Q: If you do not take deliberate steps in your code to handle the exceptions, Visual Basic handles them for you.

Q: In most applications, the code to fill a dataset with data belongs in the form's Fill event procedure.

Q: The intersection of a row and column in a DataGridView control is called a cell.

Q: The BindingSource object provides the connection between the DataSet and the bound controls on a form.

Q: The BindingNavigator control can only be used to add, delete, and save records.

Q: A TableLayoutView control displays data in a row and columnar format, similar to a spreadsheet.

Q: A Dataset is a copy of the data that can be accessed by an application.

Q: You can display the data in a relational database in any order.

Q: Parent and child tables in a database are referred to as owner and detail tables, respectively.

Q: The field used to link a child table to a parent table is called the Foreign key.

Q: A relational database can contain one or more tables.

Q: In order to maintain accurate records, most businesses store information about their employees, customers, and inventory in Excel spreadsheets.

Q: You also can include a range of values in a character list by using a(n) ____ to separate the lowest value in the range from the highest value in the range. a. hyphen b. apostrophe c. equal sign d. plus sign

Q: The ____ operator allows you to use pattern-matching characters to determine whether one string is equal to another string. a. Similar b. Comparable c. HasSimilarity d. Like

Q: The syntax of the Remove method is ____. a. Remove.string(startIndex[, numCharsToRemove]) b. string.Remove(numCharsToAccess,startIndex) c. string.Remove(startIndex[, numCharsToRemove]) d. string.Remove([numCharsToAccess],startIndex)

Q: You can use the Remove method to remove a specified number of characters located anywhere in a string. a. Erase b. Replace c. Remove d. Delete

Q: The syntax for the substring method is ____. a. Substring.string(startIndex) b. string.Substring(startIndex[, numCharsToAccess]) c. string.Substring(numCharsToAccess,startIndex) d. string.Substring([numCharsToAccess],startIndex)

Q: Visual Basic provides the ____ method for accessing any number of characters contained in a string. a. Portion b. PartialString c. Substring d. PieceString

Q: The syntax of the IndexOf method is ____. a. string.IndexOf(subString[, startIndex]) b. string.IndexOf.subString c. subString.IndexOf(string) d. string.IndexOf(startIndex, subString)

Q: You can use the ____ method to search a string to determine whether it contains a specific sequence of characters. a. IndexOf b. Index c. Location d. Locate

Q: The syntax of the insert method is ____. a. string.Insert(value,startIndex) b. Insert(startIndex,value).string c. string.Insert(value).startIndex d. string.Insert(startIndex, value)

Q: You insert characters using the ____ method. a. Insert b. InStr c. Input d. InsertInto

Q: The syntax for the trim method is ____. a. Trim.string b. string.Trim c. string.TrimMethod d. trim(string)

Q: You can use the ____ method to remove any spaces from both the beginning and end of a string. a. Clean b. CleanWhiteSpace c. Cut d. Trim

Q: The syntax of the length property is ____. a. string.Length b. Length(string) c. Length.string d. string.Len

Q: The number of characters contained in a string is stored in the string's ____ property. a. Size b. Len c. Length d. StringLength

Q: The Like operator evaluates to True when the string matches the pattern.

Q: You can use the RemoveIt method to remove the dashes from a Social Security number, the leading zeroes from a policy number, or the middle initial from a name.

Q: You can use the Substring method to display only the string's first five characters.

Q: The startIndex argument is not optional in the IndexOf method's syntax.

Q: A possible use for the Index method includes determining whether the area code "(312)" appears in a phone number.

Q: The first character in a string has an index of 1.

Q: When processing the Insert method, the computer makes a temporary copy of the string in memory, and then inserts the characters in the copy only.

Q: Using the Insert method to insert a value beginning with the fifth character in a string, you use a starting index of 5.

Q: Visual Basic provides the Replace method for replacing a sequence of characters in a string with another sequence of characters.

Q: The Trim method returns a string that excludes any leading or trailing spaces.