ERWIN Expert Quiz

Posted on: | By: – Comments Off

ERWIN Quiz

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



1) MetaData  of OLAP Databases

  1. facts, dimensions, attributes
  2. Files
  3. ERWIN
  4. Index,Primary Key

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : A[/bg_collapse]
 
 
2) Object that contains data from one or more tables, which have one or more columns in common and stores together all the rows from all the table.
 

  1. CLUSTER
  2. SET OPERATOR
  3. STRING FUNCTION
  4. DATE FUNCTION

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : A[/bg_collapse]
 
 
3) Offline Operational Databases>Offline Data warehouse:
>Real time Data Warehouse>Integrated Data Warehouse:

  1. STAGES OF  OLTP DATA  DESIGN
  2. STAGES OF  OLAP DATA  DESIGN
  3. STEPS TO READ FILE
  4. STEPS TO READ VARIABLE

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : B[/bg_collapse]
 
 
4) Stronger version of the third normal form

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

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : B[/bg_collapse]
 
 
5) Design is optimal for Warehouse

  1. OLTP
  2. FILESYSTEM
  3. NOSQL
  4. OLAP

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : D[/bg_collapse]
 
 
6) Table used  while  updating  data in  DWH

  1. INDEXED TABLE
  2. CLUSTER TABLE
  3. LOOKUP TABLE
  4. ALL

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : C[/bg_collapse]
 
 
7) LOWEST level of information that will be stored in the fact table.

  1. DIMENSION
  2. FACT
  3. GRAIN
  4. LOOKUP

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : C[/bg_collapse]
 
 
8) facts that cannot be summed up for any of the dimensions

  1. NON-Additive facts
  2. Additive facts
  3. Factless facts
  4. ALL

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : A[/bg_collapse]
 
 
9) Time

  1. Example of GRAIN
  2. Example of SLOW CHANGING DIMWENSION
  3. Example of CONFIRMED DIMWENSION
  4. NORMAL DIMENSION

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : C[/bg_collapse]
 
 
10) Data captured by Slowly Changing Dimensions (SCDs) change slowly but unpredictably

  1. SCD
  2. CONFIRMED DIMENSION
  3. Factless facts
  4. AGGREAGATE DIMENSION

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : A[/bg_collapse]



 
11) Single fact table connected to dimension tables

  1. SNOWFLAKE Schema
  2. STAR Schema
  3. OLTP SCHEMA
  4. ALL

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : B[/bg_collapse]
 
 
12) What is diff b/w DATAWAREHOUSING & BUSINESS INTELLIGENCE

  1. Used to store history data
  2. Both are Same
  3. OLTP & OLAP
  4. Stores history data and used to process KPI

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : D[/bg_collapse]
 
 
13) What is DEGENERATE DIMENSION

  1. dimension key in the fact table that does not have its own dimension table,
  2. dimension key in the fact table that does have its own dimension table
  3. KEY IN Factless fact table
  4. KEY FOR CUBE table .

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : A[/bg_collapse]
 
 
14) While Designing Warehouse,why FACT Table is normalized while other tables are Denormalized?

  1. IMPROVE PERFORMANCE
  2. IMPROVE LOGIC
  3. EASY TO  WIRTE QUERY
  4. NONE

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : A[/bg_collapse]
 
 
15) Grouping of Random flags and text Attributes in a dimension and moving them to a separate sub dimension

  1. SCD
  2. JUNK DIMENSION
  3. Factless facts
  4. AGGREAGATE DIMENSION

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : B[/bg_collapse]
 
 
16) Index used for the columns in which the ratio of the number of distinct values to the number of rows in the table is very low.

  1. BTREE
  2. UNIQUE
  3. CLUSTERED
  4. BITMAP

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : D[/bg_collapse]
 
 
17) A TABLE sits between a fact table and a dimension table to resolve many-to-many relationships between a fact and a dimension

  1. FACT TABLE
  2. BRIDGE TABLE
  3. DIMENSION TABLE
  4. ALL

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : B[/bg_collapse]
 
 
18) Which type of entity represents a logical generalization whose actual occurrence is represented by a second, associated entity?

  1. Supertype entity
  2. Subtype entity
  3. Archetype entity
  4. Instance entity

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : B[/bg_collapse]
 
 
19) Which of the options can be used for row co-location in Oracle?

  1. Cluster table
  2. Varray table
  3. Partitioning
  4. Materialized views

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : A[/bg_collapse]
 
 
20) Which of the following is HAS-A relationship?

  1. 1:1
  2. 1:N
  3. N:M
  4. All of the above

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : D[/bg_collapse]



 
21) If a denormalization situation exists with a many-to-many or associative binary relationship, which of the following is true?

  1. All fields are stored in one relation
  2. All fields are stored in two relations
  3. All fields are stored in three relations
  4. All fields are stored in four relations

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : B[/bg_collapse]
 
 
22) Which of the following is not a factor to consider when switching from small to large block size?

  1. The length of all of the fields in a table row
  2. The number of columns
  3. Block contention
  4. Random row access speed

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : B[/bg_collapse]
 
 
23) A rule of thumb for choosing indexes for a relational database includes which of the following?

  1. Indexes are more useful on smaller tables.
  2. Indexes are more useful for columns that do not appear frequently in the WHERE clause in queries.
  3. Do not specify a unique index for the primary key of each table
  4. Be careful indexing attributes that have null values

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : D[/bg_collapse]
 
 
24) A multidimensional database model is used most often in which of the following models?

  1. Data warehouse
  2. Relational
  3. Hierarchical
  4. Network

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : A[/bg_collapse]
 
 
25) A transitive dependency is which of the following?

  1. A functional dependency between two or more key attributes.
  2. A functional dependency between two or more nonkey attributes
  3. A relation that is in first normal form.
  4. A relation that is in second normal form.

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : B[/bg_collapse]
 
 
26) Which of the following data constraints would be used to specify that the value of cells in a column must be one of a specific set of possible values?

  1. A domain constraint
  2. A range constraint
  3. An intrarelation constraint
  4. An interrelation constraint

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : A[/bg_collapse]
 
 
27) Which of the following data constraints would be used to specify that the value of a cell in one column must be less than the value of a cell in another column in the same row of the same table?

  1. A domain constraint
  2. A range constraint
  3. An intrarelation constraint
  4. An interrelation constraint

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : C[/bg_collapse]
 
 
28) For every relationship, how many possible types of actions are there when enforcing minimum cardinalities?

  1. Two
  2. Three
  3. Four
  4. Six

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : D[/bg_collapse]
 
 
29) For every relationship, how many possible sets of minimum cardinalities are there?

  1. Two
  2. Three
  3. Four
  4. Six

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : C[/bg_collapse]
 
 
30) Most of the time, modification anomalies are serious enough that tables should be normalized into

  1. 1NF
  2. 2NF
  3. 3NF
  4. None of the above

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : C[/bg_collapse]



 
31) Which answer is an example of the inconsistent values problem from the below sample of data from a table?

  1. Three columns have the values 534-2435, 534-7867, and 546-2356 in the same row.
  2. Three rows have the values Brown Small Chair, Small Chair Brown, and Small Brown Chair in the same column.
  3. Three rows have the values Brown, NULL, and Blue in the same column.
  4. One row has the value “He is interested in a Silver Porsche from the years 1978-1988” in a column.

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : B[/bg_collapse]
 
 
32) The data model that is produced from reverse engineering is

  1. a conceptual model
  2. an internal model
  3. a logical model
  4. None of the above

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : D[/bg_collapse]
 
 
33) How many copies of the database schema are typically used in the redesign process?

  1. One
  2. Two
  3. Three
  4. Four

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : C[/bg_collapse]
 
 
34) A relation is in this form if it is in BCNF and has no multivalued dependencies

  1. 2NF
  2. 3NF
  3. 4NF
  4. Domain/Key Normal Form

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : C[/bg_collapse]
 
 
35) If attributes A and B determine attribute C, then it is also true that:

  1. A – C
  2. B – C
  3. (A,B) is a composite determinant
  4. C is a determinant

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : C[/bg_collapse]
 
 
36) Specialization is which of the following processes?

  1. Defining one or more subtypes of the supertype and forming supertype/subtype relationships.
  2. Defining one or more supertypes of the subtype and forming supertype/subtype relationship
  3. Defining one or more subtypes of the supertype and not forming supertype/subtype relationships
  4. Defining one or more supertypes of the subtype and not forming supertype/subtype relationships

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : A[/bg_collapse]
 
 
37) When mapping a ternary relationship with an associative entity into a relation which of the following is true?

  1. One relation is created
  2. Two relations are created
  3. Three relations are created
  4. Four relations are created

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : D[/bg_collapse]
 
 
38) Use of a supertype/subtype relationship is necessary when which of the following exists?

  1. An instance of a subtype participates in a relationship that is unique to that subtype
  2. An instance of a subtype participates in a relationship that is the same as the other subtypes
  3. Attributes apply to all of the instances of an entity type
  4. No attributes apply to any of the instances of an entity type

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : A[/bg_collapse]
 
 
39) Which of the following is not one of the three ways to classify an action assertion?

  1. Condition
  2. Integrity Control
  3. Authorization
  4. Enabler

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : D[/bg_collapse]
 
 
40) When an entity instance may be a member of multiple subtypes or it does not have to be a member of a subtype, it is which of the following?

  1. Disjoint with total specialization
  2. Disjoint with partial specialization
  3. Overlap with total specialization
  4. Overlap with partial specialization

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : C[/bg_collapse]



 
41) Which of the following options help to achieve database scalability?

  1. Partitioning
  2. Compression
  3. ILM
  4. All of the above

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : D[/bg_collapse]
 
 
42) The process of reading a database schema and producing a data model from that schema is known as

  1. Data modelling
  2. Database Design
  3. Reverse Engineering
  4. None of the above

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : C[/bg_collapse]
 
 
43) Dimesions that can be used across multiple Data Marts in combination with multiple fact tables are known as

  1. Conformed Facts
  2. Junk Dimension
  3. Degenerated Dimension
  4. None of the above

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : A[/bg_collapse]
 
 
44) Which of the following  used to implement Hybird SCD’s?

  1. SCD1
  2. SCD2
  3. Both
  4. None of the above

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : C[/bg_collapse]
 
 
45) Bottom Up architecture of Datawarehouse

  1. Ralph Kimbol
  2. Bill Inmon
  3. All of the above
  4. None of the above

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : A[/bg_collapse]
 
 
46) Which of the following helps for faster results on reporting?

  1. Views
  2. Temporary tables
  3. Materialized Views
  4. None of the above

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : C[/bg_collapse]
 
 
47) Which of the following is prefered for aggregated facts?

  1. Semi-additive
  2. Non-additive
  3. All of the above
  4. None of the above

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : A[/bg_collapse]
 
 
48) Dollar value is a

  1. Semi-additive facts
  2. Additive Fact
  3. Non-additive facts
  4. None of the above

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : B[/bg_collapse]
 
 
49) Measure and metrics are

  1. Semi-additive facts
  2. Additive Fact
  3. Non-additive facts
  4. All of the above

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : C[/bg_collapse]
 
 
50) Loading only ongoing changes in the OLTP into ODS is

  1. Incremental Load
  2. Full load
  3. Partial load
  4. None of the above

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : A[/bg_collapse]



 
51) Which of the following is bottom-up approach in which two lower level entities combine to form a higher level entity?

  1. Specialization
  2. Generalization
  3. Reverse Engineering
  4. None of the above

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : B[/bg_collapse]
 
 
52) A pilot can fly three types of planes and a plane can be piloted by any qualified pilot. The pilot-plane type relationship is

  1. N:3
  2. 3:N
  3. 1:3
  4. 3:1

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : A[/bg_collapse]
 
 
53) Data integrity is ensured by

  1. good data editing
  2. propagating data changes to all data items
  3. preventing unauthorized access
  4. preventing data duplication

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : B[/bg_collapse]
 
 
54) A check pointing system is needed

  1. to ensure system security
  2. to recover from transient faults
  3. to ensure system privacy
  4. to ensure system integrity

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : B[/bg_collapse]
 
 
55) Data integrity in a file based system may be lost because

  1. the same variable may have different values in different files
  2. files are duplicated
  3. unnecessary data is stored in files
  4. redundant data is stored in files

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : A[/bg_collapse]
 
 
56) Data independence allows

  1. sharing the same database by several applications
  2. extensive modification of applications
  3. no data sharing between applications
  4. elimination of several application programs

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : A[/bg_collapse]
 
 
57) DBMS must implement management controls to
(i) control access rights to users
(ii) implement audit trail when changes are made
(iii) allow data to be used extensively in the organization
(iv) duplicate databases

  1. i, ii
  2. ii, iii
  3. iii, iv
  4. i, iv

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : A[/bg_collapse]
 
 
58) Designing physical model of DBMS requires information on
(i) data volume
(ii) frequency of access to data
(iii) programming language used
(iv) secondary memory characteristics

  1. i, ii
  2. i, ii, iii
  3. i, ii, iii, iv
  4. i, ii, iv

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : D[/bg_collapse]
 
 
59) When a logical model is mapped into a physical storage such as a disk store the resultant data model is known as

  1. conceptual data model
  2. external data model
  3. internal data model
  4. disk data model

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : C[/bg_collapse]
 
 
60) Data independence allows
(i) no changes in application programs
(ii) change in database without affecting application programs
(iii) hardware to be changed without affecting application programs
(iv) system software to be changed without affecting appl

  1. i, ii
  2. ii, iii
  3. ii, iii, iv
  4. i, ii, iv

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : C[/bg_collapse]



 
61) A good database design
(i) caters primarily to current needs
(ii) caters to current and future needs as organizations grow
(iii) has to be modified when hardware is upgraded
(iv) ensures data security

  1. i, ii
  2. i, ii, iii
  3. ii, iv
  4. iii, iv

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : C[/bg_collapse]
 
 
62) A good database design
(i) is expandable with growth and changes in organization
(ii) easy to change when software changes
(iii) ensures data integrity
(iv) allows access to only authorized users

  1. i, ii
  2. ii, iii
  3. i, ii, iii, iv
  4. i, ii, iii

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : C[/bg_collapse]



 

Related Articles

Advanced Manufacturing Process Quiz

Web analytics, Adobe Analytics, Google Analytics Quiz

SailPoint Quiz