SQL Essential Training UPDATED
ACTUAL Questions and CORRECT
Answers
Statement - CORRECT ANSWER✔✔- the unit of execution
ex: SELECT ** FROM Countries WHERE Continent = 'Europe';
Clauses - CORRECT ANSWER✔✔- FROM, WHERE, etc.
What does the WHERE clause requirement? - CORRECT ANSWER✔✔- A logical
expression
ex: WHERE Countries = 'Europe;
What does CRUD stand for? - CORRECT ANSWER✔✔- Create Read Update Delete
What are databases for? - CORRECT ANSWER✔✔- Organizing and making data available
in different forms
Foreign Keys - CORRECT ANSWER✔✔- A column or group of columns used to represent
relationships. Values of the foreign key match values of the primary key in a different
(foreign) table.
How can a row of data be inserted into a table named Animals? - CORRECT ANSWER✔✔-
INSERT INTO Animals (Name, Age, Type)
VALUES ('Fido', 10, 'Dog');
If you use UPDATE and SET without a WHERE clause, what happens? - CORRECT
ANSWER✔✔- The entire table is updated
The ___ statement is used to add a row to a table - CORRECT ANSWER✔✔- INSERT
, The___statement is used to remove rows from a table - CORRECT ANSWER✔✔- DELETE
T/F: there WHERE clause is used with UPDATE to determine which rows are updated -
CORRECT ANSWER✔✔- True
An SQL statement is terminated with___ - CORRECT ANSWER✔✔- A semicolon
what is an example of a query to get only data containing the word "Apple"? - CORRECT
ANSWER✔✔- SELECT * FROM Fruits WHERE Name = 'Apple';
The ___ clause is used with SELECT to filter rows. - CORRECT ANSWER✔✔- WHERE
T/F: you can query columns in any order - CORRECT ANSWER✔✔- True
What is a PRIMARY KEY? - CORRECT ANSWER✔✔- the unique key for a table when
exposed as a column
What is the proper syntax for aliasing a field? - CORRECT ANSWER✔✔- SELECT
FirstName AS "First Name";
The SELECT statement is used for___ - CORRECT ANSWER✔✔- All queries
In the statement: SELECT * FROM Customers WHERE Age > 50; what is the formal name
for "FROM Customers"? - CORRECT ANSWER✔✔- clause, it modifies the verb 'SELECT'
How do you specify the columns to be selected? - CORRECT ANSWER✔✔- by name or
column heading
What is the function of the AS clause? - CORRECT ANSWER✔✔- to name a column
T/F: you can use the COUNT(*) function to count all the rows in a table - CORRECT
ANSWER✔✔- True
ACTUAL Questions and CORRECT
Answers
Statement - CORRECT ANSWER✔✔- the unit of execution
ex: SELECT ** FROM Countries WHERE Continent = 'Europe';
Clauses - CORRECT ANSWER✔✔- FROM, WHERE, etc.
What does the WHERE clause requirement? - CORRECT ANSWER✔✔- A logical
expression
ex: WHERE Countries = 'Europe;
What does CRUD stand for? - CORRECT ANSWER✔✔- Create Read Update Delete
What are databases for? - CORRECT ANSWER✔✔- Organizing and making data available
in different forms
Foreign Keys - CORRECT ANSWER✔✔- A column or group of columns used to represent
relationships. Values of the foreign key match values of the primary key in a different
(foreign) table.
How can a row of data be inserted into a table named Animals? - CORRECT ANSWER✔✔-
INSERT INTO Animals (Name, Age, Type)
VALUES ('Fido', 10, 'Dog');
If you use UPDATE and SET without a WHERE clause, what happens? - CORRECT
ANSWER✔✔- The entire table is updated
The ___ statement is used to add a row to a table - CORRECT ANSWER✔✔- INSERT
, The___statement is used to remove rows from a table - CORRECT ANSWER✔✔- DELETE
T/F: there WHERE clause is used with UPDATE to determine which rows are updated -
CORRECT ANSWER✔✔- True
An SQL statement is terminated with___ - CORRECT ANSWER✔✔- A semicolon
what is an example of a query to get only data containing the word "Apple"? - CORRECT
ANSWER✔✔- SELECT * FROM Fruits WHERE Name = 'Apple';
The ___ clause is used with SELECT to filter rows. - CORRECT ANSWER✔✔- WHERE
T/F: you can query columns in any order - CORRECT ANSWER✔✔- True
What is a PRIMARY KEY? - CORRECT ANSWER✔✔- the unique key for a table when
exposed as a column
What is the proper syntax for aliasing a field? - CORRECT ANSWER✔✔- SELECT
FirstName AS "First Name";
The SELECT statement is used for___ - CORRECT ANSWER✔✔- All queries
In the statement: SELECT * FROM Customers WHERE Age > 50; what is the formal name
for "FROM Customers"? - CORRECT ANSWER✔✔- clause, it modifies the verb 'SELECT'
How do you specify the columns to be selected? - CORRECT ANSWER✔✔- by name or
column heading
What is the function of the AS clause? - CORRECT ANSWER✔✔- to name a column
T/F: you can use the COUNT(*) function to count all the rows in a table - CORRECT
ANSWER✔✔- True
