Database Resource Management Final Review

In which of the following situations would one have to use an outer join in order to obtain the desired results? A) A report is desired that lists all customers and the total of their orders during the most recent month, and includes customers who did not place an order during the month (their total will be zero). B) A report is desired that lists all customers and the total of their orders. C) A report is desired that lists all customers who placed an order. D) There is never a situation that requires only an outer join

A) A report is desired that lists all customers and the total of their orders during the most recent month, and includes customers who did not place an order during the month (their total will be zero).

What does the following SQL statement do? Alter Table Customer_T Add (Type Varchar (2)); A) Alters the Customer_T table, and adds a field called "Type" B) Alters the Customer_T table by adding a 2-byte field called "Varchar" C) Alters the Customer_T table to accept Type 2 Varchars D) Alters the Customer_T table to be a Type 2 Varchar

A) Alters the Customer_T table, and adds a field called "Type"

An entity that associates the instances of one or more entity types and contains attributes specific to the relationships is called a(n): A) associative entity. B) build entity. C) smush entity. D) gateway entity.

A) Associative Entity

A property or characteristic of an entity type that is of interest to the organization is called a(n): A) attribute. B) coexisting entity. C) relationship. D) cross-function

A) Attribute

A ________ defines or constrains some aspect of the business. A) business rule B) business constraint C) business control D) business structure

A) Business Rule

Which of the following factors drive the need for data warehousing? A) Businesses need an integrated view of company information. B) Reduce virus and Trojan horse threats. C) Data warehouses generally have better security. D) Informational data must be kept together with operational data

A) Businesses need an integrated view of company information.

In the figure below, Customer_ID in the CUSTOMER Table is which type of key? a. Candidate b. Composite c. Standard d. Grouped

A) Candidate

Which of the following data-mining techniques identifies clusters of observations with similar characteristics? A) Clustering and signal processing B) Neural nets C) Rule discovery D) Case reasoning

A) Clustering and signal processing

An attribute that can be broken down into smaller parts is called a(n) ________ attribute. A) composite B) simple C) complex D) associative

A) Composite

The number of entity types that participate in a relationship is called the: A) counter. B) identifying characteristic. C) degree. D) number.

A) Counter

The SQL command ________ defines a logical table from one or more tables or views. A) create view B) create table C) alter table D) create relationship

A) Create View

The main concept of relational databases was published in 1970 by: A) E.F.Codd. B) Itzak Ben-Gan. C) Mills. D) Hoffer.

A) EF Codd

Which of the following finds all groups meeting stated conditions? A) Having B) Select C) Find D) Where

A) Having

The Hadoop framework consists of the ________ algorithm to solve large scale problems. A) MapReduce B) MapCluster C) MapComponent D) MapSystem

A) MapReduce

________ is/are any of several classes of software that allow an application to interoperate with other software without requiring the user to understand all software involved. A) Middleware B) User interface enhancers C) MPP D) Interface managers

A) Middleware

In the figure below, a student: A) must be a graduate student, an undergraduate, a special student or some other type of student. B) must be a graduate student or an undergraduate student. C) must be a doctoral student. D) must be at least a special student.

A) Must be a graduate student, an undergraduate, a special student or some other type of student.

The ________ rule states that an entity instance can simultaneously be a member of two (or more) subtypes. a. overlap b. disjoint c. total specialization d. partial specialization

A) Overlap

1. The ________ rule specifies that an entity instance of a supertype is allowed not to belong to any subtype. A) partial specialization B) disjointedness C) total specialization D) semi-specialization

A) Partial Specialization

In the figure below, which of the following apply to both OUTPATIENTs and RESIDENT_PATIENTs? A) Patient_Name B) Date_Discharged C) XML D) Checkback_Date

A) Patient_Name

Which of the following is an advantage of stored procedures? A) Performance improves for compiled SQL statements. B) Data integrity improves when fewer applications access the procedure. C) The layers get cleaner. D) Stored procedures result in fatter clients

A) Performance improves for compiled SQL statements.

________ is an important scripting language to help reduce the complexity of MapReduce. A) Pig B) Cat C) Dog D) Horse

A) Pig

Referential Integrity Constraints are generally established between: A) Primary and Foreign keys. B) Primary and Secondary keys. C) Referential and Integrity keys. D) Foreign and Domestic keys.

A) Primary and Foreign keys.

