Database Concepts 7th Edition

primary key using table constraints, the column must have been given the property NULL. Answer:[cpmembership level="2,3,4,5"] FALSE[/cpmembership] The Oracle DBMS supports the SQL BEFORE trigger. Answer:[cpmembership level="2,3,4,5"] TRUE[/cpmembership] Unified Modeling Language (UML) has quickly replaced the E-R Model as the most popular technique for creating data models. Answer:[cpmembership level="2,3,4,5"] FALSE[/cpmembership] When creating an OLAP report based on Access 2013

you need to create a primary key that is a composite key using SQL, the key may be defined when the table is created using the CREATE TABLE statement. Answer:[cpmembership level="2,3,4,5"] TRUE[/cpmembership] Subtype entities may be either exclusive or inclusive. Answer:[cpmembership level="2,3,4,5"] TRUE[/cpmembership] All type-valid XML documents are required to have a DTD. Answer:[cpmembership level="2,3,4,5"] TRUE[/cpmembership] The SQL GROUP

contain data from one table. Answer:[cpmembership level="2,3,4,5"] FALSE[/cpmembership] Microsoft Access 2013 database files can be easily copied to create multiple copies of a database. Answer:[cpmembership level="2,3,4,5"] TRUE[/cpmembership] A star schema resembles a star, with a dimension table at the center and fact tables radiating out from the center. Answer:[cpmembership level="2,3,4,5"] FALSE[/cpmembership] Using standard SQL, unmatched rows will not appear

database systems is that it makes database systems easier for novices to create. Using the graphical tools and wizards of a desktop DBMS product, databases and application programs can be created without developing much database expertise. The disadvantage of hiding the complexity is that the developer does not understand what

