NEW
Font size
WorksheetsSQL Programming Revision
Total questions: 20
Worksheet time: 7mins
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
How many Primary keys can be created on a table?
1
2
24
Infinite
Which of the following shows comment in SQL?
& This is a comment.
# This is a comment.
% This is a comment. %
-- This is a comment.
Which SQL keyword is used to make a new table in the database?
INSERT TABLE
NEW TABLE
CREATE TABLE
MAKE TABLE
Which SQL keyword is used to make changes to the structure of a table (e.g. adding new columns)?
CHANGE
DROP
UPDATE
ALTER
Clause to extract details of employees whose FIRST NAME contains "are" anywhere is:
LIKE ('are%')
LIKE ('%are')
LIKE ('_are%')
LIKE ('%are%')
How many tables can be combined using a single inner join?
256
5
1
2
What does "A" stand for in ACID properties of SQL Transactions?
Average
Active
Atomocity
Anonymity
Which join compels the users to create a table alias?
INNER
SELF
OUTER
LEFT
Which of the following wildcard can be used with LIKE clause to match any single character within a specified range:
[ ]
{ }
( )
##
How many clustered index can be there in an SQL table?
1
2
32
Infinite
