MSSQL Day-7

What is the main goal of normalization?

• Increase redundancy

• Decrease performance

• Eliminate redundancy

• None of the above

Which normal form eliminates repeating groups?

• 1NF

• 2NF

• 3NF

• BCNF

Which one is not a benefit of normalization?

• Data integrity

• Reduce redundancy

• Easier queries

• Complex joins

(a)   eliminates transitive dependency.

Data (a)   leads to data anomalies.

What is the purpose of authentication?

• Grant access to resources

• Identify who the user is

• Encrypt data

• Improve UI

Authorization determines:

• Who the user isWhat the user can access

• What the user can access

• The password strength

• IP address

Which token format is commonly used in authentication systems?

(a)  

In web applications, authentication data is usually stored in:

• Cookies or tokens

• CSS

• JavaScripts

• Images

The (a)   HTTP status code represents unauthorized access.