An organization that requires a sole focus on performance with the ability for keys to include strings, hashes, lists, and sorted sets would select ________ database management system. A) Redis B) Excel Spreadsheet C) Neo4j D) Access

A) Redis

Packaged data models: a. require customization. b. cannot be used for most applications. c. allow partial specialization. d. are ready to use right out of the box.

A) Require Customization

In the figure below, which attribute is multivalued? A) Skill B) Years_Employed C) Employee_ID D) Address

A) Skill

The most common types of entities are: A) strong entities. B) smush entities. C) associative entities. D) weak entities

A) Strong Entities

In a supertype/subtype hierarchy, subtypes that are lower in the hierarchy inherit attributes from not only their immediate supertype but from all ________ in the hierarchy. a. supertypes b. dimensions c. subtypes d. constraints

A) Supertypes

What will result from the following SQL Select statement? Select min(Product_Description) from Product_V; A) The first product description alphabetically in Product_V will be shown. B) SELECT @ will be displayed. C) An error message will be generated. D) The minimum value of Product_Description will be displayed

A) The first product description alphabetically in Product_V will be shown.

Subtypes should be used when: A) there are attributes that apply to some but not all instances of an entity type. B) supertypes relate to objects outside the business. C) a recursive relationship is needed. D) the instances of a subtype do not participate in a relationship that is unique to that subtype.

A) There are attributes that apply to some but not all instances of an entity type

A value that indicates the date or time of a data value is called a: A) time stamp. B) check counter. C) value stamp. D) checkpoint.

A) Time Stamp

In an E-R diagram, there are/is ________ business rule(s) for every relationship. A) two B) one C) three D) zero

A) Two

An entity type whose existence depends on another entity type is called a ________ entity. A) weak B) codependent C) variant D) strong

A) Weak

An XML-based grammar used to describe a Web service is called: A) Web Service Description Language (WSDL). B) WIDL. C) WISL. D) Business-to-Business (B2B)

A) Web Service Description Language (WSDL).

At a basic level, analytics refers to: A) analysis and interpretation of data. B) conducting a needs analysis. C) collecting data. D) normalizing data

A) analysis and interpretation of data.

A join operation: A) causes two tables with a common domain to be combined into a single table or view. B) is used to combine indexing operations. C) causes two disparate tables to be combined into a single table or view. D) brings together data from two different fields

A) causes two tables with a common domain to be combined into a single table or view.

The phrase ________ refers to a model for providing ubiquitous, convenient and on-demand network access. A) cloud computing B) network computing C) software services D) grid computing

A) cloud computing

The UNION clause is used to: A) combine the output from multiple queries into a single result table. B) join two tables together to form one table. C) find all rows that are in one table, but not the other. D) find all rows that do not match in two tables

A) combine the output from multiple queries into a single result table.

When a data repository (including internal and external data) does NOT follow a predefined schema, this is called a: A) data lake. B) data dump. C) data ocean. D) data stream.

A) data lake.

With HDFS it is less expensive to move the execution of computation to data than to move the: A) data to computation. B) data to systems analysis. C) data to processes. D) data to hardware.

A) data to computation.

Data that are never physically altered once they are added to the store are called ________ data. A) periodic B) complete C) override D) transient

A) periodic

Descriptive, predictive, and ________ are the three main types of analytics. A) prescriptive B) adaptive C) decisive D) comparative

A) prescriptive

A Web server: A) processes client requests and returns HTML pages to the client. B) always contains a database. C) is used only to host Web pages. D) is considered to be part of the firewall

A) processes client requests and returns HTML pages to the client.

The main difference between Java applets and Java servlets is: A) servlets are stored on the server while applets are stored on the client. B) only applets will run on Macintosh systems. C) both applets and servlets are executed and stored on the server. D) applets are stored on the client but executed on the server.

A) servlets are stored on the server while applets are stored on the client.

NoSQL systems enable automated ________ to allow distribution of the data among multiple nodes to allow servers to operate independently on the data located on it. A) sharding B) mongo C) SQL D) sharing

A) sharding

A(n) ________ is a module of code written in SQL or some proprietary language to run business rules on a server. A) stored procedure B) select procedure C) select module D) SQL program

A) stored procedure

Every key used to join the fact table with a dimension table should be a ________ key. A) surrogate B) foreign C) secondary D) primary

A) surrogate

