What SQL command is used to de-normalize dataa.Create Tableb.Create Sequencec.Create Viewd.Create Snowflake
Two Characteristics of NoSQL databases are:a.Open Source and created after the year 2000b.Non-Normalized and uses JSONc.Open Source and Non-Normalizedd.Uses JSON and created after the year 2000
The Type of database used in Facebooka.Graph c.A & Bb.NoSQL d.None of the above
When assigning access rights to a Database the following rule(s) should be followed a. Grant access to entire tables instead of individual fieldsb.Contractors should not be given any access to the databasec.A & Bd.None of the above A snowflake design has this many fact tablesa.Noneb.Onec.Unlimitedd.N-1 Limiting access to aggregate functions in NOT a good security measure because:aSQL injection easily overcomes this feature.b.Users often use easy to guess passwords.c.It is easy to determine single record values using multiple criteria.d.Oracle stores the individual record values in all aggregate functions.’Term for temporarily linking tables togethera.Joinb.Viewc.Link Tabled.Normalization
