In an SQL query, which SQL keyword is used to join two conditions that both must be true for the rows
to be selected?
A -
AND
B -
EXISTS
C -
HAVING
D -
IN
2-
In an SQL query, which SQL keyword is used to determine if a column value is equal(=) to any one of a
set of values?
A -
AND
B -
EXISTS
C -
HAVING
D -
IN
3-
Which of the following illustrates the author's preferred style of defining a primary key?
A -
CREATE TABLE CUSTOMER ( CustomerID Integer Primary Key LastName Char(35) Not Null First Name Char(25) Null):
B -
CREATE TABLE CUSTOMER ( CustomerID Integer Not Null LastName Char(35) Not Null First Name Char(25) Null CONSTRAINT CustomerPK PRIMARY KEY (CustomerID);
C -
CREATE TABLE CUSTOMER ( CustomerID Integer Not Null LastName Char(35) Not Null First Name Char(25) Null): ALTER TABLE CUSTOMER ADD CONSTRAINT CustomerPK PRIMARY KEY (CustomerID);
D -
None of these answers.
4-
Which SQL keyword is used to delete a table's structure?
A -
DELETE
B -
DROP
C -
ALTER
D -
MODIFY
5-
In an SQL query, which SQL keyword is used to specify the table(s) to be used?
A -
EXISTS
B -
FROM
C -
SELECT
D -
SET
6-
In an SQL query, which SQL keyword is used to state the condition that specifies which rows are to be
selected?
A -
EXISTS
B -
FROM
C -
SET
D -
WHERE
7-
In an SQL query, which built-in function is used to compute the number of rows in a table?
A -
AVG
B -
COUNT
C -
MAX
D -
MIN
8-
All constraints are stored in .
A -
the parent table
B -
the child table
C -
an intersection table
D -
the database metadata
9-
In an SQL query, which SQL keyword is used to sort the result table by the values in one or more
columns?
A -
GROUP BY
B -
ORDER BY
C -
SORT BY
D -
WHERE
10-
In an SQL query, which SQL keyword is used to specify the condition(s) for a join operation?