Q&A Hero

Q: Which of the following is NOT an action that can ensure data integrity?a. Input masks c. Key fieldsb. Lookup routines d. Data cubes

Q: A field ____ rule is a specification such as a range or maximum for a field.a. validation c. normalizationb. specification d. integrity

Q: If you want to store data as one of two options, such as True or False, assign a(n) ____ data type.a. character c. logicalb. memo d. BLOB

Q: The arrangement of fields, tables and relationships is called the database ____.a. layout c. formatb. structure d. hierarchy

Q: A(n) ____ is an object in a Web page that contains fields used to collect information.a. tag c. attributeb. table d. form

Q: Which of the following is NOT an example of a program used to create server-side programs?a. ASP c. ERDb. CGI d. PHP

Q: A server-side program is another term for a(n) ____.a. XML document c. HTML documentb. script d. Xform

Q: In the figure above, users see a Web page that reflects their preferences, indicating that it was created using ____ Web publishing.a. dynamic c. clientb. static d. personal

Q: A(n) ____ database is stored on different computers or networks.a. relational c. serverb. hierarchical d. distributed

Q: When many network users are making updates simultaneously, database ____ software should be used.a. distribution c. serverb. client d. workstation

Q: In a network database, a(n) ____ is the rough equivalent to a child record type.a. root c. ownerb. node d. member

Q: In the figure above, the top node is the ____ node.a. parent c. rootb. child d. top

Q: In the figure above, all of the relationships are classified as: ____.a. one-to-one c. one-to-manyb. one-to-all d. many-to-many

Q: The database shown in the above figure is an example of a(n) ____ database.a. network c. cardinalb. relational d. hierarchical

Q: A(n) ____-relationship diagram depicts the relationships between record types.a. entity c. fieldb. object d. attribute

Q: The number of associations possible between record types is called ____.a. functionality c. entitiesb. cardinality d. attributes

Q: In Microsoft Access, a record type is called a(n) ____.a. occurrence c. field nameb. field d. table

Q: A record ____ is defined by the database designer and is a group of fields in the database.a. variable c. typeb. occurrence d. field

Q: A(n) ____-length field expands to fit the data entered, up to a maximum number of characters.a. fixed c. maximumb. variable d. flexible

Q: A(n) ____ contains the smallest unit of meaningful information in a database.a. field c. variableb. record d. table

Q: Entry-level DBMSs, such as Microsoft Access, typically provide tools to support data warehouses.

Q: Simple data analysis can be used to predict future trends.

Q: OLAP systems can be used to look for relationships among multiple data dimensions.

Q: Data in a descending alphanumeric sort appears as 123 or ABC.

Q: A report template is an interactive screen that walks you through data organization and presentation.

Q: The figure above is an example of a printed database report.

Q: Using normalization, database designers can create a clickable list for data entry.

Q: An input mask specifies the format in which a field's data should be entered.

Q: A conversion routine brings data into a database.

Q: Computers store real numbers in a different format than integers.

Q: Integer data types are whole numbers.

Q: XML is most often used for structured data.

Q: A downside to storing data in an XML document is that it is not portable.

Q: The way you query an XML database depends on how it was created, where it is stored, and whether you have authorization.

Q: The figure above demonstrates Static Web publishing.

Q: Data independence means keeping data separated from the programs that manipulate data.

Q: Microsoft Excel is an example of RDBMS software.

Q: Most database projects today are implemented with RDBMS software.

Q: Some spreadsheet software can be used to create flat database files.

Q: In a hierarchical database, each parent node can have only one child node.

Q: In a network database, a set contains both a parent and child node.

Q: In a network database, data is stored in a single collection of related tables, and all of the records in a table are of the same data type.

Q: Relational databases are the most popular models today.

Q: A record occurrence is sometimes called a table.

Q: Computer databases typically display records as rows in a table or as a form.

Q: A Rolodex is an example of an unstructured file.

Q: Microsoft Outlook is a computer database.

Q: A fixed-length field automatically adds blank spaces if the data you enter is shorter than the allocated length.

Q: List some of the actions you can take to ensure the integrity of the data in your database.

Q: Describe different methods for entering or bringing data into a database.

Q: Describe the differences between the following three database types: hierarchical, network, and relational.

Q: Describe the types of databases that might work well for the following situations: an end-user who wants to store names and addresses, and a business where many users will be making updates at the same time.

Q: Data ____________________ is the method used to clarify hidden relationships.

Q: Information used for OLAP queries can be represented as a data ____________________.

Q: Data ____________________ is the process of interpreting information to discover trends and patterns.

Q: A table's ____________________ order is the order in which records are stored on disk.

Q: A(n) ____________________ key is a field that contains data unique to a record.

Q: A(n) ____________________ data type is a picture or graphic.

Q: You should store telephone numbers, ZIP codes, and Social Security Numbers as ____________________ fields.

Q: The figure above demonstrates ____________________ Web publishing

Q: ____________________ Web publishing converts database reports into HTML documents.

Q: ___________________________________ is a markup language that allows field tags, data, and table to be incorporated into a Web document.

Q: Data ____________________ allows a single data management tool to be used to maintain many different files and databases.

Q: Database ____________________ software allows remote computers or network workstations to access database data.

Q: DBMS stands for ______________________________.

Q: A(n) ____________________ database allows both one-to-many and many-to-many relationships.

Q: A(n) ____________________ is the association between data stored in different record types.

Q: Describe three considerations for a project team that is evaluating hardware solutions.

Q: Describe the purpose and elements of a System Requirements Report.

Q: Describe the roles of members of a system development project team: IS department, CIO, systems analysts, and end users.

Q: Describe and give an example of each of the three types of problems: structured, semistructured, and unstructured.

Q: A systems ____________________ performs backups and data recovery, and troubleshoots operational problems.

Q: During the ____________________ phase of a system, day-to-day operations of the system are evaluated and corrections and upgrades are made as necessary.

Q: During ____________________ conversion, entries must be made into both the old and new systems.

Q: System ____________________ occurs when the old system is deactivated and the new IS is activated.

Q: ____________________ testing ensures that each module operates correctly.

Q: The ____________________ phase of the SDLC is when the components are put together and the new IS is constructed.

Q: Feature ____________________ is when changes and additions are made to an IS before it is implemented.

Q: Hardware and software is usually acquired at the end of the ____________________ phase of an IS.

Q: A(n) ____________________ system is hardware and software sold to be a complete IS.