ISM 4210 Quiz 10

Which of the following statements is true about the figure shown below? A rental unit can be an apartment, a house or just a rental unit. It could be both an apartment and a house at the same time. Correct Answer A rental unit must be either an apartment or a house, and cannot be both at the same time. You Answered A rental unit must be either an apartment or a house, and could be both. A rental unit can be an apartment, house or just a rental unit; it may not be more than one at the same time.

A rental unit must be either an apartment or a house, and cannot be both at the same time.

Which of the following is a type of network security? Random password guessing Guidelines for frequency of password changes Password naming conventions Correct! Authentication of the client workstation

Authentication of the client workstation

What does the following SQL statement do? UPDATE Product_T SET Unit_Price = 775WHERE Product_ID = 7 Updates the Product_T table to have a unit price of 775 Changes the price of a unit called Product_T to 7 Changes the length of the Unit_Price field to 775 Correct! Changes the unit price of Product 7 to 775

Changes the unit price of Product 7 to 775

Which of the following criteria should be considered when selecting an identifier? Choose an identifier that is not stable. Choose the most complex identifier possible. Correct! Choose an identifier that doesn't have large composite attributes. Choose a null identifier.

Choose an identifier that doesn't have large composite attributes.

________ is a set of commands used to control a database, including security. DML DDL DPL Correct! DCL

DCL

The number of entity types that participate in a Unary relationship is: zero. two. three. Correct! one.

ONE

Which of the following is NOT a reason to create an instance of a relational schema with sample data? Sample data can reverse database implementation errors. Sample data can be used for prototype generation. Sample data provide a convenient way to check the accuracy of your design. Sample data can be used to improve user communications.

Sample data can reverse database implementation errors.

Which type of file is most efficient with storage space? Hashed Clustered Correct! Sequential Indexed

Sequential

Which of the following is a purpose of the SQL standard? To specify maximum and incomplete standards To permit no degrees of freedom for SQL DBMS Correct! To specify syntax and semantics of SQL data definition and manipulation languages To define every operation for every SQL database

To specify syntax and semantics of SQL data definition and manipulation languages

The SDLC phase in which every data attribute is defined, every category of data is listed, and every business relationship between data entities is defined is called the ________ phase. implementation Correct! analysis design planning

analysis

The SDLC phase in which the detailed conceptual data model is created is the ________ phase. planning implementation Correct! analysis design

analysis

A property or characteristic of an entity type that is of interest to the organization is called a(n): cross-function. coexisting entity. Correct! attribute. relationship.

attribute

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

backing out the transaction.

In SQL, a(n) ________ subquery is a type of subquery in which processing the inner query depends on data from the outer query. correlated paired natural inner

correlated

In SQL, a(n) ________ subquery is a type of subquery in which processing the inner query depends on data from the outer query. paired Correct! correlated natural inner

correlated

When identifying the parts of the packaged data model that apply to your organization, one should first start with: attributes. primary keys. Correct! entities. relationships.

entities.

The figure below is an example of a(n): supertype/subtype hierarchy. Correct! entity cluster. column cluster. hierarchical data model.

entity cluster.

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

entity-relationship model.

The following code is an example of a(n): SELECT Customer_T.CustomerID, Order_T.CustomerID, CustomerName, OrderID FROM Customer_T, Order_T WHERE Customer_T.CustomerID = Order_T. CustomerID; equi-join. Right Outer JOIN. subquery. Full Outer JOIN.

equi-join.

Using a packaged data model, projects take less time and cost because: there is more time taken to model the enterprise. packaged data models only run in Oracle. less personnel are required. Correct! essential components and structures are already defined.

essential components and structures are already defined.

A(n) ________ prevents another transaction from reading and therefore updating a record until it is unlocked. exclusive lock authorization rule record controller shared lock

exclusive lock

A disadvantage of partitioning is: simplicity. Correct! extra space and update time. remote optimization. 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: fat client. database server. file server. file processor.

fat client.

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

file organization

SQL-invoked routines can be: Correct! functions or procedures. part of a DDL statement. part of a DCL statement. contained within a CREATE statement.

functions or procedures.

