SQL Quiz

To define columns should be displayed in an SQL SELECT statement:

• Use FROM to name the source table and list the columns to be shown after SELECT

• )Use the name of the source table after SELECT and list the columns to be shown after FROM

• Use SELECT to name the source table and list the columns to be shown after FROM

• Use SELECT to name the columns and list the source tables to be shown after FROM

LIKE operator uses____and____ -

• precent sign(%);  

• underscore(_)

• conditional AND

• conditional OR

Which SQL keyword is used to specify conditional search -

• WHERE

• HAVING

• FROM

• LIKE

With SQL, how do you select all the column from a table named Person -

• SELECT * Persons

• select * from Person 

• select name, lastname, age from Person

• select p.* from Person p

Whit SQL, , how do you select all the column named "FirstName" from a table named "Perons" -

• SELECT FristName FROM Persons

• Select fisrtname from Persons

• SELECT FristName Persons

• select Frist, name from Persons

SQL provides the AS keyword, which can be used to assign meaningful column names to the results of queries

• True

• False

Which of the following is the correct order of keywords for SQL SELECT statements -

• SELECT, FROM, WHERE

• SELECT, WHERE, FROM

• SELECT, WHERE, FROM, ORDER BY

• SELECT, FROM, WHERE, ORDER BY

Which of the following is the correct order of keywords for SQL SELECT statements -

• SELECT, FROM, WHERE, ORDER BY, HAVING, GROUP BY

• SELECT, WHERE, FROM, ORDER BY, HAVING

• SELECT, WHERE, FROM, HAVING, ORDER BY

• SELECT, FROM, WHERE, GROUP BY, HAVING, ORDER BY

The____operator combines all tuples from two relations excluding duplicates

• Union

• Difference

• Joins

• Intersections

What will be the result of the following SQL statement SELECT * FROM Table 1 HAVING Column 1 > 10

• The result will be all rows from Table1 which have Column1 values greater than 10

• The result will be all rows from Table1 which have Column1 values lower than 10

• The result will be first and last name from Table1 which have Column1 values lower than 10

• All of above