Q1. Why is SQL such a good database language?
It is easy to use SQL is highly popular because it offers advantages SQL queries can be optimized SQL allows users to describe the data SQL is a structured query language C and D
Q2. In slowly changing dimensions,Type 2 and Type 3 keep historic records of the changed data?
True False
Q3. Measures are linked to dimension tables through?
Primary key Unique keys Foreign keys Surrogate keys None of the above
Q4. No level of redundancy is required for a perfect database.
False True
Q5. Primary key on a table will automatically create a clustered index on that table.
True False
Q6. You can have many_____keys on a table but only one_____key
Primary key , unique key Foriegn keys ,primary keys Foreign key ,unique key Unique key , primary key