ERWIN Beginner Quiz

ERWIN Quiz

ERWIN Quiz : This ERWIN Beginner Quiz contains set of 150 ERWIN Quiz which will help to clear any exam which is designed for Beginner.



1) The property of data elements which indicates the number of allowable entries in that element is called

  1. Data Cardinality
  2. Fast Changing Property
  3. Data Repeatability
  4. Data Rationality

Answer : A

 
 
2) What is the overlap between Optionality and Cardinality?

  1. both represents maximum number of occurrences
  2. both represents minimum number of occurrences
  3. both represents minimum and maximum number of occurrences
  4. No overlap

Answer : B

 
 
3) What is the cardinality ratio for a binary relationship of type M:N ?

  1. One or more
  2. More than One
  3. Zero or more
  4. Infinite

Answer : C

 
 
4) —————– is an entity that cannot be uniquely identified by its own attributes alone

  1. sub entity
  2. weak entity
  3. minor entity
  4. None of the above

Answer : B

 
 
5) Fact table in dimensional modeling is an example of

  1. weak entity
  2. strong entity
  3. sub entity
  4. None of the above

Answer : A

 
 
6) What do you mean by Dependency of Entity?

  1. Entity is dependent or independent of other entity.
  2. Entity is Independent of other entity.
  3. Entity is dependent on other entity.
  4. None of the above.

Answer : A

 
 
7) Which of the following can NOT be an Entity type?

  1. Employee
  2. Customer
  3. Employer
  4. Emloyee Id

Answer : D

 
 
8) —————– is an entity that can be uniquely identified by its own attributes alone

  1. sub entity
  2. weak entity
  3. minor entity
  4. Strong entity

Answer : D

 
 
9) Weak entity is also referred as

  1. Major entity
  2. Minor entity
  3. Dependent entity
  4. Independent entity

Answer : C

 
 
10) Which of the following are not properties of entities

  1. Entities are usually recognizable concepts
  2. They are either concrete or abstract
  3. Entities are classified as independent only
  4. Entities are classified as independent or dependent

Answer : C




 
11) What is Data Model ?

  1. A collection of concepts that can be used to describe the structure of a database
  2. Representation of a set of business requirements in a standard structured framework understood by the users
  3. Both A and B
  4. None

Answer : A

 
 
12) Choose the most correct option of the 4 available options

  1. Ralph Kimball believes that portions of data can be combined based on relevance of data and can be used for reporting
  2. Inmon believes that portions of data can be combined based on relevance of data and can be used for reporting
  3. Ralph Kimball believes that DW is built and should be used for reporting.
  4. Both B & C

Answer : D

 
 
13) The process of combining two tables in a relational database is known as

  1. a Join
  2. a Combine
  3. a Relate
  4. a Construct

Answer : A

 
 
14) The Union of a table of N rows and of a table of M rows (M<=N) has the following number of rows:

  1. M+N
  2. A number in the range N to M+N
  3. N
  4. A number in the range 0 to M

Answer : B

 
 
15) An alternate key is also a

  1. Primary Key
  2. Candidate Key
  3. Foreign Key
  4. None of the Above

Answer : B

 
 
16) Which attribute would make the best primary key?

  1. Social security number
  2. Last name
  3. First name
  4. Age

Answer : A

 
 
17) Which can be a Primary Key for Employee table?

  1. Employee Name
  2. Employee Role
  3. Employee Number
  4. Employee first name

Answer : C

 
 
18) Which can Never be implemented as a Primary Key for Customer table?

  1. Customer Id
  2. Customer Number
  3. Account Number
  4. ZIP Code

Answer : D

 
 
19) Which of the following is a valid key field

  1. A Book Title
  2. House number + Street Name
  3. Car Registration number
  4. Initials + Family Name + Date of Birth

Answer : C

 
 
20) Which is not True about surrogate key

  1. Unique identifier for entity
  2. Unique identifier for DB object
  3. derived from application data
  4. not derived from application data

Answer : C




 
21) Maximum modeling effort needs to be on

  1. Conceptual Data Model
  2. Logical Data Model
  3. Physical Data Model
  4. Metadata model

Answer : B

 
 
22) How do you resolve Many-to-Many relations in the logical design?

  1. by adding one more orphan entity
  2. by adding one more relation
  3. by removing one entity from the model
  4. none of the above

Answer : D

 
 
