+971 55 359 3828 vuassassins@gmail.com
Spread the love

CS403 – Database Management Systems

In CS403 Database Management Systems we have you covered with Digitized Past Papers From Fall of Mid Term and Final Term.

NOTE: Tab/Click on Preparation Tab to take the MCQ’s Tests.

FINAL TERM
CS403_FINAL_SOL_SUBJEMOAAZ                            View     Download
CS403_FINALSOLMCQSMOAAZ                                 View     Download
MID TERM
CS403_Mid_2010_Mcqs_Moaaz_Paper1                     View     Download
CS403_Mid_2011_Sbj_Moaaz_Paper2                         View     Download

Quiz Cat: No Quiz found

Quiz Cat: No Quiz found

Quiz Cat: No Quiz found

POSTED DATE:06-02-2019          GDB SOLUTION

The principal vital perspective is that the different database will give better security to all association. As information isn’t shared so this will diminish the uncertainties. Intrusion in any database framework does not influence the other database of different associations. Amid upkeep and overhauls, it’s less demanding to make changes in littler database when contrasted with an extensive brought together database. Dimension of consistency will be better for each different database.

CS403– Practice Quiz 1

3 Comments

  1. AYESHA MUMTAZ

    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

    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

    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

SPIN TO WIN!

  • Try your lucky to get discount coupon
  • 1 spin per email
  • No cheating
Try Your Lucky
Never
Remind later
No thanks