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

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

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

What is karmic debt? How to clear it for a successful life

Ever felt like you're stuck in a loop, facing the same challenges over and over? You might be dealing with karmic debt—a spiritual IOU from past actions. Understanding and clearing this debt can pave the way for a more successful and fulfilling life. ​​ What is karma and how does it influence our lives? Karma, a concept rooted in ancient spiritual traditions, operates on the principle of cause and effect. Essentially, it suggests that our actions, thoughts, and intentions create energy that returns to us in kind. This universal law implies that positive deeds lead to favourable outcomes, while negative actions result in undesirable consequences. ​ In my own life, I have observed how acts of kindness often lead to unexpected blessings. Conversely, moments of negativity seem to attract further challenges. This personal experience underscores the idea that our current circumstances are shaped by past behaviours, and our present choices lay the foundation for future experiences...
2 comments
Read more