107 Questions | By Hai8179119111 | Last updated: Mar 21, 2022 | Total Attempts: 550
Feedback
During the Quiz End of Quiz
Difficulty
Sequential Easy First Hard First
.
1.
A database language enables the user to perform complex queries designed to transform the raw data into useful information.
A.
True
B.
False
2.
SQL is considered difficult to learn; its command set has a vocabulary of more than 300 words
A.
True
B.
False
3.
The COMMIT command does not permanently save all changes. In order to do that, you must use SAVE.
A.
True
B.
False
4.
All SQL commands must be issued on a single line.
A.
True
B.
False
5.
Although SQL commands can be grouped together on a single line, complex command sequences are best shown on separate lines, with space between the SQL command and the command’s components.
A.
True
B.
False
6.
An alias cannot be used when a table is required to be joined to itself in a recursive query.
A.
True
B.
False
7.
Comparison operators cannot be used to place restrictions on character-based attributes.
A.
True
B.
False
8.
11. String comparisons are made from left to right.
A.
True
B.
False
9.
13. SQL allows the use of logical restrictions on its inquiries such as OR, AND, and NOT.
A.
True
B.
False
10.
14. You cannot insert a row containing a null attribute value using SQL.
A.
True
B.
False
11.
16. The conditional LIKE must be used in conjunction with wildcard characters.
A.
True
B.
False
C.
Option 3
D.
Option 4
12.
19. The COUNT function is designed to tally the number of non-null "values" of an attribute, and is often used in conjunction with the DISTINCT clause.
A.
True
B.
False
C.
Option 3
D.
Option 4
13.
21. The SQL data manipulation command HAVING:
A.
restricts the selection of rows based on a conditional expression.
B.
restricts the selection of grouped rows based on a condition.
C.
modifies an attribute’s values in one or more table’s rows.
D.
groups the selected rows based on one or more attributes.
14.
22. The SQL command that allows a user to permanently save data changes is _____.
A.
INSERT
B.
SELECT
C.
COMMIT
D.
UPDATE
15.
23. The _____ command defines a default value for a column when no value is given.
A.
CHECK
B.
UNIQUE
C.
NOT NULL
D.
DEFAULT
16.
24. The _____ command restricts the selection of grouped rows based on a condition.
A.
DISPLAY
B.
HAVING
C.
FROM
D.
CONVERT
17.
25. A[n] _____ query specifies which data should be retrieved and how it should be filtered, aggregated, and displayed.
A.
INSERT
B.
SELECT
C.
COMMIT
D.
UPDATE
18.
26. A[n] _____ is an alternate name given to a column or table in any SQL statement.
A.
alias
B.
data type
C.
stored function
D.
trigger
19.
30. A[n] _____ join will select only the rows with matching values in the common attribute[s].
A.
Natural
B.
Outer
C.
Full
D.
Cross
20.
36. Which comparison operator indicates a value is not equal?
A.