Q&A Hero

Design

Q: Each physical record is addressed by its ________. A) relative record number (RRN) B) sequential record number (SRN) C) transaction record number (TRN) D) ultimate record number (URN)
Q: The DBMS creates ________, also called blocks, on its direct access fields. A) psuedo records B) physical records C) secondary file records D) key file records
Q: A ________ is a file that has no repeating groups. A) flat file B) stacked file C) record file D) key file
Q: The termset refers to all records having the same nonunique secondary key.
Q: The primary work key is a field or fields whose value uniquely identifies a record.
Q: The word key indicates a field or fields whose value uniquely or nonuniquely identifies a record or set of records.
Q: An intersection record is a record that is created when a complex network is decomposed into a simple network.
Q: A complex network cannot be decomposed into trees or simple networks.
Q: A simple network can be represented using linked lists and indexes.
Q: To represent a tree structure using indexes, store each 1:N relationship as an index.
Q: A tree structure cannot be represented using indexes.
Q: A complex network is a collection of records and the 1:N relationships between them.
Q: A simple network is a collection of records and the 1:N relationships between them.
Q: A multilevel index that allows both sequential and direct processing of data records is called a C-tree.
Q: An index is a table that cross-references record addresses with some attribute value.
Q: A two-way linked list has links in both directions.
Q: In a linked list, the sequence field holds the address of the next record in the logical sequence.
Q: Linked lists can be used to keep records in a logical order even if they are not necessarily in physical order.
Q: Each physical record is addressed by its sequential record number (SRN).
Q: The DBMS creates physical records, also called blocks, on its direct access fields.
Q: A flat file is a file that has repeating groups.
Q: What is a set?
Q: What are tree, simple networks and complex networks?
Q: What is a B-tree?
Q: What is a linked list?
Q: How does a DBMS store data on its direct access files?
Q: An important property of B-Trees is that they are balanced to maintain efficient and predictable performance. "Balanced" here means that ________. A) every pointers allows access to the same number of data records B) the numbers at every level of the B-Tree have the same average value C) the key field values are the same at every level D) every data record is the same distance from the top entry of the B-Tree
Q: In a B-Tree whose top entry contains the values 47 and 88, the middle arrow allows access to all records whose key field values are ________. A) less than 47 B) greater than 47 and less than 88 C) greater than 47 and less than or equal to 88 D) greater than 88
Q: Data structures are typically used to ________. A) unbalance a B-Tree B) represent simple and complex networks C) enhance database security D) fry an egg
Q: Each of the following is an example of a data structure except ________. A) binary relationship B) sequential list C) linked list D) index
Q: The term set refers to all records that have the same ________. A) primary key B) unique secondary key C) nonunique secondary key D) search key
Q: Keys may include all of the following except ________. A) primary keys B) unique secondary keys C) nonunique secondary keys D) nonunique primary keys
Q: Complex networks can be represented by reducing them to simple networks, which requires the introduction of a(n) ________. A) association record B) link record C) intersection record D) sequential record
Q: Complex networks can be represented by reducing them to simple networks, and then representing the simple networks using ________. A) indexes or linked lists B) linked lists or sequential lists C) sequential lists or indexes D) trees
Q: Simple networks can be represented by using ________. A) indexes or linked lists B) linked lists or sequential lists C) sequential lists or indexes D) complex networks
Q: DBMS products represent trees using all of the following except ________. A) indexes B) linked lists C) sequential lists D) secondary lists
Q: A collection of records and the N:M relationships between them is a ________. A) simple network B) complex network C) compound network D) logical network
Q: A collection of records and the 1:N relationships between them is a ________. A) simple network B) complex network C) compound network D) logical network
Q: In Microsoft Visio 2013, describe the possible cardinality settings for a Relationship object that can be set in the symbols menu in a database design, and how these settings correspond to the IE Crow's Foot symbols shown in Figure F-20.
Q: In Microsoft Visio 2013, how do we create database designs?
Q: In Microsoft Visio 2013, how do we format line ends in data models to represent the symbols used in the IE Crow's Foot notation?
Q: In Microsoft Visio 2013, how do we create data models?
Q: When using Microsoft Visio 2013, how do we create a blank diagram for use with a data model?
Q: In Microsoft Visio 2013, for a Relationship object relationship that is one-optional on the child side of the relationship, the correct setting in the Symbol menu is ________. A) 1 and only 1 B) 1 or more C) Zero or 1 D) Zero or more
Q: In Microsoft Visio 2013, for a Relationship object relationship that is many-mandatory on the child side of the relationship, the correct setting in the Symbol menu is ________. A) 1 and only 1 B) 1 or more C) Zero or 1 D) Zero or more
Q: In Microsoft Visio 2013, the cardinalities of the Relationship connector object end points are formatted using ________. A) the Set Begin Symbol command B) the Set End Symbol command C) the Set Non-primary Key Unique column D) Both A and B are correct
Q: In Microsoft Visio 2010, which object can be formatted with the line end symbols needed to create IE Crow's Foot notation? A) Relationship connector object B) Category object C) Parent to category connector object D) Category to child connector object
Q: In Microsoft Visio 2013, we can create supertype/subtype relationships in database designs using ________. A) Entity and Dynamic connector objects B) Entity and Relationship connector objects C) Category and Relationship connector objects D) We cannot create database designs in Microsoft Visio 2013.
Q: In Microsoft Visio 2013, we can create supertype/subtype relationships in data models using ________. A) Entity and Dynamic connector objects B) Table and Relationship connector objects C) Category and Relationship connector objects D) There are no separate objects to create supertype/subtype, so we use standard objects.
Q: In Microsoft Visio 2013, we can create database designs using ________. A) Entity and Dynamic connector objects B) Entity and Relationship connector objects C) Category and Dynamic connector objects D) We cannot create database designs in Microsoft Visio 2013.
Q: In Microsoft Visio 2013, we can create data models using ________. A) Entity and Dynamic connector objects B) Entity and Relationship connector objects C) Category and Dynamic connector objects D) We cannot create data models in Microsoft Visio 2013.
Q: In Microsoft Visio 2013, the Crow's Foot Database Notation stencil objects include ________. A) an Entity object B) a Relationship object C) a Dynamic connector object D) Both A and B are correct
Q: In Microsoft Visio 2013, when the Entity object is placed in a diagram, it is labeled as a(n) ________. A) entity B) table C) relationship D) dynamic connector
Q: In Microsoft Visio 2013, the data models in this book are created using ________. A) the Chen's Database Notation template B) the UML database Notation template C) the IDEF1X Database Notation template D) the Crow's Foot Database Notation template
Q: In Microsoft Visio 2013, clicking the FILE command tab opens ________. A) the File menu B) the Backstage view C) the Open dialog box D) the Save As dialog box
Q: In Microsoft Visio 2013, for a Relationship object relationship that is one-mandatory on the child side of the relationship, the correct setting in the Symbol menu is ________. A) 1 and only 1 B) 1 or more C) Zero or 1 D) Zero or more
Q: In Microsoft Visio 2013, the cardinalities of the relationshipare set using the Set Begin Symbol and Set End Symbol commands.
Q: In Microsoft Visio 2013, the arrow end of the Dynamic connector object points to the table containing the primary key.
Q: In Microsoft Visio 2013, the arrow end of the Relationship connector object points to the table containing the foreign key.
Q: In Microsoft Visio 2013, Relationship connector objects can be formatted with the line end symbols needed to create IE Crow's Foot notation.
Q: In Microsoft Visio 2013, Dynamic connector objects can be formatted with the line end symbols needed to create IE Crow's Foot notation.
Q: In Microsoft Visio 2013, we can create database designs using Entity and Dynamic connector objects.
Q: In Microsoft Visio 2013, we can create data models using Entity and Relationship objects.
Q: In Microsoft Visio 2013, the Crow's Foot Database Notation stencil objects include a Category object.
Q: In Microsoft Visio 2013, the Crow's Foot Database Notation stencil objects include a Recursive Relationship object.
Q: In Microsoft Visio 2013, when the Entity object is placed in a diagram, it is labeled as a table.
Q: In Microsoft Visio 2013, a group of template objects is called a stencil.
Q: In Microsoft Visio 2013, both data models and database designs are created using the Database Model Diagram template.
Q: In Microsoft Visio 2013, clicking the File command tab opens the Backstage view.
Q: Microsoft Visio 2013 can be used to create data models.
Q: Microsoft Visio 2013 is a component of Microsoft Office 2013.
Q: Describe the MySQL Connector/ODBC and how to install it.
Q: Describe how to create relationships in a MySQL Workbench database design.
Q: Describe how to set table properties in a MySQL Workbench database design.
Q: Describe how to add a table object to a MySQL Workbench database design.
Q: Describe how to get started creating a new database design in the MySQL Workbench.
Q: By default, the E-R diagrams created in the MySQL Workbench use ________. A) IE Crow's Foot notation B) IDEF1X notation C) UML notation D) Microsoft Visio 2013 Arrow notation
Q: The MySQL Workbench can be used to create ________. A) data models B) data designs C) database models D) database designs
Q: In the MySQL Workbench, a 1:N identifying relationship between two tables that already contain the needed primary and foreign keys is created using ________. A) the 1:N Identifying Relationship button B) the 1:N Non-identifying Relationship button C) the N:M Identifying Relationship button D) the Place a Relationship Using Existing Columns button
Q: In the MySQL Workbench, a 1:N identifying relationship between two tables that do not contain the needed primary and foreign keys is created using ________. A) the 1:N Identifying Relationship button B) the 1:N Non-identifying Relationship button C) the N:M Identifying Relationship button D) the Place a Relationship Using Existing Columns button
1 2 3 … 68

Subjects

Accounting Anthropology Archaeology Art History Banking Biology & Life Science Business Business Communication Business Development Business Ethics Business Law Chemistry Communication Computer Science Counseling Criminal Law Curriculum & Instruction Design Earth Science Economic Education Engineering Finance History & Theory Humanities Human Resource International Business Investments & Securities Journalism Law Management Marketing Medicine Medicine & Health Science Nursing Philosophy Physic Psychology Real Estate Science Social Science Sociology Special Education Speech Visual Arts