Final Exam - True/False Flashcards
Client/server describes a networked computing model that distributes processes between computers that request services and computers that provide services.
T
The presentation logic component of a client/server system is responsible for formatting and presenting data on the user’s screen.
T
Business rules logic includes such activities as data validation and identification of processing errors.
F
The storage component of a client/server architecture is responsible for data storage and retrieval from the physical storage devices associated with the application.
T
A fat client does most of its processing on the server.
F
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
When developing an application, one must decide where it will be placed when it is developed.
F
An API is a set of routines that a database server uses to access database objects.
F
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.
T
In some three-tier architectures, most application code is stored on the application server.
T
Java servlets execute from within another program and reside on the server.
T
PHP is a platform for Web development.
T
Two-tier architectures are much more scalable than three-tier architectures.
F
Three-tier architectures generally result in higher long-term costs.
F
Cloud computing will have a limited impact on three-tier applications.
F
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.
T
The development of the relational data model did not contribute to the emergence of data warehousing.
F
The need for data warehousing in an organization is driven by its need for an integrated view of high-quality data.
T
When multiple systems in an organization are synchronized, the need for data warehousing increases.
F
Informational systems are designed to support decision making based on historical point-in-time and prediction data.
T
A separate data warehouse causes more contention for resources in an organization.
T
An independent data mart is filled with data extracted from the operational environment without the benefit of a data warehouse.
T
A data mart is a data warehouse that contains data that can be used across the entire organization.
T
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
Independent data marts do not generally lead to redundant data and efforts.
F
An enterprise data warehouse is the control point and single source of all data made available to end users for decision support applications.
T
A distributed database is not just a collection of files.
T
Distributed databases make data sharing more difficult because of the data communication problems.
F
Distributed databases do not easily satisfy both transaction and analytical processing systems.
F
In a homogeneous environment, the same DBMS is used at each location.
T
In a heterogeneous environment, not all users use the same DBMS.
T
Users of distributed database systems always need to know the location of the data.
F
Local autonomy means that data are not accessible from remote sites.
F
With an asynchronous distributed database, all data across the network is continuously kept up to date.
F
A distributed database may require more costly and complex software than a centralized database.
T
Replicated databases usually result in tightly coupled nodes.
F
Replication is often used for noncollaborative data.
T
Replication should NOT be used if timely updates are important.
T
Applications such as decision support or data warehousing often do not require current data and are supported by periodic snapshots.
T
Shared ownership of data is most appropriate as business activities move across time zones.
F
One way to generate messages for near-real-time replication is through the use of database triggers.
T
Applications that can tolerate out-of-date data are not the best candidates for data replication.
F
Horizontal partitioning offers increased efficiency because data are close to use areas.
T
An object encapsulates both data and behavior.
T
A state represents how an object acts.
F
An object class is a set of objects that share a common structure and behavior
T
A class diagram shows the dynamic structure of an object-oriented model.
F
An operation is a function or service that is provided by all of the classes.
T
Encapsulation is the technique of hiding the internal implementation details of an object from its external view.
T
A constructor operation does not alter an instance of a class.
F
A class-scope operation applies to a class rather than an object instance.
T
An association role is the end of an association where it connects to a class.
T
Storing the state of an object between application execution sessions is called providing obfuscation to the object.
F
Serialization is a built-in mechanism for storing a persistent state of an object in object-oriented languages.
T
Serialization is not a realistic method for storing large amounts of structured data.
T
Serialization’s performance is scalable and provides sufficient response time.
F
The difference between the object-oriented world and the relational world is called integrity-object mismatch.
F
Object-relational mapping defines structural relationships between object-oriented and relational representations of data.
T
The conceptual gap between the object-oriented approach to application design and the relational model for database design and implementation is often labeled as a perfect match.
F
The identity of the core elements (objects/entity instances) is dealt with differently in the object-oriented and relational worlds.
T
In the relational world, each object has its own identity based upon its existence.
F
Object-oriented environments and relational environments have the same navigational model for accessing persistent data.
F
In the object-oriented world, a typical way to access a data item is to call the accessor method associated with a specific attribute.
F
The PHP Extension and Application Representation (PEAR) is a committee that oversees the open source PHP code.
T
One of the most popular PEAR code modules is PEAR DB, which simplifies access between PHP and a database server.
T
The mysqli package is the object-oriented equivalent of the mysql package.
T
The mysql_connect() function returns a 1 if it connects to the database successfully or 0 if it doesn’t.
F
The mysql_close() function is used to explicitly close a database connection.
T
The mysql_error() function returns a value of FALSE if it detects an error.
F
You can suppress error message by using the error control operator (%).
F
The error control operator disables error checking.
T
You can use the mysql_select_db() function to select a database or change to a different database.
T
The mysql_delete_db(“dbname”[, connection]); script is used to delete a database.
T
PHP, you use the mysql_send() function to send SQL statements to MySQL.
F
A list of records that are returned from a query is called a resultset.
T
The query pointer is a way of keeping track of where you are in a resultset.
T
To prevent code from trying to create a table that already exists, use the SHOW EXISTING TABLES command.
F
The PRIMARY KEY keywords are used to generate a unique id for each new row in a table.
T
The NOT NULL keywords are often used with primary keys to require that a field include a value.
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
The first record added to a table that has an auto-incrementing primary key will be assigned a value of 0.
F
To update records in a table, use the UPDATE, SET, and WHERE keywords with the mysql_query() function.
T
To delete records in a table, use the DELETE and WHERE keywords with the mysql_query() function.
T
With queries that return results, such as SELECT queries, you can use the mysql_num_rows() function to find the number of records returned from a query.
T
With queries that modify tables, but do not return results, such as INSERT, UPDATE, and DELETE queries, you use the mysql_modified_rows() function to determine the number of changed rows.
F
You pass the mysql_affected_rows() function the variable containing the result pointer from the mysql_query() function.
T
The mysql_info() function returns the number of operations for various types of actions, depending on the type of query.
T
The mysql_info() function also returns information for LOAD DATA queries.
T
The mysql_query() function returns a result pointer that represents the query results when the SELECT or SHOW statement which returns a resultset.
T
The mysql_fetch_row() function returns the fields in the current row of a resultset into an indexed array and moves the result pointer to the next row.
T
The mysql_fetch_assoc() function returns the fields into an associative array and uses each row name as the array key.
T
When you are finished working with query results retrieved with the mysql_query() function, you should use the mysql_free_resultset() function to close the resultset.
T
Maintaining state refers to storing persistent data about a Web site visit using hidden form,query strings, cookies and sessions.
T
A hidden form field is not displayed by the browser.
T
You can use a query string to pass information from one Web page to another.
T
Cookies were originally created for use with CGI scripts.
T
Each individual server or domain can store between 20 and 70 cookies on a user’s computer.
T
Users can choose whether to accept cookies that a script attempts to write to their system.
T
By default, cookies cannot contain semicolons.
T
You do not need to delete persistent cookies because they automatically cease to exist when the current browser session ends.
F
The session_start() function does not accept any arguments.
T
Session state information is stored in the $_SESSION autoglobal.
T