(OLD Question)NEB GRADE XII 2081 ( 2024 ) Computer Science Queston

 

(OLD Question Grade Improvement Exam)NEB GRADE XII 2080 ( 2023 ) Computer Science Queston

 NEB – GRADE XII

2080 (2023)

Computer Science

Grade Increment (Supplementary) Examination

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 SQL keyword is used to retrieve data from a table? (a) SELECT (b) FROM (c) WHERE (d) JOIN 2. Which of the following principle apply to 2NF? (a) a table must have a primary key (b) all non-key attributes must be dependent on the primary key (c) all attributes must be atomic (d) a table must have at least more than two attributes 3. Which of the following is a device that connects two or more networks and can filter and forward network traffic based on its destination address? (a) switch (b) router (c) hub (d) modem 4. Which JavaScript function use to text input? (a) alert() (b) prompt() (c) confirm() (d) console.log() 5. Which of the following PHP functions is used to connect to a MySQL database? (a) mysql_connect() (b) mysqli_connect() (c) pdo_connect() (d) db_connect() 6. What is the correct way to open a file named “data.txt” in C for reading? (a) fopen(“data.txt”,”r”); (b) fopen(“data.txt”,”w”); (c) fopen(“data.txt”,”a”); (d) fopen(“data.txt”,”rb”); 7. Which of the following concepts in object-oriented programming refers to binding data and function into a single unit. (a) Encapsulation (b) Abstraction (c) Polymorphism (d) Inheritance 8. What does the term “QA” stand for in the software development process? (a) Quality Assurance (b) Quality Analysis (c) Quality Assessment (d) Quantity Assurance 9. What type of communication technology is commonly used in IoT devices? (a) Wi-Fi (b) Bluetooth (c) Zigbee (d) All of the above

Group ‘B’

Short answer questions 5×5=25

10. Describe the second normal form (2NF) with an example. OR What are the importance of database security in database management systems? Describe. 11. How do you add an event handler in JavaScript? Give an example. OR Explain the database connection PHP function for MySQL. 12. Describe the object and class in OOPs with an example. 13. Explain the agile software development methodology in brief. 14. Give any five examples of AI related applications.

Group ‘C’

Long answer questions 2×8=16

15. Compare the bus and star network topology. Which of the network cable is suitable to design star topology in the school’s network? Justify. 4+4 16. Write a program to store five employees’ records (EID, Name, post and department) and display them using structure. OR Describe file handling modes on C. Write a C program to create and write data into a file. 4+4

THE END

(XII) Marking Scheme of NEB Computer 2080(2023)

  NEB – GRADE XII

2080(2023) New Course Computer Science (4281) Marking SchemaFull Marks: 50Group A
(Multiple Choice Questions) 9×1=9Correct option of Multiple-choice questions (1 Marks for correct option) Q.N. 1 (c) the $ sign Q.N. 2 (b) select Q.N. 3 (c) www Q.N. 4 (a) 192.168.1.1 Q.N. 5 (a) hide ( ) Q.N. 6 (b) mysqli_connect() Q.N. 7 (d) FILE is a structure and fpt is a pointer to the structure of FILE type Q.N. 8 (c) Testing Q.N. 9 (d) Guided Transmission MediaGroup B
(Short Answer Questions) 5 × 5 = 25Q.N.10 Explain the Relational database model with an example. (5) - Definition of relational data model – 1 mark - Use of explanation of any three terminologies; such as relation, tuple, field , primary key, domain and integrity constraints – 3 marks - Diagram for relational data model- 1 mark Based on the above partial points and concepts will be scored partial marks Q. No. 10 : OR Write SQL DDL command 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)). [5 marks] Here's a suggested marking scheme for the given task: (1) Correct syntax and table creation (2 marks) - Allot 2 marks if the CREATE TABLE statement is correct and creates a table with the specified table name, columns and data types. (2) If column names and data types match the provided schema. (1 mark) (3) If column lengths are according to the provided schema. (1 mark) (4) Overall structure and readability (1 mark) - Allot 1 mark for correctly aligning and formatting with proper indentation and spacing to the SQL statement. - An indentation is the space at the beginning of a line of writing when it starts further away from the edge of the paper than all the other lines. Note : Data type can be integer or int and character or char. Q. No. 11: Define syntax for database connectivity. Write a server side scripting code to insert data into a table student having fields (first name, last name, mark and email). Assume that server name= “localhost”, username= “root”, password="", database name= "studentDB". [5] Give any one syntax for database connection:- 1 mark Syntax: $con=new mysqli($servername,$username,$password,$database); OR $con=mysqli_connect($servername,$username,$password,$database); <?php // step 1: Database configuration. :- 1 marks for steps 1 and 2. e.g. : $servername= “localhost”; $username= “root”; $password= " "; $database= “studentDB”; // step 2: Establish a connection to the database e.g. $con=new mysqli($servername,$username,$password,$database); Note: Above steps 1 and 2 can be in a single line. //Step 3: Check if the connection was successful:- 1 mark e.g. if($con->connect_error) { die(“Connection failed:”.$con->connect_error); } //Step 4: Prepare the SQL statement for insertion:- 1 mark e.g.: $sql= "INSERT INTO student (first_name,last_name,mark,email) VALUES ("Ram", "Sah",45, "ramsah@gmail.com")"; //Step 5: Execute the SQL statement:- 1 mark for steps 5 and 6 e.g.: if($con->query($sql) = = = true) { echo "Data inserted successfully"; } else { echo “Error:”.$sql. “<br>”.$con->error; } //step 6: close the database connection e.g. : $con->close(); ?> Above partial points and concepts will be scored partial marks Q. No. 11: OR
Write a JavaScript code to calculate the factorial of a given number. [5] 1. Correct syntax and its structure – 1 mark Award 1 mark if the JavaScript code has the correct syntax and structure, including proper indentation and formatting. 2. Proper variable declaration and assignment- 1 mark Allot 1 mark if the code declares a variable to store the factorial result and assigns an initial value to it. 3. Handling of input and error conditions- 1 mark Allot 1 mark if the code correctly handles input validation and error conditions, such as checking if the input is a positive integer. 4. Looping and factorial calculation with proper display of the output- 2 marks Allot 1 mark if the code uses a loop (such as for loop or while loop) to calculate the factorial of the given number and displays the result accurately. Note: The marking scheme provided is subjective and may vary depending on the specific requirements provided by your instructor. Q. No. 12: How is an event-driven program (or OOP) differing from procedural oriented programming language? Explain. Full Marks(5)

