NEB Past questions

1. Javascript

2. PHP

3. Chapter 7: Recent trends in Technology

4.Chapter Wise Important Question 

5. NEB 2082

6.NEB 2081

7.NEB 2080

8.NEB 2079

9.Model Question by CDC-2079


Write the SQL statement to perform the following task.

a. Create a table named Employees with the following fields and insert five records.

Employee_ID
Name
Department
Address
Salary

b. Add a new field named Position in the above table.

c. Display Name, Department, and Address of all employees from the table Employees.

d. Display all the records of employees whose Address is "Kathmandu".

e. Display Employee_ID, Name, and Salary from the table Employees.

f. Increase the Salary of all employees by 10%.

g. Update the Name and Department of an employee to "Ramesh" and "Finance" whose Employee_ID is 5.

h. Delete the record of the employee named Sita.

i. Display all the records in ascending order by Name.

j. Display all the records whose Name starts with "A".

k. Display the records of employees whose Department is "IT" and lives in Kathmandu.

l. Display the record of employees whose Salary lies between 30,000 and 60,000.

Popular posts from this blog

Computer

Sequential Programs