Skip to main content

Question Paper of Database Systems- PTU - BBA- Semester - 2nd

Total No. of Questions: 13
Paper ID [ Bo111]
Database Systems
Time: 03 Hours Maximum Marks: 75

Instruction to Candidates:
1) Section - A is Compulsory
2) Attempt any Nine questions from Section - B

Section - A (15*2=30)
Q-1)
a) Define database management system.
b) What are limitations of network data model?
c) Write down commands for deleting records in FOXPRO?
d) What is compound index?
e) Why we sort database? How is it different from indexing?
f) Define terms:-
Record field
g) Write down the applications of database management system?
h) How data can be converted from one type to another?
i) Define degree of a relation.
j)What is the purpose of the DO command?
k) What is the difference between LIST and DISPLAY
l) Describe the use of REPORT FORM COMMAND.
m) Differentiate between @row, col SAY and @row, col GET?
n) List three uses of BROWSE command?
0) What key sequence can you use to delete a field?

Section - B (9*5 = 45)

Q-2) Differentiate between hierarchical and network data model
Q3) What are the advantages of database management system over conventional file processing system?
Q4) What are different data types allowed in FOXPRO?
Q5) With the help of example differentiate between LOCATE an SEEK commands.
Q-6) Describe Relational Data MOdel?
Q-7) What are macros? What is the use of macros and how they are created in FOXPRO?
Q-8) Describe various FOXPRO statements for displaying text and accepting data from keyboard.
Q-9) What is procedure command in FOXPRO? Explain with an example.
Q-10) List the steps you use to create a menu system.
Q-11) Write a working example of the @ row, col SAY command.
Q-12) What is an Index? Why we use Indexes? Differentiate between single and compound indexes?
Q-13) How can you add new records to a database?

<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<

Reblog this post [with Zemanta]
Labels:

Comments

Post a Comment

Also read

Why do we crave bookshops when life falls apart? A deep reading of Welcome to the Hyunam-dong Bookshop

This article reflects on Welcome to the Hyunam-dong Bookshop by Hwang Bo-reum, a gentle novel about burnout, healing, and second chances. Through Yeong-ju and her quiet community, the book reminds you that meaning often returns slowly, through books, people, and ordinary days that begin to feel like home again. Why do so many of us secretly dream of walking away from everything? At some point, usually on a crowded weekday morning or during yet another meeting that could have been an email, you wonder if this is all there is. You did what you were told. You studied, worked hard, built a career, stayed responsible. And yet, instead of contentment, there is exhaustion. Welcome to the Hyunam-dong Bookshop begins exactly at this uncomfortable truth. Hwang Bo-reum’s novel does not shout its intentions. It does not promise transformation through grand revelations. Instead, it sits beside you quietly and asks a gentler question. What if the problem is not that you failed, but that you nev...
Post a Comment
Read more

Spill the Tea: Noor and the Silence After Doing Everything right

Noor has done everything she was supposed to do — moved out, built a life, stayed independent. Yet beneath the neat routines and functional success lies a quiet emptiness she cannot name. Part of the Spill the Tea series, this story explores high-functioning loneliness, emotional flatness, and the unsettling fear of living a life that looks complete from the outside. The verandah was brighter than Noor expected. Morning light lay flat across the tiles, showing every faint scuff mark, every water stain from old monsoons. The air smelled of detergent from a neighbour’s washed curtains flapping overhead. On the table, the paneer patties waited in a cardboard bakery box I’d emptied onto a plate. A squeeze bottle of ketchup stood beside it, slightly sticky around the cap. Two cups of tea, steam already thinning. In one corner, a bamboo palm stood in a large terracotta planter. Thin stems. Too many leaves. Trying very hard to look like it belonged indoors. Noor sat down and pulled the chair ...
Post a Comment
Read more

Cutting people off isn’t strength—It is a trauma response

Your ability to cut people off and self-isolate is not a skill you should be proud of—It is a trauma response Cutting people off and self-isolating may feel like a protective shield, but it is often rooted in unresolved or unhealed trauma and an inability to depend on others. While these behaviors seem like self-preservation, they end up reinforcing isolation and blocking meaningful connections. Confronting these patterns, seeking therapy, and nurturing supportive relationships can help break this unhealthy cycle. Plus, a simple act like planting a jasmine plant can symbolise the start of your journey towards emotional healing. Why do we cut people off and isolate? If you’re someone who prides themselves on “cutting people off” or keeping a tight circle, you might believe it’s a skill—a way to protect yourself from betrayal, hurt, or unnecessary drama. I get it. I’ve been there, too. But here’s the thing: this ability to isolate yourself is not as empowering as it may seem. In fact, i...
1 comment
Read more