Font size
WorksheetsRemedial Examination (Programming)
Total questions: 25
Worksheet time: 25mins
Display only columns FirstName, LastName and rows from Contacts table where FirstName is Rodel.
(a)
Display only columns EmployeeID, FirstName FROM Contacts table.
(a)
Display only columns EmployeeID, FirstName FROM Employees table.
(a)
Add new record into Employees table.
(a)
Add new record into Contacts table.
(a)
Display all columns and rows from Contacts table where FirstName is Ronnie.
(a)
Display only row 1009 from Contacts table.
(a)
Display only columns FirstName, LastName and rows from Employees table where FirstName is Lanie.
(a)
Display only row 1 from Employees table.
(a)
Display only columns FirstName, LastName and rows from Contacts table where LastName is Ann.
(a)
Display only columns ContactID, FirstName, LastName and rows from Contacts table
(a)
Display only columns FirstName, LastName and rows from Contacts table where LastName is Madriaga.
(a)
Display only columns FirstName, LastName and rows from Contacts table where LastName is Angeles.
(a)
Display all columns and rows from Contacts table where LastName is Tan.
(a)
Display all columns and rows from Employees table where FirstName is Angelo.
(a)
Display all columns and rows from Employees table where LastName is Molina.
(a)
Display only columns FirstName, LastName and rows from Contacts table where LastName is Evangelista.
(a)
Display only columns FirstName, LastName and rows from Employees table where LastName is Uy.
(a)
Display all columns and rows from Employees table where FirstName is Randy.
(a)
Display all columns and rows from Employees table where LastName is Garcia.
(a)
Display all columns and rows from Contacts table.
(a)
Create new database and named as DBEmployees.
(a)
Create new table and named as Employees.
(a)
Display all columns and rows from Employees table.
(a)
Create new table and named as Contacts.
(a)
