CS403 Database Management Systems paper
View more random threads:
- ENG101 English Comprehension Quiz No.1 Solution Spring...
- CS201 Midterm Paper May 2010
- CS408 - Human Computer Interaction Quiz No. 01 Fall...
- mgt 201 paper May 26,2010
- Check Online IT430 E-Commerce Quiz No. 02 Solution and...
- MGT602 Entrepreneurship Online Quiz No.01 Ideal Solution...
- Need mid term past papers of cs301( data structures)....
- STA 630 Approx. 267 solved MCQ’s May 3,2010 Part 4
- MGT402- Cost &Management Accounting (Session - 4) June...
- MGT602 GDB#2 enterpeneureship Semester Spring solution due...
Total 22 Questions, out of which
16 MCQs of marks 1 each
2 short questions of marks 2 each
2 short questions of marks 3 each (i'm not sure whether there were 2 short questions of marks 3 each or 3 short questions, but what I remember, there were 2 short questions of marks 3 each)
2 short questions of marks 5 each
Some of the short questions that I remember are:
I do not remember the exact statements of questions, but the concept which was asked in questions is as under:
1. For what purpose do we use Relational Data model?
2. What is the difference between Primary key and unique key with reference to null value?
3. Write two sub-categories of outer join?
4. attribute and key attribute, give example as well. (I think the question was, what is the difference b/w attribute and key attribute, anyways, I wrote about attribute and key attribute in answer with one example)
5. Explain union? (marks 5) (page # 152 of handouts)
6. What is first normal form? (page # 167 of handouts)
Describe with example function of Union Operation in relational algebra (05 Marks)
Describe with example Refrential integrity constraints (03 Marks)
Describe functional dependency (03 Marks)
Give atleast 02 benefits of Normalization (02 Marks)
What is Data Definition Language (DDL) ? (02 Marks)
What is data type? (02 Marks)
There are currently 1 users browsing this thread. (0 members and 1 guests)