Punjab Technical University 2010-2nd Sem B.B.A Database Systems - Question Paper
Paper ID [B0111]
[Total No. of Pages : 02
Roll No...........................
Total No. of Questions : 13]
(Please fill this Paper ID in OMR Sheet)
BBA (BB - 205) (S05) (O) (Sem. - 2nd) DATABASE SYSTEMS
Time : 03 Hours Instruction to Candidates:
Maximum Marks : 75
1) Section - A is Compulsory.
2) Attempt any Nine questions from Section - B.
Section - A
(15*2 = 30)
Q1
a) What are the functions of DBMS?
b) Explain LOCATE command with example.
c) Define the terms Data Integrity and Data Consistency?
d) What is the purpose of REPORT FORM command? Explain with example.
e) Discuss Relational Model.
f) Discuss procedure for creating database structure.
g) Explain ACCEPT and INPUT commands to input data.
h) Discuss Browsing in multiple databases with examples.
i) Explain copying database structure command with example. j) Explain how to create Structure Compound Index files.
k) What is a program file? How can you create and run a program file?
l) Explain the conversion of numeric data to character with examples.
m) What is a memory variable? Discuss STORE command to create memory variable.
n) Explain SUM and AVERAGE commands with examples.
o) Explain with example to restrict data input with RANGE clause in @
...SAY...GET.
(9*5 = 45)
Q2) What is a database system? What are the components of database system? Q3) Explain the Hierarchical Model? Give its advantages and disadvantages.
Q4) Write down the commands to achieve the following in a database file in use:
(a) Delete all records that have Jalandhar in the CITY field.
(b) Recall all the deleted records.
(c) Permanently remove all the records marked for deletion.
(d) Display all the records.
(e) Replace Delhi with New Delhi in the current record.
Q5) Differentiate between :
(a) EDIT and BROWSE commands.
(b) DELETE and ERASE commands.
Q6) What is indexing of database? What are advantages and disadvantages of indexing over sorting?
Q7) Explain the SEEK command with suitable examples. How it differs from FIND command?
Q8) Discuss the five mathematical functions with examples.
Q9) Explain DO CASE-ENDCASE command with example.
QIO) Discuss the procedure to create and print Report of a database.
QII) What are the commonly used PICTURE codes for @...SAY to format the text.
Q12) Explain the concept of opening and linking multiple databases with suitable examples.
Q13) Explain MONTH( ), CTOD( ), DOW( ), DTOC( ) and CDOW( ) functions with examples.
A-19 P
|
Attachment: |
| Earning: Approval pending. |
