1033 + Mcqs in Database McqOptions

1.	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

2.	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

3.	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

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

Discussion

5.	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

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

Discussion

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

Discussion

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

Discussion

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

Discussion

10.	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

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

Discussion

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

Discussion

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

Discussion

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

Discussion

15.	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

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

Discussion

17.	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

18.	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

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

Discussion

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

Discussion

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

Discussion

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

Discussion

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

Discussion

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

Discussion

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

Discussion

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

Discussion

27.	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

28.	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

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

Discussion

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

Discussion

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

Discussion

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

Discussion

33.	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

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

Discussion

35.	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

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

Discussion

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

Discussion

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

Discussion

39.	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

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

Discussion

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

Discussion

42.	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

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

Discussion

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

Discussion

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

Discussion

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

Discussion

47.	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

48.	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

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

Discussion

50.	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 Testing Subject.

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.