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