Roll
No………………
Total
No. of Questions :13]
Paper
ID [A0304]
(Please
fill this Paper ID in OMR Sheet )
B.Sc
.IT –(102) (old )
B.Sc
.IT (203) (New) /DCA -104 (New )
RDBMS
–I
Time
: 03 Hours Max
Marks :75
Instruction
to Candidates :
1) Section
–A is Compulsory .
2) Attempt
any Nine questions from section –B .
SECTION-A
Q1)
(a)What are operators and conditions ?
(b)What
are NULL indicators ?
(c)What are features of Information
Processing ?
(d) What is database view and how can it be
used ?
(e) Differentiate between Logical and
physical Database ?
(f) Define QBE and view?
(g) What are the advantages and disadvantages
of data sharing of different functional
areas?
(h) What is utility of Dialog Box,
Menus and Toolbars?
(i) What are DDL and DML?
(j)What advantages of SQL?
(k) What do you Secondary Key?
(l) What do you mean by filtering
Record?
(m) Write syntax for UPDATE Query?
(n) What is Relational Data Integrity?
(o) Write syntax for SELECT Query?
SECTION-B
Q2.
Explain the various types of Data Base Management Systems?
Q3.
Consider the following relation database.
Give an expression in SQL for each of the following queries:
Enrol
(Rollno., Name, Fname, DOB, Subjectcode)
Teach
(Prof, Subjectcode)
Subject
(Subjectcode, Sname)
(a)
List all students taking subject with subject code BSIT 104 or BSIT 105.
(b)
List those professors who teach more than one subjects.
Q4.
Describe the types of facilities provided in RDBMS.
Q5.
Explain how table is created, deleted and its values can be sorted using SQL.
Q6.
Explain with an example how tables can be modified without data lost.
Q7.
Explain any four operations of Structured Query Language?
Q8.
Explain usefulness of various types of Report and Screen forms.
Q9.
Describe how in a form data can be searched, edited and deleted.
Q10.
What are various objectives of database systems?
Q11.
Explain Database design process?
Q12.
Use following schema, to express the queries in SQL:
CUSTOMER (cust_id, cust_name,
annual_revenue, city_name)
SHIPMENT (shipment_#,cust_id, weight,
truck_#, destination, ship_date)
TRUCK (truck_#,driver_name)
CITY (city_name, population)
(a)
Give all data for shipments weighing over 120 kg.
(b)
List cities of population over ten lacks which have received a 150 kg package
from customer 315.
Q13.
What are major requirements to create query?
0 comments:
Post a Comment
North India Campus