1. (TCO A) A database stores (Points : 5)
2. (TCO B) Entities of a given type are grouped into a(n) _____. (Points : 5)
3. (TCO C) A determinant that determines all the other columns in a relation is a _____. (Points : 5)
D) candidate key
4. (TCO C) A table that meets the definition of a relation is in _____ (Points : 5)
A) First Normal Form
5. (TCO D) In a SQL query, which SQL keyword is used with built-in functions to group together rows that have the same value in a specified column? (Points : 5)
A) GROUP BY
6. (TCO E) Business intelligence systems fall into which of the following categories? (Points : 5)
E) B and C
7. (TCO E) One remedy ...view middle of the document...
In the common data architecture, cardinality is documented with data integrity but not with data structure.
13. (TCO C) Describe the requirements that a table must meet to qualify as a relation. (Points : 21)
In order for a table to meet the requirements of a relation, it must satisfy certain conditions. First, the rows contain data about an entity or some portion of the entity. Second, the columns contain data that represent attributes of the entity – each column must contain the same kind of data for all rows – and each column must have a unique name. Third, the cells must contain single values – no group or array values are allowed. Finally, the rows must be unique. It is worth noting that the order of the columns and the rows is insignificant.
14. (TCO C) What is the multivalue, multicolumn problem, and why is it a problem? (Points : 21)
The multivalue, multicolumn problem occurs when a table is designed to include multiple columns that hold variations of one type of attribute data. One example is where boat owners have the names of their boats stored as BOAT_01, BOAT_02 and BOAT_03. A form of multivalued dependency is found in ________.
A) the multivalued, multicolumn problem
15. (TCO D) What is SQL? What is it used for? Describe the categories of SQL. (Points : 21)
SQL (pronounced "ess-que-el") stands for Structured Query Language. SQL is used to communicate with a database. According to ANSI (American National Standards Institute), it is the standard language for relational database management systems. SQL statements are used to perform tasks such as update data on a database, or retrieve data from a database
Data Definition Language (DDL) statements are used to define the database structure or schema. Some examples:
◦CREATE - to create objects in the database
◦ALTER - alters the structure of the database
◦DROP - delete objects from the database
◦TRUNCATE - remove all records from a table, including all spaces allocated for the records are removed
◦COMMENT - add comments to the data dictionary
◦RENAME - rename an object
Data Manipulation Language (DML) statements are used for managing data within schema objects. Some examples:
◦SELECT - retrieve data from the a database
◦INSERT - insert data into a table
◦UPDATE - updates existing data within a table
◦DELETE - deletes all records from a table, the space for the records remain
◦MERGE - UPSERT operation (insert or update)
◦CALL - call a PL/SQL or Java subprogram
◦EXPLAIN PLAN - explain access path to data
◦LOCK TABLE - control concurrency
Data Control Language (DCL) statements. Some examples:
◦GRANT - gives user's access privileges to database
◦REVOKE - withdraw access privileges given with the GRANT command
Transaction Control (TCL) statements are used to manage the changes made by DML...