sql

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

• SELECT * FROM Persons WHERE FirstName=’a’

• SELECT * FROM Persons WHERE FirstName LIKE ‘a%’

• SELECT * FROM Persons WHERE FirstName LIKE ‘%a’

• SELECT * FROM Persons WHERE FirstName=’%a%’

What does SQL stand for?

• Standard Query Language

• Sequential Query Language

• Structured Question Language

• Structured Query Language

Match the following SQL term with a description - FROM

• The criteria which must be met

• The fields to display

• The field and order used to sort the results

• The table used in the query

In what order does SQL process the instructions?

• FROM - SELECT - WHERE - ORDER BY

• WHERE - FROM - SELECT - ORDER BY

• SELECT - FROM - WHERE - ORDER BY

• SELECT - FROM - ORDER By - WHERE

Which statement is used to extract data from a database?

• Extract

• Get

• Open

• Select

Less than or equal to?

• >=

• =>

• =<

• <=

A primary key can be NULL in the table? TRUE or FALSE

• TRUE

• FALSE

SQL is

• Structured Query Language

• Simple Query Language

• Structured Question Language

• Structure Quality Language

How many records are in this table?

• 7

• 6

• 5

• 4

How many fields are there?

• 4

• 5

• 6

• 7