question

1) Howie is a business analyst who is given access to the database of a product prior to its launch. He needs to understand the data presented and take appropriate action. Which of the following is Howie most likely to do? A) send the database back to the source to interpret the data B) use the data present in the database in its raw format C) encrypt the data to secure the product's authenticity D) use SQL or graphical tools to query the database

answer

D

question

2) Which of the following is an international standard language for querying databases? A) C++ B) SQL C) Python D) Visual Basic

answer

B

question

3) The purpose of a database is to ________. A) test and troubleshoot newly installed software B) design the source code for computer programs C) describe and build computer architectures D) store lists of data involving multiple themes

answer

D

question

4) Google is a database that is used by Facebook and Twitter.

answer

F

question

5) Databases are static and it is only the information systems that change.

answer

F

question

6) Databases are required to keep track of lists with multiple themes.

answer

T

question

8) A ________ is a self-describing collection of integrated records. A) datasheet B) dataflow C) database D) dataspace

answer

C

question

9) Which of the following best describes a byte in a database? A) It is a character of data. B) It is a group of rows. C) It is a collection of data. D) It is a group of columns.

answer

A

question

10) In a database, bytes are grouped into ________. A) tables B) columns C) rows D) records

answer

B

question

11) In a database, columns are also called ________. A) records B) tables C) files D) fields

answer

D

question

12) In a database, rows are also called ________. A) records B) fields C) tables D) files

answer

A

question

13) In a database, a group of similar rows is called a ________. A) table B) record C) field D) matrix

answer

A

question

14) In a database, a table is also called a ________. A) record B) matrix C) file D) field

answer

C

question

15) In a database, a column or group of columns that identifies a unique row in a table is known as a ________. A) field B) record C) file D) key

answer

D

question

16) In a database, columns that are keys of a different table than the one in which they reside are known as ________ keys. A) foreign B) alternate C) relational D) candidate

answer

A

question

17) Databases that carry their data in the form of tables and represent relationships using foreign keys are called ________ databases. A) hierarchical B) network C) relational D) object

answer

C

question

18) In a database, a table is formally referred to as a ________. A) matrix B) field C) record D) relation

answer

D

question

19) Which of the following best describes the metadata in a database? A) programs used to create, process, and administer a database B) special data that describes the structure of a database C) data that is stored in a Web site D) special data that is unique to a specific user

answer

B

question

20) Bytes are grouped into rows in a database.

answer

F

question

21) In a database, columns are also called records.

answer

F

question

22) In a database, the collection of data for all columns is called a file.

answer

F

question

23) In a database, a key is a column or group of columns that identifies a unique row in a table.

answer

T *

question

24) Databases that carry their data in the form of tables and that represent relationships using foreign keys are called discrete databases.

answer

F

question

25) The format of the metadata in a database depends on the software product that is processing the database.

answer

T

question

26) To find out what a database contains, one can look at the metadata inside the database.

answer

T

question

30) A(n) ________ is a program that is used to create, process, and administer a collection of self-describing integrated records. A) decision support system (DSS) B) knowledge management system (KMS) C) database management system (DBMS) D) enterprise planning system (EPS)

answer

C

question

31) Which of the following is a database management system (DBMS) product from Microsoft? A) MySQL B) SQL Server C) DB2 D) Sybase ASE

answer

B

question

32) ________ is a popular enterprise database management system (DBMS) product from IBM. A) DB2 B) Access C) SQL Server D) MySQL

answer

A

question

33) Access and SQL Server are popular ________ DBMS products. A) open source B) IBM C) Oracle Corporation D) Microsoft

answer

D

question

34) Which of the following is a function of the database management system (DBMS)? A) implementing lean systems in workstations B) eliminating bottlenecks in business processes C) automating workflows in the databases of companies D) processing a database by inserting or modifying data

answer

D

question

35) The database management system (DBMS) provides applications for processing operations such as ________. A) sending and receiving emails B) generating software codes C) inserting or deleting information D) automating business processes

answer

C

question

36) SQL stands for ________. A) Standard Query Language B) Secondary Query Language C) Structured Query Language D) Simplified Query Language

answer

C

question

37) One of the important functions of a database management system (DBMS) is to provide the necessary tools for ________. A) encrypting emails B) encapsulating data objects C) administering the database D) testing program codes

answer

C

question

38) Which of the following is considered an administrative function of the database management system (DBMS)? A) adding structures to improve the performance of database applications B) testing program codes in the system for errors C) creating tables, relationships, and other structures in databases D) using international standard languages for processing database applications

answer

A

question

39) Monitoring the performance of a database after providing solutions for improving its performance is an activity of the DBMS pertaining to ________. A) creation B) modification C) processing D) administration

answer

D

question

40) Conducting training to ensure that users and operations personnel know and understand recovery procedures is a task associated with the DBMS ________. A) processing B) administration C) creation D) modification

answer

B *

question

41) Most organizations develop their own database management systems.

answer

F

question

42) DB2 is a popular database management system product that is licensed from Microsoft.

answer

F

question

43) A database management system is also referred to as a database.

answer

F

question

44) HyperText Markup Language is an international standard language for processing a database.

