SQL-PHP-Login

What does SQL stand for?

• SQL

• Structured Query Language

• Static Query Language

• Structure Query Language

What does a Relationship do within a database?

• It reduces data redundancy by linking fields in different tables.
• It shows which users in a database are related.
• It increases data redundancy by linking fields in different tables.
• The fields are the vertical columns in a table.

What word is missing from the line below?
SELECT *
_______ CUSTOMER;

• FROM
• WHERE
• SELECT
• ORDER BY

Which SQL query would display all pupils details who have the surname Smith?

• SELECT surname FROM Pupils WHERE Smith

• SELECT * FROM Pupils WHERE surname = Smith

• SELECT * FROM Pupils WHERE surname = "Smith"

• SELECT * FROM Pupils

Which HTTP method is used for logout?

• GET

• POST

• PUT

• DELETE

How many fields are there?

• 4

• 5

• 6

• 7

How many records are in this table?

• 7

• 6

• 5

• 4

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;

What does “SQL” stand for?

• Standard Query Language.
• Structured Query Language.
• Structured Quick-access Language.
• Standard Questioning Language.

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;