Database Processing: Fundamentals, Design, and Implementation 14th Edition

In a common form of RFM analysis, customers with an R score of 5 are in the 20% of customers who have the most recent orders. Answer: FALSE Answer: FALSE Answer: FALSE The SQL built-in function MIN obtains the smallest value in a numeric column. Answer: TRUE Answer: TRUE Answer: TRUE MySQL uses the MySQL TODAYS_DATE()

In Microsoft Access, foreign keys are designated by using the Foreign Key button in the toolbar. Answer: FALSE[/cpmembership] Answer: FALSE[/cpmembership] Answer: FALSE[/cpmembership] In regard to database security, neither the DBMS nor the database applications can enforce processing responsibilities. Answer: TRUE Answer: TRUE Answer: TRUE In two-phase locking, all locks are obtained during the growing phase. Answer: TRUE Answer:

Data warehouses are populated with data prepared by Extract, Transform, and Load (ETL) systems. Answer: TRUE Answer: TRUE Answer: TRUE In general, the overall responsibility of the DBA is to facilitate the development and use of the database system. Answer: TRUE Answer: TRUE Answer: TRUE To represent an IS-A relationship in a relational database design, the IS-A

Locks placed by a command issued to the DBMS from the application program are called explicit locks. Answer: TRUE Answer: TRUE Answer: TRUE Sequenced Query Language (SQL) is an internationally recognized standard language that is understood by all commercial database management system products. Answer: FALSE Answer: FALSE Answer: FALSE A passive data repository is preferred over

Microsoft Access is just a DBMS. Answer: FALSE[/cpmembership] Answer: FALSE[/cpmembership] Answer: FALSE[/cpmembership] The IIS Web server is managed using the Microsoft Internet Information Service (IIS) Manager. Answer: TRUE Answer: TRUE Answer: TRUE With Oracle Database, data must be entered at the Oracle Database command prompt. Answer: FALSE[/cpmembership] Answer: FALSE[/cpmembership] Answer: FALSE[/cpmembership] In the MySQL Workbench, a 1:N non-identifying relationship

UML-style E-R diagrams allow for the existence of class attributes which are attributes that pertain to the collection of all entities within that class, not to the individual entity instances themselves. Answer: TRUE Answer: TRUE Answer: TRUE To set a column value to an initial value that is selected according to some complicated

In a correlated subquery, the DBMS must run the lower SELECT statement as a process that is nested within the upper SELECT statement. Answer: TRUE Answer: TRUE Answer: TRUE In SQL Server, triggers can roll back the transaction that caused them to be fired. Answer: TRUE Answer: TRUE Answer: TRUE To execute an SQL query, click the

MySQL uses MySQL OLD transition variables with triggers to access old data updated or deleted from a table row. Answer: TRUE Answer: TRUE Answer: TRUE In Microsoft Visio 2013, a group of template objects is called a stencil. Answer: TRUE Answer: TRUE Answer: TRUE The IDEF1X default cardinality of a nonidentifying connection relationship is indicated by a

SQL Server built-in system function names start with the @@ symbol. Answer: TRUE Answer: TRUE Answer: TRUE Microsoft Access wizards allow easy building of forms and reports. Answer: TRUE Answer: TRUE Answer: TRUE A combination key is a group of attributes that uniquely identifies a row. Answer: FALSE[/cpmembership] Answer: FALSE[/cpmembership] Answer: FALSE[/cpmembership] A data warehouse is a database system

Unless it is being used to copy data from one table to another, the SQL INSERT statement can be used to insert only a single row into a table. Answer: TRUE Answer: TRUE Answer: TRUE A business process is a set of activities that transforms materials into products. Answer: FALSE Answer: FALSE Answer: FALSE Rows in

While many subqueries can be alternatively written as joins, correlated subqueries do work that cannot be duplicated as a join. Answer: TRUE Answer: TRUE Answer: TRUE An information system is a set of components that interact to achieve some purpose or goal. Answer: FALSE Answer: FALSE Answer: FALSE SQL stands for Standard Query Language. Answer: FALSE Answer:

A defining requirement for Boyce-Codd Normal Form (BCNF) is that every candidate key must be a determinant. Answer: FALSE Answer: FALSE Answer: FALSE Among its many functions, SQL*Plus is also a programming language. Answer: FALSE Answer: FALSE Answer: FALSE In the Windows 8 or 8.1 OS, to start working with the MySQL Workbench use the command

The size of a lock is referred to as the lock granularity. Answer: TRUE Answer: TRUE Answer: TRUE MySQL is an open source DBMS that only runs on Unix and Linux operating systems. Answer: FALSE Answer: FALSE Answer: FALSE If the table ITEM has a column WEIGHT, and WEIGHT has the data type Numeric (4,2), the

When designing a database, first identify the entities, then determine the attributes, and finally create the relationships. Answer: FALSE Answer: FALSE Answer: FALSE In every database, not just the databases discussed in this book, table names are capitalized. Answer: FALSE Answer: FALSE Answer: FALSE The SQL built-in function ADDUP totals values in numeric columns. Answer: FALSE Answer:

