SQL SELECT

Which statement will show all fields and records from the table called "celebs"?

• SELECT * FROM celebs;

• SELECT FROM celebs;

• SELECT forename, surname FROM celebs;

• SELECT celebs;

The SQL statement being run is:

SELECT player_name, score FROM leaderboard;

What is the name of the table in this query?

• SELECT

• player_name

• score

• leaderboard

The SQL statement being run is:

SELECT player_name, score FROM leaderboard;

How many columns of results will be shown when this query is run?

• 0

• 1

• 2

• 3

Which SQL statement will show the names and heights of all basketball players taller than 200?

• SELECT name FROM Player WHERE height >200;

• SELECT name FROM Player WHERE height >=200;

• SELECT name, height FROM Player WHERE height >200;

• SELECT name, height FROM Player WHERE height <200;

Which SQL statement will show the names and weights of all wrestlers lighter than 170?

• SELECT name, weight FROM Wrestler WHERE weight >170;

• SELECT name, weight FROM Wrestler WHERE weight <= 170;

• SELECT name, weight FROM Wrestler WHERE weight <170;

• SELECT name, weight FROM Wrestler WHERE weight >=170;

Which character always appears at the end of a SQL statement?

• ;

• :

• ,

• .

Which of these statements will show all wrestlers sorted from the heaviest to the lightest?

• SELECT * FROM Wrestler WHERE weight <170;

• SELECT * FROM Wrestler WHERE weight >170;

• SELECT * FROM Wrestler ORDER BY weight ASC;

• SELECT * FROM Wrestler ORDER BY weight DESC;

Which of these statements will show all wrestlers in alphabetical order of their name

• SELECT * FROM Wrestler ORDER BY name ASC;

• SELECT * FROM Wrestler ORDER BY name DESC;

• SELECT * FROM Wrestler ORDER BY weight ASC;

• SELECT * FROM Wrestler ORDER BY weight DESC;

Which SQL statement will show the names and heights of all basketball players sorted from smallest to tallest?

• SELECT name FROM Player ORDER BY height ASC;

• SELECT name FROM Player ORDER BY height DESC;

• SELECT name, height FROM Player ORDER BY height ASC;

• SELECT name, height FROM Player ORDER BY height DESC;

The SQL statement that was run was:

SELECT username, score FROM Player WHERE score>900;

The results were:

andy_pandy_12 911

aleeyah_nasoor_09 920

new_slang 907

utter_mess 901

How many records were returned in the query results?

• 2

• 3

• 4

• 8