Archives

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. The SQL built-in function MIN obtains the smallest value in a numeric column. Answer: […]

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

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

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

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

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. To set a column value to an initial value […]

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

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

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

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. A business process is a set of activities that transforms materials […]

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

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

The size of a lock is referred to as the lock granularity. MySQL is an open source DBMS that only runs on Unix and Linux operating systems. Answer: FALSE If the table ITEM has a column WEIGHT, and WEIGHT has […]

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

SQL statements end with a colon. Outer joins can be either up joins or down joins. Answer: FALSE Report delivery is more difficult for data mining than it is for reporting systems. Answer: FALSE Because EXISTS and NOT EXISTS are […]

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

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

Dimensional databases are used for analytical data processing. 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 To […]

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

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

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

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

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

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

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

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

In 1:N relationships, the table on the “many” side is called the child. Only the 64-bit version of the Java Runtime Environment should be installed when using a 64-bit operating system. Answer: FALSE The SQL SET keyword is used to […]

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