answer

F *

question

45) Structured query language statements can be issued directly to the database management system (DBMS) by an application program.

answer

T

question

46) The database management system (DBMS) can be used to set up a security system involving user accounts, passwords, permissions, and limits for processing the database.

answer

T

question

47) Database management system (DBMS) administrative functions include adding structures to improve the performance of database applications.

answer

T

question

48) The administrative functions of a database management system (DBMS) include backing up database data.

answer

T

question

53) A ________ is a collection of forms, reports, queries, and programs that serves as an intermediary between users and database data. A) database application B) metadata table C) database hierarchy D) dimension table

answer

A

question

54) Which of the following elements of a database application helps in the insertion of new data and the deletion of existing data? A) reports B) application programs C) queries D) forms

answer

D

question

55) Which of the following elements of a database application presents data in a structured manner using sorting, grouping, filtering, and other operations? A) queries B) forms C) reports D) application programs

answer

C

question

56) Which of the following elements of a database application provides security, data consistency, and special-purpose processing? A) query applications B) application programs C) reports D) forms

answer

B

question

57) Traditional database application programs are written in object-oriented languages like ________. A) Pascal B) Visual Basic C) Datalog D) Unigraphics

answer

B

question

58) Which of the following is true of browser-based database applications? A) They are written in object-oriented languages such as Structured Query Language. B) The application, database management system (DBMS), and the database reside on the user's computer. C) They are displayed and processed using html, html5, or css3. D) They use C++ as the standard language for user-side processing.

answer

C

question

59) Browser-based database applications differ from traditional applications in that they ________. A) have no security requirements B) are used only by corporates C) are usually open to the public D) fail to support graphical queries

answer

C

question

60) Which of the following is a major drawback of multi-user processing of a database? A) lack of data integrity B) software redundancy C) lost-update problem D) limited access to data

answer

C

question

61) A database application serves as an intermediary between users and database data.

answer

T

question

62) Queries in database applications present data in a structured manner using operations such as sorting, grouping, and filtering.

answer

F

question

63) Reports in database applications provide security, data consistency, and special-purpose processing.

answer

F

question

64) All traditional databases require the Internet to transmit traffic between a user's computer and a database management system (DBMS) server computer.

answer

F

question

65) In single-user databases, the application, the database management system (DBMS), and the database all reside on a user's computer.

answer

T *

question

66) Traditional database application programs are written in object-oriented languages such as C++.

answer

T

question

67) Browser database application forms, reports, and queries are displayed and processed using HyperText Markup Language (HTML).

answer

T

question

68) Browser applications are thin-client applications that need not be preinstalled on the users' computers.

answer

T

question

69) Security requirements are more stringent for traditional applications than for browser-based ones.

answer

F *

question

70) The lost-update problem caused by multi-user processing in databases can be prevented by avoiding all types of database locking.

answer

F

question

72) Which of the following is an open source document-oriented NoSQL DBMS product? A) Access B) MongoDB C) SQL Server D) DB2

answer

B

question

73) Which of the following is a drawback of the relational database processing model? A) It utilized an extensive amount of storage space. B) It required powerful processors to function. C) It was never a natural fit with business documents. D) It did not enable document piece-making via normalization.

answer

C

question

74) Which of the following is true of the relational database processing model? A) It supports very high transaction rates. B) It can efficiently store files with large collections of bits. C) It helps organizations store new data types such as images, audio, and videos. D) It represents relationships with the help of foreign keys.

answer

C

question

75) One of the reasons for the appearance of new styles of nonrelational database processing is the need for ________. A) storing data types such as images, audio, and videos in organizations B) gaining faster performance by limiting the number of servers used C) breaking up sales orders via normalization D) limiting the use of open-source document-oriented DBMS

answer

A

question

76) Which of the following is a nonrelational data store developed by Amazon.com? A) Bigtable B) Dynamo C) Cassandra D) MongoDB

answer

B

question

77) ________ refers to software products that support very high transaction rates, processing relatively simple data structures, replicated on many servers in the cloud. A) NoSQL DBMS B) MySQL DBMS C) Traditional DBMS D) Relational DBMS

answer

A

question

78) The conversion of the existing traditional databases in organizations to NoSQL databases is ________. A) highly efficient and is being practiced by many organizations B) highly recommended because it is user friendly C) very cost-effective but can be enormously disruptive D) unnecessary when relational databases meet the needs of organizations

answer

D

question

79) NoSQL database management system products are very technical and can be used only by those with a deep background in computer science.

answer

T

question

1) Which of the following is true of a data model? A) It is created after the database is designed. B) It is an attribute whose value is associated with only one entity instance. C) It is a logical representation of the structure of the data. D) It does not describe the relationships among the data.

answer

C

question

2) Once the users have validated and approved the data model, it is transformed into a ________. A) database design B) technical report C) knowledge system D) data repository

answer

A

question

3) A data model is a logical representation of the structure of the data.

answer

T

question

4) A data model does not depict the relationships among the data.

answer

F

question

5) A database contains a description of both the data and the relationships among the data.

answer

F *

question

