Learn ComputerXII With Madhav

 

  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 JavaScr...

  NEB – GRADE XII 2080(2023) New Course Computer Science (4281) Marking Schema Full Marks: 50 Group A (Multiple Choice Questions) 9×1=9 Correct 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 Media Group B (Short Answer Questions) 5 × 5 = 25 Q.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 ...

  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() ...

SYLLABUS: 1.1 Introduction to data, database, Database system, DBMS 1.2 Field, Record, Objects, Primary Key, Alternate key, Candidate key 1.3 Advantages of using DBMS 1.4 DDL (Data Definition Language) and DML (Data Manipulation Language) 1.5 Database Model: Network Model, Hierarchical Model, Relational database model 1.6 Concept of Normalization: 1NF, 2NF, 3NF 1.7 Centralized Vs. Distributed Database 1.8 Database Security Advantages of a DBMS over a flat-file system: 1. Improved Data Security: DBMS protects data by allowing access only to authorized users, ensuring that sensitive information remains safe. 2. Reduced Data Redundancy: DBMS reduces the unnecessary duplication of data, which saves storage space and improves efficiency. 3. Maintained Data Integrity: DBMS maintains the accuracy, consistency, and reliability of data throughout the database. 4. Data Independence: DBMS allows changes to the database structure without affecting the application programs that use the data. 5. Imp...