CIS 2109 Final Study Guide
Which of the following is the wildcard operator in SQL statements?
*
________ is a set of commands used to control a database, which includes security.
DCL
________ 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.
Database administration
Which of the following is not a disadvantage of stored procedures?
Decreases in network traffic are realized.
For the relationship represented in the figure below, which of the following is true? https://blackboard.temple.edu/courses/1/7302015103440/ppg/pearson/tm/mdm11h/f2g1q40g1.jpg
A department can have more than one employee.
(True or False) A constraint is a rule in a database system that can be violated by users.
False
________ is the process of assigning pieces of application code to clients or servers.
Application partitioning
Which of the following is a type of network security?
Authentication of the client workstation
(True or 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.
False
(True or False) A fact table holds descriptive data about the business.
False
(True or False) A fat client does most of its processing on the server.
False
(True or False) A foreign key is a primary key of a relation that also is a primary key in another relation.
False
(True or False) A function has only input parameters but can return multiple values.
False
(True or False) A ternary relationship is equivalent to three binary relationships.
False
(True or False) An API is a set of routines that a database server uses to access database objects.
False
(True or False) An XML Schema is a language used to define HTML.
False
(True or False) An anomaly is a type of flaw in the database server.
False
(True or False) An enterprise data model describes the scope of data for only one information system.
False
(True or False) An equi-join is a join in which one of the duplicate columns is eliminated in the result table.
False
(True or False) An intranet utilizes Web-based technology to improve communication with parties outside of the organization.
False
(True or False) An operational data store typically holds a history of snapshots of the state of an organization whereas an enterprise data warehouse does not typically contain history.
False
(True or False) Business rules logic includes such activities as data validation and identification of processing errors.
False
(True or False) Customer-oriented architectures are a collection of services that communicate with each other in some manner.
False
(True or False) DCL is used to update the database with new records.
False
(True or False) Independent data marts do not generally lead to redundant data and efforts.
False
(True or False) Indexes are most useful on small, clustered files.
False
(True or False) It is not permissible to associate attributes with relationships.
False
(True or False) Multidimensional OLAP (MOLAP) tools use variations of SQL and view the database as a relational database, in either a star schema or other normalized or denormalized set of tables.
False
(True or False) NoSQL is a great technology for storing well-structured data.
False
(True or False) The development of the relational data model did not contribute to the emergence of data warehousing.
False
(True or False) The query processor always knows the best way to process a query.
False
(True or False) The representation of data in a graphical format is called data mining.
False
Which type of file is easiest to update?
Hashed
Which of the following finds all groups meeting stated conditions?
Having
Which of the following threats involves outside parties using information to embarrass a company?
Loss of confidentiality
In the figure below, which of the following are subtypes of patient? https://blackboard.temple.edu/courses/1/7302015103440/ppg/pearson/tm/mdm11h/f3g1q5g1.jpg
Outpatient
Which of the following is an advantage of stored procedures?
Performance improves for compiled SQL statements.
An iterative methodology that rapidly repeats the analysis, design, and implementation phases of the SDLC is called:
RAD
OLAP tools that use the database as a traditional relational database are called:
ROLAP tools.
In the figure below, what type of key is depicted? https://blackboard.temple.edu/courses/1/7302015103440/ppg/pearson/tm/mdm11h/f4g1q25g1.jpg
Recursive foreign
________ are established between entities in a well-structured database so that the desired information can be retrieved.
Relationships
________ is used to undo unwanted database changes.
Rollback
Which of the following will produce the minimum of all standard prices?
Select min(standard_price) from Product_V;
Which of the following data-mining applications identifies customers for promotional activity?
Target marketing
Which of the following is true of the order in which SQL statements are evaluated?
The SELECT clause is processed before the ORDER BY clause.
(True or False) The role of a data warehouse administrator emphasizes integration and coordination of metadata and data across many data sources.
True
(True or False) The role of database administration is typically a more hands-on, physical involvement with the management of databases.
True
(True or False) Vertical partitioning means distributing the columns of a table into several separate physical records.
True
(True or False) The first requirement for building a user-friendly interface is a set of metadata that describes the data in the data mart in business terms that users can easily understand.
True
(True or False) The goal of database security is the protection of data from accidental or intentional threats to its integrity and access.
True
Which of the following is NOT an area of concern when trying to maintain a well-tuned database?
User interface design
An XML-based grammar used to describe a Web service is called:
Web Service Description Language (WSDL).
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
In an SQL statement, which of the following parts states the conditions for row selection?
Where
The following figure shows an example of: https://blackboard.temple.edu/courses/1/7302015103440/ppg/pearson/tm/mdm11h/f2g1q22g1.jpg
a composite attribute.
A user view is:
a logical description of some portion of the database.
Extensible Markup Language (XML) is:
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: https://blackboard.temple.edu/courses/1/7302015103440/ppg/pearson/tm/mdm11h/f2g1q14g1.jpg
a strong entity and its associated weak entity.
Extensible Business Reporting Language (XBRL) is an example of:
an XML-based vocabulary.
While views promote security by restricting user access to data, they are not adequate security measures because:
an unauthorized person may gain access to a view through experimentation.
An entity type name should be all of the following EXCEPT:
as short as possible.
A person's name, birthday, and social security number are all examples of:
attributes.
Sensitivity testing involves:
checking to see if missing data will greatly impact results.
The phrase ________ refers to a model for providing ubiquitous, convenient and on-demand network access.
cloud computing
A method to allow adjacent secondary memory space to contain rows from several tables is called:
clustering.
The UNION clause is used to:
combine the output from multiple queries into a single result table.
A rule that CANNOT be violated by database users is called a:
constraint.
The value a field will assume unless the user enters an explicit value for an instance of that field is called a(n):
default value.
A ________ is a temporary table used in the FROM clause of an SQL query.
derived table
A primary key whose value is unique across all relations is called a(n):
enterprise key.
Customers, cars, and parts are examples of:
entities.
An index on columns from two or more tables that come from the same domain of values is called a:
join index.
A relationship where the minimum and maximum cardinality are both one is a(n) ________ relationship.
mandatory one
All of the following are the main goals of normalization EXCEPT:
maximize storage space.
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):
outer join.
A method that speeds query processing by running a query at the same time against several partitions of a table using multiprocessors is called:
parallel query processing.
Data that are never physically altered once they are added to the store are called ________ data.
periodic
One of the most popular RAD methods is:
prototyping.
A two-dimensional table of data sometimes is called a:
relation.
An attribute of an entity that must have a value for each entity instance is a(n):
required attribute.
A single value returned from an SQL query that includes an aggregate function is called a(n):
scalar aggregate.
A type of join where a table is joined to itself is called a(n):
self-join.
A workgroup database is stored on a central device called a(n):
server.
An expanded version of a star schema in which all of the tables are fully normalized is called a(n):
snowflake schema.
A module of code that may be written in a proprietary language such as Oracle's PL/SQL that implements business rules on a database server is called a:
stored procedure.
SQL provides the ________ technique, which involves placing an inner query within the WHERE or HAVING clause of an outer query.
subquery
A type of query that is placed within a WHERE or HAVING clause of another query is called a:
subquery.
A fact is an association between two or more:
terms.
A PC configured to handle user interface with little or no local storage is called a:
thin client.
Database access frequencies are estimated from:
transaction volumes.
A relationship between the instances of a single entity type is called a(n) ________ relationship.
unary
Because applications are often developed independently in file processing systems:
unplanned duplicate data files are the rule rather than the exception.
All of the following are objectives when selecting a data type EXCEPT:
use a lot of storage space.
Which of the following is true about three-tier architectures?
More technological flexibility
Which type of file is most efficient with storage space?
Sequential
(True or False) A business rule is a statement that defines or constrains some aspect of the business.
True
(True or False) A cascading delete removes all records in other tables associated with the record to be deleted.
True
(True or False) A referential integrity constraint is a rule that maintains consistency among the rows of two relations.
True
(True or False) A relational database establishes the relationships between entities by means of a common field.
True
(True or False) It is desirable that no two attributes across all entity types have the same name.
True
(True or False) Joining tables or using a subquery may produce the same result.
True
(True or False) PHP is a platform for Web development.
True
(True or False) Rule discovery searches for patterns and correlations in large data sets.
True
(True or False) Sample data are useful for developing prototype applications and for testing queries.
True
(True or False) Security is one advantage of partitioning.
True
(True or False) The storage component of a client/server architecture is responsible for data storage and retrieval from the physical storage devices associated with the application.
True
(True or False) There are applications for fact tables without any nonkey data, only the foreign keys for the associated dimensions.
True
An alternative name for an attribute is called a(n):
alias.
Which of the following advances in information systems contributed to the emergence of data warehousing?
All of these. (Improvements in database technology, particularly the relational data model Advances in computer hardware, especially affordable mass storage and parallel computer architectures Advances in middleware products that enabled enterprise database connectivity across heterogeneous platforms)
Which of the following is a technique for optimizing the internal performance of the relational data model?
Clustering data
(True or False) A business rule is a statement of how a policy is enforced or conducted.
False
(True or False) A database is maintained and queried using the data mapping language (DML).
False
(True or False) A join index is a combination of two or more indexes.
False
(True or False) A member of a subtype does NOT necessarily have to be a member of the supertype.
False
(True or False) A simple attribute can be broken down into smaller pieces.
False
(True or False) A single value returned from an SQL query that includes an aggregate function is called a vector aggregate.
False
(True or False) EXISTS takes a value of false if the subquery returns an intermediate result set.
False
(True or False) Generalization is a top-down process.
False
(True or False) Horizontal partitioning refers to the process of combining several smaller relations into a larger table.
False
(True or False) Loss of data integrity does not impact the quality of data in a database.
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.
Middleware
In the figure below, what type of relationship do the relations depict? https://blackboard.temple.edu/courses/1/7302015103440/ppg/pearson/tm/mdm11h/f4g1q23g1.jpg
One-to-many
The subtype discriminator in the figure below is: https://blackboard.temple.edu/courses/1/7302015103440/ppg/pearson/tm/mdm11h/f3g1q26g1.jpg
Part_Type.
SOAP stands for:
Simple Object Access Protocol Method.
In the figure below, which attribute is multivalued? https://blackboard.temple.edu/courses/1/7302015103440/ppg/pearson/tm/mdm11h/f2g1q23g1.jpg
Skill
Which of the following is a generic entity type that has a relationship with one or more subtypes?
Supertype
(True or False) A client PC that is responsible for presentation logic, application logic, and many DBMS functions is called a fat client.
True
(True or False) A client/server configuration that has three layers (one client and two servers) has a three-tier architecture.
True
(True or False) A correlated subquery is executed once for each iteration through the outer loop.
True
(True or False) A data warehouse contains summarized and historical information.
True
(True or False) Data modeling is about documenting rules and policies of an organization that govern data.
True
(True or False) Data structures include data organized in the form of tables with rows and columns.
True
(True or False) Drill-down involves analyzing a given set of data at a finer level of detail.
True
The preferred method of fixing an aborted transaction is:
backing out the transaction.
A ________ specifies the number of instances of one entity that can be associated with each instance of another entity.
cardinality constraint
A join operation:
causes two tables with a common domain to be combined into a single table or view.
An attribute that can be broken down into smaller parts is called a(n) ________ attribute.
composite
In the SQL language, the ________ statement is used to make table definitions.
create table
Data modeling may be the most important part of the systems development process because:
data characteristics are important in the design of programs and other systems components.
All of the following are some beneficial applications for real-time data warehousing EXCEPT:
data entry.
When we consider data in the data warehouse to be time-variant, we mean:
data in the warehouse contain a time dimension so that they may be used to study trends and changes.
(True or False) The storage format for each attribute from the logical data model is chosen to maximize ________ and minimize storage space.
data integrity
A logical data mart is a(n):
data mart created by a relational view of a slightly denormalized data warehouse.
A graphical system used to capture the nature and relationships among data is called a(n):
data model.
A data mart is a(n):
data warehouse that is limited in scope.
A computer that provides database storage and access in a client/server environment is called a:
database server.
A star schema contains both fact and ________ tables.
dimension
A ________ addresses whether an instance of a supertype may simultaneously be a member of two or more subtypes.
disjointedness constraint
Going from a summary view to progressively lower levels of detail is called data:
drill-down.
Any create command may be reversed by using a ________ command.
drop
An advantage of partitioning is:
efficiency.
The smallest unit of application data recognized by system software is a:
field.
A(n) ________ is a technique for physically arranging the records of a file on secondary storage devices.
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:
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:
grain.
A file organization that uses hashing to map a key into a location in an index where there is a pointer to the actual data record matching the hash key is called a:
hash index table.
A(n) ________ is a routine that converts a primary key value into a relative record number.
hashing algorithm
An attribute that may have more than one meaning is called a(n):
homonym.
Distributing the rows of data into separate files is called:
horizontal partitioning.
One major advantage of the outer join is that:
information is not lost.
The analysis of summarized data to support decision making is called:
informational processing.
An operational data store (ODS) is a(n):
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:
integrity constraints
A dependent data mart:
is filled exclusively from the enterprise data warehouse with reconciled data.
All of the following are limitations of the independent data mart EXCEPT:
it is often more expedient to build a data mart than a data warehouse.
A student can attend five classes, each with a different professor. Each professor has 30 students. The relationship of students to professors is a ________ relationship.
many-to-many
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):
natural join.
The entity integrity rule states that:
no primary key attribute can be null.
Data that describe the properties of other data are:
none of these. (relationships. logical. physical.)
An application programming interface that enables an application program to process RDBMS databases meets the:
open database connectivity standard.
An attribute (or attributes) that uniquely identifies each row in a relation is called a:
primary key.
A Web server:
processes client requests and returns HTML pages to the client.
All of the following are properties of metadata EXCEPT:
processing logic.
An integrity control supported by a DBMS is:
range control.
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.
Relational databases establish the relationships between entities by means of common fields included in a file called a(n):
relation entity.
A centralized knowledge base of all data definitions, data relationships, screen and report formats, and other system components is called a(n):
repository.
The following figure shows a(n): https://blackboard.temple.edu/courses/1/7302015103440/ppg/pearson/tm/mdm11h/f3g1q31g1.jpg
supertype/subtype hierarchy.
Every key used to join the fact table with a dimension table should be a ________ key.
surrogate
A simultaneous relationship among the instances of three entity types is called a(n) ________ relationship.
ternary
All of the following are unique characteristics of a logical data mart EXCEPT:
the process of creating a logical data mart is lengthy.
A(n) ________ is often developed by identifying a form or report that a user needs on a regular basis.
user view
A data warehouse derives its data from:
various operational data sources.
Which of the following is a component of processing logic?
Business rules
In the figure below, the primary key for "Order Line" is which type of key? https://blackboard.temple.edu/courses/1/7302015103440/ppg/pearson/tm/mdm11h/f4g1q10g1.jpg
Composite
The three-schema approach includes which of the following schemas?
Internal
In the following diagram, what type of relationship is depicted? https://blackboard.temple.edu/courses/1/7302015103440/ppg/pearson/tm/mdm11h/f2g1q34g1.jpg
Ternary
(True or False) All values that appear in a column of a relation must be taken from the same domain.
True
(True or False) Along with table scans, other elements of a query can be processed in parallel.
True
The MERGE command:
allows one to combine the INSERT and UPDATE operations.
Data that are detailed, current, and intended to be the single, authoritative source of all decision support applications are called ________ data.
reconciled
Multiple values returned from an SQL query that includes an aggregate function are called:
vector aggregates.
An entity type whose existence depends on another entity type is called a ________ entity.
weak
A relation that contains minimal redundancy and allows easy use is considered to be:
well-structured.
Horizontal partitioning makes sense:
when different categories of a table's rows are processed separately.
Operational and informational systems are generally separated because of which of the following factors?
All of these. (A data warehouse centralizes data that are scattered throughout disparate operational systems and makes them readily available for decision support applications. A properly designed data warehouse adds value to data by improving their quality and consistency. A separate data warehouse eliminates contention for resources that results when informational applications are confounded with operational processing.)
The real-time data warehouse is characterized by which of the following?
All of these. (It accepts near-real time feeds of transaction data. Data are immediately transformed and loaded into the warehouse. It provides near-real-time access for the transaction processing systems to an enterprise data warehouse.)
Which of the following is true of data visualization?
All of these. (It is easier to observe trends and patterns in data. Correlations and clusters in data can be easily identified. It is often used in conjunction with data mining.)
An entity cluster can be formed by:
All of these. (abstracting a supertype and its subtype. combining directly related entity types and their relationships. combining a strong entity and its weak entities.)
When incorrect data have been introduced, the database is best recovered by:
All of these. (backward recovery, if the error has been discovered soon enough. human intervention for only a few errors. restarting from the most recent checkpoint and processing subsequent transactions.)
Conformed dimensions allow users to do the following:
All of these. (share nonkey dimension data. query across fact tables with consistency. work on facts and business subjects for which all users have the same meaning.)
The common types of entities are:
All of these. (strong entities. weak entities. associative entities.)
A method for handling missing data is to:
All of these. (substitute and estimate for the missing data. track missing data with special reports. perform sensitivity testing.)
In the figure below, what is depicted? https://blackboard.temple.edu/courses/1/7302015103440/ppg/pearson/tm/mdm11h/f4g1q24g1.jpg
An associative entity
Which of the following factors drive the need for data warehousing?
Businesses need an integrated view of company information.
(True or False) A catalog is the structure that contains object descriptions created by a user.
False
(True or False) Parallel query processing speed is not significantly different from running queries in a non-parallel mode.
False
(True or False) SOX stands for the Sorbet-Oxford Act.
False
(True or False) SQL has been implemented only in the mainframe and midrange environments.
False
(True or False) The DROP command deletes rows from a table individually or in groups.
False
(True or False) The HAVING clause and the WHERE clause perform the same operation.
False
(True or False) The degree of a relationship is the number of attributes that are associated with it.
False
(True or False) The smallest unit of named application data is a record.
False
(True or False) The term legacy system refers to a newly installed database management system.
False
Which of the following questions is answered by the SQL statement? Select Count (Product_Description) from Product_T;
How many products have product descriptions in the Product Table?
In the figure below, what type of relationship do the relations depict? https://blackboard.temple.edu/courses/1/7302015103440/ppg/pearson/tm/mdm11h/f4g1q22g1.jpg
Strong entity/weak entity
The traditional methodology used to develop, maintain and replace information systems is called the:
Systems Development Life Cycle.
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.
(True or False) A data model is a graphical system used to capture the nature and relationships among data.
True
(True or False) A database table is defined using the data definition language (DDL).
True
(True or False) A fact is an association between two or more terms.
True
(True or False) A join in which the joining condition is based on equality between values in the common column is called a(n) equi-join.
True
(True or False) A major benefit of SQL as a standard is reduced training costs.
True
(True or False) A single occurrence of an entity is called an entity instance.
True
(True or False) A subtype can become a supertype if the subtype has other subtypes beneath it.
True
(True or False) A time stamp is a time value that is associated with a data value.
True
(True or False) A universal data model is a generic or template data model that can be reused as a starting point for a data modeling project.
True
(True or False) A well-structured relation contains minimal redundancy and allows users to manipulate the relation without errors or inconsistencies.
True
(True or False) Although personal databases improve productivity, one risk is that data cannot be shared with other users.
True
(True or False) Web Services are a set of emerging standards that define protocols for automatic communication between software programs over the Web.
True
(True or False) Web services allow for communication between programs over the Internet.
True
(True or False) When a GROUP BY clause is included in an SQL statement, only those columns with a single value for each group can be included.
True
(True or False) When a dimension participates in a hierarchy, the database designer can normalize the dimension into a nested set of tables with 1:M relationships between them.
True
(True or False) When creating tables, it's important to decide which columns will allow null values before the table is created.
True
The promise of Web services is the development of a standardized communication system using:
XML.
In the figure below, which attribute is derived? https://blackboard.temple.edu/courses/1/7302015103440/ppg/pearson/tm/mdm11h/f2g1q24g1.jpg
Years_Employed
Service-oriented architectures (SOA) are:
a collection of services that communicate with each other in some manner.
CASE is a class of tools that:
automates the design of databases and application programs.
A join in which the joining condition is based on equality between values in the common columns is called a(n):
both equi-join and natural join
Factless fact tables may apply when:
both we are tracking events and we are taking inventory of the set of possible occurrences.
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.
completeness
All of the following are ways to handle changing dimensions EXCEPT:
create a snowflake schema.
In most cases, the goal of ________ dominates the design process.
efficient data processing
The coding or scrambling of data so that humans cannot read them is called:
encryption.
The logical representation of an organization's data is called a(n):
entity-relationship model.
A person, place, an object , an event or concept about which the organization wishes to maintain data is called a(n):
entity.
A database action that results from a transaction is called a(n):
event.
A disadvantage of partitioning is:
extra space and update time.
A factor to consider when choosing a file organization is:
All of these. (fast data retrieval. security. efficient storage.)
A requirement to begin designing physical files and databases is:
All of these. (normalized relations. definitions of each attribute. technology descriptions.)
An understanding of how to merge relations is important because:
All of these. (there may be a need to merge relations on projects with subteams. different views may need to be integrated. new data requirements may produce new relations to be merged.)
(True or False) Advances in computer hardware, particularly the emergence of affordable mass storage and parallel computer architectures, was one of the key advances that led to the emergence of data warehousing.
True
(True or False) An SQL query that implements an outer join will return rows that do not have matching values in common columns.
True
(True or False) An audit trail of transactions and database changes is kept by a journalizing facility.
True
(True or False) An enterprise data warehouse that accepts near-real time feeds of transactional data and immediately transforms and loads the appropriate data is called a real-time data warehouse.
True
(True or False) Information is processed data.
True
(True or False) A modern database management system automates more of the backup and recovery tasks than a file system.
True
(True or False) Specialization is the reverse of generalization.
True
A rule of thumb for choosing indexes is to:
All of these. (be careful indexing attributes that may be null. index each primary key of each table. use an index when there is variety in attribute values.)
Which of the following is an objective of derived data?
All of these. (ease of use for decision support systems faster response time for user queries support data mining applications)
(True or False) Transient data are never changed.
False
(True or False) Using an index for attributes referenced in ORDER BY and GROUP BY clauses has no significant impact upon database performance.
False
(True or False) When creating a table, it is not important to consider foreign keyprimary key mates.
False
(True or False) An extranet uses Internet protocols to establish limited access to company data by the company's customers and suppliers.
True
(True or False) 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.
True
(True or False) A physical schema contains the specifications for how data from a conceptual schema are stored in a computer's secondary memory.
True
(True or False) A pointer is a field of data that can be used to locate a related field or record of data.
True
(True or False) Adding the DISTINCT keyword to a query eliminates duplicates.
True
(True or False) 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.
True
(True or False) An event is a database action that results from a transaction.
True
(True or False) An independent data mart is filled with data extracted from the operational environment without the benefit of a data warehouse.
True
(True or False) An operational data store is typically a relational database and normalized, but it is tuned for decision-making applications.
True
(True or False) 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.
True
(True or False) Client/server describes a networked computing model that distributes processes between computers that request services and computers that provide services.
True
(True or False) Clustering allows for adjacent secondary memory locations to contain rows from several tables.
True
(True or False) Cost and complexity are just two of the disadvantages of database processing.
True
(True or False) Fast data retrieval is one factor to consider when choosing a file organization for a particular database file.
True
(True or False) For performance reasons, it may be necessary to define more than one fact table for a star schema.
True
(True or False) In a supertype/subtype hierarchy, attributes are assigned at the highest logical level that is possible in the hierarchy.
True
(True or False) In order to find out what customers have not placed an order for a particular item, one might use the NOT qualifier along with the IN qualifier.
True
(True or False) In some three-tier architectures, most application code is stored on the application server.
True
(True or False) Indexes are most useful for columns that frequently appear in WHERE clauses of SQL commands, either to qualify the rows to select or for linking.
True
(True or False) Keeping the zip code with the city and state in a table is a typical form of denormalization.
True
(True or False) Medical claims and pharmaceutical data would be an example of big data.
True
(True or False) ODBC is an application programming interface that provides a common language for application programs to access and process an SQL database independent of the particular RDBMS that is accessed.
True
(True or False) One objective of selecting a data type is to minimize storage space.
True
(True or False) 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
(True or False) Requirements for response time, data security, backup and recovery are all requirements for physical design.
True
(True or False) The ALTER TABLE command is used to change a table definition.
True
(True or False) 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.
True
(True or False) The first line of defense for authentication is the use of passwords, which is a one-factor authentication scheme.
True
(True or False) The need for data warehousing in an organization is driven by its need for an integrated view of high-quality data.
True
(True or False) The presentation logic component of a client/server system is responsible for formatting and presenting data on the user's screen.
True
