Class 12 Computer model question with its solution!!

Group ‘A’

Multiple choice questions.

1. Which of the following is the purpose of using a primary key in a database?
2. A company needs to modify an existing table by adding a new column for employee email addresses. For this, which SQL command should be used?
3. Which protocol is used for secure communication over a computer network?
4. Which control structure in JS(JavaScript) is used to execute a block of code repeatedly based on a given condition?
5. Select the invalid variable name in PHP.
6. The statement Int number (int a); is a
7. In which of the following programming is the emphasis given on data rather than on procedures?
8. Which type of feasibility study evaluated whether a system can be developed with the available technology?
9. Which of the following is NOT a type of cloud computing service?

Group ‘B’

short answer questions.

10. Write any three differences between DDl and DML. Give an example of each.

Or

What is normalization? Explain 2NF and 3NF

11. Write JavaScript code to input any three numbers and find the smallest number among them.

Or

Write a PHP script to connect to a MySQL database.]

12. Write short notes on class and inheritance in OOPs with examples.

13. What is requirement gathering? Explain Different Requirement Gathering Methods

14. What is AI? Explain the application areas of AI in education.

Group ‘c’

15 What is a transmission medium? Explain its major types with advantages and disadvantages.

16. Write a C program that reads the account_number, name, and address of ten customers from the user and displays the account_number, name, and address of these customers using an Array and a structure

Or

What are the components of a function of C? Describe the Call-by-value and Call-by-reference, and passing the function parameters.