1:N non-identifying relationship between two tables that already contain the needed primary and foreign keys is created using the Place a Relationship Using Existing Columns button. Answer:[cpmembership level="2,3,4,5"] TRUE[/cpmembership] In the MySQL Table Editor, the abbreviation PK stands for partial key. Answer:[cpmembership level="2,3,4,5"] FALSE[/cpmembership] Microsoft Access 2013 switchboards use command buttons as part of the menu. Answer:[cpmembership

and joins are both used to process data for queries that require data from multiple tables. Subqueries involve embedding a second query within the WHERE clause of the first query. Many levels of subqueries can exist. Joins involve combining the rows of multiple tables into a single relation whose rows

stored using the file extension .accdb. Answer:[cpmembership level="2,3,4,5"] TRUE[/cpmembership] To create a new MySQL Workbench EER model, you can use the File | New Model command. Answer:[cpmembership level="2,3,4,5"] TRUE[/cpmembership] Dimensional databases are used for analytical data processing. Answer:[cpmembership level="2,3,4,5"] TRUE[/cpmembership] Market basket analysis is a data mining technique for determining which sets of products customers tend to purchase at

of ________ activities. Answer:[cpmembership level="2,3,4,5"] support[/cpmembership] Using SQL commands, multiple tables can be queried so that all the values from one table appear in the results, regardless of whether they have one or more corresponding values in the other table, by using the SQL ________ command. Answer:[cpmembership level="2,3,4,5"] OUTER JOIN[/cpmembership] A key that contains two or

command tab. Click the Query Design button, which will display a Query window together with the Show Tables dialog box. Close the Show Tables dialog box by clicking the Close button, and then click the SQL View button on the Design command tab to switch the Query window to SQL

database system, the users are asked about the need for changes to existing forms and reports. Answer:[cpmembership level="2,3,4,5"] FALSE[/cpmembership] NetBeans is an IDE. Answer:[cpmembership level="2,3,4,5"] TRUE[/cpmembership] Microsoft Access 2013 switchboards use text labels as part of the menu. Answer:[cpmembership level="2,3,4,5"] TRUE[/cpmembership] The primary key is used both to identify unique rows in a relation and to represent rows in

text files created for or within SQL Developer is .sql. Answer:[cpmembership level="2,3,4,5"] TRUE[/cpmembership] A data mart is a collection of data that addresses a particular component or functional area of a business. Answer:[cpmembership level="2,3,4,5"] TRUE[/cpmembership] SQL views can be used to hide complicated SQL syntax. Answer:[cpmembership level="2,3,4,5"] TRUE[/cpmembership] Since surrogate keys are used to uniquely identify rows, their values

for using SQL Server 2014 Express is that it has full SQL capabilities. Answer:[cpmembership level="2,3,4,5"] TRUE[/cpmembership] When using Oracle Database, a sequence is an object that generates a sequential series of unique numbers. Answer:[cpmembership level="2,3,4,5"] TRUE[/cpmembership] An advantage of keeping data in lists is that if you add a new row of data to the list,

columns. Answer:[cpmembership level="2,3,4,5"] WHERE[/cpmembership] The relationship between two attributes that denotes that if the value of the first attribute is known, then the value of the second attribute can be determined, is called a(n) ________. Answer:[cpmembership level="2,3,4,5"] functional dependency[/cpmembership] How is minimum cardinality expressed in crow's foot E-R diagrams? Answer:[cpmembership level="2,3,4,5"] The crow's foot E-R diagram notation uses

create a primary key using the CREATE TABLE column description method, the primary key must be a single attribute. For the primary key attribute, the column property is specified to be PRIMARY KEY. There can be only one attribute specified as PRIMARY KEY with the CREATE TABLE column description method.

NOT keyword to form the NOT LIKE condition for selecting values. Answer:[cpmembership level="2,3,4,5"] TRUE[/cpmembership] Column family databases may use columns, super columns, column families and super column families. Answer:[cpmembership level="2,3,4,5"] TRUE[/cpmembership] DTD stands for Document Type Declaration. Answer:[cpmembership level="2,3,4,5"] TRUE[/cpmembership] Generally, the more restrictive the transaction isolation level, the less the throughput of database processing. Answer:[cpmembership level="2,3,4,5"] TRUE[/cpmembership] Because SQL stored procedures

workspace named NetBeansProjects. Answer:[cpmembership level="2,3,4,5"] TRUE[/cpmembership] A relational database stores data in the form of lists. Answer:[cpmembership level="2,3,4,5"] FALSE[/cpmembership] XML documents that do not conform to their DTD are said to be non-type-valid XML documents. Answer:[cpmembership level="2,3,4,5"] TRUE[/cpmembership] One of the important properties of an attribute is whether or not it is required. Answer:[cpmembership level="2,3,4,5"] TRUE[/cpmembership] One of the four categories of

called a stencil. Answer:[cpmembership level="2,3,4,5"] TRUE[/cpmembership] Column family databases that use column families and super column families contain keyspaces. Answer:[cpmembership level="2,3,4,5"] TRUE[/cpmembership] To force the DBMS to remove duplicate rows from the results of an SQL SELECT query, the keyword DISTINCT must be used. Answer:[cpmembership level="2,3,4,5"] TRUE[/cpmembership] In Microsoft Visio 2013, we can create database designs using Entity and

level="2,3,4,5"] TRUE[/cpmembership] Unlike application code, stored procedures are never distributed to the client computers. Answer:[cpmembership level="2,3,4,5"] TRUE[/cpmembership] In XML Schema, the default minimum cardinality can be overridden using the minOccurs attributes. Answer:[cpmembership level="2,3,4,5"] TRUE[/cpmembership] With Oracle Database, data must be entered using SQL INSERT statements. Answer:[cpmembership level="2,3,4,5"] FALSE[/cpmembership] Microsoft Access 2013 uses a user-level security system. Answer:[cpmembership level="2,3,4,5"] FALSE[/cpmembership] Values of existing data can

ensure that the values in a field in one table have matching values in a corresponding field in another table. These constraints are enforced by the DBMS, which will not allow changes to the values of the database that would result in violations of this rule. For example, a database

would be a database application that retrieves and produces weather forecasts based on ZIP codes. Using XML Web services, this application could be published so that it can be embedded in various Web pages. Users of those Web pages would then actually be using this application without realizing that it

structure of the entities in that class. Answer:[cpmembership level="2,3,4,5"] TRUE[/cpmembership] Built-in SQL functions cannot be applied to data combined using the GROUP BY keyword. Answer:[cpmembership level="2,3,4,5"] FALSE[/cpmembership] Microsoft Access 2013 uses banded form and report editors. Answer:[cpmembership level="2,3,4,5"] TRUE[/cpmembership] A stored program that is stored within the database and compiled when used is called a trigger. Answer:[cpmembership level="2,3,4,5"] FALSE[/cpmembership] In the normalization