23) How do you resolve One-to-One relationships while doing the  logical design ?

  1. by merging both the entities as one entity without loosing any attribute.
  2. by removing one entity
  3. by adding one more entity and creating one-to-one relation between them.
  4. depends on a particular situation

Answer : D

 
 
24) A puristic Business Representation of data with entity and relationships only is called as

  1. Logical Model
  2. Conceptual Model
  3. Business Model
  4. None of the above

Answer : B

 
 
25) The ____ data model follows a treelike structure.

  1. distributed
  2. hierarchical
  3. network
  4. relational

Answer : B

 
 
26) The data model that captures the business rules of the orgranization

  1. Conceptual
  2. Logical
  3. Physical

Answer : B

 
 
27) The data model that captures the business view

  1. Conceptual
  2. Logical
  3. Physical

Answer : A

 
 
28) The data model that is dependant on the technology & database

  1. Conceptual
  2. Logical
  3. Physical
  4. Business model

Answer : C

 
 
29) The data model wherein most of the modeling effort is contributed

  1. Conceptual
  2. Logical
  3. Physical

Answer : B

 
 
30) The data model which the desginers look for

  1. Conceptual
  2. Logical
  3. Physical
  4. None of the above

Answer : B




 
31) The data model which the implementors look for

  1. Conceptual
  2. Logical
  3. Physical
  4. None of the above

Answer : C

 
 
32) The Entity Relation Model models

  1. Entities
  2. Relationships
  3. Entities, Relationships and Processes
  4. Entities and Relationships

Answer : D

 
 
33) The ER model is meant to

  1. enable low level descriptions of data
  2. replace relational design
  3. be close to a users perception of the data
  4. enable detailed descriptions of data query processing

Answer : C

 
 
34) The type of data model which the business users look for

  1. Conceptual
  2. Logical
  3. Physical
  4. None of the above

Answer : A

 
 
35) What are different types of Data Model ?

  1. Physical model, Logical model
  2. Hybrid model
  3. Conceptual model
  4. Both A and C

Answer : D

 
 
36) What comes before the Logical DM?

  1. PDM
  2. LDM
  3. Conceptual Data Model

Answer : C

 
 
37) Which data model depicts a semantic layer representing business view?

  1. Conceptual
  2. Logical
  3. Physical
  4. None of these

Answer : A

 
 
38) Which data model depicts the business rules of an organization?

  1. Conceptual Data Model
  2. Subject Area Data Model
  3. Logical Data Model
  4. Physical Data Model

Answer : C

 
 
39) Which data model is not independent of the database technology?

  1. Conceptual Data Model
  2. Logical Data Model
  3. Physical Data Model
  4. Metadata model

Answer : C

 
 
40) Which data model is RDBMS dependent?

  1. Conceptual Data Model
  2. Logical Data Model
  3. Physical Data Model
  4. Subject Area data model

Answer : C




 
41) Which data model is the most detailed specific one?

  1. Conceptual
  2. Logical
  3. Physical
  4. None of these

Answer : C

 
 
42) Which data model is the most generic and abstract?

  1. Conceptual
  2. Logical
  3. Physical
  4. None of these

Answer : A

 
 
43) Which is the detailed specific data model amongst the mentioned ones?

  1. Conceptual Data Model
  2. Subject Area Data Model
  3. Metadata model
  4. Physical Data Model

Answer : D

 
 
44) Which is traditional modeling approach?

  1. Entity Relational Modeling
  2. Dimensional Modeling
  3. Snow flake Modeling
  4. None of these

Answer : A

 
 
45) Which step is done first in a Data Modeling development life cycle?

  1. Logical Modeling
  2. Physical Modeling
  3. Conceptual Modeling
  4. None of the choices

Answer : C

 
 
46) After which stage will you carry out the data staging design and development?

  1. Dimensional modeling
  2. Physical design
  3. Technical architecture design
  4. Requirements definition

Answer : B

 
 
47) What is the correct sequence of data modeling phases?

  1. Conceptual data modeling -> logical data modeling -> physical data modeling
  2. Physical data modeling -> conceptual data modeling -> logical data modeling
  3. Conceptual data modeling -> physical data modeling -> logical data modeling
  4. None of these

Answer : A

 
 
48) Which data model is independent of Physical, data storage device.

  1. Logical Model
  2. Physical Moddel
  3. Both A & B
  4. None of these

