Archives

A(n) ____________________ relationship is also known as an identifying relationship. Cursor-style processing involves retrieving data from the cursor, one row at a time. Answer: T Generalization is based on grouping unique characteristics and relationships of the subtypes. Answer: F In […]

In the SQL environment, the word ____________________covers both questions and actions. In order to develop an accurate data ____________________, the designer must have a thorough understanding of the company’s data types, extent, and uses. Answer: model Triggers are critical to […]

____________________ databases focus primarily on storing data used to generate information required to make tactical or strategic decisions. A data ____________________ is a centralized, consolidated database that integrates data derived from the entire organization and from multiple sources with diverse […]

The “____” characteristic of a primary key states the following: The PK should not have embedded semantic meaning. An attribute with embedded semantic meaning is probably better used as a descriptive characteristic of the entity rather than as an identifier. […]

The ER model refers to a specific table row as an entity occurrence. The Crow’s Foot notation depicts the strong relationship with a(n) ____________________ line between the entities. Answer: solid A(n) ____________________ character is a symbol that can be used […]

A ____ schema is a type of star schema in which the dimension tables can have their own dimension tables. a. snowflake b. starflake c. mesh d. matrix Assume you are using the UNION ALL operator to combine the results […]

A table that has all key attributes defined, has no repeating groups, and all its attributes are dependent on the primary key, is said to be in ____. a. 1NF b. 2NF c. 3NF d. 4NF With partial dependencies, data […]

A table is in BCNF if every determinant in the table is a candidate key. Because every request for structural changes requires retracing the SDLC steps, the system is always at some stage of the SDLC. Answer: T Usually, the […]

A table that is in 2NF and contains no transitive dependencies is said to be in ____. a. 1NF b. 2NF c. 3NF d. 4NF A(n) ____ database stores each database fragment at a single site. a. partially replicated b. […]

The ____ table space is used for transaction-recovery purposes. a. system b. user data c. temporary d. rollback segment Non-overlapping subtypes are subtypes that contain a(n) ____ subset of the supertype entity set. a. entity b. subtypes c. unique d. […]

The data cache is where the data read from the database data files are stored ____ the data have been read or ____ the data are written to the database data files. a. after, before b. after, after c. before, […]

In the ____ model, the user perceives the database as a collection of records in 1:M relationships, where each record can have more than one parent. a. hierarchical b. network c. object-oriented d. entity relationship From a system functionality point […]

The DIVIDE operation uses one single-column table (e.g., column “a”) as the divisor and one two-column table (e.g., columns “a” and “b”) as the dividend. Oracle users can use the Access QBE (query by example) query generator. Answer: F During […]

A(n) ____________________ view is a view that can be used to update attributes in the base table(s) that are used in the view. The relationships depicted within the specialization hierarchy are sometimes described in terms of “is-a” relationships. Answer: T […]

Which query will output the table contents when the value of the character field P_CODE is alphabetically less than 1558-QW1? a. SELECT P_CODE, P_DESCRIPT, P_QOH, P_MIN, P_PRICE FROM PRODUCT WHERE P_CODE <‘1558-QW1’; b. SELECT P_CODE, P_DESCRIPT, P_QOH, P_MIN, P_PRICE FROM […]

The DBA must supervise the installation of all software and hardware designated to support the data administration strategy, must have a thorough understanding of the components being installed, and must be familiar with the installation, configuration, and startup procedures of […]

A(n) ____ phase in a two-phase lock is when a transaction releases all locks and cannot obtain any new lock. a. growing b. shrinking c. locking d. unlocking A ____ entity has a primary key that is partially or totally […]

An alias is especially useful when a table must be joined to itself in a(n) ____________________ query. XML is derived from the _____________________________________________, an international standard for the publication and distribution of highly complex technical documents. Answer: Standard Generalized Markup […]

Storing ____________________ attributes requires constant maintenance. The database administrator must be prepared to perform routine maintenance activities within the database. Answer: T You can select partial table contents by naming the desired fields and by placing restrictions on the rows […]

The data warehouse development life cycle differs from classical systems development. In an SQL-based relational database, rows in different tables are related based on common values in common attributes. Answer: T Cardinality expresses the minimum and maximum number of entity […]

A ____ index is based on 0 and 1 bits to represent a given condition. a. logical b. multidimensional c. star d. bitmapped The query to join the P_DESCRIPT and P_PRICE fields from the PRODUCT table and the V_NAME, V_AREACODE, […]

SQL is considered difficult to learn; its command set has a vocabulary of more than 300 words. A recursive relationship is one in which a relationship can exist between occurrences of the same entity set Answer: T A relationship ____________________ […]

