CS431 - Final Review (T/F)
39) Users of distributed database systems always need to know the location of the data
F
46) Data which arrive via XML and B2B channels is always guaranteed to be accurate
F
47) Adding notations to the EER diagram regarding data volumes and usage is of no value to the physical design process
F
58) EXISTS takes a value of false if the subquery returns an intermediate result set
F
1) Infrastructure-as-a-Service refers to the use of technologies such as servers, storage and networks from external service providers
F
33) A state represents how an object acts
F
35) A class diagram shows the dynamic structure of an object-oriented model
F
36) Distributed databases do not easily satisfy both transaction and analytical processing systems
F
38) A constructor operation does not alter an instance of a class
F
39) A data governance committee is always made up of high-ranking government officials
F
40) Dirty data saves work for information systems projects
F
40) Local autonomy means that data are not accessible from remote sites
F
41) Databases are generally the property of a single department within an organization
F
41) Each role has a duplicity, which indicates how many objects participate in a given relationship
F
41) With an asynchronous distributed database, all data across the network is continuously kept up to date
F
42) Quality data does not have to be unique
F
43) A ternary relationship can easily be replaced by three binary relationships
F
43) Replicated databases usually result in tightly coupled nodes
F
43) Specifications for transactions do not need to be reviewed quickly
F
44) An association class is an association that participates in no relationships
F
44) Retention refers to the amount of data that is not purged periodically from tables
F
44) SQL has been implemented only in the mainframe and midrange environments
F
44) The logical database design always forms the best foundation for grouping attributes in the physical design
F
44) When multiple systems in an organization are synchronized, the need for data warehousing increases
F
45) Generally, records in a customer file never become obsolete
F
45) Open-source software always comes with complete documentation
F
46) A separate data warehouse causes more contention for resources in an organization
F
46) SOX stands for the Sorbet-Oxford Act
F
47) Loss of data integrity does not impact the quality of data in a database
F
47) Shared ownership of data is most appropriate as business activities move across time zones
F
48) A data mart is a data warehouse that contains data that can be used across the entire organization
F
48) Implementation of a standard can never stifle creativity and innovation
F
48) The smallest unit of named application data is a record
F
49) A data stewardship program does not help to involve the organization in data quality
F
49) A domain is a way to create a structure that acts like a table
F
49) Applications that can tolerate out-of-date data are not the best candidates for data replication
F
50) A catalog is the structure that contains object descriptions created by a user
F
50) A default value is the value that a field will always assume, regardless of what the user enters for an instance of that field
F
50) Independent data marts do not generally lead to redundant data and efforts
F
50) Total quality management (TQM) focuses on defect correction rather than defect prevention
F
52) DCL is used to update the database with new records
F
52) One method to handle missing values is to substitute an exact value
F
53) An operational data store (ODS) is not designed for use by operational users
F
54) Denormalization is the process of transforming relations with variable-length fields into those with fixed-length fields
F
57) Horizontal partitioning refers to the process of combining several smaller relations into a larger table
F
58) Horizontal partitioning is very different from creating a supertype/subtype relationship
F
60) A subquery in which processing the inner query depends on data from the outer query is called a codependent query
F
79) Java programs similar to applets that execute on the server are called hamlets
F
83) A(n) HTTP Schema Definition is a language used for defining XML databases
F
84) A DTD is a language used for defining XML databases
F
87) A language used to transform complex XML documents and also used to create HTML pages from XML documents is called Extensible Stylesheet Transformation
F
89) WXDL is an XML-based grammar
F
91) Customer-oriented architectures are a collection of services that communicate with each other in some manner
F
A common use of Web pages is to gather information that is stored in a database on a client PC
F
MySQL is a commercial product and is not free
F
PHP, you use the mysql_send() function to send SQL statements to MySQL
F
The PHP Extension and Application Representation (PEAR) is a committee that oversees the open source PHP code
F
The PRIMARY KEY keywords are used to generate a unique id for each new row in a table
F
The error control operator disables error checking
F
The mysql_connect() function returns a 1 if it connects to the database successfully or 0 if it doesn't
F
The mysql_delete_db("dbname"[, connection]); script is used to delete a database
F
The mysql_error() function returns a value of FALSE if it detects an error
F
The query pointer is a way of keeping track of where you are in a resultset
F
To prevent code from trying to create a table that already exists, use the SHOW EXISTING TABLES command
F
You can suppress error message by using the error control operator (%)
F
40) An association role is the end of an association where it connects to a class
T
42) The role of database administration is typically a more hands-on, physical involvement with the management of databases
T
45) Replication should NOT be used if timely updates are important
T
48) A view can be built to present only the data to which a user requires access
T
32) An object encapsulates both data and behavior
T
34) An object class is a set of objects that share a common structure and behavior
T
36) An operation is a function or service that is provided by all of the classes
T
37) Encapsulation is the technique of hiding the internal implementation details of an object from its external view
T
37) In a homogeneous environment, the same DBMS is used at each location
T
38) In a heterogeneous environment, not all users use the same DBMS
T
39) A class-scope operation applies to a class rather than an object instance
T
40) The data administrator takes responsibility for the overall management of data resources
T
41) Data quality is essential for SOX and Basel II compliance
T
42) A distributed database may require more costly and complex software than a centralized database
T
42) Requirements for response time, data security, backup and recovery are all requirements for physical design
T
42) The most common multiplicities are 0..1, *, and 1
T
43) Completeness means that all data that are needed are present
T
43) One decision in the physical design process is selecting structures
T
43) SQL is both an American and international standard for database access
T
43) The need for data warehousing in an organization is driven by its need for an integrated view of high-quality data
T
44) Replication is often used for noncollaborative data
T
44) The role of a data warehouse administrator emphasizes integration and coordination of metadata and data across many data sources
T
45) An association class is similar to an associative entity in the E-R model
T
45) Efficient database structures will be beneficial only if queries and the underlying database management system are tuned to properly use the structures
T
46) Applications such as decision support or data warehousing often do not require current data and are supported by periodic snapshots
T
46) 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
T
46) The goal of database security is the protection of data from accidental or intentional threats to its integrity and access
T
47) A major benefit of SQL as a standard is reduced training costs
T
47) An independent data mart is filled with data extracted from the operational environment without the benefit of a data warehouse
T
47) The uncontrolled proliferation of spreadsheets, databases and repositories leads to data quality problems
T
48) A data quality audit helps an organization understand the extent and nature of data quality problems
T
48) One way to generate messages for near-real-time replication is through the use of database triggers
T
49) Applications can be moved from one machine to another when each machine uses SQL
T
49) One objective of selecting a data type is to minimize storage space
T
49) Organizations adopt data mart architectures because it is easier to have separate, small data warehouses than to get all organizational parties to agree to one view of the organization in a central data warehouse
T
50) A trigger can be used for security purposes to prohibit inappropriate actions, such as changing a salary value outside of a business day
T
50) Horizontal partitioning offers increased efficiency because data are close to use areas
T
51) A range control limits the set of permissible values that a field may assume
T
51) An enterprise data warehouse is the control point and single source of all data made available to end users for decision support applications
T
51) Authorization rules are controls incorporated in the data management system that restrict access to data and also restrict the actions that people may take when they access the data
T
51) Some DBMS can handle graphic data types as well as text and numbers
T
52) A dependent data mart is filled from the enterprise data warehouse and its reconciled data
T
53) Sensitivity testing involves ignoring missing data unless knowing a value might significantly change results
T
55) Keeping the zip code with the city and state in a table is a typical form of denormalization
T
56) Denormalization almost always leads to more storage space for raw data
T
57) 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
T
59) When EXISTS or NOT EXISTS is used in a subquery, the select list of the subquery will usually just select all columns as a placeholder because it doesn't matter which columns are returned
T
6) 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
62) A correlated subquery is executed once for each iteration through the outer loop
T
78) Application Programming Interfaces are more efficient than CGI scripts and are implemented as shared code or dynamic link libraries
T
86) XQuery is an XML transformation language for querying relational data as well as XML databases
T
88) Web Services are a set of emerging standards that define protocols for automatic communication between software programs over the Web
T
90) Simple Object Access Protocol (SOAP) is an XML-Based communication protocol
T
A list of records that are returned from a query is called a resultset
T
Any information that can be organized into ordered collection of data can be considered a database
T
Each row in a database is called a record
T
For simple collections of information, flat-file databases are usually adequate
T
How you enable MySQL support in PHP depends on the version of PHP and how you installed MySQL
T
MySQL Monitor is a command-line program for manipulating MySQL databases
T
One of the most popular PEAR code modules is PEAR DB, which simplifies access between PHP and a database server
T
Primary and foreign keys link records across multiple tables in a relational database
T
Relational databases are preferred solutions for large and complex collections of information
T
The NOT NULL keywords are often used with primary keys to require that a field include a value
T
The first record added to a table that has an auto-incrementing primary key will be assigned a value of 0
T
The mysql_close() function is used to explicitly close a database connection
T
The mysqli package is the object-oriented equivalent of the mysql package
T
To update records in a table, use the UPDATE, SET, and WHERE keywords with the mysql_query() function
T
When accessing databases with PHP, you must use a data manipulation language
T
When you add records to a table that includes an AUTO_INCREMENT field, you omit the column name and value from the lists
T
You can use the mysql_select_db() function to select a database or change to a different database
T
You know you have successfully logged into MySQL when you see the mysql> prompt
T