CIS2109 WEEK 1-3

Which of the following is the wildcard operator in SQL statements? < > * = &

*

There are a number of requirements for a table to be called a relation. List three of them.

-It must have a unique name. -Every attribute value must be atomic (not multivalued, not composite). -Every row must be unique (can't have two rows with exactly the same values for all their fields). -Attributes (columns) in tables must have unique names. -The order of the columns must be irrelevant. -The order of the rows must be irrelevant.

The first three steps to Normalization are ________________, _______________, and _____________________.

1NF, 2NF, 3NF 1. Multivations 2. separate into its tables 3. Get rid of the transitive

________ is the process of assigning pieces of application code to clients or servers. Application partitioning Modularizing programs Code distribution Program breakup

Application partitioning

What does the following SQL statement do? Update Product_T Set Unit_Price = 775 Where Product_ID = 7 A. Changes the price of a unit called Product_T to 7 B. Changes the unit price of Product 7 to 775 C. Changes the length of the Unit_Price field to 775 D. Updates the Product_T table to have a unit price of 775

Changes the unit price of Product 7 to 775

Which of the following is a technique for optimizing the internal performance of the relational data model? A. Avoiding indexes on secondary keys B. Clustering data C. Not reporting statistics to save machine resources D. Using random index organizations

Clustering data

Which of the following is NOT a method for storing XML documents? Shredding Use a BLOB or CLOB to store the entire XML file Use an XML native database Convert to text

Convert to text

Two types of subqueries are: ___________________ and __________________________ subqueries

Correlated and uncorrelated

SQL has been implemented only in the mainframe and midrange environments. True False

False

A _________________ view is a view that exists as a table

Materialized

CASE is a class of tools that: CASE. CAD. RAD. MST.

RAD

OLAP tools that use the database as a traditional relational database are called: ROLAP tools. MOLAP tools. slice and dice. None of these.

ROLAP tools

When creating tables, it's important to decide which columns will allow null values before the table is created. T/F

True

To eliminate duplicate rows in a query, the ________ qualifier is used in the SQL Select command. alter distinct check specific

distinct

Any create command may be reversed by using a ________ command. truncate drop delete unpack

drop

All of the following are concerns about developing a Web services approach EXCEPT: transaction speed. user acceptability. security. reliability.

user acceptability

Multiple values returned from an SQL query that includes an aggregate function are called: A. vector aggregates. B. scalar aggregates. C. agates. D. summations.

vector aggregates

An entity type whose existence depends on another entity type is called a ________ entity. strong weak codependent variant

weak

A relation that contains minimal redundancy and allows easy use is considered to be: clean. simple. complex. well-structured.

well-structured

For the relationship represented in the figure below, which of the following is true? (Department ERD image) A. An employee can work in more than one department but does not have to work for any department. B. A department must have at least one employee. C. A department can have more than one employee. D. An employee has to work for more than one department.

A department can have more than one employee

What will be returned when the following SQL query is executed? Select driver_no,count(*) as num_deliveries from deliveries group by driver_no having count(*)>2; A. A listing of all drivers who made more than 2 deliveries as well as a count of the number of deliveries B. A listing of all drivers C. A listing of the number of deliveries greater than 2 D. A listing of all drivers who made more than 2 deliveries

A listing of all drivers who made more than 2 deliveries as well as a count of the number of deliveries

A data warehouse administrator has which of the following responsibilities? A. Build and administer an environment supportive of decision-support applications B. Build a stable architecture for the data warehouse C. Develop service level agreements with suppliers and consumers of data for the data warehouse D. All of these

All of these

A method for handling missing data is to: substitute and estimate for the missing data. track missing data with special reports. perform sensitivity testing. All of these.

All of these

An entity cluster can be formed by: A. abstracting a supertype and its subtype. B. combining directly related entity types and their relationships. C. combining a strong entity and its weak entities. D. All of these.

All of these

An understanding of how to merge relations is important because: A. there may be a need to merge relations on projects with subteams. B. different views may need to be integrated. C. new data requirements may produce new relations to be merged. D. All of these.

All of these

The benefits of a standardized relational language include: a. application longevity. b. reduced training costs. c. cross-system communication. d. All of these.

All of these

The common types of entities are: strong entities. weak entities. associative entities. All of these.

All of these

The real-time data warehouse is characterized by which of the following? A. It accepts near-real time feeds of transaction data. B. Data are immediately transformed and loaded into the warehouse. C. It provides near-real-time access for the transaction processing systems to an enterprise data warehouse. D. All of these.

All of these

When incorrect data have been introduced, the database is best recovered by: A. backward recovery, if the error has been discovered soon enough. B. human intervention for only a few errors. C. restarting from the most recent checkpoint and processing subsequent transactions. D. All of these.

All of these

Which of the following is a purpose of the SQL standard? A. To specify syntax and semantics of SQL data definition and manipulation B. To specify minimal and complete standards, which permit different degrees of adoption in products C. To define the data structures and basic operations for SQL databases D. All of these

All of these

Which of the following is true of data visualization? A. It is easier to observe trends and patterns in data. B. Correlations and clusters in data can be easily identified. C. It is often used in conjunction with data mining. D. All of these.

All of these

Databases may be more expensive to maintain than files because of: a. the need for specialized personnel. b. the complexity of the database environment. c. backup and recovery needs. d. All of these.

All of these.

What does the following SQL statement do? Alter Table Customer_T Add (Type Varchar (2)); A. Alters the Customer_T table to accept Type 2 Varchars B. Alters the Customer_T table to be a Type 2 Varchar C. Alters the Customer_T table, and adds a field called "Type" D. Alters the Customer_T table by adding a 2-byte field called "Varchar"

Alters the Customer_T table, and adds a field called "Type"

In the figure below, what is depicted? A one-to-one relationship A unary relationship A one-to-many relationship An associative entity

An associative entity

Which of the following is a type of network security? A. Authentication of the client workstation B. Password naming conventions C. Guidelines for frequency of password changes D. All of these

Authentication of the client workstation

In the figure below, the primary key for "Order Line" is which type of key? (primeandsql) Composite Foreign Standard Grouped

Composite

________ use the result of the outer query to determine the processing of the inner query. A. Correlated subqueries B. Outer subqueries C. Inner subqueries D. Subqueries

Correlated subqueries

________ is a set of commands used to control a database, which includes security. A. DML B. DDL C. DCL D. DPL

DCL

________ is a set of commands used to update and query a database DML DDL DCL DPL

DML

is a set of commands used to update and query a database.

DML

________ is a technical function responsible for database design, security, and disaster recovery. Data administration Database administration Tech support Operations

Database administration

A business rule is a statement of how a policy is enforced or conducted.T/F

False

The degree of a relationship is the number of attributes that are associated with it. T/F

False

When creating a table, it is not important to consider foreign key-primary key mates. T/F

False

Which of the following finds all groups meeting stated conditions? A. Select B. Where C. Having D. Find

Having

Which of the following questions is answered by the SQL statement? Select Count (Product_Description) from Product_T; A. How many products are in the table Product_T? B. How many products have product descriptions in the Product Table? C. How many characters are in the field name "Product_Description"? D. How many different columns named "Product_Description" are there in table Product_T?

How many products have product descriptions in the Product Table?

Which of the following questions is answered by the SQL statement? Select Count (Product_Description) from Product_T; A. How many products are in the table Product_T? B. How many products have product descriptions in the Product Table? C. How many characters are in the field name "Product_Description"? D. How many different columns named "Product_Description" are there in table Product_T?

How many products have product descriptions in the Product Table?

Which of the following is an objective of selecting a data type? Represent a small number of possible values Maximize storage space Limit security Improve data integrity

Improve data integrity

Three examples of joins are: _______________________, ________________________, and _______________________ joins.

Inner, right outer, left outer, full outer, union, cross

Which of the following threats involves outside parties using information to embarrass a company? A. Accidental loss B. Theft and fraud C. Loss of confidentiality D. Loss of data integrity

Loss of confidentiality

What is the term given to information that describes data?

Metadata

To get all the customers from Hawaii sorted together, which of the following would be used? Order By Group By Having Sort

Order By

In the figure below, which of the following are subtypes of patient? (patient ERD) Outpatient Physician Bed All of these

Outpatient

The subtype discriminator in the figure below is: (supplier ERD) Part_Type. Part_No. Manufactured Part. Location.

Part_Type

Which of the following will produce the minimum of all standard prices? A. Select standard_price from Product_V where Standard_Price = min; B. Select min(standard_price) from Product_V; C. Select Standard_Price from min(Product_V); D. Select min(Standard_Price) from Product_V where Standard_Price = min(Standard_Price);

Select min(standard_price) from Product_V;

SOAP stands for: A. what you wash your hands with. B. Simple ODBC Access Protocol. C. Strategic Operational Advanced Planning. D. Simple Object Access Protocol Method.

Simple Object Access Protocol Method.

In the figure below, which attribute is multivalued? (look at the Employee image1) Years_Employed Employee_ID Correct Skill Address

Skill

Which of the following is a generic entity type that has a relationship with one or more subtypes? Megatype Supertype Subgroup Class

Supertype

It is desirable that no two attributes across all entity types have the same name. t/f

TRUE

In the following diagram, what type of relationship is depicted? (Vendor image1) Unary Binary Ternary Quad

Ternary

What result will the following SQL statement produce? Select Avg(standard_price) as average from Product_V; A. The average of all products in Product_V B.Correct The average Standard_Price of all products in Product_V C. The average price of all products D. None of these

The average Standard_Price of all products in Product_V

What will result from the following SQL Select statement? Select min(Product_Description) from Product_V; A. The minimum value of Product_Description will be displayed. B. An error message will be generated. C. The first product description alphabetically in Product_V will be shown. D. None of these.

The first product description alphabetically in Product_V will be shown.

A business rule is a statement that defines or constrains some aspect of the business. T/F

True

A natural join is the same as an equi-join, except that it is performed over matching columns that have been defined with the same name, and one of the duplicate columns is eliminated. T/F

True

A range control limits the set of permissible values that a field may assume.T/F

True

A referential integrity constraint is a rule that maintains consistency among the rows of two relations. T/F

True

A single occurrence of an entity is called an entity instance. T/F

True

A subtype can become a supertype if the subtype has other subtypes beneath it.T/F

True

A time stamp is a time value that is associated with a data value.

True

A trigger is a named set of SQL statements that are considered when a data modification occurs. T/F

True

In order to update data in SQL, one must inform the DBMS which relation, columns, and rows are involved. True False

True

The content of dynamic views is generated when they are referenced. T/F

True

The first line of defense for authentication is the use of passwords, which is a one-factor authentication scheme. T/F

True

A technical specification for creating a distributed registry of Web services and businesses that are open to communicating through Web services is called: HTML. B2B. UDDI. XML.

UDDI

The ________ clause is used to combine the output from multiple queries into a single result table. Selected Answer: INTERSECT DIVIDE COLLATE UNION

UNION

In an SQL statement, which of the following parts states the conditions for row selection? Select From Where Group By

Where

In an SQL statement, which of the following parts states the conditions for row selection? a. Select b. From c. Where d. Group By

Where

In the figure below, which attribute is derived? (look at the Employee image1) Years_Employed Employee_ID Skill Address

Years_Employed

An alternative name for an attribute is called a(n): synonym. alias. alternate attribute. related characteristic.

alias

A person's name, birthday, and social security number are all examples of: attributes. entities. relationships. descriptors.

attributes

The preferred method of fixing an aborted transaction is: repairing the schema. switching. duplication of data. backing out the transaction.

backing out the transaction

A join in which the joining condition is based on equality between values in the common columns is called a(n): equi-join. unilateral join. natural join. both equi-join and natural join.

both equi-join and natural join

A ________ constraint is a type of constraint that addresses whether an instance of a supertype must also be an instance of at least one subtype. disjoint overlap completeness weak

completeness

An attribute that can be broken down into smaller parts is called a(n) ________ attribute. associative simple composite complex

composite

All of the following are some beneficial applications for real-time data warehousing EXCEPT: A. just-in-time transportation. B. e-commerce. For example, an abandoned shopping cart can trigger an email promotional message. C. fraud detection in credit card transactions. D. data entry.

data entry

An attribute that can be calculated from related attribute values is called a(n) ________ attribute. simple composite multivalued derived

derived

A star schema contains both fact and ________ tables narrative cross functional dimension starter

dimension

A person, place, an object , an event or concept about which the organization wishes to maintain data is called a(n): relationship. object. attribute. entity.

entity

An index on columns from two or more tables that come from the same domain of values is called a: bitmap index. multivalued index. join index. transaction index.

join index

A join in which rows that do not have matching values in common columns are still included in the result table is called a(n): natural join. equi-join. outer join. union join.

outer join

All of the following are properties of metadata EXCEPT: a. data definitions. b. processing logic. c. rules or constraints. d. data structures.

processing logic

A ________ is a DBMS module that restores the database to a correct condition when a failure occurs. backup facility recovery manager restart facility transaction logger

recovery manager

A rule that states that each foreign key value must match a primary key value in the other relation is called the: referential integrity constraint. key match rule. entity key group rule. foreign/primary match rule.

referential integrity constraint.

A two-dimensional table of data sometimes is called a: group. set. declaration. relation.

relation

A type of join where a table is joined to itself is called a(n): unary join. self-join. unnatural join. pinned join.

self-join.

An expanded version of a star schema in which all of the tables are fully normalized is called a(n): snowflake schema. operational schema. DSS schema. complete schema.

snowflake schema

When an XML document is shredded, each element is: thrown away. split up. stored in a relational table. added to other XML documents.

stored in a relational table

A(n) ________ is a module of code written in SQL or some proprietary language to run business rules on a server. SQL program select module select procedure stored procedure

stored procedure

A type of query that is placed within a WHERE or HAVING clause of another query is called a: A. master query. B. Correct subquery. C. superquery. D. multi-query.

subquery

A relationship between the instances of a single entity type is called a(n) ________ relationship. ternary primary binary unary

unary

What will be returned when the following SQL statement is executed? Select driver_no,count(*) as num_deliveries from deliveries group by driver_no; A. A listing of all drivers, sorted by driver number B. A listing of each driver as well as the number of deliveries that he or she has made C. A count of all of the deliveries made by all drivers D. None of these

A listing of each driver as well as the number of deliveries that he or she has made

A database is maintained and queried using the data mapping language (DML). True False

False

A default value is the value that a field will always assume, regardless of what the user enters for an instance of that field.T/F

False

A fat client does most of its processing on the server. T/F

False

A foreign key is a primary key of a relation that also is a primary key in another relation. True False

False

A join index is a combination of two or more indexes.T/F

False

Count(*) tallies only those rows that contain a value, while Count counts all rows. T/F

False

DCL is used to update the database with new records. True False

False

Generalization is a top-down process. T/F

False

Indexes generally slow down access speed in most RDMS. T/F

False

It is not permissible to associate attributes with relationships. T/F

False

NoSQL is a great technology for storing well-structured data.T/F

False

Open-source software always comes with complete documentation. T/F

False

SOX stands for the Sorbet-Oxford Act. T/F

False

Subqueries can only be used in the WHERE clause. T/F

False

The DELETE TABLE DDL command is used to remove a table from the database T/F

False

The DROP command deletes rows from a table individually or in groups T/F

False

The HAVING clause and the WHERE clause perform the same operation. T/F

False

When the SELECT clause in the create view statement contains the keyword DISTINCT, the view can be used to update data. T/F

False

Which of the following can produce scalar and vector aggregates? A. Order By B. Group By C. Having D. Sort

Group By

PHP is a popular API for MySQL because of all of the following EXCEPT: Microsoft integration. high performance. easy to use. MySQL connectivity built-in.

Microsoft integration

A class of database technology used to store textual and other unstructured data is called: mySQL. NoSQL. KnowSQL. PHP.

NoSQL

Which of the following is true of the order in which SQL statements are evaluated A. The SELECT clause is always processed first. B. The SELECT clause is always processed last. C. The SELECT clause is processed before the ORDER BY clause. D. The GROUP BY clause is processed before the WHERE clause.

The SELECT clause is processed before the ORDER BY clause.

What three clauses are contained in most SQL retrieval statements?

The SELECT clause, which lists the columns and calculated expression from base tables. The FROM clause, which identifies tables and views which we want to gather data from in the query. Finally, the WHERE clause, which is used to specify conditions for selection of rows in the result set.

A correlated subquery is executed once for each iteration through the outer loop. T/F

True

A well-structured relation contains minimal redundancy and allows users to manipulate the relation without errors or inconsistencies.

True

Adding the DISTINCT keyword to a query eliminates duplicates. T/F

True

All values that appear in a column of a relation must be taken from the same domain. T/F

True

An SQL query that implements an outer join will return rows that do not have matching values in common columns. T/F

True

An enterprise resource planning system integrates all functions of the enterprise. True False

True

An entity cluster can have a relationship with another entity cluster much the same way that an entity can have a relationship with another entity.T/F

True

An insert command does not need to have the fields listed. T/F

True

Application partitioning gives developers the opportunity to write application code that can later be placed on either a client workstation or a server, depending upon which location will give the best performance. T/F

True

Cost and complexity are just two of the disadvantages of database processing. True False

True

Denormalization almost always leads to more storage space for raw data.T/F

True

SQL is both an American and international standard for database access.T/F

True

Sample data are useful for developing prototype applications and for testing queries.T/F

True

Separation of metadata from application programs that use the data is called data independence. True False

True

Specialization is the reverse of generalization. T/F

True

The ALTER TABLE command is used to change a table definition. T/F

True

The asterisk (*) wildcard designator can be used to select all fields from a table as well as in WHERE clauses when an exact match is not possible. T/F

True

The views are created by executing a CREATE VIEW SQL command. T/F

True

Vertical partitioning means distributing the columns of a table into several separate physical records.T/F

True

When a GROUP BY clause is included in an SQL statement, only those columns with a single value for each group can be included. T/F

True

When a GROUP BY clause is included in an SQL statement, only those columns with a single value for each group can be included.T/F

True

What steps should be followed when preparing to create a table?

When preparing to create a table, one should: 1. Identify the appropriate data type and length for each attribute 2. Identify the columns that should accept null values 3. Identify that columns that need to be unique 4. Identify all primary-foreign key mates 5. Determine default values 6. Identify any columns for which domain constraints, such as check, need to be stated 7. Create the table and any indexes using create table and create index statements

Given a table named store with 5 fields: store_id, address, city, state, zipcode, why would the following insert command not work? insert into store values ('234 Park Street') a. It would work just fine. b. You must specify the fields to insert if you are only inserting some of the fields. c.There is no table keyword. d.None of these.

You must specify the fields to insert if you are only inserting some of the fields.

A transaction that terminates abnormally is called a(n) ________ transaction. terminated aborted completed deleted

aborted

A form of denormalization where the same data are stored in multiple places in the database is called: data duplication. data replication. advanced placement. horizontal partitioning.

data replication

A dependent data mart: A. is filled with data extracted directly from the operational system. B. is filled exclusively from the enterprise data warehouse with reconciled data. C. is dependent upon an operational system. D. participates in a relationship with an entity.

is filled exclusively from the enterprise data warehouse with reconciled data

A relationship where the minimum and maximum cardinality are both one is a(n) ________ relationship optional unidirectional mandatory link mandatory one

mandatory one

The following figure shows a(n): (student ERD) disjoint constraint. completeness constraint. supertype/subtype hierarchy. spindle constraint

supertype/subtype hierarchy

A simultaneous relationship among the instances of three entity types is called a(n) ________ relationship. ternary tertiary primary binary

ternary

A PC configured to handle user interface with little or no local storage is called a: server. fat client. thin client. workstation.

thin client

A discrete unit of work that must be processed completely or not at all within a computer system is called a: change control device. transaction. before image. journalizing facility.

transaction

Database access frequencies are estimated from: transaction volumes. user logins. security violations. None of these.

transaction volumes

A foreign key is a primary key of a relation that also is a primary key in another relation.T/F

False

A member of a subtype does NOT necessarily have to be a member of the supertype. T/F

False

A physical schema contains the specifications for how data from a conceptual schema are stored in a computer's secondary memory. True False

False

A simple attribute can be broken down into smaller pieces.T/F

False

A single value returned from an SQL query that includes an aggregate function is called a vector aggregate. T/F

False

A ternary relationship is equivalent to three binary relationships. T/F

False

An anomaly is a type of flaw in the database server. T/F

False

An anomaly is a type of flaw in the database server.T/F

False

An equi-join is a join in which one of the duplicate columns is eliminated in the result table. T/F

False

________ is/are any of several classes of software that allow an application to interoperate with other software without requiring the user to understand all software involved. User interface enhancers Middleware Interface managers MPP

Middleware

When two tables are joined together, the ________________ of one table is matched with the ________________ of the other table.

Primary and Foreign keys

In the figure below, what type of key is depicted? (Employeesqlerd) Primary Recursive primary Composite Recursive foreign

Recursive foreign

_______ is used to undo unwanted database changes. Rollback Rollforward Restart Encryption

Rollback

A relation that contains no multivalued attributes and has nonkey attributes solely dependent on the primary key but contains transitive dependencies is in which normal form? First Second Third Fourth

Second

Which of the following will produce the minimum of all standard prices? A. Select standard_price from Product_V where Standard_Price = min; B. Correct Select min(standard_price) from Product_V; C. Select Standard_Price from min(Product_V); D. Select min(Standard_Price) from Product_V where Standard_Price = min(Standard_Price);

Select min(standard_price) from Product_V;

What does the following SQL statement do? Select * From Customer Where Cust_Type = "Best" A. Selects all the fields from the Customer table for each row with a customer labeled "Best" B. Selects the "*" field from the Customer table for each row with a customer labeled "Best" C. Selects fields with a "*" in them from the Customer table D. Selects all the fields from the Customer table for each row with a customer labeled "*"

Selects all the fields from the Customer table for each row with a customer labeled "Best"

The main difference between Java applets and Java servlets is: A. applets are stored on the client but executed on the server. B. Servlets are stored on the server while applets are stored on the client. C. both applets and servlets are executed and stored on the server. D. None of these.

Servlets are stored on the server while applets are stored on the client.

Select Customer_Name, telephone from customers Where city in('Boston', 'New York', 'Denver'); A. The Customer_Name and telephone of all customers B. The Customer_Name and telephone of all customers living in either Boston, New York or Denver C. The Customer_Name and telephone of all customers living in Boston and New York and Denver D. The Customer_Name of all customers living in Boston, New York or Denver

The Customer_Name and telephone of all customers living in either Boston, New York or Denver

What result set will the following query return? Select Item_No from Order_V Where quantity > 10; A. The Item_No of all orders that had more than 10 items B. The Order_Id of all orders that had more than one item C. The Order_Id of all orders that had more than 10 items D. The Item_No of all orders that had 10 or more items

The Item_No of all orders that had more than 10 items

A business transaction is a sequence of steps that constitute some well-defined business activity.T/F

True

A cascading delete removes all records in other tables associated with the record to be deleted. T/F

True

A client/server configuration that has three layers (one client and two servers) has a three-tier architecture. T/F

True

A data model is a graphical system used to capture the nature and relationships among data. True False

True

A data warehouse contains summarized and historical information. True False

True

A database table is defined using the data definition language (DDL). True False

True

A join in which the joining condition is based on equality between values in the common column is called a(n) equi-join. T/F

True

A major benefit of SQL as a standard is reduced training costs. True False

True

A modern database management system automates more of the backup and recovery tasks than a file system. True False

True

A universal data model is a generic or template data model that can be reused as a starting point for a data modeling project.T/F

True

A view can be built to present only the data to which a user requires access.T/F

True

Data modeling is about documenting rules and policies of an organization that govern data.

True

Data structures include data organized in the form of tables with rows and columns.

True

Data structures include data organized in the form of tables with rows and columns.T/F

True

E. F. Codd developed the relational data model during the 1970s. False True

True

For performance reasons, it may be necessary to define more than one fact table for a star schema.T/F

True

In a supertype/subtype hierarchy, attributes are assigned at the highest logical level that is possible in the hierarchy.T/F

True

In prototyping, implementation and maintenance activities are repeated as necessary until the product is correct. True False

True

Information is processed data. True False

True

Keeping the zip code with the city and state in a table is a typical form of denormalization. True False

True

Medical claims and pharmaceutical data would be an example of big data. T/F

True

One of the original purposes of the SQL standard was to provide a vehicle for portability of database definition and application modules between conforming DBMSs. True False

True

Open Database Connectivity is an application programming interface that provides a common language for application programs to access and process SQL databases independent of the particular RDBMS that is accessed. T/F

True

Service-oriented architectures (SOA) are: A. a set of tiers designed to serve each other. B. a collection of services that communicate with each other in some manner. C. architecture designed for the military. D. None of these.

a collection of services that communicate with each other in some manner

The following figure shows an example of: (look at the student image1) A. a composite attribute. B. a relational attribute. C. a derived attribute. D. a multivalued attribute.

a composite attribute.

An open-source DBMS is: A. a free source-code RBMS that provides the functionality of an SQL-compliant DBMS. B. a beta release of a commercial RDBMS. C. an object-oriented database management system. D. source code for a commercial RDBMS.

a free source-code RBMS that provides the functionality of an SQL-compliant DBMS.

Extensible Markup Language (XML) is: A. a scripting language that allows the creation of customized tags to enable easier sharing of data across organizations. B. a database language. C. a product used for database middleware. D. None of these.

a scripting language that allows the creation of customized tags to enable easier sharing of data across organizations.

The following figure shows an example of: (look at the Employee erd image) A. a one-to-many relationship. B. a strong entity and its associated weak entity. C. a co-dependent relationship. D. a double-walled relationship.

a strong entity and its associated weak entity.

An alternative name for an attribute is called a(n): synonym. alias. alternate attribute. related characteristic.

alias

The SQL command ________ adds one or more new columns to a table. A. create table B. alter table C. create view D. create relationship

alter table

While views promote security by restricting user access to data, they are not adequate security measures because: A. an unauthorized person may gain access to a view through experimentation. B. all users can read any view. C. a view's data does not change. D. None of these.

an unauthorized person may gain access to a view through experimentation.

Web services: A. are a set of services available to all on the Web. B. Correct are a set of emerging standards for protocols for automatic communication between software over the Web. C. are a set of standards based upon HTML. D. None of these.

are a set of emerging standards for protocols for automatic communication between software over the Web.

An entity type name should be all of the following EXCEPT: concise. specific to the organization. as short as possible. a singular noun.

as short as possible

A ________ specifies the number of instances of one entity that can be associated with each instance of another entity. degree cardinality constraint counter constraint limit

cardinality constraint

A join operation: A. brings together data from two different fields. B. causes two tables with a common domain to be combined into a single table or view. C. causes two disparate tables to be combined into a single table or view. D. is used to combine indexing operations

causes two tables with a common domain to be combined into a single table or view.

Data modeling may be the most important part of the systems development process because: A. data characteristics are important in the design of programs and other systems components. B. the data in a system are generally less complex than processes and play a central role in development. C. data are less stable than processes. D. it is the easiest.

data characteristics are important in the design of programs and other systems components.

A data mart is a(n) A. enterprisewide data warehouse. B. smaller system built upon file processing technology. C. data warehouse that is limited in scope. D. generic on-line shopping site.

data warehouse that is limited in scope

One application of data warehouses is: shipping of information. order processing. decision support. file updating.

decision support

A ________ is a temporary table used in the FROM clause of an SQL query. A. correlated subquery B. derived table C. view table D. None of these

derived table

A ________ addresses whether an instance of a supertype may simultaneously be a member of two or more subtypes. disjointedness constraint disjoint rule partial specialization total specialization

disjointedness constraint

Going from a summary view to progressively lower levels of detail is called data cubing. drill-down. dicing. pivoting.

drill-down

Any create command may be reversed by using a ________ command. A. truncate B. drop C. delete D. unpack

drop

The coding or scrambling of data so that humans cannot read them is called: demarcation. hiding. encoding. encryption.

encryption

A primary key whose value is unique across all relations is called a(n): global primary key. inter-table primary key. enterprise key. foreign global key.

enterprise key

Customers, cars, and parts are examples of: entities. attributes. cardinals. relationships

entities

The logical representation of an organization's data is called a(n): database model. entity-relationship model. relationship systems design. database entity diagram.

entity-relationship model

A command used in Oracle to display how the query optimizer intends to access indexes, use parallel servers and join tables to prepare query results is the: explain plan. show optimization. explain query. analyze query.

explain plan.

A disadvantage of partitioning is: simplicity. remote optimization. extra space and update time. shorter technology spans.

extra space and update time

A client PC that is responsible for processing presentation logic, extensive application and business rules logic as well as many DBMS functions is called a(n): file server. file processor. database server. Fat client.

fat client

A(n) ________ is a technique for physically arranging the records of a file on secondary storage devices. physical pointer retrieval program file organization update program

file organization

An attribute in a relation of a database that serves as the primary key of another relation in the same database is called a: link attribute. link key. foreign key. foreign attribute.

foreign key

The level of detail in a fact table determined by the intersection of all the components of the primary key, including all foreign keys and any other primary key elements, is called the: span. Grain. selection. aggregation.

grain

An attribute that may have more than one meaning is called a(n):

homonym.

The first in a series of steps to follow when creating a table is to: A. identify columns that must be unique. B. identify each attribute and its characteristics. C. create an index. D. identify columns that must be null.

identify each attribute and its characteristics.

The ________ occurs when one user reads data that have been partially updated by another user. inconsistent read problem distant read problem honest dirty data data quality problem

inconsistent read problem

An operational data store (ODS) is a(n): A. place to store all unreconciled data. B. representation of the operational data. C. integrated, subject-oriented, updateable, current-valued, detailed database designed to serve the decision support needs of operational users. D. small-scale data mart.

integrated, subject-oriented, updateable, current-valued, detailed database designed to serve the decision support needs of operational users

A domain definition consists of the following components EXCEPT: domain name. data type. integrity constraints. size

integrity constraints

All of the following are limitations of the independent data mart EXCEPT: A. separate extraction, transformation, and loading processes are developed for each data mart. B. data marts may not be consistent with one another. C. there is no capability to drill down into greater detail in other data marts. D. it is often more expedient to build a data mart than a data warehouse.

it is often more expedient to build a data mart than a data warehouse

All of the following are the main goals of normalization EXCEPT: A. minimize data redundancy. B. simplify the enforcement of referential integrity. C. Correct maximize storage space. D. make it easier to maintain data.

maximize storage space.

All of the following are the main goals of normalization EXCEPT: minimize data redundancy. simplify the enforcement of referential integrity. maximize storage space. make it easier to maintain data.

maximize storage space.

A join that is based upon equality between values in two common columns with the same name and where one duplicate column has been removed is called a(n): A. equi-join. B. Correct natural join. C. multivariate join. D. inner join.

natural join.

The entity integrity rule states that: A. no primary key attribute can be null. B. referential integrity must be maintained across all entities. C. each entity must have a primary key. D. a primary key must have only one attribute.

no primary key attribute can be null

The use of a set of graphical tools that provides users with multidimensional views of their data is called: A. on-line geometrical processing (OGP). B. drill-down analysis. C. on-line analytical processing (OLAP). D. on-line datacube processing (ODP).

on-line analytical processing (OLAP)

A method that speeds query processing by running a query at the same time against several partitions of a table using multiprocessors is called: multiple partition queries. perpendicular query processing. parallel query processing. query optimization.

parallel query processing

A(n) ________ is a field of data used to locate a related field or record. key index lock pointer

pointer

An attribute (or attributes) that uniquely identifies each row in a relation is called a: column. foreign field. primary key. duplicate key.

primary key

A Web server: A. is used only to host Web pages. B. processes client requests and returns HTML pages to the client. C. always contains a database. D. is considered to be part of the firewall.

processes client requests and returns HTML pages to the client.

One of the most popular RAD methods is: automated design. structured walkthrough. prototyping. crafting.

prototyping.

Indexes are created in most RDBMSs to: A. provide a quicker way to store data. B. decrease the amount of disk space utilized. C. provide rapid random and sequential access to base-table data. D. increase the cost of implementation.

provide rapid random and sequential access to base-table data.

All of the following are primary purposes of a database management system (DBMS) EXCEPT: a. creating data. b. updating data. c. storing data. d. providing an integrated development environment.

providing an integrated development environment.

Data that are detailed, current, and intended to be the single, authoritative source of all decision support applications are called ________ data. reconciled subject derived detailed

reconciled

An attribute of an entity that must have a value for each entity instance is a(n): optional attribute. composite attribute. required attribute. fuzzy attribute.

required attribute

A single value returned from an SQL query that includes an aggregate function is called a(n): A. agate. B. Correct scalar aggregate. C. vector aggregate. D. summation.

scalar aggregate

SQL provides the ________ technique, which involves placing an inner query within the WHERE or HAVING clause of an outer query. grouping joining subquery union

subquery

Because applications are often developed independently in file processing systems: A.the data is always non-redundant. B. unplanned duplicate data files are the rule rather than the exception. C.data can always be shared with others. D.there is a large volume of file I/O.

unplanned duplicate data files are the rule rather than the exception

Horizontal partitioning makes sense: A. when different categories of a table's rows are processed separately. B. when less security is needed. C. when partitions must be organized the same. D. when all of these are true.

when different categories of a table's rows are processed separately