questions on DATA DICTIONARY

1)      What are the different types of data dictionary objects?

Ans :  Tables – Data Elements – Domains  -  Structure – Foreign Keys

2)      How many types of tables exist and What are they in data dictionary?

Ans : Transparent Tables -  Pooled Tables – Cluster Tables

3)      What is the step by step process to create a table in data dictionary?

Ans : Create Domain – Create Data elements – Create fields – Create Tables

4)      Can a transparent table exist in data dictionary but not in the database physically?

5)      What are the domains and data elements?

Ans : domain describes Technical Characteristics of a table fields e.g. value range

6)      Elements describe role played by a fields in technical contains e.g. Form of field text.

7)      Can you create a table with fields not referring to data elements?   

Ans : yes