XII Computer Model Set
Group ‘A’ (9 x 1 = 9)
Multiple Choice Questions. Tick the correct answer.
1. Which of the statements are used in DDL?
A) Create, alter and drop
B) Create, insert and select
C) Insert, update and delete
D) Delete, alter and drop.
2. With SQL, how do
you select all the records from a table named “Persons” where the value of the
column “FirstName” ends with an “a”?
A) SELECT * FROM Persons WHERE FirstName=’a’
B) SELECT * FROM Persons WHERE FirstName LIKE ‘a%’
C) SELECT * FROM Persons WHERE FirstName LIKE ‘%a’
D) SELECT * FROM Persons WHERE FirstName=’%a%’.
3. Which of the
following statements is true about a star network topology?
A) Each device is connected to a switch or hub
B) Each device is connected to each other
C) Each device is connected in a trunk
D) Each device is connected to a terminal.
4. Which of the
following is the correct syntax to display “Stay Safe” in an alert box using
JavaScript?
A) alert-box(“Stay Safe”);
B) confirm(“Stay Safe”);
C) msgbox(“Stay Safe”);
D) alert(“Stay Safe”);
5. What is the use
of<A> tag?
A) To insert an image
B) To create a link
C) To create a hyperlink
D) To create a list.
6. What is the output
of given C program?
A) FIRST FIRST 0 0
B) FIRST FIRST 1 1
C) FIRST FIRST 1 0
D) FIRST FIRST 0 1
7. Where is a class derived in inheritance?
A) Superclass
B) Subclass
C) Subset class
D) Relative class.
8. Which of these is
the correct order of the SDLC?
A) Analysis, Design, Coding, Testing, Implementation
B) Analysis, Design, Testing, Implementation, Coding
C) Implementation, Coding, Analysis, Design, Testing
D) Design, Testing, Implementation, Coding, Analysis.
9. Why is cloud
computing popular nowadays?
A) Cost-sharing and easily accessible
B) As modern technology and costly
C) Accessible and freely available
D) Affordable to all.
Group
‘B’ (5 x 5 = 25)
Short Answer Questions
1. Explain 2NF and 3NF with examples.
OR
Demonstrate the basic DML statement with an example.
2. Write a function to add any two numbers in JavaScript.
OR
Demonstrate the external CSS implemented in the web page.
3. Describe any five features of OOPs.
4. What are the different stages of software planning?
Describe.
5. Define the concept of AI and IoT. (2+3)
Group ‘C’ (2 x 8 = 16)
Long Answer Questions
6. How do you implement the Class C IP address in the local
area network? Describe.
7. Write a program to enter ten integer numbers into an
array, sort and display them in ascending order.
OR
Write a program to read the marks of any 5 students in a subject and count how
many students are pass and fail.