Answer : A

 
 
49) Which model will define how the business operates?

  1. Data Model
  2. Metadata model
  3. Process Model
  4. None of these

Answer : C

 
 
50) What are the different types of relationship notations ?

  1. IEX
  2. IDFIX
  3. IE
  4. Both B and C

Answer : C




 
51) In this notation, entities are represented by boxes, and relationships by labelled arcs

  1. Crow’s foot
  2. UML
  3. Bachman
  4. IDEF

Answer : A

 
 
52) Which is the correct Data Modeling notation?

  1. ER Model
  2. Information Engineering (IE)
  3. Star schema
  4. None of these

Answer : B

 
 
53) _____ ensure that attributes are allocated to the correct entity type.

  1. Normalization
  2. De-Normalization
  3. Datamodeling
  4. Optimization

Answer : A

 
 
54) ______ is the lowest normal form requiring Primary Key identification

  1. 1NF
  2. 2NF
  3. 3NF
  4. 4NF

Answer : A

 
 
55) A goal of normalization is to

  1. minimize the number of relationships
  2. minimize the number of entities
  3. minimize the number of tables
  4. minimize data redundancy

Answer : D

 
 
56) A table MOVIES in an object-oriented database consists of the attributes title (the primary key), year-produced, and actor-name; actor-name is a repeating group; different movies may have different numbers of actors. The table MOVIES violates the followin

  1. 1NF
  2. 2NF
  3. 3NF
  4. 4NF

Answer : A

 
 
57) A table that satisfies 2NF:

  1. Always satisfies 1NF
  2. May violate 1NF
  3. Always satisfies 3NF
  4. None of the above

Answer : A

 
 
58) A table that satisfies 3NF:

  1. Always satisfies 2NF
  2. May violate 2NF
  3. May satisfy 2NF
  4. None of the above

Answer : A

 
 
59) A table with a unique key  and without any repeatable columns is in _NF

  1. 5th
  2. 6th
  3. 3rd
  4. 1st

Answer : D

 
 
60) Characteristics of Third Normal Form

  1. Table should be in 2nd NF
  2. no transitive dependencies
  3. Partial functional dependency
  4. a and b

Answer : D




 
61) OLTP(Online transaction Processing) Data Models are mostly designed using

  1. 1NF
  2. 2NF
  3. 3NF
  4. 4NF

Answer : C

 
 
62) If columns in a relational table are not repeating group or arrays then the table is in

  1. first normal form
  2. second normal form
  3. third normal form
  4. 4th normal form

Answer : A

 
 
63) In a 2ND NORMAL FORM (2NF) relation
 

  1. all non-key attributes are dependent only on the key
  2. all non-key attributes are functionally dependent on every attribute value making up the key
  3. All the key attributes are atomic
  4. None of the above

Answer : B

 
 
64) In which normal form we remove non-key attributes that are partially dependent on the primary key.

  1. 1 NF
  2. 3 NF
  3. 2 NF
  4. BCF

Answer : C

 
 
65) Move attributes that are not functionally dependent on the entire primary key to their own entity type. This happens in which normal form?

  1. 1NF
  2. 2NF
  3. 3NF
  4. BCNF

Answer : B

 
 
66) Primary Key are identified in which form

  1. 1NF
  2. 2NF
  3. 3NF
  4. 4NF

Answer : A

 
 
67) Removing Partial Dependencies is a step towards getting to

  1. 1NF
  2. 2NF
  3. 3NF
  4. BCNF

Answer : B

 
 
68) The rule that prohibits transitive dependencies is

  1. third normal form
  2. first normal form
  3. second normal form
  4. None of the Above

Answer : A

 
 
69) The rule that requires that each non-key field (attribute) should be fully functionally dependent on the primary key is

  1. Third Normal Form
  2. First Normal Form
  3. Second Normal Form
  4. None of the Above

Answer : C

 
 
70) The rule that specifies that there should be no repeating fields and that fields should be atomic is

  1. third normal form
  2. second normal form
  3. first normal form
  4. None of the Above

Answer : C




 
71) Which normal form is used for most data model development?

  1. 1NF
  2. 2NF
  3. 3NF
  4. 4NF

Answer : C

 
 
72) Which normalization form recommend: “Eliminate Columns Not Dependent On Key”?

  1. 1NF
  2. 2NF
  3. 3NF
  4. 4NF

