Brainscape's Knowledge GenomeTM

Browse over 1 million classes created by top students, professors, publishers, and experts.


See full index

Database > Final Exam - True/False > Flashcards

Final Exam - True/False Flashcards

1
Q

Client/server describes a networked computing model that distributes processes between computers that request services and computers that provide services.

A

T

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
2
Q

The presentation logic component of a client/server system is responsible for formatting and presenting data on the user’s screen.

A

T

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
3
Q

Business rules logic includes such activities as data validation and identification of processing errors.

A

F

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
4
Q

The storage component of a client/server architecture is responsible for data storage and retrieval from the physical storage devices associated with the application.

A

T

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
5
Q

A fat client does most of its processing on the server.

A

F

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
6
Q

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.

A

T

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
7
Q

When developing an application, one must decide where it will be placed when it is developed.

A

F

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
8
Q

An API is a set of routines that a database server uses to access database objects.

A

F

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
9
Q

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.

A

T

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
10
Q

In some three-tier architectures, most application code is stored on the application server.

A

T

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
11
Q

Java servlets execute from within another program and reside on the server.

A

T

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
12
Q

PHP is a platform for Web development.

A

T

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
13
Q

Two-tier architectures are much more scalable than three-tier architectures.

A

F

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
14
Q

Three-tier architectures generally result in higher long-term costs.

A

F

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
15
Q

Cloud computing will have a limited impact on three-tier applications.

A

F

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
16
Q

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.

A

T

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
17
Q

The development of the relational data model did not contribute to the emergence of data warehousing.

A

F

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
18
Q

The need for data warehousing in an organization is driven by its need for an integrated view of high-quality data.

A

T

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
19
Q

When multiple systems in an organization are synchronized, the need for data warehousing increases.

A

F

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
20
Q

Informational systems are designed to support decision making based on historical point-in-time and prediction data.

A

T

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
21
Q

A separate data warehouse causes more contention for resources in an organization.

A

T

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
22
Q

An independent data mart is filled with data extracted from the operational environment without the benefit of a data warehouse.

A

T

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
23
Q

A data mart is a data warehouse that contains data that can be used across the entire organization.

A

T

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
24
Q

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.

A

T

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
25
Q

Independent data marts do not generally lead to redundant data and efforts.

A

F

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
26
Q

An enterprise data warehouse is the control point and single source of all data made available to end users for decision support applications.

A

T

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
27
Q

A distributed database is not just a collection of files.

A

T

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
28
Q

Distributed databases make data sharing more difficult because of the data communication problems.

A

F

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
29
Q

Distributed databases do not easily satisfy both transaction and analytical processing systems.

A

F

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
30
Q

In a homogeneous environment, the same DBMS is used at each location.

A

T

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
31
Q

In a heterogeneous environment, not all users use the same DBMS.

A

T

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
32
Q

Users of distributed database systems always need to know the location of the data.

A

F

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
33
Q

Local autonomy means that data are not accessible from remote sites.

A

F

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
34
Q

With an asynchronous distributed database, all data across the network is continuously kept up to date.

A

F

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
35
Q

A distributed database may require more costly and complex software than a centralized database.

A

T

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
36
Q

Replicated databases usually result in tightly coupled nodes.

A

F

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
37
Q

Replication is often used for noncollaborative data.

A

T

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
38
Q

Replication should NOT be used if timely updates are important.

A

T

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
39
Q

Applications such as decision support or data warehousing often do not require current data and are supported by periodic snapshots.

A

T

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
40
Q

Shared ownership of data is most appropriate as business activities move across time zones.

A

F

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
41
Q

One way to generate messages for near-real-time replication is through the use of database triggers.

A

T

42
Q

Applications that can tolerate out-of-date data are not the best candidates for data replication.

A

F

43
Q

Horizontal partitioning offers increased efficiency because data are close to use areas.

A

T

44
Q

An object encapsulates both data and behavior.

A

T

45
Q

A state represents how an object acts.

A

F

46
Q

An object class is a set of objects that share a common structure and behavior

A

T

47
Q

A class diagram shows the dynamic structure of an object-oriented model.

A

F

48
Q

An operation is a function or service that is provided by all of the classes.

A

T

49
Q

Encapsulation is the technique of hiding the internal implementation details of an object from its external view.

A

T

50
Q

A constructor operation does not alter an instance of a class.

A

F

51
Q

A class-scope operation applies to a class rather than an object instance.

A

T

52
Q

An association role is the end of an association where it connects to a class.

A

T

53
Q

