[$@mi]

MY todays paper
TOTAL 52 QUESTIONS
40= MCQZ= APPROXIMATELY 15 FROM PAST PAPERS, REST MCQZ WERE new logical mcqz,
4 question - 3 marks of each
4 question-2 marks of each
4 question-5 marks of each
5 marks questions
find Cartesian product from given?
create index of following query?
draw cross reference matrix of following?
different statements which is correct and which is incorrect?
3 marks question
one to one relationship
INDEXES CLASSIFICATION ACCORDING TO OPTIONS?
what is the common disadvantages of indexes and materialized views?
create alter statement of following
2 marks questions
what is the purpose of AND OPERATOR?
what is the purpose of OR OPERATOR?
CREATE SYNTAX OF SELECT STATEMENT?
WHICH IS USED FOR WILDCARD?

[Admin]

very nice dear

[$@mi]

thanks alot admin

[$@mi]

my today's papar 18-7-2012
Q.1:If a company can not compromise on data access time. which file processing technique you'll suggest in this case.
Q.2: difference b/w semi join & natural join.
Q.3: if table 1 has 20 indexes & table 2 has 14. both have same data & values. three statements were given to choose correct or incorrect b/w the tables.
q.4: statement: text based interfaces include more tables than GUI. justify it as true.
q.5: a table can have more than one clustered index . if true justify it.
q.6: semi join sql coding & 2 tables were given & you have to calculate resultant table.


q.7: what does SELECT keyword in sql?
q.8: A view have to created & a student table was given. in view you have to collect all st.ID which in ascending order where city=something.

[$@mi]

My today paper 17-7-2012 at 8:00 am
Mostly MCQ's new thae 25% past paper se ae thae
2 Marks

What is diff b/w database and dbms? 2 Mark
What is the purpose of OR OPERATOR? 2 Mark
Write any two similarities between matererialized views and indexs?
2Marks
Ak organization store karti hai data or wo uske lye tape use nae karti or baten ke storage ke lye kia behtr hogai for direct acess

3 Marks

1. State the basic difference between Inner join and Left Outer Join. . 3 marks
2. In recovery procedure, transaction ended before the check points are redone. Correct it and justify? 3 marks
3. Rehashing is better than chaining in term of time. (Rehashing and chaining collision resolution technique in hashing). Justify it ? 3 Mark
4. a table is given and btana tha kun sa worst hai good hai and average hai according to time….1st one tha linear piping shayad,, 2nd chaining and 3rd rehasing? 3 Marks

5 Marks

1. Analyze the below given statements and mark as correct and incorrect and also explain. (Marks 5)
1. Deadlock occurs when one transaction wants to read more than on object at same time.
2. The mechanism ―Wait for Graph‖ is used to apply join on multiple.

2. Given two tables DOCTOR (D_ID,D_CONTACT) , MEDICINE(M- CODE, Description) (i) Create unique index DOCTOR on D_ID on field
(ii)Create unique index MEDICINE on composite M-CODE, Description

ERD digram banai thin yeh bhi 5 marks ka tha
Table diye hoe thae r btana tha kun sa join hai….

[$@mi]

Q.1:If a company can not compromise on data access time. which file processing technique you'll suggest in this case.
Q.2: difference b/w semi join & natural join.
Q.3: if table 1 has 20 indexes & table 2 has 14. both have same data & values. three statements were given to choose correct or incorrect b/w the tables.
q.4: statement: text based interfaces include more tables than GUI. justify it as true.
q.5: a table can have more than one clustered index . if true justify it.
q.6: semi join sql coding & 2 tables were given & you have to calculate resultant table.


q.7: what does SELECT keyword in sql?
q.8: A view have to created & a student table was given. in view you have to collect all st.ID which in ascending order where city=something.

[VAMPIRE EYES]

thanx fro sharing..

[$@mi]

not mention

[$@mi]

write down the alternative name of browser base form? 2 marks
Q2: Different classification of indexes? 2 Marks
Q3: List down any two problems which may come up if the concurrency is not controlled properly? 2 marks ( handout page 307)
Q4: In three schema architecture, External schema is responsible for data storage on hard disk. Correct and justify it. 3 marks
Q5: Create view named “Product_list” on product table which will show all the columns? 3 marks
Q6: Describe the importance of Data link properties tool in designing form by using MS Access? 3 marks
Q7: In recovery procedure, transaction ended before the check points are redone. Correct it and justify? 3 marks
Q8: Draw cross Reference matrix? 5 marks diagram was given
Q9: Deadlock is a serious threat for the concurrent transaction; shortly explain the approach which is used to detect the deadlock by DBMS? 5 marks
Q10: Rehashing is better than chaining in term of time. (Rehashing and chaining collision resolution technique in hashing). Justify it ? 5 Marks