Answer : C

 
 
73) An object/entity in an application contains an array of values (among other properties). Referring to the scenario above, storing this object in a single column of a single table violates which normal form?

  1. 1st
  2. 2nd
  3. 3rd
  4. 4th

Answer : A

 
 
74) Every non key attribute is non transitively dependent on the primary key – which level of Normalization are we in?

  1. 1
  2. 3
  3. 2
  4. Boyce Codd

Answer : B

 
 
75) What may be the result of over normalization?

  1. It will improve database performance
  2. It may degrade database performance
  3. No impact on performance
  4. None of the above

Answer : B

 
 
76) Which is NOT true for Normalization?

  1. Normalization can validate the accuracy of a model in reflecting business requirement.
  2. Normalization ensures that attributes are allocated to the correct entity type.
  3. Normalization ensures that entity types contain data about only one thing.
  4. Normalization verifies structural correctness.

Answer : A

 
 
77) Column data type finalization takes place during

  1. Conceptual Data Modeling
  2. Logical Data Modeling
  3. Physical Data Modeling
  4. None of these

Answer : C

 
 
78) Database schema (DDL) is generated from

  1. Physical Data Model
  2. Logical Data Model
  3. Conceptual Data Model
  4. Subject Area data model

Answer : A

 
 
79) Database schema is implemented from

  1. Conceptual Data Model
  2. Logical Data Model
  3. Physical Data Model
  4. Metadata model

Answer : C

 
 
80) RDBMS specific features are implemented in

  1. Physical Data Model
  2. Metadata model
  3. Conceptual Data Model
  4. Logical Data Model

Answer : A




 
81) What is Physical Data Model ?

  1. Conceptual
  2. Geared for performance and may consists of redundant data
  3. Both A and B
  4. None

Answer : B

 
 
82) When transforming a Logical Model to a Physical model what technique is used

  1. Dimensional Modeling
  2. Normalization
  3. Denormalization
  4. None of the above.

Answer : C

 
 
83) Bit mapped indexing can be used

  1. When the distinct value of a column is high
  2. When the distinct value of a column is low
  3. When the storage space available is less
  4. When the table has a few rows

Answer : B

 
 
84) Correct attribute / column data type selection is done during

  1. Conceptual Data Modeling
  2. Logical Data Modeling
  3. Physical Data Modeling
  4. None of these

Answer : C

 
 
85) DBAs typically get involved during ____ phase

  1. Conceptual Data Modeling
  2. Logical Data Modeling
  3. Physical Data Modeling
  4. Subject Area Data Modeling phase

Answer : C

 
 
86) IF I want to store true / false in sql values from my frontend which datatype should I use at the best level interms of minimum storage?

  1. Char
  2. Varchar
  3. Bit
  4. Int

Answer : C

 
 
87) In which model do you define a Database View object?

  1. Conceptual Data Model
  2. Logical Data Model
  3. Physical Data Model
  4. None of the above

Answer : C

 
 
88) In which model do you define database partitioning strategy?

  1. Conceptual Model
  2. Logical Model
  3. Physical Model
  4. None of the above

Answer : C

 
 
89) What are Default Values in Data Model?

  1. The physical value a column is defaulted to
  2. The logical value a column is defaulted to
  3. Default Values are associated with entities in logical design
  4. None of the above

Answer : A

 
 
90) Which of the following data model is used for creating Database Objects ?

  1. Conceptual Model
  2. Logical Model
  3. Physical Model
  4. None of the above

Answer : C




 
91) You are in the process of deciding the indexes required for your application DB.
This process belong to which of the following phase ?

  1. Physical design
  2. Logical design
  3. Optimization plan
  4. Fall back plan

Answer : A

 
 
92) Cross-reference (X-Ref) table design is part of

  1. Conceptual Data Model
  2. Logical data model
  3. Physical data model
  4. None of these

Answer : C

 
 
93) How do you define the below scenario/action in physical data model ?
Scenario/action: Each time an instance in the parent entity is deleted, the foreign key
attribute(s) in each related instance in the child entity are set to NULL

  1. By Using Cascade option
  2. By Using Restrict option
  3. By Using Set Null
  4. By Using Set Default

Answer : C

 
 
