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

Answer : A

 
 
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

Answer : A

 
 
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

Answer : B

 
 
4) Stronger version of the third normal form

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

Answer : B

 
 
5) Design is optimal for Warehouse

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

Answer : D

 
 
6) Table used  while  updating  data in  DWH

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

Answer : C

 
 
7) LOWEST level of information that will be stored in the fact table.

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

Answer : C

 
 
8) facts that cannot be summed up for any of the dimensions

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

Answer : A

 
 
9) Time

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

Answer : C

 
 
10) Data captured by Slowly Changing Dimensions (SCDs) change slowly but unpredictably

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

Answer : A




 
11) Single fact table connected to dimension tables

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

Answer : B

 
 
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

Answer : D

 
 
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 .

Answer : A

 
 
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

Answer : A

 
 
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

Answer : B

 
 
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

Answer : D

 
 
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

Answer : B

 
 
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

Answer : B

 
 
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

Answer : A

 
 
20) Which of the following is HAS-A relationship?

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

Answer : D




 
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

Answer : B

 
 
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

Answer : B

 
 
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

Answer : D

 
 
24) A multidimensional database model is used most often in which of the following models?

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

Answer : A

 
 
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.

Answer : B

 
 
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

Answer : A

 
 
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

Answer : C

 
 
28) For every relationship, how many possible types of actions are there when enforcing minimum cardinalities?

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

Answer : D

 
 
29) For every relationship, how many possible sets of minimum cardinalities are there?

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

Answer : C

 
 
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

Answer : C




 
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.

Answer : B

 
 
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

Answer : D

 
 
33) How many copies of the database schema are typically used in the redesign process?

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

Answer : C

 
 
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

Answer : C

 
 
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

Answer : C

 
 
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

Answer : A

 
 
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

Answer : D

 
 
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

Answer : A

 
 
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

Answer : D

 
 
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

Answer : C




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

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

Answer : D

 
 
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

Answer : C

 
 
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

Answer : A

 
 
44) Which of the following  used to implement Hybird SCD’s?

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

Answer : C

 
 
45) Bottom Up architecture of Datawarehouse

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

Answer : A

 
 
46) Which of the following helps for faster results on reporting?

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

Answer : C

 
 
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

Answer : A

 
 
48) Dollar value is a

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

Answer : B

 
 
49) Measure and metrics are

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

Answer : C

 
 
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

Answer : A




 
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

Answer : B

 
 
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

Answer : A

 
 
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

Answer : B

 
 
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

Answer : B

 
 
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

Answer : A

 
 
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

Answer : A

 
 
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

Answer : A

 
 
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

Answer : D

 
 
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

Answer : C

 
 
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

Answer : C




 
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

Answer : C

 
 
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

Answer : C




 

Related Articles

Advanced Manufacturing Process Quiz

Web analytics, Adobe Analytics, Google Analytics Quiz

SailPoint Quiz