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)
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]


Popular posts from this blog

चाहने वाला हूँ तेरा, देख ले दर्द ज़रा; तू जो वेइखे एक नज़र कारा लखान दा शुक्र सोहनीये! देख तू कह के मूझे , जान भी दे दूंगा तुझे; तेरा ऐसा हूँ दीवाना, तुने अब तक ये ना जाना हीरीए !!! --------------------------------------------- आ सोनी तेनू चाँद की मैं चूड़ी पहरावा, मैनू कर दे इशारा ते मैं डोली ले आंवा !!!


IN A 5 – STAR HOTEL GUEST ROOM:- 1. BED:- 1. Mattress (1) 2. Maters protector (1) 3. Bed sheet (2) 4. Night spread (1) 5. Blanket (1) 6. Pillows (2) 7. Bed cover (1) (Boisters) 2. ENTRANCE DOORS:- 1. Lire exit plan 2. DND card on the door know 3. Collect my laundry card 4. Please clean my room card 3. WARDROBE:- 1. Coat hangers 2. Skirt trouser hangers 3. Laundry bags 4. Pot 5. Extra blanket and pillows 6. Bed slippers 4. LOUNGE :- 1. Sofa,

Career Impact in times of Corona Virus

In the last few days, as India comes to terms with Covid-19 and struggles with dealing with this pandemic, one question several people are asking me relates to its impact on their careers. Coronavirus is what you hear everywhere these days. Public distancing and lockdowns are being touted as effective preventive measures to limit its spread. The highly contagious virus has brought the entire global economy to its knees. In this environment, what happens to our careers? Feb-March-April is a period when several corporates roll out their annual appraisal. Salaries are hiked, promotions granted, and career advancements planned. This year, however, things look not so promising for anyone as companies brace for adverse effects on balance sheets and glaring losses due to prolonged disruptions in businesses. Here is what you need to do, confined in your homes to thrive your career -  1) Work from home - Don't just pretend to work. Get some real work done. When this is all