Exam time XII
SET 1
Group ' B '
Short
answer questions (5x5 = 25)
a.
Differentiate
the centralized and distributed database system. What is importance of database
describe.
OR
Explain relational data model with
example.
b.
Describe
the function in C.Write a program to find the factorial of any given number
using function.
OR
What is pointer? Write a C program to
find a product of two number using pointer.
c.
What
is transmission medium also explain its major types with advantages and
disadvantages. Differentiate between peer to peer network architecture and
client server network architecture with example.
d.
Write
short notes on: class, inheritance, object in OOP with example
e.
What
is array? Explain the different types of array. .
Group
' C '
Long
answer questions (8x2 = 16)
a.
Write
the SQL statement to perform the following task.
i.
Create
a database named ‘employee’.
ii.
Create
a table ‘employee’ with following fields.
employee_id--------------integer
employee_name---------varchar(100)
employee_address-------varchar(100)
employee_salary----------float
iii.
Insert
any 6 records using ‘insert’ and ‘values’ command.
iv.
Display
all the records of all fields.
v.
Display
all the records of fields employee_id and employee_name.
vi.
Display
records of employees whose name starts with letter ‘a’.
vii.
Display
records of employees whose name ends at letter ‘y’.
viii.
Display
all the records of employees whose salary is 20000.
b.
Create
a sequential data file “student.txt” to input roll , name and age of 10
students and store them properly.
OR
A sequential data file “student.txt” consist
of roll , name and age of few students
and write a program to add few records until users choice.
SET 2
Group ' B '
Short
answer questions (5x5 = 25)
a.
Differentiate
DDL and DML Give example each.
OR
What are the purposes of normalization?
Explain 1NF, 2NF and 3NF with example
b.
List
advantages of function in C program. Write a program to check whether the given number is positive or negative using
function.
OR
Write advantages of pointer? Write a C
program to find a greatest among two numbers using pointer.
c.
How
does star topology differ from bus topology in terms of architectural layout
and data transmission methodology in modern computing environment?
d.
How
is even driven program(or OOP) differ from procedural oriented program. Explain
e.
What
is looping? Differentiate between while and do while loop with example.
Group
' C '
Long
answer questions (8x2 = 16)
a.
Write
the SQL statement to perform the following task.
i.
Create
a database named ‘staff.
ii.
Create
a table ‘staff with following fields.
staff_id--------------integer
staff _name---------varchar(100)
staff _department-------varchar(100)
staff _bonus----------float
iii.
Insert
any 5 records using ‘insert’ and ‘values’ command.
iv.
Display
all the records of all fields.
v.
Display
all the records of fields staff _id and staff _department.
vi.
Display
records of staff whose name starts with letter ‘S’.
vii.
Display
records of staff whose department ends at letter ‘y’.
viii.
Display
all the records of staff whose bonus is 2000.
b.
A
sequential data file “student.txt” consist of
roll , name and age of students
write a program to display all the records.
OR
A sequential data file “student.txt”
consist of roll , name and age of students write a program to display those
records whose age is more than 12.
SET 3
Group ' B '
Short
answer questions (5x5 = 25)
a.
Evaluate
advantage of DBMS compared to traditional file based data storage system.
OR
. Write SQL DDL command to execute the
following task with reference to the schema given below
Student_info(regno as integer, name as
character(25), class integer, gender character(1), address character(25) )
b.
What
are the importance of function in C
program. Write a program to check whether the
given number is odd or even using function.
OR
What is string function? Write a C
program to concatenate two string.
c.
What
is network topology? Differentiate between guided and unguided media with
example.
d.
Explain
the concept of Encapsulation. How does it help in achieving data hiding in OOP.
e.
Differentiate
between structure and union example.
Group
' C '
Long
answer questions (8x2 = 16)
a.
Write the SQL statement to perform the following
task.
|
i.
Create a database named ‘staff. ii.
Create a table ‘staff with following fields. staff_id--------------integer
staff
_name---------varchar(100) staff
_department-------varchar(100) staff
_bonus----------float iii.
Insert any 5 records using ‘insert’ and ‘values’
command. iv.
Display all the records of all fields. v.
e Display all the records of staff whose salary is
30000 and who are from address “Kathmandu”. vi.
j. Update
the staff name with any other name who has id 4. vii.
k. Delete the
record of staff whose id is 5. viii.
l. Display
the records of staff in sorted order using field ‘staff _name’. Use ‘order by
field name asc/desc’. |
b.
A datafile “student.txt” contain
name, class and marks obtained in 3 different subject of few students. Write a
C program to read and display only records of all students who secure
distinction.
OR
A sequential data file “student.txt”
consist of roll , name and age of students write a program to display those
records whose name is Sita.