We are here with you hands in hands to facilitate your learning & don't appreciate the idea of copying or replicating solutions. Read More>>

Looking For Something at vustudents.ning.com? Click Here to Search

www.bit.ly/vucodes

+ Link For Assignments, GDBs & Online Quizzes Solution

www.bit.ly/papersvu

+ Link For Past Papers, Solved MCQs, Short Notes & More

CS403 Current Final Term Papers Fall 2010 (11~26 Feb 2011)

Please Share Your Current Paper pattern, MCQs & subjective Questions to help each other. Thanks

+ Click Here To Join also Our facebook study Group.

+ How to Join Subject Study Groups & Get Helping Material?

+ How to become Top Reputation, Angels, Intellectual, Featured Members & Moderators?


See Your Saved Posts Timeline

Views: 572

.

+ http://bit.ly/vucodes (Link for Assignments, GDBs & Online Quizzes Solution)

+ http://bit.ly/papersvu (Link for Past Papers, Solved MCQs, Short Notes & More)

+ Click Here to Search (Looking For something at vustudents.ning.com?)

Replies to This Discussion

Here is my paper held on Feb12,2011 5PM session

  1. What are two primary modes for taking locks---2 marks
  2. How minimum cardinality finding is important for relationship --2
  3. What are purpose of INPUT form ---2 marks
  4. What are three concurrency problems --3 marks
  5. Define composite key --3 marks
  6. Write down factors in defining key for index sequenced file --3 marks
  7. What is purpose behind HAVING clause ---3 marks
  8. Write down five features of VIEWS --- 5 marks
  9. What is purpose of VIEWS in DBMS--- 5 marks
  10. Write down syntax for IN clause --5 marks
  11. Differentiate Total and Partial completeness -- 5mark

keep remember in ur prayers

 

Total 52 questions

40Mcqs.90%mcqs were from chap#20-45.7-8mcqs were from past papers.

Some subjective questions which I remember are

What is a transaction? What are ACID properties?

What happened when lack of durability in transaction?

What is alternate key?

What are five features of Views?

Difference b/w Delete and truncate commands?

What is the purpose of DML commands?

What is serial execution?

What are the features of indexed serial execution?

What is Unary and Ternary relationship?

People the paper is quite lengthy(and the dusty keyboards makes it more lengthy ;)) ;)) )
52 questionions
42(objectives)
What is the difference between Commit and rollback?(2marks)
What is the problem which occur in normalization of 1 form of normalization(2marks)
Why will u prefer direct access over sequential access?(2marks)
This question i have forgotten(5marks)
What type of information is stored in data dictionary?(3marks)
What problem occurs when data concurrency is not controlled?(3marks)
What is the purpose of file protection?(3marks)
What are database objects?(5marks)
Write sql statement for display list of persons in table PERSON and show only that records whose first name is Ahmed and who's Last name is Ali(5marks)
What is unary and ternary Relationship?(5marks)
1.Application programmer as user of database systems, (5)
2.different b/w rollback and rollforward.(5)
3.why will you prefer delete command on drop command while deleting a table,(5)
4.how many number of clusters are used in database and reason of limit,
5.purpose of having clause,
6.purpose of protection,
7.explain data independency
8.two types of interface,
9.write DML statement that changes the values of one or more than one attribute based on some condition.
10.describe insertion anomaly,
11.COMMIT and ROLLBACK
1.Application programmer as user of database systems, (5)
2.different b/w rollback and rollforward.(5)
3.why will you prefer delete command on drop command while deleting a table,(5)
4.how many number of clusters are used in database and reason of limit,
5.purpose of having clause,
6.purpose of protection,
7.explain data independency
8.two types of interface,
9.write DML statement that changes the values of one or more than one attribute based on some condition.
10.describe insertion anomaly,
11.COMMIT and ROLLBACK
Dear Friends

AOA

I have given CS-403 DBMS paper. Most of the MCQ's are from past papers. Some subjective questions which i remeber are:


What is the purpose of IN Fucntions?
In which situation join is used?
What is serial execution?
Write three advantages of views?
What are locking protocols, explain?
What is rehashing?
In which situation self join is used?
Why direct access is preferred over sequential access?


