1033 + Mcqs in Database Page 12 McqOptions

551.	An increasingly popular option for data distribution as well as for fault tolerance of any database is to store a separate copy of the database at each of two or more sites.
A.	True
B.	False
Answer» B. False

Discussion

552.	Asynchronous technology can result in unsatisfactorily slow response time because the distributed DBMS is spending considerable time checking that an update is accurately and completely propagated across the network.
A.	True
B.	False
Answer» C.

Discussion

553.	A distributed unit of work allows various statements within a unit of work to refer to multiple remote DBMS locations.
A.	True
B.	False
Answer» B. False

Discussion

554.	The problem of concurrency control is more complex in a distributed database.
A.	True
B.	False
Answer» B. False

Discussion

555.	Databases that are stored on computers at multiple locations and are not interconnected by a network are known as distributed databases.
A.	True
B.	False
Answer» C.

Discussion

556.	Formatting the report is part of authoring a report.
A.	True
B.	False
Answer» B. False

Discussion

557.	Market basket analysis primarily uses the technique of conditional probabilities.
A.	True
B.	False
Answer» C.

Discussion

558.	Database applications are seldom intended for use by a single user.
A.	True
B.	False
Answer» C.

Discussion

559.	For every relationship, there are six possible sets of minimum cardinalities.
A.	True
B.	False
Answer» C.

Discussion

560.	A data mart is a collection of data that, while smaller than a data warehouse, still addresses the entire business.
A.	True
B.	False
Answer» C.

Discussion

561.	The DBMS ranked as being the "easiest to use" in the text is Oracle Corporation's Oracle.
A.	True
B.	False
Answer» C.

Discussion

562.	Intersection tables are ID-dependent on both their parent tables.
A.	True
B.	False
Answer» B. False

Discussion

563.	OnLine Analytical Processing (OLAP) is a BI reporting system.
A.	True
B.	False
Answer» B. False

Discussion

564.	An intersection table is required to represent M:N relationships.
A.	True
B.	False
Answer» B. False

Discussion

565.	In an enterprise-class database system, business users interact directly with database applications, which directly access the database data.
A.	True
B.	False
Answer» C.

Discussion

566.	(STREET ADDRESS, CITY, STATE, ZIP) is an ideal primary key.
A.	True
B.	False
Answer» C.

Discussion

567.	When the child entity is required, we are restricted from creating a new parent row without also creating a corresponding child row at the same time.
A.	True
B.	False
Answer» B. False

Discussion

568.	When the parent entity is required and the parent has a surrogate key, update actions can be ignored.
A.	True
B.	False
Answer» B. False

Discussion

569.	When the parent entity is required, a new parent row can always be inserted.
A.	True
B.	False
Answer» B. False

Discussion

570.	For every relationship, there are six possible referential integrity actions.
A.	True
B.	False
Answer» B. False

Discussion

571.	An ideal primary key is short, numeric and seldom changing.
A.	True
B.	False
Answer» B. False

Discussion

572.	Microsoft Access is an enterprise-class database product.
A.	True
B.	False
Answer» C.

Discussion

573.	Applications are programs that interact directly with the database.
A.	True
B.	False
Answer» C.

Discussion

574.	The purpose of a database is to help people stop using spreadsheets.
A.	True
B.	False
Answer» C.

Discussion

575.	The DBMS allows surrogate keys to be changed.
A.	True
B.	False
Answer» C.

Discussion

576.	Cascading updates refers to child rows being automatically deleted when a parent row is deleted.
A.	True
B.	False
Answer» C.

Discussion

577.	Structured Query Language (SQL) is an internationally recognized standard language that is understood by all commercial database management system products.
A.	True
B.	False
Answer» B. False

Discussion

578.	When transforming an entity-relationship model into a relational database design, each entity is represented as a table.
A.	True
B.	False
Answer» B. False

Discussion

579.	Surrogate keys have much meaning for users.
A.	True
B.	False
Answer» C.

Discussion

580.	The XML family of standards is very important in database processing today.
A.	True
B.	False
Answer» B. False

Discussion

581.	A database has a built-in capability to create, process and administer itself.
A.	True
B.	False
Answer» C.

Discussion

582.	Enterprise Resource Planning (ERP) is an example of a single user database.
A.	True
B.	False
Answer» C.

Discussion

583.	In an Enterprise-class database system, business users interact directly with database applications that interact with the DBMS, which directly accesses the database data.
A.	True
B.	False
Answer» B. False

Discussion

584.	The DBMS ranked as being the "hardest to use" in the text is Microsoft's SQL Server.
A.	True
B.	False
Answer» C.

Discussion

585.	Prior to 1970, all data was stored in separate files, which were mostly stored on reels of magnetic tape.
A.	True
B.	False
Answer» B. False

Discussion

586.	RFM analysis is a BI reporting system.
A.	True
B.	False
Answer» B. False

Discussion

587.	Report types include static, dynamic, query and OLAP.
A.	True
B.	False
Answer» B. False

Discussion

588.	BI reporting systems summarize the current status of business activities in order to predict future activities.
A.	True
B.	False
Answer» C.

Discussion

589.	Business Intelligence (BI) reporting systems are used to make sophisticated mathematical and statistical calculations in order to prepare reports based on the data.
A.	True
B.	False
Answer» C.

