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...
Which of the following lines of code accesses the second element of the first array in a two-dimensional array of integers, numbers, and stores the result in a variable called num?
a)``` num = numbers[1][2]; ``` b)``` num = numbers[0][1]; ``` c)``` num = numbers.getElement(1, 2); ``` d)``` num = numbers.getElement(0, 1); ``` e)``` none of the above are correct ```
You can explode only one pie slice in a pie chart.?
Answer the following statement true (T) or false (F)
Once an entry point has been located by the switch statement further case evaluations will continue.
Answer the following statement true (T) or false (F)
Which file is created when you select Enable Boot Logging from the Advanced Boot Options menu and restart your system?
a. bootlog.txt b. event.log c. ntbtlog.txt d. BCD Store