A named set of SQL statements that are considered when a data modification occurs are called: A) triggers. B) trapdoors. C) stored procedures. D) treatments.

A) triggers.

What will be returned when the following SQL query is executed? Select driver_no, count(*) as num_deliveries from deliveries group by driver_no having count(*) > 2; A) A listing of all drivers B) A listing of all drivers who made more than 2 deliveries as well as a count of the number of deliveries C) A listing of all drivers who made more than 2 deliveries D) A listing of the number of deliveries greater than 2

B) A listing of all drivers who made more than 2 deliveries as well as a count of the number of deliveries

A(n) ________ is a set of application routines that programs use to direct the performance of procedures by the computer's operating system. A) RPC B) API C) LAN D) MOM

B) Application Program Interface (API)

The property by which subtype entities possess the values of all attributes of a supertype is called: a. hierarchy reception. b. attribute inheritance. c. class management. d. generalization.

B) Attribute Inheritance

In the figure below, the primary key for "Order Line" is which type of key? a. Foreign b. Composite c. Grouped d. Standard

B) Composite

Which of the following is NOT a method for storing XML documents? A) Shredding B) Convert to text C) Use an XML native database D) Use a BLOB or CLOB to store the entire XML file

B) Convert to text

________ use the result of the outer query to determine the processing of the inner query. A) Outer subqueries B) Correlated subqueries C) Subqueries D) Inner subqueries

B) Correlated subqueries

The command for creating a database is: A) create table. B) create schema. C) create view. D) create authorization

B) Create Schema

In order to embed SQL inside of another language, the ________ statement must be placed before the SQL in the host language. A) RUN SQL B) EXEC SQL C) GET SQL D) SQL SQL

B) EXEC SQL

A join that is based upon equality between values in two common columns with the same name and where one duplicate column has been removed is called a(n): A) equi-join. B) natural join. C) multivariate join. D) inner join.

B) Natural Join

The subtype discriminator is a composite attribute when there is a(n): A) disjoint rule. B) overlap rule. C) full specialization. D) partial specialization

B) Overlap Rule

The subtype discriminator in the figure below is: a. Part_No. b. Part_Type. c. Location. d. Manufactured Part.

B) Part_Type

Which of the following data-mining techniques searches for patterns and correlations in large data sets? A) Signal processing B) Rule discovery C) Neural nets D) Case reasoning

B) Rule discovery

What does the following SQL statement do? Select * From Customer Where Cust_Type = "Best" A) Selects the "*" field from the Customer table for each row with a customer labeled "Best" B) Selects all the fields from the Customer table for each row with a customer labeled "Best" C) Selects fields with a "*" in them from the Customer table D) Selects all the fields from the Customer table for each row with a customer labeled "*"

B) Selects all the fields from the Customer table for each row with a customer labeled "Best"

________ is a method to store XML documents by storing each element independently in a relational table. A) Sledding B) Shredding C) Shedding D) Writing

B) Shredding

An attribute of the supertype that determines the target subtype(s) is called the: a. determinant. b. subtype discriminator. c. disjoint indicator. d. subtype decision.

B) Subtype dicriminator

Which of the following is a generic entity type that has a relationship with one or more subtypes? A) Subgroup B) Supertype C) Class D) Megatype

B) Supertype

What results will be produced by the following SQL query? Select sum(standard_price) as Total_Price from Product_V where Product_Type = 'WOOD'; A) The Standard_Price of any wood product in the table B) The total price of all products that are of type wood C) The total price of all products D) The Standard_Price of the first wood product in the table

B) The total price of all products that are of type wood

A relationship between the instances of a single entity type is called a _______ relationship. A) Binary B) Urnary C) Ternary D) Primary

B) Urnary

An XML transformation language that allows applications to query both XML data and relational databases is called: A) Xdatabase. B) XQuery. C) Xtransform. D) Xstation.

B) XQuery.

In the figure below, which attribute is derived? A) Skill B) Years_Employed C) Address D) Employee_ID

B) Years_Employed

Given a table named store with 5 fields: store_id, address, city, state, zipcode, why would the following insert command not work? insert into store values ('234 Park Street') A) It would work just fine. B) You must specify the fields to insert if you are only inserting some of the fields. C) There is no table keyword. D) Insert into should be INSERT to.

B) You must specify the fields to insert if you are only inserting some of the fields.

