PABSON SLC PRE-BOARD EXAM 2079 Computer
PABSON
SLC PRE-BOARD EXAM
2079
Grade: XII
Subject: Computer
Full Marks: 50
Time: 2 hrs.
Candidates are required to give their answer according to the given instructions.
Attempt all questions
Group A (Multiple choice question)
Select the best answer from the following alternatives. 1×9 = 9
1. Which of the following is not a DDL command?
a. UPDATE b. TRUNCATE c. ALTER d. None of the above
2. In Hierarchical Model, records are organized as
a. Table b. List c. Link d. Tree
3. In
which topology, devices are connected through the hub?
a. Star topology b. Mesh topology c. Ring topology d. Bus topology
4. Which of the following is not an OOPs concept?
a.
Encapsulation b. Polymorphism c. Exception d. Abstraction
5. What is the output of the following?
main ()
{
Char *p;
P= “Nepal”;
Printf(“%c”, *&*p);
}
a. Nepal b. N c. some address will be printed d. non of the above
6. What are the two method of form access?
a. Get/post b. get/set c. give/take d.
Input/output
7. Which of the following is used to display the output in
PHP?
a. echo b. print c. write d. both (a) and (b)
8.
Which of the following is the correct full form of SaaS?
a.
Storage as a Service b. Server
as a Software c. Software as a Service
d.
None of the above
9. The context diagram is also known as…………..?
a. Level-0 DFD b. Level-1 DFD c. Level-2 DFD d. Level-4 DFD
Group - B
Short Answer Questions
Attempt
any five questions. 5×5=25
10. Explain DDL and
DML with some commands.
DDL (Data
Definition Language) is a set of SQL commands that are used to create, modify,
and delete database objects like tables, indexes, and views.
Some
commonly used DDL commands are:
CREATE:
Used to create a new table, view, or other database objects.
ALTER: Used
to modify the structure of an existing table or view.
DROP: Used
to delete an existing table or view.
DML (Data
Manipulation Language) is a set of SQL commands that are used to insert, update,
and delete data in a database.
Some
commonly used DML commands are:
INSERT:
Used to insert new data into a table.
UPDATE:
Used to update existing data in a table.
DELETE:
Used to delete data from a table.
OR
What
is normalization? Describe about 1NF with example.
Normalization
is a process of organizing data in a database to reduce redundancy and
dependency between data. It involves breaking down a table into smaller tables
and defining relationships between them.
1NF
(First Normal Form) is a basic level of normalization that requires each column
in a table to contain only atomic values, i.e., a single value in each cell.
For example, if a table contains a column with multiple values separated by
commas, we need to split the column into a separate table to achieve 1NF.
|
S.N |
Name |
Phone No: |
|
1 |
Ram |
9847824,9847836 |
|
2 |
Hari |
9878452,9847866 |
1NF Table
|
S.N |
Name |
Phone No: |
|
1 |
Ram |
9847824 |
|
1 |
Ram |
9847836 |
|
2 |
Hari |
9878452 |
|
2 |
Hari |
9847866 |
11. How do you insert data into database table in PHP? Describe.
Description:
- Ø
Set up the database
connection using the mysqli class
- Ø
Check if the connection to
the database is successful or not
- Ø
Define the SQL INSERT
statement to insert a new record into the table
- Ø
Execute the INSERT statement
using the query method.
- Ø
Close the database connection
using the close method.
Example:
<?php
$servername = "localhost";
$username = "username";
$password = "password";
$dbname = "myDB";
$conn = new mysqli($servername, $username, $password,
$dbname);
if ($conn->connect_error)
{
die("Connection failed: " . $conn->connect_error);
}
$sql = "INSERT INTO MyGuests (firstname, lastname, email)
VALUES ('John', 'Doe', 'john@example.com')";
if ($conn->query($sql) === TRUE)
{
echo "New record created successfully";
}
$conn->close();
?>
12. Describe any five
features of OOPs.
- 1.
Encapsulation:
bundling data and methods into a single unit to protect data integrity and
control access.
- 2.
Abstraction:
hiding complexity and providing only necessary details to the user.
- 3.
Inheritance:
creation of new classes based on existing ones to reduce redundancy and improve
reusability.
- 4.
Polymorphism:
objects can take on many forms or behaviors depending on context.
- 5.
Encapsulation:
bundling data and methods into a single unit to protect data integrity and
control access.
13. What is
feasibility study? Describe its types.
A feasibility study is an evaluation of the practicality
and potential success of a proposed project or business venture. It assesses
the technical, economic, and operational aspects of the project. The three
types of feasibility studies are:
- Ø
Technical
feasibility: examines the technological requirements and limitations of the
project.
- Ø
Economic
feasibility: assesses the financial viability of the project, including the
costs and potential revenue.
- Ø
Operational
feasibility: evaluates the practicality of implementing the project, including
its compatibility with existing operations and available resources.
14. Explain the
concept of cloud computing and e-commerce.
Cloud computing means using computer resources, like servers and storage,
over the internet instead of owning and managing them locally. E-commerce means
buying and selling goods and services online. Cloud computing and e-commerce
have transformed businesses by making it easier and cheaper to run online
stores and sell products over the internet. Cloud computing provides businesses
with access to computing resources that can scale up or down as needed.
E-commerce allows businesses to reach customers all over the world and sell
products online without needing a physical storefront. Together, these
technologies have made it easier for businesses to operate, reduce costs, and
reach customers online.
Group - C
Long
Answer Questions (Any two) 2× 8=16
15. What do you mean by
transmission media? Describe the types of guided media.
Transmission media refers to the physical means through
which data is transmitted from one device to another in a communication
network. Guided media, also known as wired media, are those transmission media
that use a physical path or a conductor to transmit signals.
The three types of guided media are:
- Ø
Twisted
pair cable: It is the most commonly used transmission media for LANs. It
consists of two copper wires twisted together to reduce electromagnetic
interference.
- Ø
Coaxial
cable: It consists of a copper core surrounded by an insulating material, a
braided wire shield, and an outer jacket. It is commonly used for cable TV and
broadband internet services.
- Ø
Optical
fiber cable: It uses light to transmit data and consists of a core made of
glass or plastic, surrounded by a cladding material, and an outer jacket. It is
used for long-distance communication and offers high bandwidth and low signal
attenuation.
16.
What is structure? Write a program that takes serial number, name and
address of any 5 employees and prints the record on the screen using
structure.
In C, a structure is a user-defined data type that groups related data
items of different data types under a single name.
#include <stdio.h>
#include<conio.h>
struct Employee {
int serial_no;
char name[50];
char address[100];
}e[5];
int main()
{
int i;
for (i = 0; i < 5; i++)
{
printf("Enter serial number, name,
and address of employee");
scanf("%d %s %s",
&e[i].serial_no, e[i].name, e[i].address);
}
printf("Employee Records");
for (i = 0; i < 5; i++)
{
printf("Serial No= %d", e[i].serial_no);
printf("Name= %s", e[i].name);
printf("Address= %s", e[i].address);
}
return 0;
}
OR
Write
a program to write and read symbol number, name and percentage of any 10
students to/from data file “students.txt”.
#include <stdio.h>
#include<conio.h>
struct student
{
int symbol_number;
char name[50];
float percentage;
}s[10];
int main()
{
FILE *fp;
int i;
fp = fopen("students.txt", "w");
for (i = 0; i < 10; i++) {
printf("Enter the symbol number of student ");
scanf("%d", &s[i].symbol_number);
printf("Enter the name of student ");
scanf("%s", s[i].name);
printf("Enter the percentage of student ", );
scanf("%f", &s[i].percentage);
fprintf(fp, "%d %s %f \n", s[i].symbol_number, s[i].name, s[i].percentage);
}
fclose(fp);
fp = fopen("students.txt", "r");
while (!feof(fp))
{
fscanf(fp, "%d %s %f", &s[i].symbol_number, s[i].name, &s[i].percentage);
printf("%d \t %s \t %f", s[i].symbol_number, s[i].name, s[i].percentage);
}
fclose(fp);
return 0;
}
Post a Comment