Model set by CDC-2079
The answers are presented in point form for easy understanding. Students are advised to elaborate each point as required in the examination to obtain full marks.
Group B: Short Answer Questions
10.
Which type of database system is mostly preferred by financial institutions
like a bank? Give reasons.
Financial institutions like banks mostly
prefer a Centralized Database System.
Reasons (any four):
1. High security: Data is stored at a
single location, making it easier to control access and protect sensitive
financial information.
2. Easy management: Backup, recovery,
and updates can be managed centrally.
3. Data consistency: All branches access
the same data, reducing redundancy and inconsistency.
4. Better control: Administrators can
easily monitor transactions and user activities.
OR
Why
do business organizations prefer the relational model for database design?
Most business organizations prefer the relational
model because:
1. Data is stored in tables, which are
easy to understand and manage.
2. It reduces data redundancy using
normalization.
3. Ensures data integrity using primary
and foreign keys.
4. Easy to retrieve data using SQL
queries.
5. It supports security and flexibility,
making it suitable for large organizations.
11. JavaScript program to swap the
values of two variables
<html>
<head>
<title>Swap
Two Numbers</title>
</head>
<body>
<script>
let a = 5;
let b = 10;
let temp;
temp = a;
a = b;
b = temp;
document.write("After
swapping:<br>");
document.write("a
= " + a + "<br>");
document.write("b
= " + b);
</script>
</body>
</html>
OR
How
can you connect a database with PHP?
PHP can connect to a database using MySQLi
or PDO.
Example using MySQLi:
<?php
$conn =
mysqli_connect("localhost", "root", "",
"school");
if (!$conn) {
die("Connection failed");
}
echo "Database connected
successfully";
?>
12. Object Oriented and Procedure
Oriented Programming
Object Oriented Programming (OOP):
OOP is a programming approach that uses objects
and classes. It focuses on data security and reuse using concepts like
encapsulation, inheritance, and polymorphism.
Procedure Oriented Programming (POP):
POP is based on functions or procedures.
It focuses on step-by-step instructions and does not emphasize data security.
13. Any five qualities of good software
1. Reliability: Performs correctly
without failure.
2. Efficiency: Uses system resources
effectively.
3. User-friendly: Easy to learn and
operate.
4. Maintainability: Easy to modify and
update.
5. Portability: Can run on different
platforms.
14.
Explain mobile computing with advantages and disadvantages
Mobile Computing:
Mobile computing refers to the use of
portable devices like smartphones and tablets to access data and services
wirelessly from anywhere.
Advantages:
1. Portability
2. Anywhere, anytime access
3. Increased productivity
Disadvantages:
1. Security risks
2. Limited battery life
Group C: Long Answer Questions
15.
Why do business organizations prefer client-server architecture?
Business organizations prefer client-server
architecture because it provides centralized control and efficient resource
management.
Advantages:
1. Centralized data management
2. High security
3. Easy maintenance
4. Scalable system
5. Efficient resource sharing
6. Better performance
Disadvantages:
1. Server failure affects all clients
2. High cost of setup
16.
C program using structure for 12 students
#include <stdio.h>
struct student {
int roll;
char name[30];
int sub1, sub2, sub3;
};
int main() {
struct student s[12];
int i;
float total, percent;
for(i=0; i<12; i++) {
printf("Enter roll number: ");
scanf("%d", &s[i].roll);
printf("Enter name: ");
scanf("%s", s[i].name);
printf("Enter marks in 3 subjects: ");
scanf("%d%d%d", &s[i].sub1, &s[i].sub2,
&s[i].sub3);
}
for(i=0; i<12; i++) {
total = s[i].sub1 + s[i].sub2 + s[i].sub3;
percent = total / 3;
printf("\nRoll: %d Name: %s Total: %.2f Percentage: %.2f%%",
s[i].roll, s[i].name, total,
percent);
}
return 0;
}
OR
C
program to create and display a data file (score.dat)
#include <stdio.h>
struct student {
int reg;
char name[30];
char gender[10];
char address[30];
};
int main() {
FILE fp;
struct student s;
char ch;
fp = fopen("score.dat", "ab");
do {
printf("Enter Reg No: ");
scanf("%d", &s.reg);
printf("Enter Name: ");
scanf("%s", s.name);
printf("Enter Gender: ");
scanf("%s", s.gender);
printf("Enter Address: ");
scanf("%s", s.address);
fwrite(&s, sizeof(s), 1, fp);
printf("Continue? (y/n): ");
scanf(" %c", &ch);
} while(ch == 'y');
fclose(fp);
fp = fopen("score.dat", "rb");
printf("\nRecords:\n");
while(fread(&s, sizeof(s), 1, fp)) {
printf("%d %s %s %s\n", s.reg, s.name, s.gender, s.address);
}
fclose(fp);
return 0;
}