SQL Quiz 1
What is the correct code to remove row 3 from the student table?
DELETE FROM student WHERE id=3;
Which code is the correct way to update the GPA for the student in row 7 from the student table?
UPDATE student SET GPA=3.5 WHERE id=7;
What is the best way to return the number of rows in the student table?
SELECT COUNT (*) FROM student;
What is the function of an AS clause?
to name a column
Which statement is true about selecting columns in SQL?
Column names must be separated by commas.
The _____ statement is used to remove rows from a table.
DELETE
What is the purpose of a foreign key?
Foreign keys refer to the primary key in another table to link the two tables together. Foreign keys define the relationship between two tables.
The _____ statement is used to add a row to a table
INSERT
How can a row of data be inserted into a table named Animals?
INSERT INTO Animals (Name, Age, Type) VALUES ('Fido', 10, 'Dog');
Which statement would generate the fifth record in the following table?
INSERT INTO customer (name, city, state) VALUES ('Jimi Hendrix', 'Renton', 'WA');
Which statement is true about removing rows from a table?
Remove existing rows from a table with the DELETE FROM statement
Which SQL statement allows you to retrieve data from a SQL database?
SELECT
What is an example of a query to get only data containing the word "Apple"?
SELECT * FROM Fruits WHERE Name = 'Apple';
Which code returns the first 10 students who have a 4.0 GPA from the Grade table ordered alphabetically?
SELECT * FROM Grade WHERE GPA=4.0 ORDER BY Name LIMIT 10;
What is the proper syntax for aliasing a field?
SELECT FirstName AS "First Name";
The WHERE clause is used with UPDATE to determine which rows are updated.
TRUE
You can query columns in any order.
TRUE
You can use the COUNT(*) function to count all the rows in a table.
TRUE
Which clauses allow you to get rows and columns from a table in the database?
The SELECT statement retrieves data from the database by easily selecting the rows and columns from a table.
If you use UPDATE and SET without a WHERE clause, what happens?
The entire table is updated.
The _____ clause is used with SELECT to filter rows.
WHERE
Which statement is true about inserting data to a table?
You must execute the select statement after the insert into statement to see the result with the added row.
An SQL statement is terminated with _____
a semicolon
The SELECT statement is used for _____
all queries
How do you specify the columns to be selected?
by name or column heading
In the statement SELECT * FROM Customers WHERE Age > 50;, what is the formal name for FROM Customers?
clause (It modifies the verb `SELECT`)
What is a PRIMARY KEY?
the unique key for a table when exposed as a column
In the statement COUNT(*), what does the * mean
to consider all rows