Q&A Hero

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.

Q: The Trim method removes characters from the original string.

Q: The StringLength property stores an integer that represents the number of characters contained in a String.

Q: If an application expects the user to enter a seven-digit phone number or a five-digit ZIP code, the application's code should verify that the user entered the required number of characters.

Q: Applications rarely need to manipulate (process) string data.

Q: The syntax of the Peek method is ____. a. streamReaderVariableName.Peekaboo b. Peek.streamReaderVariableName c. streamReaderVariableName.Peek d. Peek(streamReaderVariableName)

Q: A ____ is defined as a sequence (stream) of characters followed by the newline character. a. line b. row c. column d. string

Q: The ____ method can be used to read a file's contents, one line at a time. a. Read b. ReadLine c. ReadInputLine d. ReadInput

Q: The syntax for determining whether a sequential access file exists is ____. a. IO.Exists(fileName) b. IO.(fileName).Exists() c. IO.File.Exists(fileName) d. IO.File(fileName).Exists

Q: The ____ method returns the Boolean value True if the file exists; otherwise, it returns the Boolean value False. a. IsThere b. CanFind c. DoesExist d. Exists

Q: After declaring a StreamReader variable, you can use the ____ method to open a sequential access file for input, which automatically creates a StreamReader object. a. ReadText b. InputText c. GetText d. OpenText

Q: The syntax to close a sequential access file associated with a StreamWriter object is ____. a. streamWriterVariableName.Close() b. streamWriterVariableName.FileClose() c. streamWriterVariableName.CloseFile() d. Close.streamWriterVariableName(data)

Q: If the file to be opened exists, the ____ method writes new data after any existing data in the file. a. InsertText b. AppendText c. CreateText d. AddText

Q: You use the ____ method to create a new, empty sequential access file to which data can be written. a. OpenText b. AppendText c. CreateText d. NewText

Q: The syntax for declaring a streamwriter variable is ____. a. [Dim | Private] streamWriterVariableName As IO.StreamWriter b. {Dim | Private} streamWriterVariableName As IO.StreamWriter c. {Dim | Private} streamWriterVariableName As IO.StreamWriteObject d. Private streamWriterVariableName As IO.StreamWriter

Q: In Visual Basic, you use a ____ object to write a stream of characters to a sequential access file. a. StreamReader b. StreamWriteObject c. StreamWriter d. StreamReadWriteObject

Q: Programmers refer to a sequence of characters as a(n) ____. a. array stream b. bytestream c. flow d. stream of characters

Q: Most input and output files are referred to as ____ files. a. sequential access b. random access c. any access d. serial access

Q: Files that are read by the computer are called ____ files. a. output b. readOnly c. writeOnly d. input

Q: Files to which data is written are called ____ files. a. input b. output c. writeOnly d. readOnly

Q: The Peek method determines whether a file contains another character to read.

Q: In most cases, an application will need to read each line of text contained in a sequential access file, one line at a time.

Q: The ReadLine method requires you to provide the file's name.

Q: In most cases, you assign the string returned by the ReadLine method to a String variable.

Q: The ReadLine method returns a string that contains the sequence of characters in the current line, including the newline character at the end of the line.