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

Does India need communal parties?

I think, it was Tan's post on this blog itself, Republic Day Event, where this question was raised. My answer. YES. we need communal parties even in Independent, Secular India. Now let me take you, back to events before 1947. When India was a colony of the British Empire. The congress party, in its attempt to gain momentum for the independence movement, heavily used Hinduism, an example of which is the famous Ganesh Utsav held in Mumbai every year. Who complains? No one. But at that time, due to various policies of the congress, Muslims started feeling alienated. Jinnah, in these times, got stubborn over the need of Pakistan and he did find a lot of supporters. Congress, up till late 1940's never got bothered by it. And why should we? Who complains? No one. But there were repercussions. The way people were butchered and slaughtered during that brief time when India got partitioned, was even worse than a civil war scenario. All in the name of religion. And there indeed was cr...
40 comments
Read more

Union Budget India 2026-2027: 12 shocking truths that affect your wallet and future

The Union Budget India 2026-2027 is more than numbers on paper. It’s a mirror of promises, propaganda, and practical policies. This article breaks down what’s truly useful for you—jobs, taxes, inflation, and infrastructure—while cutting through the noise. Think of it as a friendly guide that explains the budget like a story, not a spreadsheet. Why does the Union Budget India 2026-2027 matter to you? India’s fiscal deficit for 2026–27 is pegged at nearly ₹17 lakh crore, while interest payments alone consume over ₹14 lakh crore. This means most of what the government borrows is not funding new projects but servicing old debt—a cycle that resembles “evergreening” of loans. Despite record tax collections, a large share is swallowed by debt servicing rather than fresh development. Breaking Down the Numbers Fiscal Deficit (FY27) : ₹16.95 lakh crore, or 4.3% of GDP . Interest Payments : Over ₹14 lakh crore, making it the single largest expenditure item. Total Expenditure : Around ₹53....
Post a Comment
Read more

Epitome of equality

First of all This is not to demean any religion.. I am a Hindu by birth, but yes I respect all religions .I offer my daily prayers , fast on holy days , but there was something that was disturbing me . God as per me was a Friend, someone who was by my side always , someone who was a dear friend , but this is not what everyone else thought , for others he was the Judge who gives his verdict always and punishes anyone and everyone . Walk into any temple and you would see , if you have money , you will be treated in a way as if you are the ONLY disciple of the God . I have had too many experiences where I was treated as a second class citizen in the temple . Why? Well I could not afford giving thousands as donation. This is not how it should be , God looks at each one of us with the same divinity .As I mentioned God for me is a friend, so tell me, do we chose friends based on their bank balances? Do we give our verdict on them ? then how can God do it? I know many of us would ...
32 comments
Read more