94) How do you define the below scenario/action in physical data model ?
Scenario/action: Each time an instance in the parent entity is deleted, the foreign
key attribute(s) in each related instance in the child entity are set to the
specified default value.

  1. By Using Cascade option
  2. By Using Restrict option
  3. By Using Set Null
  4. By Using Set Default

Answer : D

 
 
95) How do you define the below scenario/action in physical data model?
Scenario/action: Deletion of an instance in the parent entity is prohibited if there are one or more related instances in the child entity.

  1. By Using Cascade option
  2. By Using Restrict option
  3. By Using Set Null
  4. By Using Set Default

Answer : B

 
 
96) How do you define the below scenario/action in physical data model?
Scenario/action: Each time an instance in the parent entity is deleted, each related instance in the child entity must also be deleted.

  1. By Using Cascade option
  2. By Using Restrict option
  3. By Using Set Null
  4. By Using Set Default

Answer : A

 
 
97) How do you prevent users from adding records to a related table if there is no associated record in the primary table?

  1. By enforcing Referencial integrity
  2. By Data integrity
  3. By Unique Constraint
  4. None

Answer : A

 
 
98) The entity integrity rule states that the value of the primary key can never be ———

  1. infinity
  2. null
  3. blank
  4. None of the above

Answer : B

 
 
99) Unique Constraint enforces

  1. single number value to be entered
  2. single character to be entered
  3. multiple values in set of columns
  4. uniqueness of the values
  5. in a set of columns

Answer : D

 
 
100) When the referential integrity rule is enforced, which one is usually not a valid action in response to the deletion of a row that contains a primary key value referenced elsewhere?

  1. Do not allow the deletion
  2. Accept the deletion without any other action
  3. Delete the related rows
  4. Set the foreign keys of related rows to null

Answer : B




 
101) User-Defined Integrity enforces

  1. null constraints
  2. some specific business
  3. rules
  4. check contraints
  5. entity integrity

Answer : B

 
 
102) What is meaning of Soft Referential Integrity?

  1. Referential integrity rules implemented in ETL process only
  2. Referential integrity rules implemented at the database (DBMS) level only
  3. Referential integrity rules implemented either at ETL or database level
  4. None of these

Answer : A

 
 
103) What is the meaning of Hard Referential Integrity?

  1. Referential integrity rules implemented in ETL process only
  2. Referential integrity rules implemented at the database (DBMS) level only
  3. Referential integrity rules implemented either at ETL or database level
  4. None of these

Answer : B

 
 
104) How is ER data modeling approach different from Dimensional Modeling approach?

  1. Normalized; goal is to eliminate redundancy; look for transaction efficiency
  2. Star schema, query processing
  3. Ease of understanding & use
  4. None of the above

Answer : A

 
 
105) In ER notation entities as represented by

  1. circular boxes
  2. diamond boxes
  3. rectangular boxes
  4. oval boxes

Answer : C

 
 
106) The most popular database model currently in use is the ____.

  1. relational model
  2. hierarchical model
  3. network model
  4. object model

Answer : A

 
 
107) What is a technique for documenting the relationships between entities in a database environment?

  1. Attributes
  2. Entity identifier
  3. Data model
  4. Entity-relationship diagram

Answer : D

 
 
108) What is the goal of relational data modeling?

  1. De-normalize data
  2. Normalize data
  3. Segregate data
  4. Integrate data

Answer : B

 
 
109) Which of the following is not an step in defining a ER model

  1. Defining Entities and Relationships
  2. Add key attributes to the diagram
  3. Adding business and integrity rules
  4. None of the above

Answer : D

 
 
110) Which is NOT an objective of Entity Relational Modeling approach?

  1. Eliminate Redundancy
  2. Transaction Efficiency
  3. Query Performance
  4. None of these

Answer : C




 
111) For a Weak entity to be meaningful, it must be part of a

  1. one-to-one relationship
  2. one-to-many relationship
  3. many-to-many relationship
  4. depends on a particular situation

Answer : B

 
 
112) Good approach to normalize many to many relationship?

  1. create view
  2. create materialized view
  3. create dimension table
  4. third table containing the primary keys of both the tables

Answer : D

 
 
113) Helper tables are used

  1. For handling one to many relationships
  2. For handling many to one relationships
  3. For handling many to many relationships
  4. None of the above

Answer : C

 
 
