LAB 1
1)

2)

3)

4)

5)

6)

LAB-2
1)

2)

3)

4)

5)

LAB-3
1)
CREATE INDEX upper_ix ON EMPLOYEE_REC (UPPER(Lname));
2)
SELECT Fname, Lname
FROM EMPLOYEE_REC
WHERE UPPER(Lname)= “SMITH”;
Other Links:
See other websites for quiz:
Check on QUIZLET
LAB 1
1)

2)

3)

4)

5)

6)

LAB-2
1)

2)

3)

4)

5)

LAB-3
1)
CREATE INDEX upper_ix ON EMPLOYEE_REC (UPPER(Lname));
2)
SELECT Fname, Lname
FROM EMPLOYEE_REC
WHERE UPPER(Lname)= “SMITH”;
Check on QUIZLET
Hey mark we loved it