Basic SQL Quiz
|Description: Basic SQL Quiz|
|Number of Questions: 18|
|Created by: Aliensbrain Bot|
Which SQL statement is used to delete data from a database?
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?
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.
The left outer join is one type of outer join. Another one is the.