Question 1 of 25
Hints left: 3
Q1
The wildcard in a WHERE clause is useful when?
Q2
A subquery in an SQL SELECT statement is enclosed in:
Q3
To remove duplicate rows from the results of an SQL SELECT statement, the ________ qualifier specified must be included.
Q4
You can add a row using SQL in a database with which of the following?
Q5
A view is which of the following?
Q6
You may specify an object identifier with only one unique tag name.
Q7
The command to remove rows from a table 'CUSTOMER' is:
Q8
Which of the following is valid SQL for an Index?
Q9
In an SQL SELECT statement querying a single table, according to the SQL-92 standard the asterisk (*) means that:
Q10
The SQL -92 wildcards are ____ and ____ .
Q11
Which of the following is the original purpose of SQL?
Q12
If you know all the possible values that an attribute can have, you can enumerate those values in ODL.
Q13
SQL data definition commands make up a(n) ________ .
Q14
An attribute's value is always literal.
Q15
Which of the following are the five built-in functions provided by SQL?
-
A
-
B
-
C
-
D
Q16
Which of the following is the correct order of keywords for SQL SELECT statements?
Q17
An ordered collection of elements of the same type are called sets.
Q18
Specifying a key ensures that no two objects belonging to a class have the same value for the key attribute(s).
Q19
The SQL WHERE clause:
Q20
The command to eliminate a table from a database is:
Q21
ON UPDATE CASCADE ensures which of the following?
Q22
The result of a SQL SELECT statement is a(n) ________ .
Q23
The HAVING clause does which of the following?
Q24
In ODL, you specify an operation using parentheses after its name.
Q25
The SQL keyword(s) ________ is used with wildcards.