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

Debate : Do the ends justify the means...

Note : Give it all a fair thought before you jot down... Flaming and religion-bashing will not be tolerated. Your participation is gladly appreciated. I dunno if you folks remember this incident; a couple of yrs back, the UPSC exam had a question where the emainee had to assert his views on *revolutionary terrorism* initiated by Bhagat Singh. As is typical of the government, hue and cry was not far behind... Anyway, let us look at some facts -   Bhagat Singh was an atheist, considered to be one of the earliest Marxist in India and in line with hi thinking, he renamed the Hindustan Republican Party and called it the Hindustan Socialist Revolutionary Party. Bhagat Finally, awaiting his own execution for the murder of Saunders, Bhagat Singh at the young age of 24 studied Marxism thoroughly and wrote a profound pamphlet “Why I am an Atheist.” which is an ideological statement in itself. The circumstances of his death and execution are worth recounting. Although, Bhagat Singh had a...
30 comments
Read more