SQL-invoked routines can be: part of a DDL statement. contained within a CREATE statement. part of a DCL statement. Correct! functions or procedures.

functions or procedures.

A file organization where files are not stored in any particular order is considered a: Correct! heap file organization. hashed file organization. hash key. multi-indexed file organization.

heap file organization.

A requirement to begin designing physical files and databases is: normalized relations. implementation complete. all datatypes determined. physical tables created.

normalized relations.

Durability means that: Correct! once a transaction is committed, no subsequent failure of the database can reverse the effect of the transaction. transactions can withstand failure. transactions can't be erased. transactions never finish on time.

once a transaction is committed, no subsequent failure of the database can reverse the effect of the transaction.

Packaged data models: allow partial specialization. Correct! require customization. cannot be used for most applications. are ready to use right out of the box.

require customization.

Determining the structure of data and the relationships between data elements either right before or at the time of use of the data is called: on demand paging. tables on write. caching. Correct! schema on write.

schema on write.

A credit-card sized plastic card with an embedded microprocessor chip with the ability to store, process, and output electronic data in a secure manner is called a(n): Correct Answer smart card. You Answered smart chip. e-credit card. secure card.

smart card.

The following diagram shows: the overlap rule. (employee, salaried, hourly) partial specialization. Correct! subtype discriminator. total specialization.

subtype discriminator.

A candidate key must satisfy all of the following conditions EXCEPT: Correct! the key must indicate the row's position in the table. the key must be nonredundant. each nonkey attribute is functionally dependent upon it. the key must uniquely identify the row.

the key must indicate the row's position in the table.

Quality data can be defined as being: inaccurate. precise. Correct! unique. historical.

unique.

Establishing IF-THEN-ELSE logical processing within an SQL statement can be accomplished by: using a subquery. Correct! using the CASE key word in a statement. using the if-then-else construct. using the immediate if statement.

using the CASE key word in a statement.

A data warehouse derives its data from: CORRECT: various operational data sources. You Answered a data mart. reports. on-line transactions.

various operational data sources.

A good data definition will describe all of the characteristics of a data object EXCEPT: subtleties. Correct! who can delete the data. examples. who determines the value of the data.

who can delete the data.

A good data definition will describe all of the characteristics of a data object EXCEPT: who can delete the data. who determines the value of the data. examples. subtleties.

who can delete the data.

The command for removing a table is: TRUNCATE TABLE. Correct! DROP TABLE. REMOVE TABLE. CREATE TABLE.

DROP TABLE.

The role that is responsible for developing overall policies and procedures for database security is: Database Development. Correct! Data Administration. Database Administration. Accounting.

Data Administration.

The role responsible for administering database security is: Security. You Answered Data Administration. Developers. Correct Answer Database Administration.

Database Administration.

Which of the following questions is answered by the SQL statement? SELECT COUNT (Product_Description) FROM Product_T; How many different columns named "Product_Description" are there in table Product_T? Correct! How many products have product descriptions in the Product Table? How many characters are in the field name "Product_Description"? How many products are in the table Product_T?

How many products have product descriptions in the Product Table?

The LAMP stack consists of all of the following EXCEPT: PHP or Python. Apache. MySQL. Correct! IIS.

IIS.

A data-interchange format easily for humans to read and machines to parse and process is called: HTML. Correct! JavaScript Object Notation (JSON). XML. Java Oriented Notation (JON).

JavaScript Object Notation (JSON).

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

Order By

In which data model would a code table appear? Correct! Physical Logical Data layout Conceptual

Physical

Which of the following is NOT an advantage of database systems? Program-data independence Correct! Redundant data Better data quality Reduced program maintenance

Redundant data

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

Rollback

Which of the following will produce the minimum of all standard prices? SELECT Standard_Price FROM min(Product_V); Correct! SELECT MIN(Standard_Price) FROM Product_V; SELECT Standard_Price FROM Product_V WHERE Standard_Price = min; SELECT MIN(Standard_Price) FROM Product_V WHERE Standard_Price = min(Standard_Price);

SELECT MIN(Standard_Price) FROM Product_V;

Which of the following violates the atomic property of relations? Hinz Correct! Sam Hinz Atomic Sam

Sam Hinz