7) Which of the following is a highly popular technique for creating a data model with which the developers describe the content of a database by defining what is to be stored in the database and the associations among them? A) entity-relationship (E-R) data model B) Unified Modeling Language (UML) C) object-relational model D) semantic data model

answer

A

question

8) Which of the following is true of entities? A) Entities have an identifier whose value is associated with every entity in the data model. B) Entities can only represent a logical construct or transaction, not a physical object. C) The characteristics of entities are described by attributes. D) The names of entities are always plural.

answer

C

question

9) Carol, an online shopping customer, raises a complaint stating she had placed an order for books two weeks ago but has still not received them. Nigel, in charge of handling complaints for the site, wants to verify Carol's complaint. He tracks the order number and the order date for Carol's books. The data that Nigel is tracking are also called ________. A) attributes B) dependencies C) cardinalities D) alternatives

answer

A

question

10) Which of the following statements is true of identifiers? A) They are constraints on minimum requirements in a relationship. B) They are data that users want to track. C) They highlight instances of data duplication in a database. D) They are attributes whose values are associated with only one entity instance.

answer

D

question

11) Which of the following is true of an entity-relationship (E-R) diagram? A) Each entity is shown in separate rectangles. B) Many-to-many relationships are generally denoted by N:N. C) A crow's foot represents a 1:N relationship between two entities. D) Crow's foot is a shorthand representation for a single relationship between entities.

answer

C

question

12) Roger teaches a Chemistry class at the state university. Each student in the class can only be tutored by Roger; however, he can tutor multiple students. In a data model, this relationship is best represented as a(n) ________. A) N:M relationship B) N:N relationship C) 1:N relationship D) 1:1 relationship

answer

C

question

13) Which of the following notations signifies that an adviser can be related to many students and that a student can be related to many advisers? A) 1:N B) N:M C) N:1 D) N:N

answer

B

question

14) In an organization, the administrative department consists of one clerk whose sole responsibility is the management of various administrative functions. The notation that accurately indicates this relationship is ________. A) 1:N B) N:N C) 1:1 D) N:M

answer

C

question

15) The angled lines in an entity-relationship (E-R) diagram used as shorthand to represent multiple relationships are referred to as a(n) ________. A) crow's foot B) identifier C) attribute D) cardinality line

answer

A

question

16) Maximum cardinality in an entity-relationship (E-R) diagram refers to the maximum number of ________. A) normalizations possible in a diagram B) entities that can be involved in a relationship C) identifiers possible in a particular diagram D) attributes associated with an entity

answer

B

question

17) Entities have attributes that describe characteristics of the entity.

answer

T *

question

18) An identifier is an attribute whose value is associated with every entity in the data model.

answer

F

question

19) Entities have relationships to attributes but not to each other.

answer

F

question

20) In an entity-relationship (E-R) diagram, a line is used to represent a relationship between two entities.

answer

T

question

21) The notation N:N is used to indicate a many-to-many relationship in an E-R diagram.

answer

F *

question

22) While representing the relationship between two entities in an entity-relationship diagram, the N:N notation is used to indicate that the same number of entities are present on each end of the relationship.

answer

T

question

23) 1:N means that more than one entity is allowed on each side of the relationship.

answer

F

question

24) The crow's foot notation shows the minimum number of entities that can be involved in a relationship.

answer

F

question

25) The maximum number of entities that can be involved in a relationship is known as maximum cardinality.

answer

T

question

26) In an entity-relationship diagram, a vertical bar on the lines indicates that at least one entity of that type is required in the relationship.

answer

T

question

29) The process of converting poorly structured tables into two or more well-structured tables is referred to as ________. A) replication B) integration C) actualization D) normalization

answer

D

question

30) The data integrity problem can occur only if data are ________. A) duplicated B) missing C) inefficient D) insufficient

answer

A

question

31) Normalized tables eliminate ________. A) data dependency B) data duplication C) data insufficiency D) data conversion

answer

B

question

32) The general goal of normalization is to ________. A) create a copy of an existing table B) establish relationships among the entities in a table C) convert two or more tables into a single table D) construct tables such that every table has a single topic

answer

D *

question

33) According to the kinds of problems they have, database practitioners classify tables into various ________. A) solved forms B) cardinalities C) normal forms D) relationships

answer

C *

question

34) Normalization is a database design concept that helps to construct well-structured tables.

answer

T

question

35) The data integrity problem can occur only if data are missing.

answer

F

question

36) The general goal of normalization is to construct tables such that every table has a single topic or theme.

answer

T

question

37) Tables that are not normalized can have data integrity problems.

answer

T

question

38) Database practitioners classify tables into various normal forms according to the kinds of problems they have.

answer

T

question

39) To represent an N:M relationship between two entities, two normalized tables are sufficient.

answer

F

question

42) The easiest time to change the database structure is ________. A) during the data modeling stage B) after constructing the database C) during the database designing stage D) after creating database reports

answer

A *

question

43) The easiest time to change the database structure is after the database has been constructed and loaded with data.

answer

F

MIS 300 Chapter 5 – Flashcards

Unlock all answers in this set

Haven't found what you were looking for?

Search for samples, answers to your questions and flashcards