National Examinations Board Grade 12 Computer Science — Model Question 2079 (2023)

National Examinations Board · Computer Science (Grade 12) · 2079 (2023) BS · Model Question — 16 questions — a free old question paper on Goodone.club’s exam-paper archive.

  1. In which normal form of a database is atomicity introduced? (A) First (B) Second (C) Third (D) Fourth [1 marks]
  2. Which type of database system (centralized or distributed) is mostly preferred by financial institutions like a bank? Give any four suitable reasons. [1+4] OR Nowadays most business organizations prefer applying the relational model for database design compared to other models. Justify the statement with your arguments. [5] [5 marks]
  3. Why do most business organizations prefer setting up their network with the client-server architecture? Write its advantages and disadvantages. [2+6] [8 marks]
  4. Which of the following techniques is not implemented to protect a database? (A) Rollback (B) Backup (C) Recovery (D) Firewall [1 marks]
  5. Develop a program in JavaScript to exchange/swap the values of any two variables. [5] OR How can you connect a database with PHP? Demonstrate with an example. [5] [5 marks]
  6. Develop a program in C using a structure to ask for the information of any 12 students with roll_number, name and marks scored in sub1, sub2 and sub3. Also display them in proper format along with the calculation of total and percentage. (Note: the full marks of each subject is 100.) OR Demonstrate a program in C to create a data file named score.dat to store students' information with Reg_no, name, gender and address. The program should ask the user whether to continue; when finished, it should display all records in the proper format. [8 marks]
  7. Which SQL command displays all records having the second letter in LNAME (last name) as "A" from the customer table? (A) SELECT * FROM CUSTOMER WHERE LNAME LIKE "?A%"; (B) SELECT * FROM CUSTOMER WHERE LNAME LIKE "_A%"; (C) SELECT * FROM CUSTOMER WHERE LNAME LIKE "A%"; (D) SELECT * FROM CUSTOMER WHERE LNAME LIKE "%A"; [1 marks]
  8. Describe the concept of object-oriented and procedure-oriented programming in brief. [2+3] [5 marks]
  9. Which of the following is an incorrect IP address? (A) 192.168.0.1 (B) 192.168.1 (C) 172.255.0.0 (D) 202.10.79.4 [1 marks]
  10. Write down any five qualities of good software. [5] [5 marks]
  11. Which of the following is a server-side scripting language? (A) JavaScript (B) MySQL (C) PHP (D) jQuery [1 marks]
  12. Explain mobile computing with its advantages and disadvantages. [5] [5 marks]
  13. Which of the following keywords are used to declare a variable in JavaScript? (A) int or var (B) float or let (C) var or let (D) char or var [1 marks]
  14. Which of the following commands is executed in PHP to concatenate the variables $x with $y? (A) $x + $y (B) $x = $y (C) concat($x, $y) (D) $x.$y [1 marks]
  15. Which statement is incorrect about the object-oriented approach? (A) Emphasis is on data rather than procedure (B) Data is hidden and cannot be accessed (C) Objects communicate through functions (D) It supports abstract data but not the class [1 marks]
  16. Which of the following feasibility studies is concerned with cost-benefit analysis? (A) Technical feasibility (B) Economic feasibility (C) Operational feasibility (D) Schedule feasibility [1 marks]