114) How do you define an Orphan Entity?

  1. An entity that has one to one relationship with another entity
  2. An entity in a Logical Data Model that has no relationship to any other entity.
  3. An entity that has many to many relationship with another entity
  4. None of the above

Answer : B

 
 
115) Which of the following statements best decribes the function of an entity relation model?

  1. An ER model provides a view of the logic of the data and not the physical implementation.
  2. An ER model is concerned primarily with a physical implementation of the data and secondly with the logical view
  3. An ER model is entirely concerned with modelling the physical implemetation
  4. An ER model is concerned primarily with a logical view of the data and secondly with the physical implementation

Answer : A

 
 
116) “some employees are married to other employees” is an example of

  1. Binary relation ship
  2. recursive binary relationship
  3. ternary relationship
  4. None of the above

Answer : B

 
 
117) __________ in a database is a unique identifier for either an entity in the modeled world or an object in the database

  1. Primay Key
  2. Foreign Key
  3. Surrogate key
  4. Composite key

Answer : C

 
 
118) A CHECK constraint is used to limit the values that can be placed in a column. Check Constraints are used to enforce

  1. user defined integrity
  2. domain integrity
  3. entity integrity
  4. referential integrity

Answer : B

 
 
119) A foreign key constraint prevents any action that would destroys the relation between data between two tables. A foreign key constraint is useful to enforce the

  1. referential integrity
  2. domain integrity
  3. entity integrity
  4. user defined integrity

Answer : A

 
 
120) Candidate Key could be a

  1. Primary Key, Foreign Key
  2. Alternate Key, Foreign Key
  3. Primary Key, Alternate Key
  4. Foreign Key

Answer : C




 
121) Cardinality can never be

  1. One
  2. Zero
  3. Less than 1
  4. Greater than 1

Answer : C

 
 
122) Cardinality is applicable to which data modeling constuct?

  1. Entity
  2. Attribute
  3. Smart Key
  4. Relationship

Answer : D

 
 
123) Define cardinality

  1. Min and max no. of occurrences between two related entity types
  2. relationship between entities
  3. 1:1, 1:many, many:many relationship
  4. None of the above

Answer : A

 
 
124) Entity level data quality issues are typically resolved using

  1. Check constraints
  2. Referential Integrity Constraints
  3. Primary Key and Alternate key identification
  4. None of these

Answer : C

 
 
125) How are the identifier attribute commanly known as?

  1. Primary key
  2. Foreign key
  3. Non-key
  4. None of the above

Answer : A

 
 
126) How do you enforce domain integrity in the RDBMS by restricting the range of possible values the user can input?

  1. Primary Key Constraints
  2. Check Constraints
  3. Default Definitions
  4. Check and Default Defintions

Answer : D

 
 
127) If an attribute A is related to the primary key of the table through another non-key attribute B, it is called as

  1. Partial Dependency
  2. Functional Dependency
  3. Transitive Dependency
  4. None of the above

Answer : C

 
 
128) If an attribute A is related to the primary key of the table through attribute B, it is called as

  1. Partial Dependency
  2. Functional Dependency
  3. Transitive Dependency
  4. None of the above

Answer : C

 
 
129) If an entity is related to itself through different roles, it is an Example of

  1. Role Based Association
  2. Recursive Hierarchy
  3. Recursive Network
  4. Association

Answer : C

 
 
130) In Many to Many relationship, migrate the primary key

  1. from any side to the other side
  2. resolve the relationship first then migrate
  3. Do not migrate the primary key
  4. None of these

Answer : B




 
131) In One to Many relationships, migrate the primary key from

  1. one side to many side
  2. many side to one side
  3. Do not migrate the primary key
  4. None of these

Answer : A

 
 
132) In One to One relationship, migrate the primary key from

  1. mandatory side to optional side
  2. optional side to mandatoy side
  3. Do not migrate the primary key
  4. None of these

Answer : A

 
 
133) Order-Sales relationship is

  1. SuperType-Sub Type
  2. Recursive relationship
  3. Dependency
  4. Transactional

Answer : D

 
 
134) Recursive Hierarchy has ____ type of relationship

  1. 1:M
  2. M:M
  3. either 1:M or M:M
  4. Both 1:M and M:M

Answer : A

 
 
135) Recursive Network has ____ type of relationship

  1. 1:M
  2. M:M
  3. either 1:M or M:M
  4. Both 1:M and M:M

Answer : B

 
 
