SQL Programming Revision

SQL Clause Used to Filter Aggregated Data is:

• WHERE

• GROUP BY

• HAVING

• ORDER BY

SQL Tables do NOT exist on physical locations.

• TRUE

• FALSE

Which SQL statement is used to extract data from a database?

• SELECT

• OPEN

• EXTRACT

• GET

Which SQL statement is used to insert new data in a database?

• ADD RECORD

• ADD NEW

• INSERT NEW

• INSERT INTO

Which SQL statement is used to return only different values?

• SELECT DIFFERENT

• SELECT UNIQUE

• SELECT DISTINCT

With SQL, how can you insert a new record into the "Persons" table?

• INSERT VALUES ('JIMMY','JACKSON') INTO Persons

• INSERT INTO Persons VALUES ('JIMMY','JACKSON')

With SQL, how can you return the number of records in the "Persons" table?

• SELECT LEN(*) FROM Persons

• SELECT COUNT(*) FROM Persons

• SELECT COLUMNS(*) FROM Persons

• SELECT NO(*) FROM Persons

Which operator is used to select values within a range?

• WITHIN

• RANGE

• BETWEEN

The NOT NULL constraint enforces a column to not accept NULL values.

• TRUE

• FALSE

Which of the following is not an aggregate function in SQL?

• SUM

• FIND

• AVG

• COUNT