Archives

Referential________ dictates that the foreign key must contain values that match the primary key in the related table, or must contain null. a. integrity b. uniqueness c. model d. attribute In the database query scenario, the web server generates the […]

A(n)_________ specifically reserves access to the transaction that locked the object. a. shared lock b. exclusive lock c. binary lock d. deadlock Which of the following is a client-side extension? a. ActiveX b. ODBC c. SQL*Net d. TCP/IP Answer: a […]

One of the three most common data integrity and consistency problems is______________ . a. lost updates b. disk failures c. user errors d. deadlocks The____________ analyzes the SQL query and finds the most efficient way to access the data. Answer: […]

A shared lock produces no conflict as long as all the concurrent transactions are read-write only. a. True b. False Conceptually, MDBMS end users visualize the stored data as a three-dimensional cube known as a__________ . a. multi-cube b. database […]

A______ index is based on 0 and 1 bits to represent a given condition. a. logical b. multidimensional c. normal d. bitmapped The database structure in a DBMS is stored as a_____________ . a. single file b. collection of files […]

When two or more tables share the same number of columns, and when their corresponding columns share the same or compatible domains, they are said to be___________ . a. intersect-compatible b. union-compatible c. difference-compatible d. select-compatible The COMMIT command does […]

A ___________occurs when there is one entity in two 1:M relationships to other entities, thus producing an association among the other entities that is not expressed in the model. a. surrogate primary key b. time-variant data c. design trap d. […]

ANSWER: False ANSWER: False ANSWER: True ANSWER: False ANSWER: False ANSWER: True ANSWER: True ANSWER: True CHAPTER 1: DATABASE SYSTEMS 1. Data and information are essentially the same thing. a. True b. False 2. Data processing can be as simple […]

ANSWER: True ANSWER: False ANSWER: False ANSWER: True ANSWER: False ANSWER: False ANSWER: False CHAPTER 10: TRANSACTION MANAGEMENT AND CONCURRENCY CONTROL 1. Most real-world database transactions are formed by only one database request. a. True b. False 2. To ensure […]

ANSWER: True ANSWER: True ANSWER: False ANSWER: False ANSWER: False 3. All factors must be checked to ensure that each system component operates at its optimum level and has ANSWER: True 4. Good database performance starts with good database design. […]

ANSWER: False ANSWER: True ANSWER: True © 2015 Cengage Learning. All Rights Reserved. May not be scanned, copied or duplicated, or posted to a publicly accessible website, in whole or in part. ANSWER: False ANSWER: True 2. Rapid ad hoc […]

ANSWER: True ANSWER: False ANSWER: False 5. Operational data and decision support data serve the same purpose. ANSWER: False ANSWER: True ANSWER: True ANSWER: False CHAPTER 13: BUSINESS INTELLIGENCE AND DATA WAREHOUSES 1. Business intelligence is a framework that allows […]

ANSWER: True ANSWER: True ANSWER: True ANSWER: False ANSWER: False 6. Whether you purchase online or by standing in line, the system-level transaction details are essentially the same, ANSWER: True ANSWER: False CHAPTER 14: DATABASE CONNECTIVITY AND WEB TECHNOLOGIES 1. […]

ANSWER: False ANSWER: True ANSWER: False ANSWER: True ANSWER: True ANSWER: False b. False ANSWER: True CHAPTER 15: DATABASE ADMINISTRATION AND SECURITY 1. The DBMS must provide tools that give each level of management a useful view of the data […]

ANSWER: False ANSWER: True ANSWER: False ANSWER: True ANSWER: True ANSWER: False 6. In the context of data models, an entity is a person, place, thing, or event about which data will be collected and ANSWER: True CHAPTER 2: DATA […]

ANSWER: False ANSWER: True ANSWER: True ANSWER: False ANSWER: False ANSWER: False ANSWER: True ANSWER: False CHAPTER 3: THE RELATIONAL DATABASE MODEL 1. The practical significance of taking the logical view of a database is that it serves as a […]

ANSWER: True ANSWER: False ANSWER: False ANSWER: True ANSWER: True ANSWER: True ANSWER: True ANSWER: False CHAPTER 4: ENTITY RELATIONSHIP (ER) MODELING 1. The entity relationship model (ERM) is dependent on the database type. a. True b. False 2. The […]

ANSWER: False ANSWER: True ANSWER: True ANSWER: True ANSWER: False ANSWER: True ANSWER: False ANSWER: True CHAPTER 5: ADVANCED DATA MODELING 1. The entity supertype contains common characteristics, and the entity subtypes each contain their own unique characteristics. a. True […]

ANSWER: False ANSWER: True ANSWER: False ANSWER: False ANSWER: True ANSWER: True ANSWER: False 7. Reporting anomalies in a table can cause a multitude of problems for managers and can be fixed through CHAPTER 6: NORMALIZATION OF DATABASE TABLES 1. […]

ANSWER: False ANSWER: True ANSWER: True ANSWER: False ANSWER: True ANSWER: False ANSWER: True CHAPTER 7: INTRODUCTION TO STRUCTURED QUERY LANGUAGE (SQL) 1. A database language enables the user to create database and table structures to perform basic data management […]

