SQL EMPLOYMENT TEST

1.) Describe each of the following:

 a.) First Normal Form

b.) Second Normal Form

c.) Third Normal Form 

d.) Domain Integrity

 e.) Referential Integrity

 f.) Entity Integrity

2.)  Looking at the SQL Statement below what is the advantage or disadvantage of using the following statement?

 Select * from tblCustomerMain

3.) Provide the output values for the following query. 

DECLARE @myVariable AS varchar(15)

DECLARE @myNextVariable AS char(15)

SET @myVariable = 'abc'

SET @myNextVariable = 'abc'

SELECT DATALENGTH(@myVariable)as Datalength1, DATALENGTH(@myNextVariable)

as DataLength2;

Next Set->