Question

Files that are read by the computer are called ____ files.

	a.	report
	b.	serial
	c.	input
	d.	storage The database for a pet supply company includes the following table, named tblCollar, that contains product data for pet collars. The ItemDesc and Color fields contain text. The ItemNum, Price, and Quantity fields contain numbers. ItemNum ItemDesc Color Price Quantity 2358 leather studded collar black 30.00 35 2693 leather collar brown 25.00 25 3547 striped collar red 20.00 75 3855 striped collar blue 15.00 42 3764 striped collar green 15.00 48 5782 solid collar pink 12.00 36 5785 solid collar red 12.00 10 5787 solid collar blue 10.00 15 Which of the following statements would select the ItemDesc and Price fields from tblCollar for all records whose ItemDesc field begins with the word “leather” followed by zero or more characters? a. SELECT ItemDesk FROM tblCollar      WHERE ItemDesc LIKE 'leather %' b. GET ItemDesc, Price FROM tblCollar     WHERE ItemDesc LIKE 'leather %' c. SELECT ItemDesc, Price FROM tblCollar     WHERE ItemDesc LIKE 'leather %' d. SELECT ItemDesc, Price FROM tblCollar     WHERE ItemDesc LIKE leather % The ____ statement is used for exception handling in a procedure. a. aggregate b. Try…Catch c. ORDER BY d. LINQ A(n)____ function returns a single value from a group of values. a. WHERE b. Calculate c. Aggregate d. Parameter Visual Basic’s auto-implemented properties feature enables you to ____. a. add validation code to the set block b. make the property ReadOnly c. make the property WriteOnly d. specify the property of a class in one line of code are the actions to which an object can respond. a. Methods b. Behaviors c. Events d. Attributes

Answer 1

1. Files that are read by the computer are called ____ files.

   	a.	report
   	b.	serial
   	c.	input
   	d.	storage

   Answer: c. input

2. The database for a pet supply company includes the following table, named tblCollar, that contains product data for pet collars. The ItemDesc and Color fields contain text. The ItemNum, Price, and Quantity fields contain numbers.

   ItemNum	ItemDesc	Color	Price	Quantity
   2358	leather studded collar	black	30.00	35
   2693	leather collar	brown	25.00	25
   3547	striped collar	red	20.00	75
   3855	striped collar	blue	15.00	42
   3764	striped collar	green	15.00	48
   5782	solid collar	pink	12.00	36
   5785	solid collar	red	12.00	10
   5787	solid collar	blue	10.00	15

   Which of the following statements would select the ItemDesc and Price fields from tblCollar for all records whose ItemDesc field begins with the word “leather” followed by zero or more characters?

   	a.	SELECT ItemDesk FROM tblCollar      WHERE ItemDesc LIKE 'leather %'
   	b.	GET ItemDesc, Price FROM tblCollar     WHERE ItemDesc LIKE 'leather %'
   	c.	SELECT ItemDesc, Price FROM tblCollar     WHERE ItemDesc LIKE 'leather %'
   	d.	SELECT ItemDesc, Price FROM tblCollar     WHERE ItemDesc LIKE leather %

   Answer:

   c.	SELECT ItemDesc, Price FROM tblCollar     WHERE ItemDesc LIKE 'leather %'

   Explanation: Here we have to print ItemDesc and Price from tblCollar and ItemDesc should start with leather and after that it may have zero or more occurences of other characters. As the ItemDesc field is of type - text, hence the word should be within quotes and the % as in 'leather%' determines zero or more occurences of character after the characters 'leather'.

3. The ____ statement is used for exception handling in a procedure.

   	a.	aggregate
   	b.	Try…Catch
   	c.	ORDER BY
   	d.	LINQ

   Answer: b. Try...Catch (Explanation: In a try catch statement, the statements you want to be executed are put inside the try block. If the procedure fails to execute those statement then the exception is thrown to the catch block. Inside the catch block, you may mention a statement which prints the error message or do some other operation.

4. A(n)____ function returns a single value from a group of values.

   	a.	WHERE
   	b.	Calculate
   	c.	Aggregate
   	d.	Parameter

   Answer: c. Aggregate (Explanation: Aggregate functions return a single value, calculated from values in a column. They take a set of values as their argument. Aggregate functions are also called set functions. A basic aggregate function returns a single value by aggregating mulitple rows of data.)

5. Visual Basic’s auto-implemented properties feature enables you to ____.

   	a.	add validation code to the set block
   	b.	make the property ReadOnly
   	c.	make the property WriteOnly
   	d.	specify the property of a class in one line of code

   Answer: d. specify the property of a class in one line of code

6. ______ are the actions to which an object can respond.

   	a.	Methods
   	b.	Behaviors
   	c.	Events
   	d.	Attributes

   Answer: c. Events