Best of luck for your exams!

CS403 subjective

What is the difference between Commit and rollback?(2marks)
What is the problem which occur in normalization of 1 form of normalization(2marks)
Why will u prefer direct access over sequential access?(2marks)
This question i have forgotten(5marks)
What type of information is stored in data dictionary?(3marks)
What problem occurs when data concurrency is not controlled?(3marks)
What is the purpose of file protection?(3marks)
What are database objects?(5marks)
Write sql statement for display list of persons in table PERSON and show only that records whose first name is Ahmed and who's Last name is Ali(5marks)
What is unary and ternary Relationship?(5marks)

Dear Fellows in paper of CS 403 following were few questions that i m able to keep in memory

Suppose there are 8 rows and 4 columns in TABLE1 and 3 rows and 4 coulmns in TABLE2; what is the size of the cartesian product incase of CROSS JOIN between these two tables? http://vustudents.ning.com

       ► 24

       ► 32

       ► 12

       ► 16

Which of the following is not one of the properties of Transaction?

       ► atomicity

       ► consistency

       ► redundancy

       ► durability

 Which of the following is NOT a feature of Indexed sequential files?

       ► Records are stored in sequence and index is maintained.

        ► Dense and nondense types of indexes are maintained.

        ► Track overflows and file overflow areas can not be ensured.

        ► Cylinder index increases the efficiency

 

 Which of the following serves as a milestone or reference point in the log file?

 

       ► Constraints

       ► Relations

       ► Check points

       ► Transactions identities

 

Which of the following is not true regarding DB transactions?

 

       ► A set of database operations that are processed partly

       ► A database transaction is a logical unit of database operations

       ► A database transaction must be atomic

       ► A database transaction must contains the ACID property

 

 Which of the following are the general activities, which are performed during the development of application programs?

 

       ► Data input programs

       ► Editing

       ► Display

 

The main memory of a computer system is also known as

       ► ROM

       ► RAM

       ► PROM

       ► Hard disk

 

The main memory of a computer system is also known as

       ► ROM

       ► RAM

       ► PROM

       ► Hard disk

 

While recovering data, which of the following files does a recovery manager examines at first?

       ► A system file

       ► Log file

       ► Data dictionary

       ► Metadata

 

What is the alternate name of Data Dictionary?

       ► Index

       ► Metadata

       ► Data

       ► System Catalog

 

Which of the following statements are Data Definition Language command?

       ► INSERT

       ► UPDATE

       ► GRANT

       ► TRUNCATE

 

Questions were

1) Difference Bet Delete Table and Drop Table?
2) Commanlities bet Materialized View and Indexes?

3)Difference bet partial Completeness and Total Completeness Constraints

4)What is Entity Extension?

Pray For me as well

Thx

       ► All of given

Dear Fellows in paper of CS 403 following were few questions that i m able to keep in memory

Suppose there are 8 rows and 4 columns in TABLE1 and 3 rows and 4 coulmns in TABLE2; what is the size of the cartesian product incase of CROSS JOIN between these two tables?
► 24

► 32

► 12

► 16

Which of the following is not one of the properties of Transaction?

► atomicity

► consistency

► redundancy

► durability

Which of the following is NOT a feature of Indexed sequential files?

► Records are stored in sequence and index is maintained.

► Dense and nondense types of indexes are maintained.

► Track overflows and file overflow areas can not be ensured.

► Cylinder index increases the efficiency



Which of the following serves as a milestone or reference point in the log file?



► Constraints

► Relations

► Check points

► Transactions identities



Which of the following is not true regarding DB transactions?



► A set of database operations that are processed partly

► A database transaction is a logical unit of database operations

► A database transaction must be atomic

► A database transaction must contains the ACID property



Which of the following are the general activities, which are performed during the development of application programs?



► Data input programs

► Editing

► Display



The main memory of a computer system is also known as

► ROM

► RAM

► PROM

► Hard disk



The main memory of a computer system is also known as

► ROM

► RAM

► PROM

► Hard disk



While recovering data, which of the following files does a recovery manager examines at first?

► A system file

► Log file