Extensible Markup Language (XML) is: A) a database language. B) a scripting language that allows the creation of customized tags to enable easier sharing of data across organizations. C) a special SQL command to JOIN tables. D) a product used for database middleware.

B) a scripting language that allows the creation of customized tags to enable easier sharing of data across organizations.

The following code would include: SELECT Customer_T.CustomerID,CustomerName, OrderID FROM Customer_T LEFT OUTER JOIN Order_T ON Customer_T.CustomerID = Order_T.CustomerID; A) only rows that match both Customer_T and Order_T Tables. B) all rows of the Customer_T Table regardless of matches with the Order_T Table. C) all rows of the Order_T Table regardless of matches with the Customer_T Table. D) only rows that don't match both Customer_T and Order_T Tables

B) all rows of the Customer_T Table regardless of matches with the Order_T Table.

An emerging trend likely to have an effect on the development of three-tier applications is called A) local area networks. B) cloud computing. C) wide-area storage. D) corporate computing

B) cloud computing.

The following code is an example of a(n): SELECT Customer_T.CustomerID, Order_T.CustomerID, CustomerName, OrderID FROM Customer_T, Order_T WHERE Customer_T.CustomerID = Order_T. CustomerID; A) subquery. B) equi-join. C) Right Outer JOIN. D) Full Outer JOIN.

B) equi-join.

The analysis of summarized data to support decision making is called: A) operational processing. B) informational processing. C) artificial intelligence. D) data scrubbing.

B) informational processing.

All of the following are limitations of the independent data mart EXCEPT: A) separate extraction, transformation, and loading processes are developed for each data mart. B) it is often more expedient to build a data mart than a data warehouse C) there is no capability to drill down into greater detail in other data marts. D) data marts may not be consistent with one another

B) it is often more expedient to build a data mart than a data warehouse.

Big Data includes: A) large volumes of data entry with a single data type processed at very high speeds. B) large volumes of data with many different data types that are processed at very high speeds. C) large volumes of entity relationship diagrams (ERD) with many different data types that are processed at very high speeds. D) large volumes of entity relationship diagrams (ERD) with a single data type processed at very high speeds.

B) large volumes of data with many different data types that are processed at very high speeds.

The ________ is the structure that contains descriptions of objects such as tables and views created by users. A) master view B) schema C) catalog D) SQL

B) schema

A type of join where a table is joined to itself is called a(n): A) unnatural join. B) self-join. C) pinned join. D) ternary join.

B) self-join.

The following figure shows an example of: A) a co-dependent relationship. B) a double-walled relationship. C) a strong entity and its associated weak entity. D) a one-to-many relationship

C) A strong entity and its associated weak entity

________ is an ill-defined term applied to databases where size strains the ability of commonly used relational DBMSs to manage the data. A) Small data B) Mean data C) Big data D) Star data

C) Big data

What does the following SQL statement do? Update Product_T Set Unit_Price = 775 Where Product_ID = 7 A) Updates the Product_T table to have a unit price of 775 B) Changes the length of the Unit_Price field to 775 C) Changes the unit price of Product 7 to 775 D) Changes the price of a unit called Product_T to 7

C) Changes the unit price of Product 7 to 775

________ is a set of commands used to update and query a database. A) DCL B) DPL C) DML D) DDL

C) Data Manipulative Language (DML)

The real-time data warehouse is characterized by which of the following? A) It accepts batch feeds of transaction data. B) It provides periodic access for the transaction processing systems to an enterprise data warehouse. C) Data are immediately transformed and loaded into the warehouse. D) It is based on Oracle technology.

C) Data are immediately transformed and loaded into the warehouse.

What does the following SQL statement do? Delete from Customer_T where state = 'HI'; A) Removes the Customer_T table from the database B) Doesn't delete anything because of a syntax error C) Deletes all records from customer_t where the state is equal to HI D) Deletes all records from the Customer_T table

C) Deletes all records from customer_t where the state is equal to HI

Any create command may be reversed by using a(n) ________ command. A) delete B) undo C) drop D) unpack

C) Drop

________ takes a value of TRUE if a subquery returns an intermediate results table which contains one or more rows. A) In B) Extents C) Exists D) Having

C) Exists

A client PC that is responsible for processing presentation logic, extensive application and business rules logic as well as many DBMS functions is called a: A) database server. B) file server. C) fat client. D) file processor.

