Which of the following SQL statements will return only the student name and GPA from the Student table for all students having a GPA that is greater than or equal to 3.5?
a. SELECT Name, GPA FROM Student WHERE GPA >=3.5
b. SELECT * FROM Student WHERE GPA >= 3.5
c. SELECT Name, Number, GPA, CumHrs FROM Student WHERE GPA >= 3.5
d. SELECT Student WHERE GPA >= 3.5 And Name, GPA
a. SELECT Name, GPA FROM Student WHERE GPA >=3.5
You might also like to view...
A database administrator uses the ____ option to open the database prior to setting a password or database security.
A. Open Read-Only B. Open Exclusive C. Open D. Open Exclusive Read-Only
Write a sed program named ins that copies a file to standard output, chang- ing all occurrences of cat to dog and preceding each modified line with a line that says following line is modified:
What will be an ideal response?
Match the following data types with their descriptions:
I. Currency II. Decimal III. Number calculations IV. Date/Time V. Text A. Date and time values for the years 100 through 9999 B. Numeric data used in mathematical calculations C. Text and numbers that don't require calculations D. Numeric data that stores numbers from -10^38-1 through 10^38-1 E. Numeric data that involves data with one to four decimal places
Match the following data types to their examples:
I. AutoNumber II. Long Text III. Attachment IV. OLE Object V. Short Text A. a business letter created in Word B. JPG image of a lake C. 2020 Flanders St. D. description of new car for sale E. 1, 2, 3