What SQL command is used to de-normalize data a.Create Table b.Create Sequence c

Question

What SQL command is used to de-normalize data

a.Create Table
b.Create Sequence
c.Create View
d.Create Snowflake

Two Characteristics of NoSQL databases are:

a.Open Source and created after the year 2000
b.Non-Normalized and uses JSON
c.Open Source and Non-Normalized
d.Uses JSON and created after the year 2000

The Type of database used in Facebook
a.Graph c.A & B
b.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 fields
b.Contractors should not be given any access to the database
c.A & B
d.None of the above

A snowflake design has this many fact tables
a.None
b.One
c.Unlimited
d.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 together
a.Join
b.View
c.Link Table
d.Normalization

Explanation / Answer

1) d

CREATE Snowflake

2) b and c

non normalized and uses JSON

open source and non normalized

3) a and b

Graph and NoSQL

4) c

A and B

5) c

unlimited

6) c

7) a

join

Related Questions

Navigate

• Browse (All)
• Browse W
• Subjects

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.