C) Fat Client

An organization that decides to adopt the most popular NoSQL database management system would select: A) Neo4j. B) Redis. C) MongoDB. D) Access.

C) MongoDB.

An organization that requires a graph database that is highly scalable would select the ________ database management system. A) Excel Spreadsheet B) Access C) Neo4j D) Redis

C) Neo4j

Which of the following is NOT a good characteristic of a data name? A) Relates to business characteristics B) Readable C) Relates to a technical characteristic of the system D) Repeatable

C) Relates to a technical characteristic of the system

1. The process of defining one or more subtypes of a supertype and forming relationships is called: A) creating discord. B) selecting classes. C) specialization. D) generalization.

C) Specialization

The following code is an example of a: SELECT CustomerName, CustomerAddress, CustomerCity, CustomerState, CustomerPostalCode FROM Customer_T WHERE Customer_T.CustomerID = (SELECT Order_T.CustomerID FROM Order_T WHERE OrderID = 1008); A) FULL OUTER JOIN. B) JOIN. C) Subquery. D) Correlated subquery.

C) Subquery.

________ generally processes the largest quantities of data. A) Data marts B) Operational databases C) Transaction processing D) Big data

C) Transaction processing

_______ is a language used to transform complex XML documents and also to create HTML pages from XML documents. A) HTML B) SGI C) XSLT D) WSL

C) XSLT

An entity cluster is: a. a useful way to present data for a small and fairly simple organization. b. a way of developing more granular views of the data model. c. a set of one or more entity types and associated relationships grouped into a single abstract entity type. d. a formal method for specifying attributes of related entities.

C) a set of one or more entity types and associated relationships grouped into a single abstract entity type. *

The MERGE command: A) Joins 2 tables together. B) allows one to combine the INSERT and DELETE operations. C) allows one to combine the INSERT and UPDATE operations. D) is always a single table operation.

C) allows one to combine the INSERT and UPDATE operations.

Web services: A) are still conceptual and yet to be created. B) are a set of services available to all on the Web. C) are a set of emerging standards for protocols for automatic communication between software over the Web. D) are a set of standards based upon HTML.

C) are a set of emerging standards for protocols for automatic communication between software over the Web.

When we consider data in the data warehouse to be time-variant, we mean: A) that the time of storage varies. B) that there is a time delay between when data are posted and when we report on the data. C) data in the warehouse contain a time dimension so that they may be used to study trends and changes. D) that time is relative

C) data in the warehouse contain a time dimension so that they may be used to study trends and changes.

A ________ is a temporary table used in the FROM clause of an SQL query. A) trigger B) correlated subquery C) derived table D) view table

C) derived table

To eliminate duplicate rows in a query, the ________ qualifier is used in the SQL Select command. A) specific B) check C) distinct D) alter

C) distinct

Big data: A) requires a normalized dataset to BCNF. B) requires a strictly defined schema. C) does not require a strictly defined data model. D) requires a normalized dataset to 3rd Normal Form.

C) does not require a strictly defined data model

Going from a summary view to progressively lower levels of detail is called data: A) pivoting. B) cubing. C) drill-down. D) dicing.

C) drill-down.

Grain and duration have a direct impact on the size of ________ tables. A) selection B) grain C) fact D) figure

C) fact

An operational data store (ODS) is a(n): A) small-scale data mart. B) representation of the operational data. B) representation of the operational data. C) integrated, subject-oriented, update-able, current-valued, detailed database designed to serve the decision support needs of operational users. D) place to store all unreconciled data.

C) integrated, subject-oriented, update-able, current-valued, detailed database designed to serve the decision support needs of operational users.

Dynamic SQL: A) is not used widely on the Internet. B) is quite volatile. C) is used to generate appropriate SQL code on the fly as an application is processing. D) creates a less flexible application.

C) is used to generate appropriate SQL code on the fly as an application is processing.

Big data requires effectively processing: A) a single data type (numeric). B) two data types (text and numeric). C) many data types. D) a single data type (text).

C) many data types.

NoSQL includes data storage and retrieval: A) based on the relational model. B) not based on data. C) not based on the relational model. D) based on normalized tables.

C) not based on the relational model.

An application programming interface that enables an application program to process RDBMS databases meets the: A) multi-platform connectivity standard. B) object linking and embedding standard. C) open database connectivity standard. D) open source standard

