Accounting
Anthropology
Archaeology
Art History
Banking
Biology & Life Science
Business
Business Communication
Business Development
Business Ethics
Business Law
Chemistry
Communication
Computer Science
Counseling
Criminal Law
Curriculum & Instruction
Design
Earth Science
Economic
Education
Engineering
Finance
History & Theory
Humanities
Human Resource
International Business
Investments & Securities
Journalism
Law
Management
Marketing
Medicine
Medicine & Health Science
Nursing
Philosophy
Physic
Psychology
Real Estate
Science
Social Science
Sociology
Special Education
Speech
Visual Arts
Management
Q:
A common practice is to create a(n)________________ on any field that is used as a search key, in comparison operations in a conditional expression, or when a user wants to list rows in a specific order.
Q:
Using the__________ command, SQL indexes can be created on the basis of any selected attribute.
Q:
_________________words are words used by SQL to perform specific functions.
Q:
In a 1:M relationship, a user must always create the table for the________side first.
Q:
If integer values are relatively small, ___________must be used instead of INT.
Q:
DATE() and SYSDATE are special functions that return today's date in MS Access and__________ , respectively.
Q:
U.S. state abbreviations are always two characters, so____________ (2) is a logical choice for the data type representing a state column.
Q:
With the exception of the database __________process, most RDBMS vendors use SQL that deviates little from the ANSI standard SQL.
Q:
A(n)___________ is a logical group of database objects, such as tables and indexes, that are related to each other.
Q:
The basic SQL vocabulary has fewer than ______________words.
Q:
In the SQL environment, the word_____________ covers both questions and actions.
Q:
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.a. ALTER TABLEb. UPDATE TABLEc. COMMIT TABLEd. ROLLBACK TABLE
Q:
According to the rules of precedence, which of the following computations should be completed first?a. Performing additions and subtractionsb. Performing multiplications and divisionsc. Performing operations within parenthesesd. Performing power operations
Q:
The syntax for creating an index is_________________ .a. CREATE [NOT NULL] INDEX indexname FROM viewname(column1 [, column2]);b. CREATE [UNIQUE] INDEX indexname ON tablename( column1 [, column2]);c. CREATE [UNIQUE] INDEX indexname FROM tablename(column1 [, column2]);d. CREATE [DEFAULT] INDEX indexname ON viewname(column1 [, column2]);
Q:
The___________ constraint assigns a value to an attribute when a new row is added to a table.a. CHECKb. UNIQUEc. NOT NULLd. DEFAULT
Q:
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.
Q:
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 ___________________.a. SELECT PRODUCT.P_DESCRIPT, PRODUCT.P_PRICE, VENDOR.V_NAME, VENDOR.V_CONTACT, VENDOR.V_AREACODE, VENDOR.V_PHONEFROM PRODUCT, VENDORWHERE PRODUCT.V_CODE <> VENDOR.V_CODE; ORDER BY PRODUCT.P_PRICE;b. SELECT PRODUCT.P_DESCRIPT, PRODUCT.P_PRICE, VENDOR.V_NAME, VENDOR.V_CONTACT, VENDOR.V_AREACODE, VENDOR.V_PHONEFROM PRODUCT, VENDORWHERE PRODUCT.V_CODE => VENDOR.V_CODE; ORDER BY PRODUCT.P_PRICE;c. SELECT PRODUCT.P_DESCRIPT, PRODUCT.P_PRICE, VENDOR.V_NAME, VENDOR.V_CONTACT, VENDOR.V_AREACODE, VENDOR.V_PHONEFROM PRODUCT, VENDORWHERE PRODUCT.V_CODE <= VENDOR.V_CODE; ORDER BY PRODUCT.P_PRICE;d. SELECT PRODUCT.P_DESCRIPT, PRODUCT.P_PRICE, VENDOR.V_NAME, VENDOR.V_CONTACT,VENDOR.V_AREACODE, VENDOR.V_PHONE FROM PRODUCT, VENDORWHERE PRODUCT.V_CODE = VENDOR.V_CODE; ORDER BY PRODUCT.P_PRICE;
Q:
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 is_________________ .a. SELECT P_DESCRIPT, P_PRICE, V_NAME, V_CONTACT, V_AREACODE, V_PHONE FROM PRODUCT, VENDORWHERE PRODUCT.V_CODE <> VENDOR.V_CODE;b. SELECT P_DESCRIPT, P_PRICE, V_NAME, V_CONTACT, V_AREACODE, V_PHONE FROM PRODUCT, VENDORWHERE PRODUCT.V_CODE = VENDOR.V_CODE;c. SELECT P_DESCRIPT, P_PRICE, V_NAME, V_CONTACT, V_AREACODE, V_PHONE FROM PRODUCT, VENDORWHERE PRODUCT.V_CODE <= VENDOR.V_CODE;d. SELECT P_DESCRIPT, P_PRICE, V_NAME, V_CONTACT, V_AREACODE, V_PHONE FROM PRODUCT, VENDORWHERE PRODUCT.V_CODE => VENDOR.V_CODE;
Q:
The SQL aggregate function that gives the arithmetic mean for a specific column is_______________ .a. COUNTb. AVGc. MAXd. SUM
Q:
The SQL aggregate function that gives the total of all values for a selected attribute in a given column is____________________.a. COUNTb. MINc. MAXd. SUM
Q:
The SQL aggregate function that gives the number of rows containing non-null values for a given column is____________________.a. COUNTb. MINc. MAXd. SUM
Q:
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?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;
Q:
The SQL query to output the contents of the EMPLOYEE table sorted by last name, first name, and initial is_____.a. SELECT EMP_LNAME, EMP_FNAME, EMP_INITIAL, EMP_AREACODE, EMP_PHONE FROM EMPLOYEELIST BY EMP_LNAME, EMP_FNAME, EMP_INITIAL;b. SELECT EMP_LNAME, EMP_FNAME, EMP_INITIAL, EMP_AREACODE, EMP_PHONE FROM EMPLOYEEORDER BY EMP_LNAME, EMP_FNAME, EMP_INITIAL;c. SELECT EMP_LNAME, EMP_FNAME, EMP_INITIAL, EMP_AREACODE, EMP_PHONE FROM EMPLOYEEDISPLAY BY EMP_LNAME, EMP_FNAME, EMP_INITIAL;d. SELECT EMP_LNAME, EMP_FNAME, EMP_INITIAL, EMP_AREACODE, EMP_PHONE FROM EMPLOYEESEQUENCE BY EMP_LNAME, EMP_FNAME, EMP_INITIAL;
Q:
The query used to list the P_CODE, P_DESCRIPT, P_INDATE, and P_PRICE fields from the PRODUCT table in ascending order by P_PRICE is______________________ .a. SELECT P_CODE, P_DESCRIPT, P_INDATE, P_PRICE FROM PRODUCTSEQUENCE BY P_PRICE;b. SELECT P_CODE, P_DESCRIPT, P_INDATE, P_PRICE FROM PRODUCTLIST BY P_PRICE;c. SELECT P_CODE, P_DESCRIPT, P_INDATE, P_PRICE FROM PRODUCTORDER BY P_PRICE;d. SELECT P_CODE, P_DESCRIPT, P_INDATE, P_PRICE FROM PRODUCTASCENDING BY P_PRICE;
Q:
A table can be deleted from the database by using the_____________ command.a. DROP TABLEb. DELETE TABLEc. MODIFY TABLEd. ERASE TABLE
Q:
The _______________command is used with the ALTER TABLE command to modify the table by deleting a column.a. DROPb. REMOVEc. DELETEd. ERASE
Q:
The special operator used to check whether a subquery returns any rows is_________-- .a. BETWEENb. EXISTSc. LIKEd. IN
Q:
The special operator used to check whether an attribute value matches a given string pattern is ____________.a. BETWEENb. IS NULLc. LIKEd. IN
Q:
The _________special operator is used to check whether an attribute value is null.a. BETWEENb. IS NULLc. LIKEd. NOT NULL
Q:
The special operator used to check whether an attribute value is within a range of values is ____________.a. BETWEENb. NULLc. LIKEd. IN
Q:
Which of the following queries uses the correct SQL syntax to list the table contents for either V_CODE = 21344 or V_CODE = 24288?
a. SELECT P_DESCRIPT, P_INDATE, P_PRICE, V_CODE FROM PRODUCT
WHERE V_CODE = 21344 OR V_CODE <= 24288;
b. SELECT P_DESCRIPT, P_INDATE, P_PRICE, V_CODE FROM PRODUCT
WHERE V_CODE = 21344 OR V_CODE => 24288;
c. SELECT P_DESCRIPT, P_INDATE, P_PRICE, V_CODE FROM PRODUCT
WHERE V_CODE = 21344 OR V_CODE > 24288;
d. SELECT P_DESCRIPT, P_INDATE, P_PRICE, V_CODE FROM PRODUCT
WHERE V_CODE = 21344 OR V_CODE = 24288;
Q:
Which of the following queries will use the given columns and column aliases from the PRODUCT table to determine the total value of inventory held on hand and display the results in a column labeled TOTVALUE?
a. SELECT P_DESCRIPT, P_QOH, P_PRICE, P_QOH*P_PRICE AS TOTVALUE FROM PRODUCT;
b. SELECT P_DESCRIPT, P_QOH, P_PRICE, P_QOH=P_PRICE AS TOTVALUE FROM PRODUCT;
c. SELECT P_DESCRIPT, P_QOH, P_PRICE, P_QOH/P_PRICE AS TOTVALUE FROM PRODUCT;
d. SELECT P_DESCRIPT, P_QOH, P_PRICE, P_QOH-P_PRICE AS TOTVALUE FROM PRODUCT;
Q:
A(n)__________ is an alternate name given to a column or table in any SQL statement.a. aliasb. data typec. stored functiond. trigger
Q:
Which of the following queries will use the given columns and column aliases from the PRODUCT table to determine the total value of inventory held on hand?
a. SELECT P_DESCRIPT, P_QOH, P_PRICE, P_QOH/P_PRICE FROM PRODUCT;
b. SELECT P_DESCRIPT, P_QOH, P_PRICE, P_QOH=P_PRICE FROM PRODUCT;
c. SELECT P_DESCRIPT, P_QOH, P_PRICE, P_QOH*P_PRICE FROM PRODUCT;
d. SELECT P_DESCRIPT, P_QOH, P_PRICE, P_QOH-P_PRICE FROM PRODUCT;
Q:
Which of the following queries will list all the rows in which the inventory stock dates occur on or after January 20, 2010?
a. SELECT P_DESCRIPT, P_QOH, P_MIN, P_PRICE, P_INDATE FROM PRODUCT
WHERE P_INDATE >= "20-JAN-2010";
b. SELECT P_DESCRIPT, P_QOH, P_MIN, P_PRICE, P_INDATE FROM PRODUCT
WHERE P_INDATE >= $20-JAN-2010$;
c. SELECT P_DESCRIPT, P_QOH, P_MIN, P_PRICE, P_INDATE FROM PRODUCT
WHERE P_INDATE <= "20-JAN-2010";
d. SELECT P_DESCRIPT, P_QOH, P_MIN, P_PRICE, P_INDATE FROM PRODUCT
WHERE P_INDATE >= {20-JAN-2010};
Q:
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?
a. SELECT P_CODE, P_DESCRIPT, P_QOH, P_MIN, P_PRICE FROM PRODUCT
WHERE P_CODE <"1558-QW1";
b. SELECT P_CODE, P_DESCRIPT, P_QOH, P_MIN, P_PRICE FROM PRODUCT
WHERE P_CODE = [1558-QW1];
c. SELECT P_CODE, P_DESCRIPT, P_QOH, P_MIN, P_PRICE FROM PRODUCT
WHERE P_CODE = (1558-QW1);
d. SELECT P_CODE, P_DESCRIPT, P_QOH, P_MIN, P_PRICE FROM PRODUCT
WHERE P_CODE = {1558-QW1};
Q:
Which of the following queries will output the table contents when the value of P_PRICE is less than or equal to 10?
a. SELECT P_DESCRIPT, P_INDATE, P_PRICE, V_CODE FROM PRODUCT
WHERE P_PRICE <> 10;
b. SELECT P_DESCRIPT, P_INDATE, P_PRICE, V_CODE FROM PRODUCT
WHERE P_PRICE <= 10;
c. SELECT P_DESCRIPT, P_INDATE, P_PRICE, V_CODE FROM PRODUCT
WHERE P_PRICE => 10;
d. SELECT P_DESCRIPT, P_INDATE, P_PRICE, V_CODE FROM PRODUCT
WHERE P_PRICE = 10;
Q:
Which of the following queries will output the table contents when the value of V_CODE is not equal to 21344?
a. SELECT P_DESCRIPT, P_INDATE, P_PRICE, V_CODE FROM PRODUCT
WHERE V_CODE <> 21344;
b. SELECT P_DESCRIPT, P_INDATE, P_PRICE, V_CODE FROM PRODUCT
WHERE V_CODE <= 21344;
c. SELECT P_DESCRIPT, P_INDATE, P_PRICE, V_CODE FROM PRODUCT
WHERE V_CODE = 21344;
d. SELECT P_DESCRIPT, P_INDATE, P_PRICE, V_CODE FROM PRODUCT
WHERE V_CODE => 21344;
Q:
Which of the following queries will output the table contents when the value of V_CODE is equal to 21344?a. SELECT P_DESCRIPT, P_INDATE, P_PRICE, V_CODE FROM PRODUCTWHERE V_CODE <> 21344;b. SELECT P_DESCRIPT, P_INDATE, P_PRICE, V_CODE FROM PRODUCTWHERE V_CODE <= 21344;c. SELECT P_DESCRIPT, P_INDATE, P_PRICE, V_CODE FROM PRODUCTWHERE V_CODE = 21344;d. SELECT P_DESCRIPT, P_INDATE, P_PRICE, V_CODE FROM PRODUCTWHERE V_CODE => 21344;
Q:
A(n)________ is a query that is embedded (or nested) inside another query.a. aliasb. operatorc. subqueryd. view
Q:
Explain how database designers design and normalize databases.
Q:
Explain the Boyce-Codd normal form (BCNF). How is it related to other normal forms?
Q:
What steps are involved in the conversion to third normal form?
Q:
Describe a dependency diagram and explain its purpose.
Q:
What characteristics do tables that conform to the concept of well-informed relations have?
Q:
Explain normalization and its different forms.
Q:
According to the data-modeling checklist,______________ should be nouns that are familiar to business, should be short and meaningful, and should document abbreviations, synonyms, and aliases for each entity.
Q:
Unnormalized tables yield no simple strategies for creating virtual tables known as___________ .
Q:
An ERD is created through an____________ process.
Q:
The combination of______________ and ER modeling yields a useful ERD, whose entities may now be translated into appropriate table structures.
Q:
The provides the big picture, or macro view, of an organization's data requirements and operations.
Q:
In the_____________ , no row may contain two or more multivalued facts about an entity.
Q:
When a nonkey attribute is the determinant of a key attribute, the table is in 3NF but not in___________ .
Q:
It becomes difficult to create a suitable_________ key when the related table uses a composite primary key.
Q:
In a real-world environment, changing granularity requirements might dictate changes in primary key selection, and those changes might ultimately require the use of_________ keys.
Q:
_____________refers to the level of detail represented by the values stored in a table's row.
Q:
An attribute that cannot be further subdivided is said to display______________ .
Q:
Any attribute whose value determines other values within a row is known as a___________ .
Q:
Because a partial dependency can exist only when a table's primary key is composed of several attributes, a table whose__________ key consists of only a single attribute is automatically in 2NF once it is in 1NF.
Q:
Data redundancies occur from_____________ of data on every row entry.
Q:
All relational tables satisfy the______________ requirements.
Q:
The__________-- is central to a discussion of normalization.
Q:
The problem with transitive dependencies is that they still yield data_____________- .
Q:
Dependencies can be identified with the help of a dependency_______________ .
Q:
A dependency based on only a part of a composite primary key is called a______________ .
Q:
When designing a new database structure based on the business requirements of the end users, the database designer will construct a data model using a technique such as____________- .
Q:
Any attribute that is at least part of a key is known as a__________- .
Q:
_______________is a process to help reduce the likelihood of data anomalies.
Q:
In order to meet requirements, you may have to denormalize some portions of a database design.
Q:
The price paid for increased performance through denormalization is a larger amount of______________ .
Q:
If database tables are treated as though they were files in a file system, the____________ never has a chance to demonstrate its superior data-handling capabilities.
Q:
_____________databases reflect the ever-growing demand for greater scope and depth in the data on which decision support systems increasingly rely.a. Normalizedb. Data warehousec. Temporaryd. Report
Q:
Data warehouse routinely uses _____________structures in its complex, multilevel, multisource data environment.a. 1NFb. 2NFc. 3NFd. 4NF
Q:
The conflicts between design efficiency, information requirements, and performance are often resolved through_____.a. compromises that include normalizationb. conversion from 2NF to 3NFc. compromises that include denormalizationd. conversion from 3NF to 4NF
Q:
An example of denormalization is using a_____________ denormalized table to hold report data. This is required when creating a tabular report in which the columns represent data that are stored in the table as rows.a. transitiveb. 3NFc. componentd. temporary
Q:
Normalization represents a micro view of the___________ within the ERD.a. entitiesb. attributesc. relationshipsd. forms
Q:
When designing a database, you should_____________ .a. make sure that entities are in normal form before table structures are createdb. create table structures then normalize the databasec. only normalize the database when performance problems occurd. consider more important issues such as performance before normalizing
Q:
A table is in 4NF if it is in 3NF, and_________________ .a. all attributes must be dependent on the primary key and must be dependent on each otherb. all attributes are unrelatedc. it has no multivalued dependenciesd. no column contains the same values
Q:
A table where all attributes are dependent on the primary key but are independent of each other, and no row contains two or more multivalued facts about an entity is said to be in_______________ .a. 1NFb. 2NFc. 3NFd. 4NF
Q:
Most designers consider the BCNF as a special case of the______________________ .a. 1NFb. 2NFc. 3NFd. 4NF