136) Referential integrity ensures that

  1. rows cannot be deleted,
  2. which are used by other records
  3. table contains duplicate records
  4. a column contains a particular value
  5. column doesn’t contain null values

Answer : A

 
 
137) Surrogate key is not related to

  1. Performance
  2. Storage space
  3. History
  4. Integer data type

Answer : B

 
 
138) The relationship between dimension tables and fact table in a star-schema is of the type

  1. Many-to-Many
  2. One-to-Many
  3. one-to-one
  4. None of the above

Answer : B

 
 
139) This occurs when there is a relationship between an entity and itself.

  1. Recursive Relationship
  2. Circular relationship
  3. Dependent relationship

Answer : A

 
 
140) What are the benefits of Association relationships?

  1. Optimization
  2. Performance
  3. Tracking
  4. Recognition

Answer : C




 
141) What is a degree of relation type?

  1. Number of entity types participating
  2. Number of attributes of the relation
  3. Assoication of one or more attributes
  4. None of the above

Answer : A

 
 
142) What would one call the number of entities associated with the relationship?

  1. Cardinality
  2. Degree
  3. Attribute
  4. Tuple

Answer : B

 
 
143) When the relationship between entities  A and B will be optional?

  1. A has one or more occurrences per B
  2. A has exactly one occurrence per B
  3. A has zero or one occurrence per B
  4. None of these

Answer : C

 
 
144) Which is a common application of Recursive Hierarchy?

  1. General Ledger
  2. Organizational Structure
  3. Medical procedures
  4. A and B

Answer : D

 
 
145) Which is an example of Recursive Hierarchy?

  1. Employee managing other employees
  2. Customer holding multiple accounts
  3. Ordering multiple products at the same time
  4. None of these

Answer : A

 
 
146) Which is NOT a rule for Primary Key?

  1. must uniquely identify only one record in an entity
  2. Primary key column can not be null
  3. Entity can hav only one primary key
  4. Primary key can not be made of multiple columns

Answer : D

 
 
147) Which relationship is between two entities in which an instance of entity A can be related to zero, one, or more instances of entity B and entity B can be related to zero, one, or more instances of entity A?

  1. One-to-many relationship
  2. One-to-one relationship
  3. Many-to-many relationship
  4. Many-to-one relationship

Answer : C

 
 
148) A _____ represents a structured grouping of entities that share common characteristics but maintain their unique differences.

  1. Supertype – Subtype
  2. FK
  3. PK
  4. B and C Both

Answer : A

 
 
149) A Subtype must be associated with the SuperType in a ______ Relationship

  1. One to One
  2. One to One Optional
  3. Many to One Optional
  4. One to Many Optional

Answer : B

 
 
150) An entity in ER modeling is analogous to a ——– in the relational model

  1. relation
  2. attribute
  3. tuple
  4. None of the above

Answer : A




 
151) Association is used to resolve

  1. One to Many
  2. May to Many
  3. Many to One
  4. One to Many

Answer : B

 
 
152) Association pattern is used for

  1. Looking up data
  2. Implementing Referential Integrity
  3. Resolving Many – Many relationship (M:M)
  4. None of these

Answer : C

 
 
153) Associative entities are entities used to associate two or more entities in order to resolve a ——– relationship

  1. One to many
  2. one to one
  3. many to many
  4. None of the above

Answer : C

 
 
154) Dependency is indicated by _________ each relationship

  1. cardinality of
  2. optionality of
  3. integrity of
  4. dependency on

Answer : B

 
 
155) Dependency pattern is closely associated to

  1. Relationship Cardinality
  2. Relationship Optionality
  3. Referential Integrity
  4. None of these

Answer : B

 
 
156) Derived key

  1. is not artificially created
  2. is created when unique identifier is not availbale for all the records
  3. is a foreign key
  4. hidden key

Answer : B

 
 
157) What is best practice in defining Primary key?

  1. Define composite key as primary key
  2. Define smart code as primary key
  3. Define surrogate key (running number) as primay key
  4. None of these

Answer : C

 
 
158) What is true about Subtype Relationship?

  1. Is a way to group a set of
  2. entities that share common characteristics.
  3. To take care of inheritance hierarchy
  4. A & B
  5. None of the above

Answer : C

 
 
159) Column level source data quality issues are resolved using

  1. Check constraints
  2. Data type mismatch resolution
  3. Both A & B
  4. Referential integrity constraints

