1)
Which
of the following SQL clauses is used to DELETE data from a database table?
1) REMOVE
2) CLEAR
3) DROP
DATA
4)
DELETE
2)
If
you join a table to itself, what kind of join are you using?
1. You
can't join a table to itself.
2. Selective
Join.
3.
Self
Join
3)
Which
of the following SQL statements has correct syntax?
1. SELECT
* FROM Table1 WHERE Column1 => 10
2.
SELECT
* FROM Table1 WHERE Column1 >= 10
3. SELECT
* FROM Table1 WHERE Column1 = = 10
4)
Sub-queries
can be nested in…
1.
UPDATE,
DELETE, INSERT and SELECT statements.
2. INSERT
statements only.
3. DELETE
statements only.
4. UPDATE
statements only.
5)
Which SQL functions is used to count the number of rows in a
SQL query?
1.
COUNT()
2. SUM()
3. NUMBER()
6)
What does the UNION operator do?
1.
The UNION operator combines the results of two or more
queries into a one result that includes all the rows from the queries in the
union.
2. The UNION operator sorts the selected result set.
3. The UNION operator behaves the same as the JOIN SQL clause.
7)
The SQL BETWEEN operator …
1. Specifies
that a column is a primary key.
2. Specifies
which tables we are selecting from.
3.
Specifies
a range to test.
8)
What does SQL stand for?
1. Strict
Query Language
2. Standard
Query Language.
3.
Structured
Query Language.
4. Strong
Query Language
9)
If you don't specify ASC or DESC after a SQL ORDER BY clause,
the following is used by default:
1.
ASC
2. There
is no default value.
3. DESC
10) Which of the following SQL statements is
correct?
1.
SELECT
CustomerName, COUNT(CustomerName) FROM Orders GROUP BY CustomerName
2. SELECT
CustomerName, COUNT(CustomerName) FROM Orders ORDER BY CustomerName
3. SELECT
CustomerName, COUNT(CustomerName) FROM Orders
0 comments:
Post a Comment