User-defined data types: can have defined functions and methods. are not allowed in any DBMS. can be used once in a system. are only allowed in Oracle.

can have defined functions and methods.

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

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

A DBMS periodically suspends all processing and synchronizes its files and journals through the use of a: backup facility. Correct! checkpoint facility. recovery manager. database change log.

checkpoint facility.

The actions that must be taken to ensure data integrity is maintained during multiple simultaneous transactions are called ________ actions. concurrency control multiple management transaction authorization logging

concurrency control

The actions that must be taken to ensure data integrity is maintained during multiple simultaneous transactions are called ________ actions. transaction authorization Correct! concurrency control multiple management logging

concurrency control

In the SQL language, the ________ statement is used to make table definitions. select create index create session Correct! create table

create table

A mechanism in a ResultSet object in Java that points to the current row of data is called a: trigger. stored procedure. table. Correct! cursor.

cursor.

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

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

A graphical system used to capture the nature and relationships among data is called a(n): Correct! data model. XML data model. hypertext graphic. relational database.

data model.

A good method for identifying inconsistencies and finding hidden meaning in the customized purchased data model is: data volume usage analysis. user interviews. data analysis. Correct! data profiling.

data profiling.

The attribute on the left-hand side of the arrow in a functional dependency is the: candidate key. primary key. foreign key. Correct! determinant.

determinant.

When a user creates a virtual table it is called a(n): Correct! dynamic view. virtual table. materialized view. inline view.

dynamic view.

When a user creates a virtual table it is called a(n): virtual table. inline view. materialized view. Correct! dynamic view.

dynamic view.

Data governance can be defined as: a means to slow down the speed of data. a government task force for defining data quality. You Answered a means to increase the speed of data. Correct Answer high-level organizational groups and processes that oversee data stewardship.

high-level organizational groups and processes that oversee data stewardship.

Data that are accurate, consistent, and available in a timely fashion are considered: low-quality. Microsoft-based. Oracle-based. Correct! high-quality.

high-quality.

A form of database design which maps conceptual requirements is called: response designs. security design. You Answered physical design. Correct Answer logical designs.

logical designs.

A database is an organized collection of ________ related data. Correct! logically physically badly loosely

logically

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

mandatory one

Durability means that: transactions never finish on time. transactions can withstand failure. You Answered transactions can't be erased. Correct Answer once a transaction is committed, no subsequent failure of the database can reverse the effect of the transaction.

once a transaction is committed, no subsequent failure of the database can reverse the effect of the transaction.

Understanding the steps involved in transforming EER diagrams into relations is important because: Correct! one must be able to check the output of a CASE tool. CASE tools model hypothetical business problems. there are rarely legitimate alternatives from which to choose. CASE tools can model any situation.

one must be able to check the output of a CASE tool.

The following code would include: SELECT Customer_T.CustomerID, Order_T.CustomerID, CustomerName, OrderID FROM Customer_T, Order_T WHERE Customer_T.CustomerID = Order_T. CustomerID; Correct! only rows that match both Customer_T and Order_T Tables. only rows that don't match both Customer_T and Order_T Tables. all rows of the Order_T Table regardless of matches with the Customer_T Table. all rows of the Customer_T Table regardless of matches with the Order_T Table.

only rows that match both Customer_T and Order_T Tables.

While Oracle has responsibility for managing data inside a tablespace, the tablespace, as a whole, is managed by the: CEO. Correct! operating system. XML. user.

operating system.

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): union join. equi-join. Correct! outer join. natural join.

outer join.

In the ________ approach, one consolidated record is maintained from which all applications draw data. Correct! persistent data-oriented persnickity cautious

persistent

Legacy systems often contain data of ________ quality and are generally hosted on ________. poor; personal computers excellent; workgroup computers Correct! poor; mainframes excellent; mainframes

poor; mainframes

Sarbanes-Oxley Act was enacted to ensure the integrity of: public companies' financial statements. SQL. Entity-Relationship Diagrams. private companies' shareholders meetings.

public companies' financial statements.

Requiring a CustomerID to exist in a Primary table before it can exist in a foreign table is an example of: ethical integrity. Correct! referential integrity. referential referring. the Hoffer Principle.

referential integrity.