Section 1
Preview this deck
True
Front
| 5 | 0 | ||
| 4 | 0 | ||
| 3 | 0 | ||
| 2 | 0 | ||
| 1 | 0 |
Active users
0
All-time users
0
Favorites
0
Last updated
6 years ago
Date created
Mar 1, 2020
Cards (66)
Section 1
(50 cards)
True
Some RDBMSs, such as Microsoft Access, automatically make the necessary conversions to eliminate case sensitivity.
SELECT P_DESCRIPT, P_QOH, P_MIN, P_PRICE, P_INDATE FROM PRODUCT WHERE P_INDATE >= '20-JAN-2016';
Which of the following queries will list all the rows in which the inventory stock dates occur on or after January 20, 2016?
SELECT P_DESCRIPT, P_INDATE, P_PRICE, V_CODE FROM PRODUCT WHERE V_CODE = 21344;
Which of the following queries will output the table contents when the value of V_CODE is equal to 21344?
Boolean
A specialty field in mathematics, known as _____ algebra, is dedicated to the use of logical operators.
Readable
To make SQL code more____ , most SQL programmers use one line per column (attribute) definition.
DELETE FROM PRODUCT WHERE P_CODE = 'BRT-345';
The _____ command would be used to delete the table row where the P_CODE is 'BRT-345'.
SELECT c COMMIT
The SQL command that allows a user to list the contents of a table is _____.
EXISTS
The special operator used to check whether a subquery returns any rows is _____.
DEFAULT
The _____ constraint assigns a value to an attribute when a new row is added to a table.
FORMAT
In Oracle, the _____ command is used to change the display for a column, for example, to place a $ in front of a numeric value.
SELECT PRODUCT.P_DESCRIPT, PRODUCT.P_PRICE, VENDOR.V_NAME, VENDOR.V_CONTACT, VENDOR.V_AREACODE, VENDOR.V_PHONE FROM PRODUCT, VENDOR WHERE PRODUCT.V_CODE = VENDOR.V_CODE; ORDER BY PRODUCT.P_PRICE;
The query to join the P_DESCRIPT and P_PRICE fields from the PRODUCT table and the V_NAME, V_AREACODE, V_PHONE and V_CONTACT fields from the VENDOR table, where the values of V_CODE match and the output is ordered by the price is _____.
False
The ANSI prescribes a standard SQL-the current fully approved version is known as SQL-07.
restricts the selection of grouped rows based on a condition.
The SQL data manipulation command HAVING:
UPDATE PRODUCT SET P_INDATE = '18-JAN-2004' WHERE P_CODE = '13-Q2/P2';
An example of a command a user would use when making changes to a PRODUCT table is _____.
Query
In the SQL environment, the word _____ covers both questions and actions.
all rows will be deleted
When a user issues the DELETE FROM tablename command without specifying a WHERE condition, _____.
ALTER TABLE
All changes in a table structure are made using the _____ command, followed by a keyword that produces the specific changes a user wants to make.
subquery
A(n) _____ is a query that is embedded (or nested) inside another query.
between
The special operator used to check whether an attribute value is within a range of values is _____.
True
Data type selection is usually dictated by the nature of the data and by the intended use.
Drop index
To delete an index, one must use the _____ command.
% and _. '%' is used when replacing an unspecified number of characters; for instance, 'S%' could indicate either Smith or Sanchez. '-' is used to replace only one character; 'J_n' could represent either Jon or Jan.
What are the wildcard characters that are used with the LIKE command? Provide one or more examples of each.
COUNT
The SQL aggregate function that gives the number of rows containing non-null values for a given column is _____.
True
The ANSI SQL standards are also accepted by the ISO.
DROP TABLE
A table can be deleted from the database bu using the ___ command.
False
Only numeric data types can be added and subtracted in SQL.
SELECT P_CODE, P_DESCRIPT, P_QOH, P_MIN, P_PRICE FROM PRODUCT WHERE P_CODE <'1558-QW1';
Which of the following queries will output the table contents when the value of the character field P_CODE is alphabetically less than 1558-QW1?
SELECT <column(s)> FROM <Table name> WHERE <Conditions>;
Which of the following is used to select partial table contents?
False
All SQL commands must be issued on a single line.
True
String comparisons are made from left to right.
Recursive
An alias is especially useful when a table must be joined to itself in a(n) _____ query.
False
SQL requires the use of the ADD command to enter data into a table.
True
ANSI-standard SQL allows the use of special operators in conjunction with the WHERE clause.
True
Entity integrity is enforced automatically when the primary key is specified in the CREATE TABLE command sequence.
True
SQL allows the use of logical restrictions on its inquiries such as OR, AND, and NOT.
A subquery is the query-within-a-query inside a nested query. It is used when the outer query depends on data processed by the inner query. Because of this, he RDBMS always processes the subquery first.
What is a subquery? When is it used? Does the RDBMS deal with subqueries any differently from normal queries?
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.
SELECT DISTINCT V_CODE FROM PRODUCT;
Which of the following queries 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?
True
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.
Commit
The SQL command that allows a user to permanently save data changes is _____.
False
An alias cannot be used when a table is required to be joined to itself in a recursive query.
One
In a 1:M relationship, a user must always create the table for the _____ side first.
True
The conditional LIKE must be used in conjunction with wildcard characters.
alias
A(n) _____ is an alternate name given to a column or table in any SQL statement.
LIKE
The special operator used to check whether an attribute value matches a given string pattern is _____.
Drop table, for example: DROP TABLE AUTHORS; (This command will not be executed if the Authors table is on the one side of any relationship.)
How can a table be deleted from the database? Provide an example.
SELECT P_DESCRIPT, P_INDATE, P_PRICE, V_CODE FROM PRODUCT WHERE V_CODE = 21344 OR V_CODE = 24288;
Which of the following queries uses the correct SQL syntax to list the table contents for either V_CODE = 21344 or V_CODE = 24288?
Wildcard
A(n) _____ character is a symbol that can be used as a general substitute for other characters or commands.
ROLLBACK;
The _____ command is used to restore the database to its previous condition.
SET columnname=expression
UPDATE tablename*** [WHERE conditionlist]; The _____ command replaces the *** in the syntax of the UPDATE command, shown above.
Section 2
(16 cards)