Answer : C

 
 
160) Employee can be related to multiple departments performing various roles. Which data modeling pattern can be used in such case to capture role specific details of the employee?

  1. Recursive Hierarchy
  2. Super type – sub type
  3. Role Based Association
  4. None of these

Answer : C




 
161) What is Identifying Relationship?

  1. A child table can be uniquely identified without the parent table
  2. A child table cannot be uniquely identified without the parent table
  3. All of the above
  4. None of the above

Answer : B

 
 
162) What is Non-Identifying Relationship?

  1. A child can be identified independently of the parent
  2. A child table cannot be uniquely identified without the parent
  3. All of the above
  4. None of the above

Answer : A

 
 
163) What problem you may encounter if you have many to many relationship in physical model?

  1. You may encounter performance problems
  2. You may not be able to enter data into them with out disabling constraints
  3. No problem in having many to many relationship
  4. None of the above

Answer : B

 
 
164) Refer the below Table structures  and specify  what is the relationship between Account to PersonAccount
Account (AccountID, AccountNum, AccountTypeID), AccountID is PK
PersonAccount (AccountPersonSequence, PersonID, AccountID, Balance), (AccountPersonS

  1. Optional
  2. Non-Identifying
  3. Identifying
  4. None of the above

Answer : B

 
 
165) Refer to the below Table structures and specify what is the relationship between Account to PersonAccount .
Account (AccountID, AccountNum, AccountTypeID), AccountID is PK
PersonAccount (AccountID, PersonID, Balance), (AccountID, PersonID) is PK.
 

  1. Optional
  2. Non-Identifying
  3. Identifying
  4. None of the above

Answer : C

 
 
166) What trade-offs typically take place while converting from Logical Data Model to Physical Data Model?

  1. Controlled de-normalization
  2. Derived Aggregate table structures
  3. Both of these
  4. None of these

Answer : C

 
 
167) Which of the following is NOT TRUE regarding Relationship implementation in database design?

  1. One-to-One relationship can be implemented as a single table and rarely as two tables with primary and foreign key relationships
  2. One-to-Many relationships are implemented by splitting the data into two tables with primary key and foreign key relationships
  3. Many-to-Many relationships are implemented using a helper table with the keys from both the tables forming the composite primary key of the junction table
  4. None of the above

Answer : D

 
 
168) Entity types identified by relating to specific entities from another entity type is
 

  1. Strong Entity
  2. ans) Weak Entity
  3. Owner Entity
  4. Independent Entity

Answer : B

 
 
169) A(n) ____ is a generalized class of people, places, or things for which data is collected, stored, and maintained

  1. record
  2. ans) entity
  3. attribute
  4. file

Answer : B

 
 
170) In a M:N relationship WORKS_ON between EMPLOYEE and PROJECT entity types can be determined by

  1. EMPLOYEE only
  2. PROJECT only
  3. EMPLOYEE or PROJECT
  4. ans) EMPLOYEE & PROJECT COMBINATION

Answer : D




 
171) Refer the below Table structures  and specify  what is the relationship between Account to PersonAccount
Account (AccountID, AccountNum, AccountTypeID), AccountID is PK
PersonAccount (AccountPersonSequence, PersonID, AccountID, Balance), AccountPersonSe

  1. Optional
  2. ans) Non-Identifying
  3. Identifying
  4. None of the above

Answer : B

 
 
172) Relationship (Cardinality) between a Fact and a Dimension in a Dimensional Model is

  1. ans) Many-To-One
  2. Many-To-Many
  3. One-To-One
  4. One-To-Many

Answer : A

 
 
173) Relationship between Hierarchical Data Instances represented in a single entity is called as

  1. Many-To-Many Relationships
  2. Generic Relationship
  3. ans) Recursive relationships
  4. Time Dependent Relations

Answer : C

 
 
174) The Start_Date attribute for the WORKS_FOR (N:1) relationship between EMPLOYEE and DEPARTMENT can be an attribute of

  1. ans) EMPLOYEE only
  2. DEPARTMENT only
  3. EMPLOYEE or DEPARTMENT
  4. EMPLOYEE & DEPARTMENT COMBINATION

Answer : A

 
 
175) Relationships between entities are classified in terms of

  1. Degree
  2. Cardinality
  3. Type
  4. ans) All of the above

Answer : D