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;

Which SQL Statement Is Correct?

Skriv ut
Innebygd

Ledertavle

Visuell stil

Alternativer

Bytt mal

Gjenopprett automatisk lagring: ?