CS431 - Final Review (T/F)

Réussis tes devoirs et examens dès maintenant avec Quizwiz!

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


Ensembles d'études connexes

AP Stat: Chapter 12: Warm Ups 5 and 6

View Set

ATI Custom: Unit 2 Practice Quiz

View Set

BUS 110 Chapter 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13

View Set

KHP415 Final Exam Quizzes 6-12 (Fan Gao)

View Set