KB Cambodia
In DB, which characteristic belongs to a primary key?
In DB, which characteristic belongs to a primary key? A. Unique B. Changeable C. Nullable D. All correct Answer: Option A
Category: Advanced System Analysis and Design
In DB, which characteristic does not belong to a primary key?
In DB, which characteristic does not belong to a primary key? A. Unique B. Unchanged C. Nullable D. None correct Answer: Option C
In DB, what is a derived attribute?
In DB, what is a derived attribute? A. It is similar to a composite attribute B. It is similar to a multi-valued attribute C. Its data comes from another attribute D. All correct Answer: Option C
In DB, what is a multi-valued attribute?
In DB, what is a multi-valued attribute? A. It contains multiple records of the same type B. It contains multiple types of data C. It mixes with a relationship D. None correct Answer: Option C
In DB, what is a composite attribute?
In DB, what is a composite attribute? A. It contains a single type of data B. It contains multiple types of data C. It contains a relationship D. None correct Answer: Option B
In DB, what is an atomic attribute?
In DB, what is an atomic attribute? A. It contains a single type of data B. It contains two types of data C. It contains multiple types of data D. All correct Answer: Option A
In DB, what is the main difference between an entity and an attribute?
In DB, what is the main difference between an entity and an attribute? A. “If the data is more than one, then it is an entity; otherwise, it is an attribute” B. “If the data is more than one, then…
If you have a lot of duplicated data, what should you do? a.
If you have a lot of duplicated data, what should you do? a. A. Normalize the database B. Design table and relationship C. Draw Chen’s ERD D. All correct Answer: Option A
In DB, which anomaly does not happen when data is redundant?
In DB, which anomaly does not happen when data is redundant? A. Insert anomaly B. Update anomaly C. Select anomaly D. All coreect Answer: Option C
Which numeric order is correct for DFD Level 2?
Which numeric order is correct for DFD Level 2? A. 2.0, 2.1, 2.3, 2.4 B. 2.1.1, 2.12, 2.1.3, 2.1.4 C. 2.0, 3.0, 4.0, 5.0 D. None correct Answer: Option A