architecture Online Quiz - 1
| Description: architecture Online Quiz - 1 | |
| Number of Questions: 20 | |
| Created by: Aliensbrain Bot | |
| Tags: architecture |
Conceptual data modeling is typically done in parallel with other requirements analysis and structuring steps during:
The data modeling perspective that derives the business rules for a data model from an intimate understanding of the nature of the business, rather than from any specific information requirements in screens, reports, or business forms, is referred to as the:
A detailed, logical, and graphical representation of the entities, associations, and data elements for an organization or business area best describes a(n):
Which of the following is not a data modeling tool?
What is the goal of Data Architecture
Data architecture document dos not include:
What is an alternate key?
CREATE TABLE Purchaser{
name string,
credit_card integer (PRIMARY KEY),
address string
}
CREATE TABLE Product{
product_id integer (PRIMARY KEY),
product_name string
}
CREATE TABLE Purchaser_Product{
credit_card integer,
product_id integer,
purchase_date date
}
Based on the sample code above, what is the primary key in the Purchaser_Product table?
A company has a model consisting of eight entities. The parent entity, "Company," has three child entities: "Employee," "Product," and "Order." The Product entity has a categorization of four entities: "Computer," "Software," "Accessory," and "Clearance." Each entity has only one attribute making up the key attribute. Based on the scenario above, what foreign key appears in the model exactly three times ?
If a key from a parent entity migrates into the primary key of the child entity, what type of relationship is formed?
Which one of the following is NOT a characteristic of metadata?
What can a mandatory one to one relationship indicate?
What is a schema?
Several pieces of information are captured about a book. This information includes: Title, Author First Name, Author Last Name, Book Genre, and Date Published. Based on the scenario above, what part of the entity relationship is the Title?
A student has such attributes as name, address, and gender. A student can also attend a graduate, undergraduate, or elective class that has the following attributes: class name, section name, major, and instructor. Based on the scenario above, which is the composite key in a junction table if many students can attend many classes?
PRODUCT ======= Product ID Product Description Manufacturer ID MANUFACTURER ============ Manufacturer ID Manufacturer Name Referring to the above table, what type of relationship exists between the Product table and the Manufacturer table?
How many MQ servers are assigned to each AppServer?
What is the impact if Autonomy Autoindexer process goes down?
What would be admin console port number for cell UP06 in NGI?