DDA
(T/F): The smallest unit of named application data is a record
False
All of the following are characteristics of cloud technologies EXCEPT: A) unlimited bandwidth B) on-demand self-service IT capabilities C) broad network access D) rapid elasticity
A) unlimited bandwidth
Multiple values returned from an SQL query that includes an aggregate function are called: A) vector aggregates B) scalar aggregates C) agates D) summations
A) vector aggregates
The number of entity types that participate in a relationship is called the: A) identifying characteristic B) degree C) counter D) number
B) degree
Designing physical files requires _____ of where and when data are used in various ways A) maps B) descriptions C) keys D) hints
B) descriptions
Which type of file is easiest to update? A) sequential B) hashed C) indexed D) clustered
B) hashed
Which organizational function should set database standards? A) management B) none of these C) application development D) technical services
B) none of these
A knowledge base of information on facts about an enterprise is called a(n): A) systems information unit B) repository C) database process D) enterprise information system
B) repository
The _____ is the structure that contains descriptions of objects such as tables and views created by users. A) SQL B) schema C) catalog D) master view
B) schema
(T/F): Some examples of attributes are: eye_color, weight, and student_id, student.
False
(T/F): Supertype/subtype relationships should be used when the instances of a subtype participate in no relationships which are unique to that subtype.
False
(T/F): The CREATE SCHEMA DDL command is used to create a table.
False
(T/F): The conceptual schema is always technology specific.
False
(T/F): The data that you are interested in capturing about an entity is called an instance.
False
(T/F): The maximum criminality of a relationship is the maximum number of instances of entity B that may be associated with each instance of entity A.
False
(T/F): Using an index for attributes referenced in ORDER BY and GROUP BY clauses has no significant impact upon database performance.
False
(T/F): You will never need to map data in current databases to data in a packaged data model.
False
CASE is a class of tools that: A) provide guidelines for the physical design of a database B) automate the design of databases and application programs C) assist the database administrator in maintaining a database D) provide management reporting tools
B) automate the design of databases and application programs
A named set of SQL statements that are considered when a data modification occurs are called: A) triggers B) treatments C) stored procedures D) trapdoors
A) triggers
The command for creating a database is: A) create authorization B) create schema C) create view D) create table
B) create schema
Conformance means that: A) data have been transformed B) data are stored, exchanged or presented in a format that is specified by its metadata C) data are stored in a way to expedite retrieval D) None of these
B) data are stored, exchanged or presented in a format that is specified by its metadata
The logical representation of an organization's data is called a(n): A) database model B) entity-relationship model C) relationship systems design D) database entity diagram
B) entity-relationship model
The level of detail in a fact table determined by the intersection of all the components of the primary key, including all foreign keys and any other primary key elements, is called the: A) selection B) grain C) aggregation D) span
B) grain
One major advantage of the outer join is that: A) information is easily accessible B) information is not lost C) the query is easier to write D) all of these
B) information is not lost
A(n) _____ is a set of application routines that programs use to direct the performance of procedures by the computer's operating system. A) API B) MOM C) RPC D) LAN
A) API
What does the following SQL command do? INSERT INTO Customer_T VALUES (001, 'John Smith', '231 West St', 'Boston', 'MA', '02115'); A) Adds a new record to the Customer_T B) Creates the Customer_T table C) Deletes the Customer_T table D) Updates the Customer_T table
A) Adds a new record to the Customer_T
_____ is a rapidly developing scripting language that allows for the creation of customized tags that can be used across applications. A) Extensible Markup Language B) HTML C) SGL D) CGI
A) Extensible Markup Language
The three-schema approach includes which of the following schemas? A) Internal B) Logical C) Cross-functional D) Dissecting
A) Internal
OLAP tools that use the database as a traditional relational database are called: A) ROLAP tools B) none of these C) MOLAP tools D) slice and dice
A) ROLAP tools
What result set will the following query return? SELECT Item_No FROM Order_V WHERE quantity > 10; A) The Item_No of all orders that had more than 10 items B) The Order_Id of all orders that had more than one item C) The Order_Id of all orders that had more than 10 items D) The Item_No of all orders that had 10 or more items
A) The Item_No of all orders that had more than 10 items
Which of the following is a completeness constraint? A) Total specialization B) Partial generalization C) Total recall D) Partial hybridization
A) Total specialization
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) connecting entity C) intersectional entity D) All of these
A) associative entity
An attribute that may have more than one meaning is called a(n): A) homonym B) alias C) double defined attribute D) synonym
A) homonym
An operation to join a table to itself is called a(n): A) self-join B) sufficient-join C) outer join D) inner join
A) self-join
Which of the following is the wildcard operator in SQL statements? A) <> B) * C) = D) &
B) *
Organizations that utilize the file processing approach spend as much as _____ of their IS development budget on maintenance. A) 60 percent B) 80 percent C) 25 percent D) 40 percent
B) 80 percent
Which of the following is not a disadvantage of stored procedures? A) Writing stored procedures takes more time than writing an application in Visual Basic or PowerBuilder B) Decreases in network traffic are realized C) Stored procedures are proprietary and not easy to move from one RDBMS to another D) Each client must be loaded with the application to be used at that location
B) Decreases in network traffic are realized
FLWOR is an acronym for: A) flowers B) For, LET, Where, OrderBy, Return C) For, Locate, Work, Order, Results D) None of these
B) For, LET, Where, OrderBy, Return
_____ 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) User interface enhancers B) Middleware C) Interface managers D) MPP
B) Middleware
What results would the following SQL statement produce? SELECT owner, table_name FROM dba_tables WHERE table_name = 'CUSTOMER' A) a listing of all customers in the customer table B) a listing of the owner of the customer table C) a listing of the owner of the customer table as well as customers D) an error message
B) a listing of the owner of the customer table
The following figure shows an example of: (The picture shows a box on the left labeled 'Employee'. It has a line connecting it to another box on the right labeled 'Dependent'. This box has another box inside the first box. It also has 3 prongs going into it from the line. The line is labeled 'Carries') A) a one-to-many relationship B) a strong entity and its associated weak entity C) a codependent relationship D) a double-walled relationship
B) a strong entity and its associated weak entity
Web services: A) are a set of services available to all on the Web B) are a set of emerging standards for protocols for automatic communication between software over the Web C) are a set of standards based upon HTML D) None of these
B) are a set of emerging standards for protocols for automatic communication between software over the Web
The _____ rule states that an entity instance can simultaneously be a member of two (or more) subtypes A) disjoint B) overlap C) partial specialization D) total specialization
B) overlap
Indexes are created in most RDBMSs to: A) increase the cost of implementation B) provide rapid random and sequential access to base-table data C) provide a quicker way to store data D) decrease the amount of disk space utilized
B) provide rapid random and sequential access to base-table data
A _____ limits the set of permissible values a field may assume. A) null value control B) range control C) candidate key D) primary key
B) range control
A centralized knowledge base of all data definitions, data relationships, screen and report formats, and other system components is called a(n): A) index B) repository C) data warehouse D) database management system
B) repository
A candidate key must satisfy all of the following conditions EXCEPT: A) the key must be nonredundant B) the key must indicate a row's position in the table C) each nonkey attribute is functionally dependent upon it D) the key must uniquely identify the row
B) the key must indicate a row's position in the table
A PC configured to handle user interfaces with limited local storage is called a: A) fat client B) thin client C) light client D) overweight client
B) thin client
_____ takes a value of true if a subquery returns an intermediate results table which contains one or more rows A) IN B) HAVING C) EXISTS D) EXTENTS
C) EXISTS
Which of the following is true about three-tier architectures? A) Less scalable than two-tier B) Increased risk C) More technological flexibility D) All of these
C) More technological flexibility
What result set is returned from the following query? SELECT Customer_Name, telephone FROM customers WHERE city IN ('Boston', 'New York', 'Denver') A) The Customer_Name of all customers living in Boston, New York or Denver B) The Customer_Name and telephone of all customers C) The Customer_Name and telephone of all customers living in either Boston, New York or Denver D) The Customer_Name and telephone of all customers living in Boston and New York and Denver
C) The Customer_Name and telephone of all customers living in either Boston, New York or Denver
_____ is a language used to transform complex XML documents and also to create HTML pages from XML documents. A) WSL B) HTML C) XSLT D) SGI
C) XSLT
SQL-invoked routines can be: A) procedures B) functions C) all of these D) none of these
C) all of these
The property by which subtype entities possess the values of all attributes of a supertype is called: A) hierarchy reception B) class management C) attribute inheritance D) generalization
C) attribute inheritance
A form of database specification that indicates all the parameters for data storage that are then input to database implementation is: A) logical B) conceptual C) physical D) schematic
C) physical
Another word for a data definition is a(n): A) composite key B) relationship C) structural assertion D) entity
C) structural assertion
Quality data can be defined as being: A) precise B) historical C) unique D) inaccurate
C) unique
A(n) _____ is often developed by identifying a form or report that a user needs on a regular basis. A) reporting document B) enterprise view C) user view D) user snapshot
C) user view
The real-time data warehouse is characterized by which of the following? A) It accepts near-real-time feeds of transaction data B) Data are immediately transformed and loaded into the warehouse C) It provides near-real-time access for the transaction processing systems to an enterprise data warehouse D) All of these
D) All of these
Which of the following is true of data visualization? A) It is easier to observe trends and patterns in data B) Correlations and clusters in data can be easily identified C) It is often used in conjunction with data mining D) All of these
D) All of these
Which of the following types of data can be stored in a database? A) Voice B) Letters C) Numbers D) All of these
D) All of these
In the figure below, what type of key is depicted? (A row labeled 'Employee' has 4 boxes underneath labeled Employee_ID [underlined], Name, Birthdate, and Manager_ID [dashed underlined]. There is an arrow from Manager_ID to Employee_ID) A) Primary B) Recursive primary C) Composite D) Recursive foreign
D) Recursive foreign
Which of the following is NOT a good characteristic of a data name? A) Relates to business characteristics B) Readable C) Repeatable D) Relates to a technical characteristic of the system
D) Relates to a technical characteristic of the system
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) file processor D) fat client
D) fat client
The most commonly used form of join operation is the: A) outer join B) union join C) equi-join D) natural join
D) natural join
The subtype discriminator is a composite attribute when there is a(n): A) full specialization B) disjoint rule C) partial specialization D) overlap rule
D) overlap rule
One characteristic of quality data which pertains to the expectation for the time between when data are expected and when they are available for use is: A) currency B) consistency C) referential integrity D) timeliness
D) timeliness
EXISTS will take a value of _____ if the subquery returns an intermediate results table which contains one or more rows. A) undefined B) 1 C) false D) true
D) true
(T/F): A cardinality constraint tells what kinds of properties are associated with an entity.
False
(T/F): Anomalies do not generally arise out of transitive dependencies
False
(T/F): Java programs similar to applets that execute on the server are called hamlets.
False
(T/F): Lack of secure standards and lack of user acceptance are the major issues that must be resolved with Web services.
False
(T/F): Operational metadata are derived from the enterprise data model.
False
(T/F): SOAP is an insignificant Web standard.
False
(T/F): A business rule is a statement that defines or constrains some aspect of the business.
True
(T/F): A completeness constraint may specify that each entity of the supertype must be a member of some subtype in the relationship.
True
(T/F): A universal data model is a generic or template data model that can be reused as a starting point for a data modeling project.
True
(T/F): An insert command does not need to have the fields listed.
True
(T/F): Client/server describes a networked computing model that distributes processes between computers that request services and computers that provide services.
True
(T/F): Data names should always relate to business characteristics.
True
(T/F): In an E-R diagram, an associative entity is represented by a rounded rectangle.
True
(T/F): Some DBMS can handle graphic data types as well as text and numbers.
True
(T/F): The following query totals sales for each salesperson. SELECT salesperson_id, SUM(sales) FROM salesperson GROUP BY salesperson_id;
True
(T/F): The most common way to support a group of individuals who work together on a project or group of similar projects is with a two-tier client/server database.
True
(T/F): The presentation logic component of a client/server system is responsible for formatting and presenting data on the user's screen.
True
(T/F): The repository is populated during the analysis phase of the systems development life cycle.
True
(T/F): The views are created by executing a CREATE VIEW SQL command.
True
(T/F): Web services allow for communication between programs over the Internet.
True
(T/F): When a regular entity type contains a multivalued attribute, two relations are created.
True
(T/F): When choosing an identifier, choose one that will not change its value often.
True
(T/F): When normalizing, the goal is to decompose relations with anomalies to produce smaller, well-structured relations
True
_____ is the process of assigning pieces of application code to clients or servers. A) Application partitioning B) Modularizing programs C) Code distribution D) Program breakup
A) Application partitioning
Service-oriented architectures (SOA) are: A) a collection of services that communicate with each other in some manner. B) a set of tiers designed to serve each other C) none of these D) architecture designed for the military
A) a collection of services that communicate with each other in some manner.
A nonkey attribute is also called a(n): A) descriptor B) unimportant datum C) address D) column
A) descriptor
All of the following are valid datatypes in Oracle 11g EXCEPT: A) varchar2 B) boolean C) blob D) number
B) boolean
A _____ view is materialized when referenced A) virtual B) dynamic C) materialized D) base
B) dynamic
A requirement to begin designing physical files and databases is: A) normalized relations B) definitions of each attribute C) technology descriptions D) all of these
D) all of these
An understanding of how to merge relations is important because: A) there may be a need to merge relations on projects with subteams B) different views may need to be integrated C) new data requirements may produce new relations to be merged D) all of these
D) all of these
Which of the following has affected the way businesses use computing systems to meet the demand of the competitive marketplace? A) GUI evolutions B) communication changes C) networking advances D) all of these
D) all of these
All of the following are ways to handle changing dimensions EXCEPT: A) create a new dimension table row each time the dimension object changes B) for each dimension attribute that changes, create a current value field and as many old value fields as we wish C) overwrite the current value with the new value D) create a snowflake schema
D) create a snowflake schema
Which of the following is an integrated decision support database with content derived from various operational databases? A) corporate data structure B) relational DBMS C) client-server system D) data warehouse
D) data warehouse
If the DBA wishes to describe all tables in the database, which data dictionary view should be accessed in Oracle? A) dba_tab_privs B) dba_tab_comments C) dba_table_label D) dba_tables
D) dba_tables
The most important challenge of customizing a purchased data model is: A) user training B) getting user buy-in C) implementation D) determining the business rules that will be established through the data model
D) determining the business rules that will be established through the data model
(T/F): A language used to transform complex XML documents and also used to create HTML pages from XML documents is called Extensible Stylesheet Transformation.
False
(T/F): WXDL is an XML-based grammar.
False
(T/F): Medical claims and pharmaceutical data are examples of big data.
True
(T/F): The user interface includes languages, menus, and other facilities by which users interact with various system components.
True
In the figure below, the primary key for "Order Line" is which type of key? (The picture shows 4 rows.) (The first row is labeled 'Customer' and has 6 boxes underneath labeled Customer_ID [underlined], Customer_Name, Address, City*, State*, Zip*.) (The second row is labeled 'Order' and has 3 boxes underneath labeled Order_ID [underlined], Order_Date, Customer_ID [dashed underline]) (The third row is labeled 'Order Line' and has 3 boxes underneath labeled Order_ID [underlined], Product_ID [underlined], Quantity) (The fourth row is labeled 'Product' and has 5 boxes underneath labeled Product_ID [underlined], Product_Description, Product_Finish, Standard_Price, On_Hand*) A) Composite B) Foreign C) Standard D) Grouped
A) Composite
In a supertype/subtype hierarchy, each subtype has: A) only one supertype B) at most two supertypes C) at least one subtype D) many supertypes
A) only one supertype
Data that are detailed, current, and intended to be the single, authoritative source of all decision support applications are called _____ data. A) reconciled B) derived C) detailed D) subject
A) reconciled
What will be returned when the following SQL statement is executed? SELECT driver_no, COUNT(*) AS num_deliveries FROM deliveries GROUP BY driver_no; A) A listing of all drivers, sorted by driver number B) A listing of each driver as well as the number of deliveries that he or she has made C) A count of all of the deliveries made by all drivers D) None of these
B) A listing of each driver as well as the number of deliveries that he or she has made
Which of the following questions is answered by the SQL statement? SELECT COUNT(Product_Description) FROM Product_T; A) How many products are in the table Product_T? B) How many products have product descriptions in the Product Table? C) How many characters are in the field name "Product_Description"? D) How many different columns named "Product_Description" are there in table Product_T?
B) How many products have product descriptions in the Product Table?
Which of the following is not a suggestion by Salin regarding developing data names? A) Prepare a definition of the data B) Keep insignificant or illegal words C) Arrange the words in a meaningful, repeatable way D) Assign a standard abbreviation for each word
B) Keep insignificant or illegal words
In order for two queries to be UNION-compatible, they must: A) all of these B) both output compatible data types of each column and return the same number of rows C) both have the same number of lines in their SQL statements D) both return at least one row
B) both output compatible data types of each column and return the same number of rows
A join operation: A) causes two disparate tables to be combined into a single table or view B) causes two tables with a common domain to be combined into a single table or view C) is used to combine indexing operations D) brings together data from two different tables
B) causes two tables with a common domain to be combined into a single table or view
Which of the following is NOT a reason to create an instance of a relational schema with sample data? A) Sample data can be used to improve user communications B) Sample data can be used for prototype generation C) Sample data can reverse database implementation errors D) Sample data provide a convenient way to check the accuracy of your design
C) Sample data can reverse database implementation errors
Which of the following will produce the minimum of all standard prices? A) Select standard_price from Product_V where Standard_Price = min; B) Select min(Standard_Price) from Product_V where Standard_Price = min(Standard_Price); C) Select min(standard_price) from Product_V; D) Select Standard_Price from min(Product_V);
C) Select min(standard_price) from Product_V;
A user view is: A) what a user sees when he or she looks out the window B) a table or set of tables C) a logical description of some portion of the database D) a procedure stored on the server
C) a logical description of some portion of the database
An alternative name for an attribute is a(n): A) related characteristic B) synonym C) alias D) alternate attribute
C) alias
All of the following are primary purposes of a database management system (DBMS) EXCEPT: A) creating data B) storing data C) providing an integrated development environment D) updating data
C) providing an integrated development environment
Which of the following data-mining techniques searches for patterns and correlations in large data sets? A) case reasoning B) signal processing C) rule discovery D) neural nets
C) rule discovery
One field or combination of fields for which more than one record may have the same combination of values is called a(n): A) composite key B) linked key C) secondary key D) index
C) secondary key
When an XML document is shredded, each element is: A) added to other XML documents B) split up C) stored in a relational table D) thrown away
C) stored in a relational table
A type of query that is placed within a WHERE or HAVING clause of another query is called a: A) multi-query B) master query C) subquery D) superquery
C) subquery
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) constraints B) dimensions C) supertypes D) subtypes
C) supertypes
Which of the following is a component of processing logic? A) Input B) Output C) Retrieval D) Business rules
D) Business rules
Which of the following is an entity type on which a strong entity depends? A) Owner B) Member C) Attribute D) None of these
D) None of these
Which organizational function should set database standards? A) Management B) Application development C) Technical services D) None of these
D) None of these
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) inner join B) equi-join C) multivariate join D) natural join
D) natural join
Rotating the view of a multidimensional database for a particular data point is called data: A) cubing B) drill-down C) dicing D) pivoting
D) pivoting
_____ ensures that a value of a field exists in another database table. A) domain integrity B) null value control C) index integrity D) referential integrity
D) referential integrity
All of the following are advantages of SQL-invoked routines EXCEPT: A) flexibility B) efficiency C) sharability D) security
D) security
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: A) persistent module B) function C) application component D) stored procedure
D) stored procedure
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 not a common distribution logic for two-tiered server environments? A) thin client B) distributed C) fat client D) tall client
D) tall client
In an E-R diagram, there are _____ business rule(s) for every relationship. A) no B) one C) three D) two
D) two
All of the following are objectives when selecting a data type EXCEPT: A) support all data manipulations B) represent all possible values C) improve data integrity D) use a lot of storage space
D) use a lot of storage space
A good data definition will describe all of the characteristics of a data object EXCEPT: A) subtleties B) examples C) who determines the value of the data D) who can delete the data
D) who can delete the data
(T/F): A co-dependency is a constraint between two attributes or two sets of attributes.
False
(T/F): A composite key consists of only one attribute.
False
(T/F): A data mart is a data warehouse that contains data that can be used across the entire organization.
False
(T/F): A default value is the value that a field will always assume, regardless of what the user enters for an instance of that field.
False
(T/F): A file organization is a named portion of primary memory
False
(T/F): A file organization is a named portion of primary memory.
False
(T/F): A foreign key is a primary key of a relation that also is a primary key in another relation
False
(T/F): A referential integrity constraint specifies that the existence of an attribute in one table depends upon the existence of a foreign key in the same or another table.
False
(T/F): A single value returned from an SQL query that includes an aggregate function is called a vector aggregate.
False
(T/F): A snowflake schema is usually heavily aggregated.
False
(T/F): An XML schema is a language used to define HTML.
False
(T/F): An enterprise data model describes the scope of data for only one information system.
False
(T/F): An entity type on which a strong entity is dependent is called a covariant entity.
False
(T/F): An equi-join is a join in which one of the duplicate columns is eliminated in the result table.
False
(T/F): An extent is a named portion of secondary memory allocated for the purpose of storing physical records
False
(T/F): An extent is a named portion of secondary memory allocated for the purpose of storing physical records.
False
(T/F): An operational data store typically holds a history of snapshots of the state of an organization whereas an enterprise data warehouse does not typically contain history.
False
(T/F): Count(*) tallies only those rows that contain a value, while Count counts all rows.
False
(T/F): DBA_USERS contains comments on all tables in an Oracle database.
False
(T/F): Data integrity consists of powerful operations to manipulate data stored in relations.
False
(T/F): Database development projects are never done in a bottom-up fashion.
False
(T/F): Databases were developed as the first application of computers to data processing.
False
(T/F): Denormalization is the process of transforming relations with variable-length fields into those with fixed-length fields
False
(T/F): EXISTS takes a value of false if the subquery returns an intermediate result set.
False
(T/F): Generalization is a top-down process.
False
(T/F): The degree of a relationship is the number of attributes that are associated with it.
False
(T/F): The disjoint rule specifies that if an entity instance of the supertype is a member of one subtype, it MUST simultaneously be a member of another subtype.
False
(T/F): The following figure is an example of the overlap rule. (This diagram shows a box at the top labeled EMPLOYEE. It has an arrow pointing to a circle directly below it with an x in it. This circle branches to 3 boxes below labeled SALARIED, HOURLY, and CONSULTANT. The lines connecting the lower boxes to the circle are all arrows.)
False
(T/F): When the total specialization rule is set for a supertype/subtype relationship, one could roughly compare the supertype to an abstract class in object-oriented programming.
False
(T/F): When transforming a unary many-to-many relationship to relations, a recursive foreign key is used
False
(T/F): A corporate information factory (CIF) is a comprehensive view of organizational data in support of all user data requirements.
True
(T/F): A correlated subquery is executed once for each iteration through the outer loop.
True
(T/F): A data model is a graphical system used to capture the nature and relationships among data.
True
(T/F): A data steward is a person assigned the responsibility of ensuring the organizational applications properly support the organization's enterprise goals for data quality.
True
(T/F): A modern database management system automates more of the backup and recovery tasks than a file system.
True
(T/F): A partial functional dependency is a functional dependency in which one or more non-key attributes are functionally dependent on part (but not all) of the primary key
True
(T/F): A primary key is an attribute that uniquely identifies each row in a relation
True
(T/F): A procedure is run by calling it by its name.
True
(T/F): A single occurrence of an entity is called an entity instance.
True
(T/F): A transaction is the complete set of closely related update commands that must all be done, or none of them done, for the database to remain valid.
True
(T/F): A trigger is a named set of SQL statements that are considered when a data modification occurs.
True
(T/F): A well-structured relation contains minimal redundancy and allows users to manipulate the relation without errors or inconsistencies.
True
(T/F): Adding the DISTINCT keyword to a query eliminates duplicates.
True
(T/F): Advances in computer hardware, particularly the emergence of affordable mass storage and parallel computer architectures, was one of the key advances that led to the emergence of data warehousing.
True
(T/F): An SQL query that implements an outer join will return rows that do not have matching values in common columns.
True
(T/F): Data modeling is about documenting rules and policies of an organization that govern data.
True
(T/F): Data structures include data organized in the form of tables with rows and columns.
True
(T/F): Denormalization almost always leads to more storage space for raw data.
True
(T/F): Efficient database structures will be beneficial only if queries and the underlying database management system are tuned to properly use the structures.
True
(T/F): End users can often retrieve and display data easily with a relational database.
True
(T/F): Extensible Markup Language (XML) is a scripting language based upon SGML that allows the creation of customized tags.
True
(T/F): Indexes are most useful for columns that frequently appear in WHERE clauses of SQL commands, either to qualify the rows to select or for linking.
True
(T/F): It is easy to miss the opportunity to visualize future requirements shown in the full data model when using a packaged data model.
True
(T/F): Java servlets execute from within another program and reside on the server.
True
(T/F): Mapping existing data to new data in a packaged data model is useful for developing migration plans.
True
(T/F): Metadata are data that describe the properties of other data.
True
(T/F): One decision in the physical design process is selecting structures.
True
(T/F): One objective of selecting a data type is to minimize storage space.
True
(T/F): One of the major challenges in data modeling is to recognize and clearly represent entities that are almost the same.
True
(T/F): One property of a relation is that each attribute within a relation has a unique name
True
(T/F): One property of a relation is that each attribute within a relation has a unique name.
True
(T/F): Open Database Connectivity is an application programming interface that provides a common language for application programs to access and process SQL databases independent of the particular RDBMS that is accessed.
True
(T/F): Organizations adopt data mart architectures because it is easier to have separate, small data warehouses than to get all organizational parties to agree to one view of the organization in a central data warehouse.
True
(T/F): PHP is a platform for Web development.
True
(T/F): Periodic data are data that are never physically altered or deleted once they have been added to the store.
True
(T/F): Relationships represent action being taken using a verb phrase.
True
(T/F): Rule discovery searches for patterns and correlations in large data sets.
True
(T/F): Sample data are useful for developing prototype applications and for testing queries.
True
(T/F): Software as a service (SAAS) refers to an entire application or suite of applications running on the cloud.
True
(T/F): Storing XML data is becoming a big question as XML data becomes more prevalent.
True
(T/F): The E-R model is used to construct a conceptual model.
True
(T/F): The SQL command used to populate tables is the INSERT command.
True
(T/F): The UNION clause is used to combine the output from multiple queries into a single result table.
True
(T/F): The WHERE clause includes the conditions for row selection within a single table or view and the conditions between tables or views for joining.
True
(T/F): The WHERE clause is always processed before the GROUP BY clause when both occur in a SELECT statement.
True
(T/F): The columns of a relation can be interchanged without changing the meaning or use of the relation.
True
(T/F): The first requirement for building a user-friendly interface is a set of metadata that describes the data in the data mart in business terms that users can easily understand.
True
(T/F): The storage component of a client/server architecture is responsible for data storage and retrieval from the physical storage devices associated with the application.
True
An entity type whose existence depends on another entity type is called a _____ entity. A) strong B) weak C) codependent D) variant
B) weak
(T/F): The DELETE TABLE DDL command is used to remove a table from the database.
False
What does the following SQL statement do? SELECT * FROM Customer WHERE Cust_Type = "Best" A) Selects all the fields from the Customer table for each row with a customer labeled "Best" B) Selects the "<sup>*</sup>" field from the Customer table for each row with a customer labeled "Best" C) Selects fields with a "<sup>*</sup>" in them from the Customer table D) Selects all the fields from the Customer table for each row with a customer labeled "<sup>*</sup>"
A) Selects all the fields from the Customer table for each row with a customer labeled "Best"
_____ is an ill-defined term applied to databases where size strains the ability of commonly used relational DBMSs to manage the data. A) big data B) star data C) small data D) mean data
A) big data
Which of the following is a technique for optimizing the internal performance of the relational data model? A) clustering data B) avoiding indexes on secondary keys C) not reporting statistics to save machine resources D) using random index organizations
A) clustering data
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 do not match in two tables D) none of these
A) combine the output from multiple queries into a single result table
The value a field will assume unless the user enters an explicit value for an instance of that field is called a: A) default value B) null value C) range control D) gurand
A) default value
In most cases the goal of _____ dominates the design process A) efficient data processing B) security C) quick pointer updates D) shorter design times
A) efficient data processing
The smallest unit of application data recognized by system software is a: A) field B) row C) data type D) column
A) field
The first in a series of steps to follow when creating a table is to: A) identify each attribute and its characteristics B) create an index C) identify columns that must be unique D) identify columns that must be null
A) identify each attribute and its characteristics
A simultaneous relationship among the instances of three entity types is called a _____ relationship. A) ternary B) tertiary C) primary D) binary
A) ternary
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) the instances of a subtype do not participate in a relationship that is unique to that subtype D) none of these
A) there are attributes that apply to some but not all instances of an entity type
A method for handling missing data is to: A) track missing data with special reports B) perform sensitivity testing C) all of these D) substitute and estimate for the missing data
A) track missing data with special reports
(T/F): The status of data is the representation of the data after an event has occurred.
False
(T/F): SOX stands for the Sorbet-Oxford Act
False
All of the following are limitations of the independent data mart EXCEPT: A) data marts may not be consistent with one another B) it is often more expedient to build a data mart than a data warehouse C) separate extraction, transformation, and loading processes are developed for each data mart D) there is no capability to drill down into greater detail in other data marts
B) it is often more expedient to build a data mart than a data warehouse
A database is an organized collection of _____ related data. A) loosely B) logically C) badly D) physically
B) logically
All of the following are concerns about developing a Web services approach EXCEPT: A) transaction speed B) user acceptability C) security D) reliability
B) user acceptability
Languages, menus, and other facilities by which users interact with the database are collectively called a(n): A) client B) user interface C) icon D) development environment
B) user interface
A data warehouse derives its data from: A) online transactions B) various operational databases C) reports D) a datamart
B) various operational databases
An emerging trend likely to have an effect on the development of three-tier applications is called: A) corporate computing B) local area networks C) cloud computing D) wide-area storage
C) cloud computing
_____ is a component of the relational data model included to specify business rules to maintain the integrity of data when they are manipulated. A) business integrity B) business rule constraint C) data integrity D) data structure
C) data integrity
A good method for identifying inconsistencies and finding hidden meaning in the customized purchased data model is: A) data analysis B) data volume usage analysis C) data profiling D) user interviews
C) data profiling
A detailed coding scheme recognized by system software for representing organizational data is called a(n): A) DBMS code B) SQL C) data type D) DB layout
C) data type
In the figure below, the patient must be either an outpatient or a resident patient. This is an example of the _____ rule. (In the figure, the circle joining the 'Patient', 'Outpatient', and 'Resident patient' boxes together has the letter 'd' in it.) A) generalization B) overlap C) disjoint D) specialization
C) disjoint
Which of the following organizational trends does not encourage the need for data warehousing? A) multiple, nonsynchronized systems B) focus on supplier relationship management C) downsizing D) focus on customer relationship management
C) downsizing
A constraint between two attributes is called a(n): A) functional relation B) attribute dependency C) functional dependency D) functional relation constraint
C) functional dependency
A(n) _____ is a routine that converts a primary key value into a relative record number A) record index calculator B) index pointer program C) hashing algorithm D) pointing algorithm
C) hashing algorithm
Which of the following finds all groups meeting stated conditions? A) select B) where C) having D) find
C) having
A(n) _____ is the relationship between a weak entity type and its owner. A) chain link B) jump path C) identifying relationship D) member chain
C) identifying relationship
An index on columns from two or more tables that come from the same domain of values is called a: A) bitmap index B) multi-valued index C) join index D) transaction index
C) join index
The third step in the data modeling process with a packaged data model is: A) rename relationships B) rename identified data elements C) map data to be used from package to data in current databases D) interview users
C) map data to be used from package to data in current databases
All of the following are the main goals of normalization EXCEPT: A) minimize data redundancy B) simplify the enforcement of referential integrity C) maximize storage space D) make is easier to maintain data
C) maximize storage space
In the figure below, a student: (The figure has a top box labeled 'Student', a bottom-left box labeled 'Graduate', a bottom-middle box labeled 'Undergraduate', and a bottom-right box labeled 'Special'. All four boxes have solid lines coming out of them that join a circle in the middle.) A) must be a graduate student, or an undergraduate student B) must at least be a special student C) must be a graduate student, an undergraduate, a special student or some other type of student D) none of these
C) must be a graduate student, an undergraduate, a special student or some other type of student
The use of a set of graphical tools that provides users with multidimensional views of their data is called: A) online geometrical processing (OGP) B) drill-down analysis C) online analytical processing (OLAP) D) online datacube processing (ODP)
C) online analytical processing (OLAP)
In the following diagram, what type of relationship is depicted? (There are four total boxes connected in the middle by lines.The top box is labeled 'Part', the box to the left is labeled 'Vendor', the box to the right is labeled 'Warehouse', and the bottom box is labeled 'Shipping_Mode Unit_Cost'. The top, left, and right boxes all have a solid line leading to the middle, while the bottom box has a dotted line. Underneath the solid lines is the word supplies. Each solid like has crows feat leading to the boxes.) A) binary B) quad C) ternary D) unary
C) ternary
The XML shown in the figure below describes some data from the Pine Valley Furniture case study. "PVFC.xml": <?xml version="1.0"/> <furniturecompany> <product ID="1"> <description>End Table</description> <finish>Cherry</finish> <standard price>175.00</standard price> <line>1</line> </product> </furniturecompany> What results does the following XPath expression return? /furniturecompany/product/[finish = "Cherry"]/standardprice A) all products with a cherry finish B) a description of all products with a cherry finish C) the standard price of products with a cherry finish D) nothing
C) the standard price of products with a cherry finish
In the figure below, to which of the following entities are the entities "CAR" and "TRUCK" generalized? (In the figure, the top box is labeled 'Vehicle', the bottom-left box is labeled 'Car', and the bottom-right box is labeled 'Truck'. Each box has a solid line coming out of it and leading to an empty circle in the middle.) A) price B) model C) vehicle D) make
C) vehicle
A technical specification for creating a distributed registry of Web services and businesses that are open to communicating through Web services is called: A) B2B B) XML C) HTML D) UDDI
D) UDDI
A procedure is: A) stored within the database B) given a unique name C) called by name D) all of these
D) all of these
Which of the following factors drive the need for data warehousing? A) informational data must be kept together with operational data B) none of these C) data warehouses generally have better security D) businesses need an integrated view of company information
D) businesses need an integrated view of company information
In the following diagram, which answer is true? (The diagram shows two boxes: one on the left labeled 'Employee' and one on the right labeled 'Department'. The diagram also shows three lines. One line leads to and from the 'Employee' box, one side has three prongs and a circle labeled 'Supervised_by' and the other side has two dashes labeled 'Supervises'. Another line leads from 'Employee' to 'Department', the 'Employee' side has three prongs and a dash labeled 'Works_in' and the other side has two dashes labeled 'Has_workers'. The last line leads from 'Employee' to 'Department', the 'Employee' side has two dashes labeled 'Manages' and the other side has one dash and a circle labeled 'Is_managed_by'.) A) all of these B) each employee works in more than one department C) each employee can manage many departments D) each employee can supervise one to many employees
D) each employee can supervise one to many employees
The most common source of database failures in organizations is: A) lack of planning B) inadequate budget C) inadequate hardware D) failure to implement a strong database administration function
D) failure to implement a strong database administration function
(T/F): A key is a data structure used to determine the location of rows in a file that satisfy some condition
False
(T/F): In an E-R diagram, strong entities are represented by double-walled rectangles.
False
(T/F): In the figure shown below, a rental unit can be both a house and an apartment. (The figure shows three boxes: the top box is labeled 'Rental unit', the bottom-left box is labeled 'Apartment' and the bottom-right box is labeled 'House'. All three boxes have solid likes coming out of them, joining in the middle at a circle with the letter 'd' in it.)
False
(T/F): In the figure shown below, a rental unit can be both an apartment and a house but must at least be one. (This diagram shows a box at the top labeled RENTAL UNIT. It has a bold line to a circle directly below it with an o in it. This circle branches to two boxes below labeled APARTMENT and HOUSE. The lines connecting the lower boxes to the circle are not bold.)
False
(T/F): In two-tier database architectures, little functionality needs to be programmed into the client application.
False
(T/F): Infrastructure-as-a-Service refers to the use of technologies such as servers, storage and networks from external service providers.
False
(T/F): The physical structure and storage organization of the database are decided upon during the implementation phase of the systems development life cycle.
False
(T/F): The process of assigning parts of an application to a client or server is called application partitioning.
False
(T/F): The relational data model does, at this time, directly support subtype/supertype relationships
False
(T/F): The representation of data in a graphical format is called data mining.
False
(T/F): The total specialization rule states that an entity instance of a supertype is allowed not to belong to any subtype.
False
(T/F): Transaction integrity commands are not used to identify whole units of database changes that must be completed in full for the database to retain integrity.
False
(T/F): Transient data are never changed.
False
(T/F): Triggers can be used to ensure referential integrity, enforce business rules, create audit trails, and replicate tables, but cannot call other triggers.
False
(T/F): When transforming a unary many-to-many relationship to relations, a recursive foreign key is used.
False
(T/F): A subtype can become a supertype if the subtype has other subtypes beneath it.
True
(T/F): An enterprise data warehouse is the control point and single source of all data made available to end users for decision support applications.
True
(T/F): An enterprise resource planning system integrates all functions of the enterprise.
True
(T/F): An entity instance of a subtype represents the same entity instance of the supertype.
True
(T/F): An entity is a person, place, object, event, or concept in the user environment about which the organization wishes to maintain data.
True
(T/F): An independent data mart is filled with data extracted from the operational environment without the benefit of a data warehouse.
True
(T/F): Figuring out what attributes you want in your query before you write the query will help with query writing.
True
(T/F): File processing systems have been replaced by database systems in most critical business applications today.
True
(T/F): In a supertype/subtype hierarchy, attributes are assigned at the highest logical level that is possible in the hierarchy.
True
(T/F): In the figure shown below, there could be an instance of a rental unit that is neither an apartment nor a house. (This diagram shows a box at the top labeled RENTAL UNIT. It has a line to a circle directly below it with a d in it. This circle branches to two boxes below labeled APARTMENT and HOUSE. The lines connecting the lower boxes to the circle are not bold.)
True
(T/F): When two or more attributes describe the same characteristic of an entity, they are synonyms.
True
(T/F): XQuery is an XML transformation language for querying relational data as well as XML databases.
True