► Data dictionary

► Metadata



What is the alternate name of Data Dictionary?

► Index

► Metadata

► Data

► System Catalog



Which of the following statements are Data Definition Language command?

► INSERT

► UPDATE

► GRANT

► TRUNCATE



Questions were

1) Difference Bet Delete Table and Drop Table?
2) Commanlities bet Materialized View and Indexes?

3)Difference bet partial Completeness and Total Completeness Constraints

4)What is Entity Extension?

Pray For me as well

Thx

► All of given


My cs403 subjective questions



In which situation join is used?



Join

Joins can be used in SELECT, UPDATE and DELETE statements.

What is serial execution?

Serial execution is when tasks are completed consecutively (one after the other), as opposed to concurrently (at the same time, in parallel).







Write three advantages of views?

Advantages of views:

1. View the data without storing the data into the object.

2. Restict the view of a table i.e. can hide some of columns in the tables.

3. Join two or more tables and show it as one object to user.

4. Restict the access of a table so that nobody can insert the rows into the table.

Disadvatages:

1. Can not use DML operations on this.

2. When table is dropped view becomes inactive.. it depends on the table objects.

3. It is an object so it occupies space.

What are locking protocols, explain?

What is rehashing?

One has to use 'rehash' to get

table and field completion. This gives a quicker start of

mysql and disables rehashing on reconnect. WARNING:

options deprecated; use --disable-auto-rehash instead.





In which situation self join is used?

Self Join is nothing but a table joining with itself.



It is very helpful to fetching duplicate data from a table..

if we want to fetch the emp_id from emp whice are duplicate in emp tab.

examp:



select a.emp_id b.emp_id

from emp a emp b

where a.emp_id=b.emp_id and

a.rowid<>b.rowid.



we can get duplicate value easily by help of self join



Why direct access is preferred over sequential access?

Disk storage has several characteristics to recommend it: it is physically secure, requiring no handling; it provides both sequential and direct access to records; and it is reasonable in cost. These factors make disk storage the preferred medium today.

While tape storage is relatively simple, disk storage can be complex. Although sequential access on disk is no more complex than on tape, direct access may involve complex file structures. Efficient use of these structures requires an understanding of the physical medium and the operating system components that perform the actual reading and writing of data on the disk.
FILE opertations and examples with sql? (5)
3 Transations problems
Importance of NOt NUll ? (5)
Some Questions which I could remember.

Difference b/w COMMIT and ROLLBACK (2)

Define the domain of attribute? (2)

What is the purpose of protection? (3)

What is the main objective Concurrency Control? (5)

RSS

Latest Activity

M +S +K posted a status
"Bahut Roka Dil Ko Magar Kahan Tak Rokta, Mohabbat Barhti Gayi, Tumhare Nakhron Ki Tarah"
1 minute ago
M +S +K posted a status
"Mujhe Qabool Hai Har Dard Har Takleef Teri Chahat Mein, Sirf Itna Bata Doh Kya Tumhe Meri Mohabbat Qabool Hai"
2 minutes ago
M +S +K posted a status
"Dushmano Se Mohabbat Hone Lagi Mujhe, Jaise Jaise Apno Ko Azmaate Chale Gaye"
4 minutes ago
M +S +K posted a status
"Hai Dua Hamari Sab Ko Mil Jaye Apni Apni Mohabbat, Khuda Kisi Ko Kisi Se Juda Na Kare"
5 minutes ago
+ M.Tariq Malik added 2 discussions to the group MCM310 Journalistic Writing
9 minutes ago
+ M.Tariq Malik's 35 discussions were featured
10 minutes ago
+ M.Tariq Malik liked + M.Tariq Malik's discussion MCM310 Journalistic Writing Lecture's Handouts
10 minutes ago
M +S +K posted a status
"Alfaaz Akser Adhure Hee Reh Jaate Hain Mohabbat Mein, Har Shaks Kisi Na Kisi Ki Chahat Dil Mein Dabaye Rakhta Hai"
12 minutes ago

© 2019   Created by + M.Tariq Malik.   Powered by

Promote Us  |  Report an Issue  |  Privacy Policy  |  Terms of Service