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: Data integrity:  A database system enforces data constraints and relationships, ensuring that the data is accurate and consistent. 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. Concurrent access:  A database system allows multiple users to access the same data simultaneously, without interfering with each other. Data security:  A database system provides various security mechanisms to control access ...