(XII) NEB Computer 2080(2023)

NEB – GRADE XII 2080 (2023) Computer Science New Course – Regular Students Candidates are required to give their answers in their own words as far as practicable. The figures in the margin indicate full marks. Time: 2 hrs. Full Marks: 50 Group ‘A’ Very short answer questions. 9×1=9 1. Which of the given sign is used as a shortcut for JQuery? (a) the % sign (b) the & sign (c) the $ sign (d) the @ sign 2. Which of the following is DML statement? (a) Create (b) Select (c) Create view Alter (d) Drop 3. A collection of hyperlinked documents on the internet is called (a) HTML (b) Webpage (c) www (d) email system 4. Which of the following IPv4 address valid? (a) 192.168.1.1 (b) EEE.000.33.000 (c) 257.2.5.1 (d) 202.70.71.262 5. Which jQuery method is used to hide selected elements? (a) hide() (b) hide(on) (c) invisible() (d) display(none) 6. Which function is used to connect to MySQL database? (a) mysqli_open() (b) mysqli_connect() (c) var mysqli_query() (d) $mysqli_con() 7. Which of the following is true about FILE *fpt? (a) FILE is a keyword in c for representing files and ftp is a variable of FILE type. (b) FILE is a buffered stream (c) FILE is a stream (d) FILE is a structure and fpt is a pointer to the structure of FILE type 8. Which of a SDLC phase is used to ensure quality software? (a) Implementation (b) Maintenance (c) Testing (d) System Study 9. Coaxial cable is an example of …. (a) Communication software (b) Guided Transmission Media (c) Unguided Transmission Media (d) All of the above Group ‘B’ Short answer questions 5×5=25 10. Explain the Relational Data model with example. (5) OR Write SQL DDL commands to execute the following task with reference to the schema given below: student_info ( regno as integer, name as character(25), class integer, gender character(1), address character(25) ). 11. Define syntax for database connectivity. Write a server side scripting code to insert data into the table student having fields (first name, last name, mark and email). Assume that server name= “localhost”, username=”root”, password=” “, database name=”student DB”. (1+4) OR Write a JavaScript code to calculate the factorial of a given number. (5) 12. How is even-driven program (or OOP) differing from procedural-oriented programming? Explain. (5) 13. Explain the importance of the system testing of the system development life cycle (SDLC). (1+4) 14. What is cloud computing? Point out the advantages and disadvantage of cloud computing. (5) Group ‘C’ Long answer questions 2×8=16 15. What is network topology? Differentiate between guided (wire media) and unguided (wireless media) with example. (2+6) 16. Write the advantage of pointer? Write C program to enter the radius of a football and find the area of football by using user defined function. (3+5) OR Define the structure. Write a C program using structure to input staff id, name and the salary of 50 staffs. Display staff id, name and salary of those staff whose salary range from 25 thousand to 40 thousand. (2+6) THE END