We have sent an email with your new password.


Data Modeling Test1

15 Questions  I  By Sudha_test
Data Modeling Test1
Test your understanding of Data Modeling concepts

  
Changes are done, please start the quiz.


Question Excerpt

Removing question excerpt is a premium feature

Upgrade and get a lot more done!
1.  Data modellinData modelling is the process of constructingg is the process of constructing
A.
B.
C.
D.
2.               The following data base table design is an   example of ---------------------------------                                                                                                  
PRODUCT
   Product Identifier(PK)
Product Category Name Product subCategory Name Product  Name Product  Feature Description
       
LOCATION
      Location  Identifier(PK)
Country Name State  Name city  Name ate Timestamp
                                  
  Sales
Organization  Identifier(PK) Product Identifier(PK) Location  Identifier(PK)
Sales DollarAverage sales Date and Timestamp
                                                                                                                                          
Organization
Organization  Identifier(PK)
Corporate office Name Region  Name Brach  Name Employer Name Date and Timestamp
                                                                          
A.
B.
C.
D.
3.  Dimensional table stores records related to that particular  dimension and no measures are stored  in these tables
A.
B.
4.  Data Model is a representation  of data
A.
B.
5.  Data Modeler focus on what operation performed on the data  rather than requirement of the data
A.
B.
6.  You are hired by one client for designing a database for Air line transcation. The data base has to capture the detailed level of data related to the tickets booked by the user and the updations made by them with timestamp.Which database model do you prefer?
A.
B.
C.
D.
7.  Online Analytical Processing is also called as
A.
B.
C.
D.
8.  OLTP stores detail level of data
A.
B.
9.  Logical Data model  does not contain much detail level of information about the attributes
A.
B.
10.  Dimensional model holds current data
A.
B.
11.  The Logical Data Model (LDM) is derived from the Conceptual Data Model (CDM).
A.
B.
12.  Data Model helps not store the redundant data
A.
B.
13.  An OLTP data base is designed to handle the day to day needs of a business
A.
B.
14.  Physical level of Data abstraction deals with
A.
B.
C.
D.
15.  Information in the data model are applied to define
A.
B.
C.
D.
Back to top

Removing ad is a premium feature

Upgrade and get a lot more done!
Take Another Quiz