SQL statements end with a colon. Answer: FALSE Answer: FALSE Answer: FALSE Outer joins can be either up joins or down joins. Answer: FALSE Answer: FALSE Answer: FALSE Report delivery is more difficult for data mining than it is for reporting systems. Answer: FALSE Answer: FALSE Answer: FALSE Because EXISTS and NOT EXISTS are forms of correlated subqueries, the

To use an SQL Server reserved word as a user identifier, it must be enclosed in square brackets [ ]. Answer: TRUE Answer: TRUE Answer: TRUE The values of a surrogate key have no meaning to the users. Answer: TRUE Answer: TRUE Answer: TRUE The termset refers to all records having the same nonunique secondary key.

In Microsoft Visio 2013, Dynamic connector objects can be formatted with the line end symbols needed to create IE Crow's Foot notation. Answer: TRUE Answer: TRUE Answer: TRUE In relational terms as defined by E.F. Codd, a column is called an attribute. Answer: TRUE Answer: TRUE Answer: TRUE Entities can be associated with one another in

Dimensional databases are used for analytical data processing. Answer: TRUE Answer: TRUE Answer: TRUE One weakness of UML-style E-R diagrams is that there is no means of distinguishing between a weak entity that is ID-dependent and a weak entity that is not ID-dependent. Answer: FALSE Answer: FALSE Answer: FALSE To determine the number and type of

MySQL concurrency options include four transaction isolation levels: READ UNCOMMITTED, READ COMMITTED, REPEATABLE READ, and SERIALIZABLE. Answer: TRUE Answer: TRUE Answer: TRUE The names of tables to be joined in an SQL query are listed in the FROM clause. Answer: TRUE Answer: TRUE Answer: TRUE Candidate keys are called interlocking candidate keys when they share one

Typically, there are at least four different copies of the database schema used in the redesign process. Answer: FALSE Answer: FALSE Answer: FALSE The Read Only transaction isolation level is unique to Oracle Database. Answer: TRUE Answer: TRUE Answer: TRUE Attributes preceded by a + are protected. Answer: FALSE Answer: FALSE Answer: FALSE SOAP was originally an XML-based standard

The default isolation level in Oracle Database is Read Committed, which provides statement level isolation. Answer: TRUE Answer: TRUE Answer: TRUE Graph databases are composed of three elements, one of which is the edge. Answer: TRUE Answer: TRUE Answer: TRUE SQL triggers are used for providing default values, validity checking, updating views, and performing referential integrity

MySQL uses MySQL NEW transition variables with triggers to access new data inserted into a table row. Answer: TRUE Answer: TRUE Answer: TRUE IDEF1X category clusters may be either complete or incomplete. Answer: TRUE Answer: TRUE Answer: TRUE The IDEF1X standard excludes the concept of domains found in the extended E-R model. Answer: FALSE[/cpmembership] Answer: FALSE[/cpmembership] Answer: FALSE[/cpmembership] When

MySQL uses the MySQL LAST_INSERT_ID() function to provide the value of the most recently created surrogate key. Answer: TRUE Answer: TRUE Answer: TRUE The recommended SQL Server security is Windows-only security. Answer: TRUE Answer: TRUE Answer: TRUE One of the properties of all collections is Count, which is the number of objects in the collection. Answer:

Microsoft Access is a personal database that combines a DBMS with an application generator. Answer: TRUE Answer: TRUE Answer: TRUE A complex network is a collection of records and the 1:N relationships between them. Answer: FALSE[/cpmembership] Answer: FALSE[/cpmembership] Answer: FALSE[/cpmembership] Unlike SQL views, XML views are not limited to one multivalued path. Answer: TRUE Answer: TRUE Answer: TRUE Repeatable

The ideal primary key is short, numeric, and fixed. Answer: TRUE Answer: TRUE Answer: TRUE Big Data is the name given to the enormous datasets generated by Web 2.0 applications. Answer: TRUE Answer: TRUE Answer: TRUE Oracle Database triggers are PL/SQL or Java procedures that are invoked when specified database activity occurs. Answer: TRUE Answer: TRUE Answer: TRUE Market basket

The IDEF1X default cardinality of a nonidentifying connection relationship is one-to-one, with a mandatory parent and an optional child. Answer: FALSE Answer: FALSE Answer: FALSE Paradox is the only major survivor of the "bloodbath of PC DBMS products." Answer: FALSE Answer: FALSE Answer: FALSE Relations in BCNF have no modification anomalies in regard to functional dependencies.

In 1:N relationships, the table on the "many" side is called the child. Answer: TRUE Answer: TRUE Answer: TRUE Only the 64-bit version of the Java Runtime Environment should be installed when using a 64-bit operating system. Answer: FALSE Answer: FALSE Answer: FALSE The SQL SET keyword is used to specify a new value when changing

A Java Virtual Machine must be installed on a computer before running the NetBeans IDE. Answer: TRUE Answer: TRUE Answer: TRUE The cardinalities of an attribute operate only between the attribute and the container of the attribute. Answer: TRUE Answer: TRUE Answer: TRUE In market basket analysis, lift is confidence divided by support. Answer: FALSE Answer: FALSE Answer: