1) Which SQL Statement Is Correct? a) SELECT forename and surname FROM Golfer b) SELECT forename, surname FROM Golfer; c) SELECT FROM forename, surname "Golfer"; d) SELECT forename, surname FROM "Golfer"; 2) Which SQL SELECT Statement is correct? a) SELECT FROM Movies WHERE Length >= 110; b) SELECT * FROM Movies WHERE Length => 110; c) SELECT * FROM Movies WHERE Length >= 110; d) SELECT Name FROM Movies WHERE Length >= "110"; 3) Which SQL SELECT Statement is correct? a) SELECT * FROM Movies WHERE Certificate = 15 ORDER BY DESC; b) SELECT * FROM Movies WHERE Certificate = "15" ORDER BY Type DESC; c) SELECT Name and Type FROM Movies WHERE Certificate = 15 ORDER BY Type DESC; d) SELECT * FROM Movies WHERE Certificate = 15 ORDER BY Type DESC; 4) Which SQL SELECT Statement is correct? a) SELECT forename, surname FROM Golfer WHERE age = "Senior" OR age = "Junior"; b) SELECT FROM Golfer WHERE age = "Senior" OR age = "Junior"; c) SELECT forename, surname FROM Golfer WHERE age = "Senior" OR = "Junior"; d) SELECT forename, surname FROM Golfer WHERE age = "Senior", "Junior"; 5) Which SQL SELECT Statement is correct? a) SELECT Name, Type FROM Movies WHERE Certificate = 18 ORDER BY ASC; b) SELECT Name, Type FROM Movies WHERE Certificate = 18 ORDER BY Name Ascending; c) SELECT Name, Type FROM Movies WHERE Certificate = 18 ORDER BY Name ASC; d) SELECT Name, Certificate, and Type FROM Movies WHERE Certificate = 18 ORDER BY Name ASC; 6) Which SQL SELECT Statement is Correct? a) SELECT * FROM Teachers WHERE subject = Computing; b) SELECT * FROM Teachers WHERE subject = "Computing"; c) SELECT FROM Teachers WHERE subject = "Computing"; d) SELECT * FROM Teachers WHER subject = "Computing"; 7) Which SQL SELECT Statement is Correct? a) SELECT email, name FROM Students WHERE year = "S3"; b) SELECT FROM Students WHERE year = "S3"; c) SELECT email, name FROM Students WHERE year = S3; d) SELECT email, name FROM Students WHERE year = "S3" AND year = "S4"; 8) Which SQL SELECT Statement is Correct? a) SELECT * FROM Students WHERE House = "Purple" OR = "Red"; b) SELECT * FROM Students WHERE House = "Purple" AND House = "Red"; c) SELECT * FROM Students WHERE House = "Purple" OR House = "Red"; d) SELECT * FROM Students WHERE House = Purple OR House = Red; 9) Which SQL SELECT Statement is Correct? a) SELECT bikeID, bikeBrand, bikeCost FROM Bikes WHERE bikeCost >= "200"; b) SELECT bikeID, bikeBrand, bikeCost FRM Bikes WHERE bikeCost >= 200; c) SELECT bikeID, bikeBrand, bikeCost FROM Bikes WHERE bikeCost => 200; d) SELECT bikeID, bikeBrand, bikeCost FROM Bikes WHERE bikeCost >= 200; 10) Which SQL SELECT Statement is Correct? a) SELECT * FROM Restaurants WHERE type = "Sichuan" ORDER BY Name DESC; b) SELECT * FROM Restaurants WHERE type = "Sichuan" ORDER BY Name Descending; c) SELECT FROM Restaurants WHERE type = "Sichuan" ORDER BY Name DESC; d) SELECT * FROM Restaurants WHERE type is "Sichuan" ORDER BY Name DESC;
0%
Which SQL Statement Is Correct?
Share
Share
Share
by
Millercomputing
I-edit ang Content
I-Print kini
Embed
Uban pa
Assignments
Leaderboard
Show more
Show less
Kini nga leaderboard naka-pribado. Pag-klik sa
Share
aron himuon kini nga publiko.
Kini nga leaderboard gi-disable sa tag-iya sa resource.
Kini nga leaderboard gi-disable tungod ang imong mga kapilian lahi ra sa tag-iya sa resource.
I-revert ang mga Kapilian
Ang
Quiz
usa ka open-ended nga template. Dili kini makamugna ug mga marka sa leaderboard.
Kinahanglan mag log in
Visual style
Fonts
Subscription required
Mga Option
I-switch ang template
Ipakita tanan
Daghang mga format ang mugawas samtang gidula nimo ang activity.
Open results
Copy link
QR code
Mag-delete
I-restore ang gi-autosave:
?
