Trang 2:
Câu 161: Partitioning DFDs:
a. The process of analyzing a DFD and deriving a series of manual procedures
b. Adding controls to ensure the processes are done property
c. The process of analyzing a DFD and deriving a series manual procedures and
computer programs
d. None of these answers
Câu 162: Physical data flow diagram:
a. describing processes in greater detail
b. show sequencing processes in the order they must be executed
c. show how the system operates or how the new system will be implemented
d. all of these answers
Câu 163: Physical DFDs
a. show how the system is or will be constructed.
b. not concerned about how the system is or will be constructed.
c. concerned about how the system is or will be constructed.
d. none of these answers.
Câu 164: Process names should be in the form:
a. verb
b. adjective
c. noun
d. All of these answers
Câu 165: Select option(s) not true:
a. All of these answers.
b. The database community has developed a series of guidelines for ensuring that
databases are normalized
c. A database to be in 2NF, it must first fulfill all the criteria of a 1NF database
d. Realization is the process of breaking up the data into several tables, so as to
minimize the number of times we have to repeat the same data
Câu 166: Select the false statement:
a. Requirements engineering is a generic process that does not vary from one software
project to another.
b. It is relatively common for different customers to propose conflicting requirements,
each arguing that his her version is the right one.
c. A stakeholder is anyone who will purchase the completed software system under
development.
d. None of these answers.
Câu 167: Select the error(s) in DFDs:
a. Connecting data stores and external entities directly to each other.
b. Incorrectly labeling processes and/or data flow.
c. Forgetting to include a data flow or pointing an arrowhead in the wrong direction
d. All of these answers
Câu 168: Select the false statement (about DFDs):
a. Data that travel together should be in the same data flow
b. Data should be sent only to the processes that need the data
c. A data store within a DFD usually needs to have an input data flow
d. label a process with an IF-THEN statement
Câu 169: Select the true statement:
a. System Requirements Analysis can be a challenging phase, because all of the major
Customers and their interests are brought into the process of determining requirement.(I)
b. System Requirements Analysis can’t be a challenging phase, because all of the major
Customers and their interests are brought into the process of determining requirements.
c. The quality of the final product is highly dependent on the effectiveness of the
requirements identification process(II)
d. (I) and (II)
Câu 170: Select the true statement:
a. Datastore is used to store data
b. None of these answers
c. The terms datastore and database are interchangeable
d. Database is used to store data
Câu 171: Select the true statement:
a. Context diagram contains one process node that generalizes the functiob of the
entire system in relationship to external entities.
b. Context diagram haven’t process node that generalizes the function to the entire system
in relationship to external entities.
c. Context diagram contains two process node that generalizes the function of the entire
system in relationship to external enties.
d. Context diagram contains many process node that generalizes the function of the entire
system in relationship to external entities.
Câu 172: Select the right option(s):
a. The notion of database normalization was developed reduce data redundancy as
much as possible.
b. All of these answers.
c. There are two goals of the normalization process: eliminating redundant data (for
example, storing the same data in more than one table) and ensuring data dependencies
make sense?(only storing related data in a table).
d. Normalization is the process of efficiently organizing in a database.
Câu 173: Select the true statement:
a. External entities represent people or organizations outside of the system being studied.
b. External entities shows the initial source and final recipient of data and information.
c. External entities should be named with a noun, describing that entity.
d. All of these answers.
Câu 174: Suppose you have a table with fields CAR_ID, CAR_NAME,
STICKER_PRICE, QUOTE_PRICE and DEALER, and that the following functional
dependencies exist:
CAR_ID -> CAR_NAME
CAR_ID -> STICKER_PRICE
CAR_ID -> DEALER
DEALER -> QUOTE_PRICE
Which attribute(s) may be key attributes for a 3NF table?
a. CAR_ID and DEALER
b. CAR_ID
c. CAR_NAME, STICKER_PRICE, and DEALER
d. None of the others answers
Câu 175: Suppose you have a table with fields A, B, C and D. The functional
dependencies in the table are as follows:
A,B -> C
A,B -> D
D -> C
a. BCNF
b. 3 NF
c. 2 NF
d. 1 NF
Câu 176: Suppose you have a table with fields A, B, C and D. The functional
dependencies in the table are as follows:
A -> B,C,D
C -> A,B,D
B -> A
What is the highest normal form this table can be in?
a. 2 NF
b. 1 NF
c. 3 NF
d. BCNF
Câu 177: Suppose you have a table with fields A, B, C and D. The functional
dependencies in the table are as follows:
B,C -> A,D
C -> D
What is the highest normal form this table can be in?
a. 1 NF
b. 3 NF
c. 2 NF
d. BCNF
Câu 178: The conservation of inputs and outputs and outputs to a data flow diagram
process when that process is decomposed to a lower level defines:
a. Decomposition
b. Conservation
c. Data flow structuring
d. balancing
Câu 179: The DFD Figure Bookstore’s Text book Inventory System is known as a ____.
a. Context level DFD
b. ERD
c. Bottom level DFD
d. Level 1 DFD
Câu 180: The field used to id records in a database table is known as the:
a. Primary Key
b. Relational Column
c. Query Identifer
d. Row
Câu 181: The notion of database normalization was developed to
a. reduce data intefrity.
b. increase data integrity.
c. increase data redundancy.
d. reduce data redundancy.
Câu 182: The notion of database ____ was developed to reduce data redundancy.
a. schema
b. key
c. normalization
d. redundancy check
Câu 183: The relationship between two entity types A and B is 1:1, and the relationship is
optional at the A end. Only 50% of B entities are related to an A entity. Now consider
mapping these entity types into relations. Select the best statement from the following
list:
a. A and B should kept separate with the foreign key in the A relation.
b. A and B should kept separate with the foreign key in the A and B.
c. A and B should kept separate with the foreign key in the B relation.
d. B should be subsumed by A
Câu 184: This is:
a. DFD level 0 (I)
b. Context diagram (II)
c. DFD level 1
d. (I) and (II)
Câu 185: Use a Data Flow Diagram (DFD) to:
a. show the relationships among the business process within an organization to external
systems
b. show the relationships among the business process within an organization to external
organizations
c. show the relationships among the business process within an organization to customers
