Multiple choice technology databases

The Correct Statement to select a column named "LastName" from a table named "Employee".

  1. SELECT LastName FROM Employee

  2. EXTRACT LastName FROM Employee

  3. SELECT Employee.LastName

  4. None
Reveal answer Fill a bubble to check yourself
A Correct answer
Explanation

The SELECT statement is the standard SQL command for retrieving data from a database. The syntax 'SELECT column_name FROM table_name' correctly specifies which column to retrieve from which table. EXTRACT is not a valid SQL keyword for column retrieval, and 'SELECT Employee.LastName' would only work if using qualified notation with a table alias, which is not shown in the options.

Keep practicing — related questions