ANSWER: False ANSWER: False ANSWER: False ANSWER: True ANSWER: False ANSWER: True ANSWER: False CHAPTER 8: ADVANCED SQL 1. An inequality condition is also known as a natural join and an equality condition is also called a theta join. a. […]

ANSWER: True ANSWER: True ANSWER: True ANSWER: False ANSWER: True ANSWER: True ANSWER: True CHAPTER 9: DATABASE DESIGN 1. Systems analysis establishes the need for an information system and its extent. a. True b. False 2. The term “database development” […]

The same data might be simultaneously structured and unstructured depending on the intended processing. a. True b. False In DBLC, the phase after the database initial study is ___________. a. operation b. database design c. database initial study d. implementation […]

One of the advantages of a distributed database management system (DDBMS) is growth facilitation. a. True b. False The design of the system’s processes is completed during the___________ phase of the Systems Development Life Cycle (SDLC). a. planning b. analysis […]

Both distributed processing and distributed databases require a network of interconnected components. a. True b. False Normalizing fact tables improves data access performance and saves data storage space. a. True b. False Answer: False Dependency diagrams are very helpful in […]

Denormalization produces a lower normal form. a. True b. False The process of database design is a sequential process. a. True b. False Answer: False “Linked SQL” is a term used to refer to SQL statements that are contained within […]

Normalization is a process that is used for changing attributes to entities. a. True b. False The data cache caches system catalog data and the contents of the indexes. a. True b. False Answer: True ___________transparency is the highest level […]

Computed or derived facts, at run time, are sometimes called__________ to differentiate them from stored facts. a. schemas b. attributes c. metrics d. dimensions ____________means that data used during the execution of a transaction cannot be used by a second […]

In the ADO.NET framework, the__________ object contains the actual SQL code or a stored procedure call to be run by the database. a. Command b. DataReader c. DataAdapter d. DataSet Performance transparency ensures that the system finds the most cost-effective […]

According to Codd’s________ rule of relational database, “If the system supports lowlevel access to the data, users must not be allowed to bypass the integrity rules of the database.” a. nonsubversion b. rule zero c. view updating d. information ____________is […]

_______________is a disadvantage of a distributed database management system (DDBMS). a. Processor dependence b. Lack of graphical user interface c. Security lapse d. Increased danger of a single-point failure Granularity refers to__________ . a. the size of a table b. […]

In the ODBC architecture, a(n)__________ is in charge of managing all database connections. a. ODBC API b. DLL c. ODBC driver d. driver manager A(n)_______________ is a logical storage area in Oracle. a. audit log b. datafile c. schema d. […]

In the context of the Oracle Enterprise Manager, a ______________is a named collection of settings that control how much of the database resource a given user can use. a. license b. role c. profile d. constraint If a designer wishes […]

The Oracle_____________ function compares an attribute or expression with a series of values and returns an associated value or a default value if no match is found. a. NVL b. TO_CHAR c. DECODE d. CONVERT A_____________ is a logically connected […]

The current fully approved version of standard SQL prescribed by the ANSI is______________ . a. SQL-99 b. SQL-2003 c. SQL-4 d. SQL-07 Which of the following queries will output the table contents when the value of V_CODE is equal to […]

The SQL command that allows a user to permanently save data changes is______________ . a. INSERT b. SELECT c. COMMIT d. UPDATE The _____________data type is compatible with NUMBER. a. VARCHAR(15) b. SMALLINT c. DATE d. CHAR(10) Answer: b A […]

Oracle 11g is an example of the____________ . a. hierarchical model b. file system data model c. relational data model d. XML/Hybrid data model Assume you are using the INTERSECT operator to combine the results from two tables with identical […]

String comparisons are made from left to right. a. True b. False ______________returns only the attributes requested, in the order in which they are requested. a. PROJECT b. SELECT c. UNION d. DIFFERENCE Answer: a A trigger is executed as […]

“A password must have a minimum of five characters” is an example of a________________ . a. policy b. rule c. procedure d. standard Normalization purity is often easy to sustain in the modern database environment. a. True b. False Answer: […]

A derived attribute is indicated in the Chen notation by a ___________that connects the attribute and an entity. a. single line b. dashed line c. double dashed line d. double line In a database context, a(n)________ indicates the use of […]

_____________transparency allows data to be updated simultaneously at several network sites. a. Transaction b. Distribution c. Failure d. Performance The DBA must supervise the installation of all software and hardware designated to support the data administration strategy. a. True b. […]

A transaction processor (TP) is the software component residing on each computer that stores and retrieves data located at the site. a. True b. False A database management system needs_____________ to prepare the data for presentation to the end user […]

A scheduler facilitates data isolation to ensure that two transactions do not update the same data element at the same time. a. True b. False In organizations that generate large number of transactions,____________ are often a top priority in database […]

In the Chen and Crow’s Foot notations, an entity is represented with a rectangle containing the entity’s name. a. True b. False Which of the following is a disadvantage of the hierarchical data model? a. It does not promote data […]

Most data that can be encountered are best classified as_____________– . a. structured b. semistructured c. unstructured d. historical The entity relationship model (ERM) is dependent on the database type. a. True b. False Answer: False Business intelligence (BI) architecture […]