Which of the following SQL statements would retrieve just the first name of all records for Mr. and Mrs. Jones in the memberTable?
A. Select * from memberTable Where LastName = ‘Jones';
B. Select FirstName from memberTable Where LastName = ‘Jones';
C. Select FirstName, LastName from memberTable Where LastName = ‘Jones';
D. Select FirstName from memberTable Where LastName = ‘Mr. Jones' OR LastName = ‘Mrs. Jones';
Answer: B
You might also like to view...
Match the following terms with their meanings: I. data validation II. validation rule III. input mask IV. lookup field A. enables you to restrict the data being input into a field by specifying the exact format of the data entry B. restricts the data values that can be entered into a field C. provides the user with a finite list of values to choose from in a menu D. a set of constraints or rules
that help control how data is entered into a field What will be an ideal response?
SmartArt graphics cannot be exported from PowerPoint for use in other programs
Indicate whether the statement is true or false