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 revolution 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...
Post a Comment
Read more

Legions of Slave Women in the Mahabharata

Awakening to the Bhagavad Gita (series) - 1 For, taking refuge in Me, they also, who, O Arjuna, may be of sinful birth— women, Vaisyas as well as Sudras—attain the Supreme Goal! How much more easily then the holy Brahmins and devoted royal saints (attain the goal); having obtained this impermanent and unhappy world, do thou worship Me. The Bhagavad Gita, Chap 9, Ver 32, 33 So women are of sinful birth! As well as all kinds of workers, business men, entrepreneurs, most of the general population. The only people of virtuous births are priests — Brahmins — and royal saints, meaning saintly royals, meaning noble Kshatriyas. No wonder then that Yudhishthira — to reinstate whom this whole Mahabharata war has been fought — maintained hundreds of thousands of slave women! Take that number again: hundreds of thousands! He had so much gold, he could afford to. He had so much virtue, but he wanted more! Let's find the facts and figures from Draupadi's own wo...
15 comments
Read more