Brainscape's Knowledge GenomeTM


Top Flashcards (Certified)
All Flashcards

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
Independent data marts do not generally lead to redundant data and efforts.
F
26
An enterprise data warehouse is the control point and single source of all data made available to end users for decision support applications.
T
27
A distributed database is not just a collection of files.
T
28
Distributed databases make data sharing more difficult because of the data communication problems.
F
29
Distributed databases do not easily satisfy both transaction and analytical processing systems.
F
30
In a homogeneous environment, the same DBMS is used at each location.
T
31
In a heterogeneous environment, not all users use the same DBMS.
T
32
Users of distributed database systems always need to know the location of the data.
F
33
Local autonomy means that data are not accessible from remote sites.
F
34
With an asynchronous distributed database, all data across the network is continuously kept up to date.
F
35
A distributed database may require more costly and complex software than a centralized database.
T
36
Replicated databases usually result in tightly coupled nodes.
F
37
Replication is often used for noncollaborative data.
T
38
Replication should NOT be used if timely updates are important.
T
39
Applications such as decision support or data warehousing often do not require current data and are supported by periodic snapshots.
T
40
Shared ownership of data is most appropriate as business activities move across time zones.
F
41
One way to generate messages for near-real-time replication is through the use of database triggers.
T
42
Applications that can tolerate out-of-date data are not the best candidates for data replication.
F
43
Horizontal partitioning offers increased efficiency because data are close to use areas.
T
44
An object encapsulates both data and behavior.
T
45
A state represents how an object acts.
F
46
An object class is a set of objects that share a common structure and behavior
T
47
A class diagram shows the dynamic structure of an object-oriented model.
F
48
An operation is a function or service that is provided by all of the classes.
T
49
Encapsulation is the technique of hiding the internal implementation details of an object from its external view.
T
50
A constructor operation does not alter an instance of a class.
F
51
A class-scope operation applies to a class rather than an object instance.
T
52
An association role is the end of an association where it connects to a class.
T
53
Storing the state of an object between application execution sessions is called providing obfuscation to the object.
F
54
Serialization is a built-in mechanism for storing a persistent state of an object in object-oriented languages.
T
55
Serialization is not a realistic method for storing large amounts of structured data.
T
56
Serialization’s performance is scalable and provides sufficient response time.
F
57
The difference between the object-oriented world and the relational world is called integrity-object mismatch.
F
58
Object-relational mapping defines structural relationships between object-oriented and relational representations of data.
T
59
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
60
The identity of the core elements (objects/entity instances) is dealt with differently in the object-oriented and relational worlds.
T
61
In the relational world, each object has its own identity based upon its existence.
F
62
Object-oriented environments and relational environments have the same navigational model for accessing persistent data.
F
63
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
64
The PHP Extension and Application Representation (PEAR) is a committee that oversees the open source PHP code.
T
65
One of the most popular PEAR code modules is PEAR DB, which simplifies access between PHP and a database server.
T
66
The mysqli package is the object-oriented equivalent of the mysql package.
T
67
The mysql_connect() function returns a 1 if it connects to the database successfully or 0 if it doesn’t.
F
68
The mysql_close() function is used to explicitly close a database connection.
T
69
The mysql_error() function returns a value of FALSE if it detects an error.
F
70
You can suppress error message by using the error control operator (%).
F
71
The error control operator disables error checking.
T
72
You can use the mysql_select_db() function to select a database or change to a different database.
T
73
The mysql_delete_db("dbname"[, connection]); script is used to delete a database.
T
74
PHP, you use the mysql_send() function to send SQL statements to MySQL.
F
75
A list of records that are returned from a query is called a resultset.
T
76
The query pointer is a way of keeping track of where you are in a resultset.
T
77
To prevent code from trying to create a table that already exists, use the SHOW EXISTING TABLES command.
F
78
The PRIMARY KEY keywords are used to generate a unique id for each new row in a table.
T
79
The NOT NULL keywords are often used with primary keys to require that a field include a value.
T
80
When you add records to a table that includes an AUTO_INCREMENT field, you omit the column name and value from the lists.
T
81
The first record added to a table that has an auto-incrementing primary key will be assigned a value of 0.
F
82
To update records in a table, use the UPDATE, SET, and WHERE keywords with the mysql_query() function.
T
83
To delete records in a table, use the DELETE and WHERE keywords with the mysql_query() function.
T
84
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
85
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
86
You pass the mysql_affected_rows() function the variable containing the result pointer from the mysql_query() function.
T
87
The mysql_info() function returns the number of operations for various types of actions, depending on the type of query.
T
88
The mysql_info() function also returns information for LOAD DATA queries.
T
89
The mysql_query() function returns a result pointer that represents the query results when the SELECT or SHOW statement which returns a resultset.
T
90
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
91
The mysql_fetch_assoc() function returns the fields into an associative array and uses each row name as the array key.
T
92
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
93
Maintaining state refers to storing persistent data about a Web site visit using hidden form,query strings, cookies and sessions.
T
94
A hidden form field is not displayed by the browser.
T
95
You can use a query string to pass information from one Web page to another.
T
96
Cookies were originally created for use with CGI scripts.
T
97
Each individual server or domain can store between 20 and 70 cookies on a user’s computer.
T
98
Users can choose whether to accept cookies that a script attempts to write to their system.
T
99
By default, cookies cannot contain semicolons.
T
100
You do not need to delete persistent cookies because they automatically cease to exist when the current browser session ends.
F
101
The session_start() function does not accept any arguments.
T
102
Session state information is stored in the $_SESSION autoglobal.
T

Database (6 decks)

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