ICT Past Paper Essay and Struture 1

Answer all Questions yourself and click the button CheckForAnswer to get  correct answers.

1. The following statement has been used to create a table in a database.
   
   create table student(student_no char(5), name char(30), address char(100), primary key (student_no))
   
   
   1. Write a query in SQL to add the following data to the student table.
      student number - 10001
      Name - Saman Kumar
      address - 78, Mahara Road, Maharagama
      
      
      
      
   2. If the address of the student entered in the above should be changed to 13, School Lane, Jaffna. write a query in SQL to update the relevant record in the student table.
      
      
   
   
2. 1. In an operating system, what are the events that change the state of a process in the 'running' state?
      
      
      
      
      
   2. Explain the main actions performed by an operating system during context switching.
      
      
      
      
      
   3. Explain what will happen during the booting process of a computer.
      
      
      
      
      
3. The memory of a computer system is byte addressable and has a maximum usable size of 4GB. What is the minimum width of its address bus in bits? Show all you working clearly.