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

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

Punjab’s stilt-plus-four real estate rule 2025: Game changer or urban chaos? | circle rate hike explained

When the Punjab Cabinet approved the Unified Building Rules 2025, allowing stilt-plus-four floor construction across 40-ft-wide roads, it sparked both celebration and anxiety. For homeowners, it opened a new chapter of vertical prosperity. For urban planners, it may have unlocked Pandora’s box. Add to that a steep rise in circle rates up to 67% in Mohali and you have the perfect cocktail for a cityscape revolution. Is Punjab’s stilt-plus-four policy a game changer or a warning sign for urban chaos? Punjab’s 2025 building rule reforms are rewriting its urban DNA. With stilt-plus-four floors now permitted on 250 sq yd plots and higher circle rates in force, Punjab’s real estate market is at a crossroads. Is this the dawn of new opportunities or the slow death of livable cities? The answer lies somewhere between ambition and chaos. Urban transformation often begins with good intentions and ends in gridlocks. Punjab’s new stilt-plus-four policy and simultaneous circle rate hike hav...
Post a Comment
Read more

Who the F Are You? by Harinder Singh Pelia — A sharp, kind kick to become unignorable | Book review

In this impatiently kind review I walk you through Harinder Singh Pelia's Who the F Are You?  a short practical guide to finding your unfair advantage and making it impossible to ignore. The book pairs a Minimum Viable Self framework with bite sized exercises and honest case studies. If you want clarity without theatre, this book gives you a plan. Have you ever felt invisible despite working hard? What is the book about in a few lines? The book's central promise is simple: find your unfair advantage, sharpen it and make it impossible to ignore. Pelia lays out a five step process built around the Minimum Viable Self framework. Rather than offering lofty pep talk, the book gives short exercises, prototypes and feedback loops so readers can test how they show up. It is candid, occasionally blunt, and emphatically practical. Harinder Singh Pelia’s Who the F Are You?  was published in 2025 by Penguin, the hardback spans 206 pages and wears its intent on its sleeve. The co...
Post a Comment
Read more