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

Vastu & karma: Can spaces carry energetic debt?

Ever walked into a room and felt an inexplicable heaviness? According to vastu shastra, our living spaces can absorb and reflect our karmic energies. This article explores the connection between vastu and karma, signs of negative energy in your home, and practical steps to cleanse and harmonize your space. What is vastu shastra and how does it relate to karma? Vastu Shastra, often referred to as the "science of architecture," is an ancient Indian system that outlines principles for designing and organizing spaces to promote harmony and prosperity. Rooted in the belief that the physical environment significantly influences our lives, Vastu emphasizes the balance of the five elements—earth, water, fire, air, and space—to create a conducive living atmosphere. Karma, on the other hand, is a fundamental concept in Indian philosophy that denotes the law of cause and effect. It suggests that our actions, intentions, and thoughts have consequences that shape our present and f...
Post a Comment
Read more

Design tips for bachelors

 By Ar. Tripat Girdhar, Principal Architect & Co-founder of The Design Studio As an architect in heart, I would like to highlight a few tips and tricks for newcomers and bachelors who would like to make their career in this field.   Sustainable in design  Living in a sustainable, mindful, and wise way has never been more significant before the pandemic hit. After the epidemic, everyone has noticed a major difference, especially with regard to recently proposed initiatives. Before the pandemic, a select few farms and well-known architects took the lead in sustainable initiatives and anticipated the future of architecture in design. To keep this in mind, we advise keeping your design sustainable and incorporating solar panels and rainwater harvesting systems into your projects. Sustainable projects are designed to peacefully coexist with nature, enabling us to live in harmony with our surroundings. They encourage a healthy, sustainable lifestyle and lessen their carbon ...
1 comment
Read more