Storing the state of an object between application execution sessions is called providing obfuscation to the object.

A

F

54
Q

Serialization is a built-in mechanism for storing a persistent state of an object in object-oriented languages.

A

T

55
Q

Serialization is not a realistic method for storing large amounts of structured data.

A

T

56
Q

Serialization’s performance is scalable and provides sufficient response time.

A

F

57
Q

The difference between the object-oriented world and the relational world is called integrity-object mismatch.

A

F

58
Q

Object-relational mapping defines structural relationships between object-oriented and relational representations of data.

A

T

59
Q

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.

A

F

60
Q

The identity of the core elements (objects/entity instances) is dealt with differently in the object-oriented and relational worlds.

A

T

61
Q

In the relational world, each object has its own identity based upon its existence.

A

F

62
Q

Object-oriented environments and relational environments have the same navigational model for accessing persistent data.

A

F

63
Q

In the object-oriented world, a typical way to access a data item is to call the accessor method associated with a specific attribute.

A

F

64
Q

The PHP Extension and Application Representation (PEAR) is a committee that oversees the open source PHP code.

A

T

65
Q

One of the most popular PEAR code modules is PEAR DB, which simplifies access between PHP and a database server.

A

T

66
Q

The mysqli package is the object-oriented equivalent of the mysql package.

A

T

67
Q

The mysql_connect() function returns a 1 if it connects to the database successfully or 0 if it doesn’t.

A

F

68
Q

The mysql_close() function is used to explicitly close a database connection.

A

T

69
Q

The mysql_error() function returns a value of FALSE if it detects an error.

A

F

70
Q

You can suppress error message by using the error control operator (%).

A

F

71
Q

The error control operator disables error checking.

A

T

72
Q

You can use the mysql_select_db() function to select a database or change to a different database.

A

T

73
Q

The mysql_delete_db(“dbname”[, connection]); script is used to delete a database.

A

T

74
Q

PHP, you use the mysql_send() function to send SQL statements to MySQL.

A

F

75
Q

A list of records that are returned from a query is called a resultset.

A

T

76
Q

The query pointer is a way of keeping track of where you are in a resultset.

A

T

77
Q

To prevent code from trying to create a table that already exists, use the SHOW EXISTING TABLES command.

A

F

78
Q

The PRIMARY KEY keywords are used to generate a unique id for each new row in a table.

A

T

79
Q

The NOT NULL keywords are often used with primary keys to require that a field include a value.

A

T

80
Q

When you add records to a table that includes an AUTO_INCREMENT field, you omit the column name and value from the lists.

A

T

81
Q

The first record added to a table that has an auto-incrementing primary key will be assigned a value of 0.

A

F

82
Q

To update records in a table, use the UPDATE, SET, and WHERE keywords with the mysql_query() function.

A

T

83
Q

To delete records in a table, use the DELETE and WHERE keywords with the mysql_query() function.

A

T

84
Q

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.

A

T

85
Q

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.

A

F

86
Q

You pass the mysql_affected_rows() function the variable containing the result pointer from the mysql_query() function.

A

T

87
Q

The mysql_info() function returns the number of operations for various types of actions, depending on the type of query.

A

T

88
Q

The mysql_info() function also returns information for LOAD DATA queries.

A

T

89
Q

The mysql_query() function returns a result pointer that represents the query results when the SELECT or SHOW statement which returns a resultset.

A

T

90
Q

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.

A

T

91
Q

The mysql_fetch_assoc() function returns the fields into an associative array and uses each row name as the array key.

A

T

92
Q

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.

A

T

93
Q

Maintaining state refers to storing persistent data about a Web site visit using hidden form,query strings, cookies and sessions.

A

T

94
Q

A hidden form field is not displayed by the browser.

A

T

95
Q

You can use a query string to pass information from one Web page to another.

A

T

96
Q

Cookies were originally created for use with CGI scripts.

A

T

97
Q

Each individual server or domain can store between 20 and 70 cookies on a user’s computer.

A

T

98
Q

Users can choose whether to accept cookies that a script attempts to write to their system.

A

T

99
Q

By default, cookies cannot contain semicolons.

A

T

100
Q

You do not need to delete persistent cookies because they automatically cease to exist when the current browser session ends.

A

F

101
Q

The session_start() function does not accept any arguments.

A

T

102
Q

Session state information is stored in the $_SESSION autoglobal.

A

T

Database (6 decks)

Brainscape helps you reach your goals faster, through stronger study habits.
© 2024 Bold Learning Solutions. Terms and Conditions