C) open database connectivity standard.

Data that are detailed, current, and intended to be the single, authoritative source of all decision support applications are called ________ data. A) derived B) subject C) reconciled D) detailed

C) reconciled

Informational systems are designed for all of the following EXCEPT: A) supporting decision making. B) complex queries. C) running a business in real time. D) data mining

C) running a business in real time.

A module of code that may be written in a proprietary language such as Oracle's PL/SQL that implements business rules on a database server is called a(n): A) function. B) application component. C) stored procedure. D) persistent module.

C) stored procedure.

The following figure shows a: a. disjoint constraint. b. spindle constraint. c. supertype/subtype hierarchy. d. completeness constraint.

C) supertype/subtype hierarchy

A PC configured to handle user interfaces with limited local storage is called a(n): A) light client. B) fat client. C) thin client. D) overweight client.

C) thin client.

Establishing IF-THEN-ELSE logical processing within an SQL statement can be accomplished by: A) using the immediate if statement. B) using a subquery. C) using the CASE keyword in a statement. D) using the if-then-else construct

C) using the CASE keyword in a statement.

Although volume, variety, and velocity are considered the initial three v dimensions, two additional Vs of big data were added and include: A) verified and valuable. B) veracity and verified. C) veracity and value. D) volume and verified.

C) veracity and value.

The three 'v's commonly associated with big data include: A) vigilant, viewable, and verified. B) viewable, volume, and variety. C) volume, variety, and velocity. D) verified, variety, and velocity.

C) volume, variety, and velocity.

________ is the process of assigning pieces of application code to clients or servers. A) Program breakup B) Modularizing programs C) Code distribution D) Application partitioning

D) Application partitioning

A join in which the joining condition is based on equality between values in the common columns is called a(n): A) natural join. B) unilateral join. C) equi-join. D) both A and C.

D) Both A and C

A ________ specifies the number of instances of one entity that can be associated with each instance of another entity. A) counter constraint B) limit C) degree D) cardinality constraint

D) Cardinality Constraint

The total quiz points for a student for an entire semester is a(n) ________ attribute. A) addressed B) stored C) mixed D) derived

D) Derived

A ________ view is materialized when referenced. A) virtual B) materialized C) base D) dynamic

D) Dynamic

The logical representation of an organization's data is called a(n): A) relationship systems design. B) database model. C) database entity diagram. D) entity-relationship model.

D) Entity - Relationship Model

The first part of an SQL query to be read is the ________ statement. A) ORDER BY B) WHERE C) SELECT D) FROM

D) FROM

A(n) ________ is the relationship between a weak entity type and its owner. A) member chain B) jump path C) chain link D) identifying relationship

D) Identifying Relationship

According to your text, NoSQL stands for: A) Numbered Structured Query Language. B) No Structured Query Language. C) Numeric Only Structured Query Language. D) Not Only Structured Query Language.

D) Not Only Structured Query Language.

SQL provides the ________ technique, which involves placing an inner query within the WHERE or HAVING clause of an outer query. A) union B) joining C) grouping D) subquery

D) Subquery

Which of the following is a purpose of the SQL standard? A) To define every operation for every SQL database B) To specify maximum and incomplete standards C) To permit no degrees of freedom for SQL DBMS D) To specify syntax and semantics of SQL data definition and manipulation

D) To specify syntax and semantics of SQL data definition and manipulation

A logical data mart is a(n): A) centralized, integrated data warehouse. B) integrated, subject-oriented, detailed database designed to serve operational users. C) data mart consisting of only logical data. D) data mart created by a relational view of a slightly denormalized data warehouse

D) data mart created by a relational view of a slightly denormalized data warehouse

A data mart is a(n): A) smaller system built upon file processing technology. B) enterprise wide data warehouse. C) generic on-line shopping site. D) data warehouse that is limited in scope.

D) data warehouse that is limited in scope.

The NoSQL model that is specifically designed to maintain information regarding the relationships (often real-world instances of entities) between data items is called a: A) key-value score. B) wide-column store. C) document store. D) graph-oriented database.

D) graph-oriented database

A dependent data mart: A) is dependent upon an operational system. B) participates in a relationship with an entity. C) is filled with data extracted directly from the operational system. D) is filled exclusively from the enterprise data warehouse with reconciled data.

D) is filled exclusively from the enterprise data warehouse with reconciled data.

