Question 1

If the client only performs the presentation functions (and not the business functions),then the client is known as a thin client.

Accepted Answer

This is because a thin client only performs the display and presentation functions, while the actual business processing and data storage is handled by the server.

Question 2

A distributed database is a single logical database that is physically divided among computers at several sites on a network.

Accepted Answer

A distributed database is indeed a single logical database that is physically divided among computers at several sites on a network.

Question 3

In a DDBMS,the site where the user is located is called the local site.

Accepted Answer

In a distributed database management system (DDBMS), the user's location is referred to as the local site.

Question 4

Access to a data warehouse is accomplished through the use of OLAP software.

Accepted Answer

OLAP software is commonly used to access data in a data warehouse. OLAP (online analytical processing) allows users to analyze data from multiple perspectives and dimensions, which is especially useful in large data sets.

Question 5

In objected-oriented DBMSs,the term class refers to the general structure of an object.

Accepted Answer

The term class in object-oriented DBMSs refers to the general structure or blueprint of an object. It defines the attributes and methods that an object of that particular class can have. Objects are instances of classes, created by assigning values to the attributes defined in the class.

Question 6

On a client/server network,the server is a computer that provides data to the clients.

Accepted Answer

This is correct. The server is the central computer in a client/server network that provides resources such as data and applications to the clients connected to the network.

Question 7

A local deadlock involves one transaction that requires a record held by a second transaction at one site,while the second transaction requires a record held by the first transaction at a different site.

Accepted Answer

A local deadlock involves transactions competing for resources within the same site, not across different sites. The scenario described is more accurately termed a distributed deadlock.

Question 8

Extensible Markup Language (XML) is a metalanguage.

Accepted Answer

XML is a metalanguage, which means it is a language used to define other languages. It provides a standard set of rules for creating markup languages, such as XHTML and RSS, that can be used for data exchange and storage.

Question 9

In the URL,http://www.irs.gov/individuals/index.html,the location path on the Web server is individuals.

Accepted Answer

The location path on the Web server is "individuals" in the given URL.

Question 10

In objected-oriented DBMSs,the actions defined for a class are known as macros.

Accepted Answer

The actions defined for a class in object-oriented DBMSs are known as methods or member functions, not macros. Macros are typically used in procedural programming languages.

Question 11

Access delay refers to the fixed amount of time that is required for every message.

Accepted Answer

Access delay is a fixed delay that occurs in every message transmission due to the nature of the technology used, such as the time required for data to travel through a physical medium.

Question 12

In order to view and analyze higher levels of aggregate data,you must drill down the data.

Accepted Answer

The answer of In order to view and analyze higher...

Question 13

A file server stores the files required by the users on a network.

Accepted Answer

A file server is a computer that stores and manages files for multiple users on a network. Users can access these files by connecting to the file server.

Question 14

A global deadlock occurs at a single site in a distributed database.

Accepted Answer

A global deadlock involves multiple nodes in a distributed database, not just a single site.

Question 15

The server is also known as a front-end processor or front-end machine.

Accepted Answer

The answer of The server is also known as a...

Question 16

When relational databases store complex objects,these special data types are known as CLOBs.

Accepted Answer

CLOB stands for Character Large Object, which is used to store large text data, not complex objects. Complex objects are typically stored using other data types or structures.

Question 17

One approach you can use to model all the various aspects of software development for object-oriented systems is known as UML.

Accepted Answer

UML (Unified Modeling Language) is a widely used approach for modeling various aspects of software development for object-oriented systems. It is used to depict the design and architecture of software systems and has a set of graphical notations that are well-defined and standardized. UML diagrams include use case diagrams, class diagrams, sequence diagrams, state machine diagrams, activity diagrams, and more.

Question 18

Accessing data using messages over a network takes approximately the same amount of time as accessing data on a disk.

Accepted Answer

Accessing data over a network involves multiple layers of communication protocols, routing, and potential congestion. This adds significant overhead and can result in longer access times compared to accessing data on a local disk.

Question 19

A characteristic of a DDBMS that states that users do not need to be aware of the location of the data in a database is known as replication transparency.

Accepted Answer

The characteristic described is known as location transparency, not replication transparency. Location transparency allows users to access data without knowing its physical location, while replication transparency deals with the handling of data copies in the system without user awareness.

Question 20

If users are unaware of fragmentation,the DDBMS has fragmentation transparency.

Accepted Answer

If the DDBMS has fragmentation transparency, the users are not required to be aware of the fragmentation. The system automatically handles fragmentation and presents a unified view to the users.

Quiz 9: Database Management Approaches