Shortcut Navigation:

SQL Quiz

What does SQL stand for?

Which SQL statement is used to extract data from a database?

Which SQL statement is used to update data in a database?

Which SQL statement is used to delete data from a database?

Which SQL statement is used to insert new data in a database?

With SQL, how do you select a column named "FirstName" from a table named "Persons"?

With SQL, how do you select all the columns from a table named "Persons"?

With SQL, how do you select all the records from a table named "Persons" where the value of the column "FirstName" is "Peter"?

With SQL, how do you select all the records from a table named "Persons" where the value of the column "FirstName" starts with an "a"?

The OR operator displays a record if ANY conditions listed are true. The AND operator displays a record if ALL of the conditions listed are true

With SQL, how do you select all the records from a table named "Persons" where the "FirstName" is "Peter" and the "LastName" is "Jackson"?

With SQL, how do you select all the records from a table named "Persons" where the "LastName" is alphabetically between (and including) "Hansen" and "Pettersen"?

Which SQL statement is used to return only different values?

Which SQL keyword is used to sort the result-set?

With SQL, how can you return all the records from a table named "Persons" sorted descending by "FirstName"?

With SQL, how can you insert a new record into the "Persons" table?

With SQL, how can you insert "Olsen" as the "LastName" in the "Persons" table?

How can you change "Hansen" into "Nilsen" in the "LastName" column in the Persons table?

With SQL, how can you delete the records where the "FirstName" is "Peter" in the Persons Table?

With SQL, how can you return the number of records in the "Persons" table?

Given an employees table as follows: empid name managerid a1 bob NULL b1 jim a1 B2 tom a1 What value will select count(*) from employees return?

The result of a SELECT statement can contain duplicate rows.

Sometimes the expression "select count(*)" will return fewer rows than the expression "select count(value)".

What type of lock will deny users any access to a table?

Which of the following is the correct SQL statement to use to remove rows from a table?

The only way to join two tables is by using standard, ANSI syntax.

A NULL value is treated as a blank or 0.

Tagged as: expression select count, expression select count, sql statement, expression select count, expression select count, sql statement, sql
Home | About | Create | Register | Privacy | Terms | Sitemap | [Facebook] [Twitter] [Google+]