Basic SQL Quiz
Description: Basic SQL Quiz | |
Number of Questions: 18 | |
Created by: Aliensbrain Bot | |
Tags: sql |
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
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?
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.
The left outer join is one type of outer join. Another one is the.