Section 1
Preview this deck
According to the rules of precedence, which of the following computations should be completed first? a. Additions and subtractions b. Multiplications and divisions c. Operations within parentheses d. Power operations
Front
| 5 | 0 | ||
| 4 | 0 | ||
| 3 | 0 | ||
| 2 | 0 | ||
| 1 | 0 |
Active users
3
All-time users
3
Favorites
0
Last updated
6 years ago
Date created
Mar 1, 2020
Cards (70)
Section 1
(50 cards)
According to the rules of precedence, which of the following computations should be completed first? a. Additions and subtractions b. Multiplications and divisions c. Operations within parentheses d. Power operations
ANSWER: c
The special operator used to check whether an attribute value matches a given string pattern is _____. a. BETWEEN b. IS NULL c. LIKE d. IN
ANSWER: c
Some RDBMSs, such as Microsoft Access, automatically make the necessary conversions to eliminate case sensitivity. a. True b. False
ANSWER: True
Comparison operators cannot be used to place restrictions on character-based attributes. a. True b. False
ANSWER: False
Which comparison operator indicates a value is not equal? a. < b. <= c. >= d. <>
ANSWER: d
The conditional LIKE must be used in conjunction with wildcard characters. a. True b. False
ANSWER: True
The special operator used to check whether an attribute value is within a range of values is _____. a. BETWEEN b. NULL c. LIKE d. IN
ANSWER: a
An alias cannot be used when a table is required to be joined to itself in a recursive query. a. True b. False
ANSWER: False
A(n) _____ join performs a relational product (also known as the Cartesian product) of two tables. a. full b. cross c. natural d. equi-
ANSWER: b
The ANSI SQL standards are also accepted by the ISO. a. True b. False
ANSWER: True
Oracle users can use the Access QBE (query by example) query generator. a. True b. False
ANSWER: False
How many rows would be returned from a cross join of tables A and B, if A contains 8 rows and B contains 18? a. 8 b. 18 c. 26 d. 144
ANSWER: d
Date procedures are often more software-specific than other SQL procedures. a. True b. False
ANSWER: True
ANSI-standard SQL allows the use of special operators in conjunction with the WHERE clause. a. True b. False
ANSWER: True
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.
ANSWER: b
If a designer wishes to create an inner join, but the two tables do not have a commonly named attribute, he can use a(n) _____ clause. a. OF b. USING c. HAS d. JOIN ON
ANSWER: d
You cannot insert a row containing a null attribute value using SQL. a. True b. False
ANSWER: False
_____ is a string function that returns the number of characters in a string value. a. LENGTH b. SUBSTRING c. CONCAT d. UCASE
ANSWER: a
The special operator used to check whether a subquery returns any rows is _____. a. BETWEEN b. EXISTS c. LIKE d. IN
ANSWER: b
Numeric functions take one numeric parameter and return one value. a. True b. False
ANSWER: True
What type of command does this SQL statement use? SELECT P_CODE, P_DESCRIPT, P_PRICE_V_NAME FROM PRODUCT, VENDOR WHERE PRODUCT.V_CODE=VENDOR. V_CODE a. set operator b. natural join c. "old-style" join d. procedural statement
ANSWER: c
In Oracle, the _____ function converts a date to a character string. a. CONVERT() b. TO_DATE c. TO_CHAR() d. TO_STRING()
ANSWER: c
String comparisons are made from left to right. a. True b. False
ANSWER: True
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
ANSWER: True
The SQL aggregate function that gives the number of rows containing non-null values for a given column is _____. a. COUNT b. MIN c. MAX d. SUM
ANSWER: a
A database language enables the user to perform complex queries designed to transform the raw data into useful information. a. True b. False
ANSWER: True
The _____ function returns the current system date in MS Access. a. TO_DATE() b. SYSDATE() c. DATE() d. TODAY()
ANSWER: c
The SQL command that allows a user to permanently save data changes is _____. a. INSERT b. SELECT c. COMMIT d. UPDATE
ANSWER: c
The _____ command defines a default value for a column when no value is given. a. CHECK b. UNIQUE c. NOT NULL d. DEFAULT
ANSWER: d
Which is a feature of a correlated subquery? a. The inner subquery executes first. b. The outer subquery initiates the process of execution in a subquery. c. The inner subquery initiates the process of execution in a subquery. d. The outer subquery executes independent of the inner subquery.
ANSWER: b
The Oracle _____ function compares an attribute or expression with a series of values and returns an associated value or a default value if no match is found. a. NVL b. TO_CHAR c. DECODE d. CONVERT
ANSWER: c
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
ANSWER: True
A(n) _____ join returns not only the rows matching the join condition (that is, rows with matching values in the common columns) but also the rows with unmatched values. a. outer b. inner c. equi- d. cross
ANSWER: a
SQL is considered difficult to learn; its command set has a vocabulary of more than 300 words. a. True b. False
ANSWER: False
In subquery terminology, the first query in the SQL statement is known as the _____ query. a. outer b. left c. inner d. base
ANSWER: a
_____ is a relational set operator. a. EXCEPT b. PLUS c. ALL d. EXISTS
ANSWER: a
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
ANSWER: a
A(n) _____ join will select only the rows with matching values in the common attribute(s). a. natural b. outer c. full d. cross
ANSWER: a
The COMMIT command does not permanently save all changes. In order to do that, you must use SAVE. a. True b. False
ANSWER: False
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
ANSWER: b
The _____ command restricts the selection of grouped rows based on a condition. a. DISPLAY b. HAVING c. FROM d. CONVERT
ANSWER: b
Which query is used to list a unique value for V_CODE, where the list will produce only a list of those values that are different from one another? a. SELECT ONLY V_CODE FROM PRODUCT; b. SELECT UNIQUE V_CODE FROM PRODUCT; c. SELECT DIFFERENT V_CODE FROM PRODUCT; d. SELECT DISTINCT V_CODE FROM PRODUCT;
ANSWER: a
The syntax for a left outer join is _____. a. SELECT column-list FROM table1 OUTER JOIN table2 LEFT WHERE join-condition b. SELECT column-list FROM table1 LEFT [OUTER] JOIN table2 ON join-condition c. SELECT column-list WHERE LEFT table1 = table d. SELECT column-list FROM table1 LEFT table2 [JOIN] WHERE join-condition
ANSWER: b
You can select partial table contents by naming the desired fields and by placing restrictions on the rows to be included in the output. a. True b. False
ANSWER: True
When using a(n) _____ join, only rows from the tables that match on a common value are returned. a. full b. outer c. inner d. set
ANSWER: c
All SQL commands must be issued on a single line. a. True b. False
ANSWER: False
SQL allows the use of logical restrictions on its inquiries such as OR, AND, and NOT. a. True b. False
ANSWER: True
When using the Oracle TO_DATE function, the code _____ represents a three-letter month name. a. MON b. MM3 c. MONTH d. MM
ANSWER: a
A(n) _____ is a query that is embedded (or nested) inside another query. a. alias b. operator c. subquery d. view
ANSWER: c
Most SQL implementations yield case-insensitive searches. a. True b. False
ANSWER: False
Section 2
(20 cards)