1. Code in the module/function VS class/object – 1 mark 2. The OOPs features VS procedural language features – 2 marks 3. Code reusability/ flexibility/modification concept, data security etc. – 1 mark 4. Example of both programming languages – 1 mark Above partial points will be scored partial marks. Q. No. 13: Explain the importance of the system testing of the system development life cycle (SDLC). Full Marks(5) 1. Define the system testing – 1 mark 2. Explain the importance of system testing – 4 marks (At least four points or keywords can be included like validation and verification, Error Detection and correction, reliability and Quality Assurance, and cost and risk reduction). Above partial points will be scored partial marks. Q. No. 14: What is cloud computing? Point out the advantage and disadvantage of cloud computing Full Marks(5) 1. Definition of cloud computing and example. – 2 marks 2. List of the advantages and disadvantages of cloud computing – 3 marks Above partial points will be scored partial marks.

Group C: Long Answer Questions (2×8=16) Contents Area and Marks Schema: Q. No. 15 : What is network topology? Differentiate between guided (wire media) and unguided (wireless media) with example. Full Marks(4+4)

1. Define network topology with an example. – 2 marks 2. Six differences between guided and unguided with an example – 6 marks Above partial points will be scored partial marks. Q. No. 16: Write the advantage of pointer? Write a C program to enter the radius of a football and find the area of football by using user defined function Full Marks (8)

1. Define the pointer with syntax – 1 mark NEB XII computer Marking Scheme 2080 Page 3 2. Write the four advantages of the pointer – 2 marks 3. Declaration and preparation of a user defined function to calculate area on the basis of radius input – 3 marks 4. Execution of function with the proper display of output – 2 marks The above partial concept of a calling function, declaration of a function, and function definition in C will be scored partial marks. Q. No. 16 : OR Define 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. Full Marks(8)

1. Define the structure Definition (2 marks) Provide a concise definition of a structure in C. For example: “In C, a structure is a user-defined data type that allows grouping together related variables of different types. It is defined using the ‘struct’ keyword followed by the structure name and a set of curly braces.” The definition is expected with either an example or key features or purpose as well. 2. Marking scheme for program preparation (6 marks)  Proper structure definition (1 mark) o Proper structure definition and member variables: Award 1 mark if the program includes a structure definition for storing staff information, including member variables for staff if, name and salary.  Input of staff information (1 mark) o Allot 1 mark if the program correctly prompts the user to input the staff id, name and salary for each of the 50 staff members o The program should store the inputted information in an array or any suitable data structure.  Display of staff information within salary range with proper filtering verification ( 3 mark) o Allot 1 mark for the proper loop setting to select each staff‟s data o Allot 1 mark for the proper condition setting for selection of the salary range between 25,000 and 40,000. o Allot 1 mark for the display of staff records matching the criteria  Overall clarity and coherence (1 mark) o The program should be well-organized, logically presented, and easy to understand. The above partial concept of array of structure and use logic in C will be scored partial marks

(OLD Question)NEB GRADE XII 2080 ( 2023 ) Computer Science Queston

 

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

Chapter : 1 DBMS Handwritten Notes

Advantages of a DBMS over a flat-file system:

1. Data integrity: A database system enforces data constraints and relationships, ensuring that the data is accurate and consistent.
2. Data independence: A database system allows for changes to be made to the structure of the data without affecting the applications that use the data.
3. Concurrent access: A database system allows multiple users to access the same data simultaneously, without interfering with each other.
4. Data security: A database system provides various security mechanisms to control access to the data and prevent unauthorized access.
5. Data sharing: A database system allows for data to be easily shared among different applications and users.
6. Data Backup and Recovery: Database system provides various options for data backup and recovery, which makes it easy to recover data in case of any failure.

 More Notes will be continued ...

More Notes will be continued ...

(Book Collection) Computer Science XII book of Kriti publication/Buddha publication/Ocean publication

 CLICK ME to get Kriti publication book of computer science XII

CLICK ME to get Buddha publication book of computer science XII

CLICK ME to get Ocean publication book of computer science XII

(XII) Marking Scheme of NEB Computer 2079(2022)

                                                                              Marking

Schema

Group A: Correct option of Multiple-choice questions (1 Marks for correct option)

Q No	Options	Correct Answer	Q No	Options	Correct Answer
1	A	DELETE	6	B	1234   1234
2	A	Primary Key	7	D	Inheritance
3	B	Media Access Control	8	B	Requirement  Elicitation
4	A	<script src= “myscript.js”></script>	9	D	Sensors
5	B	$variable_name=value;

Group B: Short answer questions (5×5=25) Contents Area and Marks Schema:

Q.N0 10 :	Differentiate the centralized and distributed database system
Full Marks(5)	·         Data Storage and server in single location vs server location – 1 mark ·         Single server vs multiple node – 1 mark ·         Central Data storage vs data fragmentation – 1 mark ·         Diagram of centralized vs distributed – 1mark ·         Risk/benefit/control concept of both database -1 mark Based on the above partial points and concepts will be scored partial marks.
Q. No. 10 : OR	What are the purposes of normalization? Give an example of 2NF normalization.
Full Marks(5)	·         Concept of removing the data redundancy -1 mark ·         Concept of removing of insert, update, delete anomalies -1 mark ·         Functional dependency concepts - 2 marks Above partial points and concepts will be scored partial marks.
Q. No. 11:	Write a program to find the factorial of any given number using Java Script
Full Marks(5)	·         Properly start the Java Script and close  - 1 Mark ·         Write a script to find factorial of given any number-4 mark Above partial script of factorial and concept will be scored partial marks
Q. No. 11: OR	How do you fetch data from database in PHP and display it in form?
Full Marks(5)	·         PHP and MySQL database connection class or procedure – 2 marks ·         Data fetch PHP script such as example of mysqli_connect() , mysqli_query() , mysqli_fetch_assoc() or similar use of function – 2 mark ·         SQL Select statement in a script to access data – 1 mark Above partial script and code will be scored partial marks.
Q. No. 12:	Compare the OOPs and procedural programming language.
Full Marks(5)	·         Code in model/function vs class object – 1 mark ·         OOPs features Vs Procedural language features – 2 marks ·         Code reusability/flexibility/modification concept-1 mark ·         Example of both programming languages – 1 mark Above partial points will be scored partial marks.
Q. No. 13:	What are the major activities performed to design the software? Describe.
Full Marks(5)	·         List or points of software design activities such as architecture designing, database design, user interface design, algorithmic designing-2 marks ·         Case tools handling or similar design activities concepts or diagram names- 3 marks Above partial points will be scored partial marks
Q. No. 14:	Explain the popular five application areas of AI.
Full Marks(5)	·         List of AI applications such as machine learning, robotics, natural language processing, and machine vision etc or similar types of application in any five areas of AI. (0.5×5=2.5 marks) and each area very short description. (0.5×5=2.5) Above partial points will be scored partial marks.

 

 

 

 

 

Group C: Long Answer Questions (2×8=16)               Contents Area and Marks Schema:

Q. No. 15 :	Compare the star and ring topology with pros and cons. Which of data communication cable is more appropriate to design the local area network? Describe.
Full Marks(4+4)	·         Compare star and ring topology with figure – 2 marks ·         Star and Ring topology pros and cons – 2 mark ·         Concept of  local area network- 1 mark ·         Appropriate partial cable such as UTP or CAT-6 with description (cost, distance, technology)- 3 marks Above partial points will be scored partial marks.
Q. No. 16:	What is structure? Write a program to input roll, name and age of 5 students and display them properly using structure. (2+6)
Full Marks (2+6)	·         Define structure- 2mark ·         Input and display 5 students data using structure including loop with complete C executable code – 6 marks Above partial concept of structure ; looping code and used logic in C will be scored partial marks range of 1-6 marks
Q. No. 16 : OR	Write a C program to enter ID, employee_name, and post of the employee and store them in a data file named “emp.txt”. Display each record on the screen in an appropriate format. (5+3)
Full Marks(5+3)	·         Code for showing the pointer and file opening mode – 2 marks ·         Code for entering and store C programming code allocated 5 marks using file handling functions – 3 marks ·         Code for Display data in C programming using file handling functions – 3marks Above partial concept of file handling and used logic in C will be scored partial marks range of 1-6 marks.