DBMSs use indexes for many different purposes. In the original Chen model, each attribute is represented using an oval with the attribute name connected to the entity with a line. Answer: T “Linked SQL” is a term used to refer […]

The “____” characteristic of a primary key states the following: The selected primary key must not be composed of any attribute(s) that might be considered a security risk or violation. For example, using a Social Security number as a PK […]

Each table in a relational database must have a primary key. ____________________ is another name for table space. Answer: File group UNION, INTERSECT, and MINUS work properly only if relations are union-compatible, which means that the names of the relation […]

The ____________________ cache is a shared, reserved memory area that stores the most recently executed SQL statements or PL/SQL procedures, including triggers and functions. What are database checkpoints? Answer: Database checkpoints are operations in which the DBMS writes all of […]

Fact and dimension tables are related by ____ keys. a. shared b. primary c. foreign d. linked Which of the following is true of business rules? a. They allow the designer to set company policies with regard to data. b. […]

Database ____________________ activities can be divided into those taking place either on the client side or on the server side. Each row in a relation is called a(n) ____________________. Answer: tuple DBMS query processing has ____________________ phases. Answer: 3 three […]

A(n) ______________________________ is an arrangement of computerized tools used to assist managerial decision making within a business. When you can change the internal model without affecting the conceptual model, you have ____________________ independence. Answer: logical The ____________________, also known as […]

Physical protection of hardware and software must be accomplished by the use of open installations with restricted area access. A(n) ____________________ provides limited additional semantic value to XML, such as data type support or data validation rules. Answer: DTD document […]

Describe specialization and generalization. Current relational database software generally provides only a system catalog (and not a data dictionary). Answer: T The Web server is the main hub through which all Internet services are accessed. Answer: T Answer: Specialization is […]

Which query will output the table contents when the value of P_PRICE is less than or equal to 10? a. SELECT P_DESCRIPT, P_INDATE, P_PRICE, V_CODE FROM PRODUCT WHERE P_PRICE <> 10; b. SELECT P_DESCRIPT, P_INDATE, P_PRICE, V_CODE FROM PRODUCT WHERE […]

Each time the end user clicks a hyperlink, the browser generates a(n) ____ GET page request that is sent to the designated Web server, using the TCP/IP Internet protocol. a. HTML b. browser c. HTTP d. API From the data […]

A(n) ____ join only returns matched records from the tables that are being joined. a. outer b. inner c. direct d. union Data ____________________ tools provide advanced visual analysis and techniques to enhance understanding of business data. Answer: visualization ____ […]

The ODBC API standard defines three levels of compliance: ____, Level-1, and Level-2, which provide increasing levels of functionality. a. Complete b. Basic c. Core d. Level-0 The conceptual design step that determines end-user views, outputs, and transaction-processing requirements is […]

Problems defined during the planning phase are examined in greater detail during the analysis phase. System support activities cover all tasks directly related to the day-to-day operations of a DBMS and its applications. Answer: T A remote transaction, composed of […]

Describe the use of nulls in a database. Describe query optimization and the modes that an optimizer can operate in. Answer: Query optimization is the central activity during the parsing phase in query processing. In this phase, the DBMS must […]

A data dictionary is sometimes described as “the database designer’s database” because it records the design decisions about tables and their structures. Describe the use of the UNION operator. Answer: UNION combines all rows from two tables, excluding duplicate rows. […]

____ provide(s) a description of the data characteristics and the set of relationships that link the data found within the database. a. Queries b. End-user data c. Metadata d. Information Business rules are derived from ____. a. a detailed description […]

____ CASE tools provide support for the planning, analysis, and design phases. a. Front-end b. Back-end c. Vertical d. Horizontal Instructions to create a password are an example of a ____. a. rule b. policy c. standard d. procedure Answer: […]

In Crow’s Foot notation, an optional relationship between entities is shown by drawing a(n) ____________________ on the side of the optional entity. In order to meet performance requirements, you may have to denormalize portions of the database design. Answer: T […]

Denormalization produces a lower normal form. ____________________ is a measurement of the density of the data held in the data cube and is computed by dividing the total number of actual values in the cube by the total number of […]

____________________ is the process that establishes the need for, and the extent of, an information system. The inherently complex distributed data environment increases the urgency for standard protocols governing transaction management. Answer: T All simple attributes are also single-valued. Answer: […]

In the Chen model, a multivalued attribute is connected to the owning entity with a double line. ______________________________ is a collection of concepts, techniques, and processes for the proper identification, definition, and management of data elements within an organization. Answer: […]