The use of a set of graphical tools that provides users with multidimensional views of their data is called: A) drill-down analysis. B) on-line datacube processing (ODP). C) on-line geometrical processing (OGP). D) on-line analytical processing (OLAP).

D) on-line analytical processing (OLAP).

Rotating the view of a multidimensional database for a particular data point is called data: A) drill-down. B) dicing. C) cubing. D) pivoting.

D) pivoting.

When reporting and analysis organization of the data is determined when the data is used is called a: A) entity relationship diagram. B) schema binding. C) cognitive schema. D) schema on read

D) schema on read

All of the following are guidelines for better query design EXCEPT: A) write simple queries. B) understand how indexes are used in query processing. C) retrieve only the data that you need. D) use a lot of self-joins.

D) use a lot of self-joins

An alternative name for an attribute is called a(n): a. alias. b. synonym. c. related characteristic. d. alternate attribute.

a. alias.

An attribute in a relation of a database that serves as the primary key of another relation in the same database is called a: a. foreign key. b. link key. c. link attribute. d. foreign attribute.

a. foreign key.

A two-dimensional table of data sometimes is called a: a. relation. b. set. c. group. d. declaration.

a. relation.

A relation that contains no multivalued attributes and has nonkey attributes solely dependent on the primary key but contains transitive dependencies is in which normal form? a. First b. Second c. Third d. Fourth

b. Second

In the figure below, what type of relationship do the relations depict? a. One-to-many b. Strong entity/weak entity c. Composite foreign key d. Multivalued

b. Strong entity/weak entity

In the SQL language, the ________ statement is used to make table definitions. a. create session b. create table c. select d. create index

b. create table

A primary key whose value is unique across all relations is called a(n): a. global primary key. b. enterprise key. c. inter-table primary key. d. foreign global key.

b. enterprise key.

The ________ states that no primary key attribute may be null. a. partial specialization rule b. entity integrity rule c. referential integrity constraint d. range domain rule

b. entity integrity rule

In packaged data models, all subtype/supertype relationships follow the ________ and ________ rules. a. partial specialization; disjoint b. total specialization; overlap c. total specialization; disjoint d. partial specialization; overlap

b. total specialization; overlap

In packaged data models, strong entities always have ________ between them. a. 1:1 relationships b. 1:M relationships c. M:N relationships d. weak entities

c. M:N relationships

A domain definition consists of all of the following components EXCEPT: a. size. b. data type. c. domain name d. integrity constraints.

c. domain name

All of the following are the main goals of normalization EXCEPT: a. make it easier to maintain data. b. simplify the enforcement of referential integrity. c. maximize storage space. d. minimize data redundancy.

c. maximize storage space.

Which of the following are properties of relations? a. Each attribute has the same name. b. There are multivalued attributes in a relation. c. No two rows in a relation are identical. d. All columns are numeric.

d. All columns are numeric.

________ database specification indicates all the parameters for data storage that are then input to database implementation. a. Logical b. Schematic c. Conceptual d. Physical

d. Physical

When a regular entity type contains a multivalued attribute, one must: a. create a single relation with multiple lines for each instance of the multivalued attribute. b. delete the relation and start over. c. create two new relations, both containing the multivalued attribute. d. create two new relations, one containing the multivalued attribute.

d. create two new relations, one containing the multivalued attribute.

A constraint between two attributes is called a(n): a. attribute dependency. b. functional relation. c. functional relation constraint. d. functional dependency.

d. functional dependency.

An attribute (or attributes) that uniquely identifies each row in a relation is called a: a. column. b. duplicate key. c. foreign field. d. primary key.

d. primary key.

A rule that states that each foreign key value must match a primary key value in the other relation is called the: a. entity key group rule. b. foreign/primary match rule. c. key match rule. d. referential integrity constraint.

d. referential integrity constraint.

Two or more attributes having different names but the same meaning are called: a. aliases. b. homonyms. c. alternate attributes. d. synonyms.

d. synonyms

A functional dependency between two or more nonkey attributes is called a: a. partial transitive dependency. b. partial nonkey dependency. c. partial functional dependency. d. transitive dependency.

d. transitive dependency.

A generic or template data model that can be reused as a starting point for a data modeling project is called a(n): a. packaged data model. b. collection data model. c. enterprise data model. d. universal data model.

d. universal data model.