Discussion

590.	Data warehouse data are usually normalized.
A.	True
B.	False
Answer» C.

Discussion

591.	In unsupervised data mining, explanations are created after patterns are found.
A.	True
B.	False
Answer» B. False

Discussion

592.	The delivery function of a report management system allows reports to be delivered via e-mail, via the Web, via XML Web services, via hand delivery and other delivery means.
A.	True
B.	False
Answer» C.

Discussion

593.	The term neural networks as used in data mining is a misnomer.
A.	True
B.	False
Answer» B. False

Discussion

594.	A database has data and relationships.
A.	True
B.	False
Answer» B. False

Discussion

595.	The terms alternate key and candidate key mean the same thing.
A.	True
B.	False
Answer» B. False

Discussion

596.	In 1:N relationships, which entity becomes the parent entity is arbitrary.
A.	True
B.	False
Answer» C.

Discussion

597.	One of the reasons why OODBMSs have not been widely used for business information systems is that OOP is obsolete.
A.	True
B.	False
Answer» C.

Discussion

598.	When the parent entity is required, cascading updates and cascading deletions should be allowed or the associated actions on the parent should be prohibited.
A.	True
B.	False
Answer» B. False

Discussion

599.	Business Intelligence (BI) systems do not obtain data from operational databases.
A.	True
B.	False
Answer» C.

Discussion

600.	Data Mining uses simple arithmetic techniques such as sums, averages, and groupings to perform what-if analyses, to make predictions, and to facilitate decision making.
A.	True
B.	False
Answer» C.

Discussion

Explore topic-wise MCQs in Engineering.

An increasingly popular option for data distribution as well as for fault tolerance of any database is to store a separate copy of the database at each of two or more sites.

Asynchronous technology can result in unsatisfactorily slow response time because the distributed DBMS is spending considerable time checking that an update is accurately and completely propagated across the network.

A distributed unit of work allows various statements within a unit of work to refer to multiple remote DBMS locations.

The problem of concurrency control is more complex in a distributed database.

Databases that are stored on computers at multiple locations and are not interconnected by a network are known as distributed databases.

Formatting the report is part of authoring a report.

Market basket analysis primarily uses the technique of conditional probabilities.

Database applications are seldom intended for use by a single user.

For every relationship, there are six possible sets of minimum cardinalities.

A data mart is a collection of data that, while smaller than a data warehouse, still addresses the entire business.

The DBMS ranked as being the "easiest to use" in the text is Oracle Corporation's Oracle.

Intersection tables are ID-dependent on both their parent tables.

OnLine Analytical Processing (OLAP) is a BI reporting system.

An intersection table is required to represent M:N relationships.

In an enterprise-class database system, business users interact directly with database applications, which directly access the database data.

(STREET ADDRESS, CITY, STATE, ZIP) is an ideal primary key.

When the child entity is required, we are restricted from creating a new parent row without also creating a corresponding child row at the same time.

When the parent entity is required and the parent has a surrogate key, update actions can be ignored.

When the parent entity is required, a new parent row can always be inserted.

For every relationship, there are six possible referential integrity actions.

An ideal primary key is short, numeric and seldom changing.

Microsoft Access is an enterprise-class database product.

Applications are programs that interact directly with the database.

The purpose of a database is to help people stop using spreadsheets.

The DBMS allows surrogate keys to be changed.

Cascading updates refers to child rows being automatically deleted when a parent row is deleted.

Structured Query Language (SQL) is an internationally recognized standard language that is understood by all commercial database management system products.

When transforming an entity-relationship model into a relational database design, each entity is represented as a table.

Surrogate keys have much meaning for users.

The XML family of standards is very important in database processing today.

A database has a built-in capability to create, process and administer itself.

Enterprise Resource Planning (ERP) is an example of a single user database.

In an Enterprise-class database system, business users interact directly with database applications that interact with the DBMS, which directly accesses the database data.

The DBMS ranked as being the "hardest to use" in the text is Microsoft's SQL Server.

Prior to 1970, all data was stored in separate files, which were mostly stored on reels of magnetic tape.

RFM analysis is a BI reporting system.

Report types include static, dynamic, query and OLAP.

BI reporting systems summarize the current status of business activities in order to predict future activities.

Business Intelligence (BI) reporting systems are used to make sophisticated mathematical and statistical calculations in order to prepare reports based on the data.

Data warehouse data are usually normalized.

In unsupervised data mining, explanations are created after patterns are found.

The delivery function of a report management system allows reports to be delivered via e-mail, via the Web, via XML Web services, via hand delivery and other delivery means.

The term neural networks as used in data mining is a misnomer.

A database has data and relationships.

The terms alternate key and candidate key mean the same thing.

In 1:N relationships, which entity becomes the parent entity is arbitrary.

One of the reasons why OODBMSs have not been widely used for business information systems is that OOP is obsolete.

When the parent entity is required, cascading updates and cascading deletions should be allowed or the associated actions on the parent should be prohibited.

Business Intelligence (BI) systems do not obtain data from operational databases.

Data Mining uses simple arithmetic techniques such as sums, averages, and groupings to perform what-if analyses, to make predictions, and to facilitate decision making.