3 Comments

1. 

   AYESHA MUMTAZ on February 8, 2019 at 9:58 am

   CS403 – Database Management Systems
   Final term Subjective Paper 2011(fall)
   Question#1 (Marks 2)
   SELECT * FRO Persons
   WHERE Firstname Like ―% da %‖;
   What does the above statement returne?
   Answer:-
   Return all records containing L in attribute name ‗Firstname‘ from persons table.
   Question#2 (Marks 2)
   What is the difference between Primary key and a unique key with reference to clustered and non-clustered
   indexes?
   Answer:- Click here for detail
   Primary key can not be null but unique can have only one null value.
   Primary key create the cluster index automatically but unique key not.
   A table can have only one primary key but unique key more than one.
   Question#3 (Marks 5)
   Create a simple index, named ―Personal Index‖ on the LastName field of the person table?
   Answer:- Click here for detail
   TABLE person
   (
   FirstName char(15),
   LastName char(15),
   Address char(50),
   City char(50),
   Country char(25),
   )
   CREATE INDEX new_person_ LastName
   on person (LastName)
   Question#4 (Marks 5)
   Writing the basic syntax of adding a record to a table.
   Answer:- Click here for detail
   INSERT INTO table_name
   VALUES (value1, value2, value3…)
   20
   Question#5 (Marks 5)
   Give 4 similarities between Materialized views and indexes?
   Answer:- (Page 290)
   • They consume storage space.
   • They must be refreshed when the data in their master tables changes.
   • They improve the performance of SQL execution when they are used for query rewrites.
   • Their existence is transparent to SQL applications and users.
   Question#6 (Marks 3)
   How the stamping approach does works to give priorities to the transactions?
   Question#7 (Marks 3)
   Name the primary key modes for taking locks?
   Answer:- rep
   Question#8 (Marks 2)
   State any two problems that can come up as a result of inconsistent data base?
   Answer:- (Page 307)
   Lost Update Problem
   Uncommitted Update Problem
   Inconsistent Analysis Problem

2. 

   AYESHA MUMTAZ on February 8, 2019 at 10:03 am

   FINALTERM EXAMINATION
   Spring 2010
   CS403- Database Management Systems
   Question No: 28 ( M a r k s: 2 )
   Define domain of an attribute.
   Answer:- rep
   Question No: 29 ( M a r k s: 2 )
   Write the main feature of volatile storage media?
   Answer:- (Page 255)
   Computer storage that is lost when the power is turned off is called as volatile storage. For example RAM
   Question No: 30 ( M a r k s: 2 )
   Suppose you want to delete a table row by row and record an entry in the transaction log for each deleted row.
   Which DML command will you use?
   Answer:- rep
   Question No: 31 ( M a r k s: 3 )
   Write three benefits of using VIEWS.
   Answer:- rep
   Question No: 32 ( M a r k s: 3 )
   SELECT * FROM Persons
   WHERE FirstName LIKE ‘%da%’;
   Question No: 33 ( M a r k s: 3 )
   What is the difference between a primary key and a unique key with reference to clustered and nonclustered
   indexes?
   Answer:- rep
   23
   Question No: 34 ( M a r k s: 5 )
   Consider a table named COMPANY with fields COMPANY_NAME,
   DESCRIPTION, ORDER_NUMBER. Write an SQL statement to display company names in reverse
   alphabetical order.
   Answer:- Click here for detail
   select COMPANY_NAME
   from COMPANY order by COMPANY_NAME desc;
   Question No: 35 ( M a r k s: 5 )
   Name the five main components of Database management systems software.
   Answer:- Click here for detail
   1. DBMS engine
   2. Data definition subsystem
   3. Data manipulation subsystem
   4. Application generation subsystem
   5. Data administration subsystem
   Question No: 36 ( M a r k s: 5 )
   Give 4 similarities between Materialized views and indexes.
   Answer:- rep

3. 

   AYESHA MUMTAZ on February 8, 2019 at 10:05 am

   FINALTERM EXAMINATION
   Spring 2010
   CS403- Database Management Systems (10 Aug 2010)
   Question No: 23 ( M a r k s: 2 )
   Give 2 similarities between Materialized views and indexes.
   Answer:- rep
   Question No: 24 ( M a r k s: 2 )
   What are the forms of cache normally used in desktop computers
   Answer:- Click here for detail
   Two types of caching are commonly used in personal computers: memory caching and disk caching.
   Question No: 25 ( M a r k s: 3 )
   Write the properties of Sequence File
   Answer:- (Page 259)
   Records are arranged on storage devices in some sequence based on the value of some field, called sequence
   field. Sequence field is often the key field that identifies the record.
   24
   Simply, easy to understand and manage, best for providing sequential access. It is not feasible for direct or
   random access; inserting/deleting a record in/from the middle of the sequence involves cumbersome record
   searches and rewriting of the file.
   Question No: 26 ( M a r k s: 3 )
   What is meant by database recovery services?
   Answer:- (Page 47)
   Recovery services mean that in case a database gets an inconsistent state to get corrupted due to any invalid
   action of someone, the DBMS should be able to recover itself to a consistent state, ensuring that the data loss
   during the recovery process of the database remains minimum.
   Question No: 27 ( M a r k s: 5 )
   Write four steps to recover from a deadlock between the transactions
   Answer:- (Page 320)
   Following are some of the approaches for the deadlock handling:
   • Deadlock prevention
   • Deadlock detection and resolution
   • Prevention is not always possible
   • Deadlock is detected by wait-for graph
   Question No: 28 ( M a r k s: 5 )
   Consider a table named COMPANY with fields COMPANY_NAME,
   DESCRIPTION, ORDER_NUMBER. Write an SQL statement to display company names in reverse
   alphabetical order.
   Answer:- rep
   Question No: 29 ( M a r k s: 5 )
   Write five advantages of using VIEWS.
   Answer:- rep