• architecture Online Quiz - 1
Back
0

architecture Online Quiz - 1

Description: architecture Online Quiz - 1
Number of Questions: 20
Created by:
Tags: architecture
Start the Quiz
Attempted 0/20 Correct 0 Score 0
‹
›

Database modelling:

technology architecture

  1. is achieved using an information flow digram

  2. uses a dataflow diagram

  3. is necessary to remove database anomalies through normalization

  4. is the same as process modelling

  5. is all of the above

Show answer
Correct Option: C

Conceptual data modeling is typically done in parallel with other requirements analysis and structuring steps during:

technology architecture

  1. system planning and selection

  2. systems design

  3. systems analysis

  4. systems implementation and operation

  5. systems evaluation

Show answer
Correct Option: C

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:

technology architecture

  1. top-down approach

  2. bottom-up approach

  3. overview approach

  4. business approach

  5. conceptual approach

Show answer
Correct Option: A

AI Explanation

To answer this question, we need to understand the different data modeling perspectives and how they relate to deriving business rules for a data model.

Option A) top-down approach - This option is correct because the top-down approach in data modeling involves starting with a high-level understanding of the business and then gradually refining the model by adding more details. In this approach, the business rules are derived from an intimate understanding of the nature of the business, rather than from specific information requirements in screens, reports, or business forms. Therefore, Option A is the correct answer.

Option B) bottom-up approach - This option is incorrect because the bottom-up approach in data modeling involves starting with specific information requirements, often derived from screens, reports, or business forms, and then building the data model from there. Business rules in this approach are derived based on the specific requirements identified. Therefore, Option B is incorrect.

Option C) overview approach - This option is incorrect because there is no specific data modeling perspective referred to as the "overview approach." This is not a commonly used term in data modeling. Therefore, Option C is incorrect.

Option D) business approach - This option is incorrect because the term "business approach" is not commonly used to describe a specific data modeling perspective. It is a broad term that can encompass various approaches or methodologies used in data modeling. Therefore, Option D is incorrect.

Option E) conceptual approach - This option is incorrect because the conceptual approach in data modeling refers to creating a high-level, abstract representation of the data model. It focuses on the concepts and relationships between them, rather than the detailed business rules. Therefore, Option E is incorrect.

The correct answer is Option A) top-down approach. This option is correct because it aligns with the perspective of deriving business rules for a data model from an intimate understanding of the nature of the business, rather than from specific information requirements in screens, reports, or business forms.

A detailed, logical, and graphical representation of the entities, associations, and data elements for an organization or business area best describes a(n):

technology architecture

  1. logical model

  2. data flow diagram

  3. entity-relationship diagram

  4. data tree

Show answer
Correct Option: C

Which of the following is not a data modeling tool?

technology architecture

  1. Visio

  2. ERwin

  3. ER/Studio

  4. Data Builder

  5. empowER

Show answer
Correct Option: D

What is the goal of Data Architecture

technology architecture

  1. Design logical data systems

  2. Design physical storage system

  3. Define data entities relevant to the enterprise

  4. All of the above

Show answer
Correct Option: C

Data architecture document dos not include:

technology architecture

  1. Business Data Model

  2. Logical Data Model

  3. Data Management Process Model

  4. Data entity/business function Matrix

  5. Data Interface requirements

Show answer
Correct Option: E

What is an alternate key?
technology architecture

  1. The relationship between more than one entity which has more than one attribute

  2. An attribute that cannot easily identify a record, but can easily viewed as a field

  3. An attribute, other than primary key, that can be used to identify an instance of an entity

  4. A non-distinguishable primary key which is not used to identify fields or records

  5. A primary key with two or more columns on a non-clustered index

Show answer
Correct Option: C 
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?
technology architecture

  1. purchase_date

  2. Credit_card

  3. null

  4. credit_card & product_id

  5. product_id

Show answer
Correct Option: D

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 ?

technology architecture

  1. computer_id

  2. product_id

  3. company_id

  4. employee_id

  5. order_id

Show answer
Correct Option: C

If a key from a parent entity migrates into the primary key of the child entity, what type of relationship is formed?
technology architecture

  1. Identifying

  2. Normalizing

  3. Categorizing

  4. Non-identifying

  5. Emphasizing

Show answer
Correct Option: A

Which one of the following is NOT a characteristic of metadata?

technology architecture

  1. Data about data

  2. Describe a data dictionary

  3. Self-describing

  4. Includes user data

  5. Supports its own structure

Show answer
Correct Option: D

AI Explanation

To answer this question, you need to understand the concept of metadata. Metadata refers to data about data and provides information about the characteristics and properties of the data. Let's go through each option to understand why it is correct or incorrect:

Option A) Data about data - This option is correct because it accurately describes the concept of metadata.

Option B) Describe a data dictionary - This option is correct because a data dictionary is a type of metadata that provides descriptions and definitions of data elements.

Option C) Self-describing - This option is correct because metadata is designed to be self-describing, meaning it provides information about the structure, format, and organization of the data.

Option D) Includes user data - This option is incorrect because user data is not a characteristic of metadata. Metadata focuses on providing information about the data itself, rather than including user-specific data.

Option E) Supports its own structure - This option is correct because metadata often has its own structure and organization to ensure that it can effectively describe and represent the data it refers to.

The correct answer is Option D. This option is incorrect because including user data is not a characteristic of metadata. Metadata focuses on providing information about the data, rather than including specific user-related information.

What can a mandatory one to one relationship indicate?

technology architecture

  1. More entities are needed

  2. The model should be denormolized

  3. The tables are not properly indexed

  4. The model cannot be implemented physically

  5. More attributes are needed

Show answer
Correct Option: E

What is a schema?
technology architecture

  1. A diagram showing the domains of all attributes in the data model

  2. A schedule of data modeling steps

  3. A plan of action for database design

  4. A diagram showing the flow of data in an application

  5. A graphical or language representation of a data model or database

Show answer
Correct Option: E

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?

technology architecture

  1. Entity

  2. Category

  3. Hierarchy

  4. Relationship

  5. Attribute

Show answer
Correct Option: E

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?

technology architecture

  1. section name, age

  2. name

  3. undergraduate

  4. name, class name

  5. major, gender

Show answer
Correct Option: D

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?
technology architecture

  1. Product - Many Manufacturer - Many

  2. Product - Many Manufacturer - One

  3. Product - One Manufacturer - One

  4. Product - One Manufacturer – Many

Show answer
Correct Option: B

How many MQ servers are assigned to each AppServer?

technology architecture

  1. 1

  2. 2

  3. 3

  4. 4

Show answer
Correct Option: B

What is the impact if Autonomy Autoindexer process goes down?

technology architecture

  1. Won't able to access VCM Tool

  2. Job management Console down

  3. Search option in the VCM tool will be impacted

  4. All the above

Show answer
Correct Option: C

What would be admin console port number for cell UP06 in NGI?

technology architecture

  1. 25975

  2. 25976

  3. 25981

  4. 25980

Show answer
Correct Option: C
- Hide questions
ADVERTISEMENT

Find more quizzes from top tags

general knowledge
3615 Quizzes
119858 Questions
 technology
307 Quizzes
36705 Questions
 sports
963 Quizzes
19148 Questions
 history
1187 Quizzes
13475 Questions
 physics
598 Quizzes
13441 Questions
 biology
1160 Quizzes
12174 Questions
 science & technology
551 Quizzes
11015 Questions
 chemistry
490 Quizzes
9892 Questions
 maths
518 Quizzes
9324 Questions
 softskills
0 Quizzes
7131 Questions