Blog: CS403 Finalterm Paper 2013 File 7 Shared by Sweet Honey

  My today’s paper

1. How a VIEW can be used for security purposes?
2. List down the difference b/w relation and relationship?
3. Which DML statement is used to add new column in a table?
4. Differentiate b/w Exhaustive and Partial type indexes?
5. SELECT*FROM person

          WHERE FirstName LIKE ‘%a’
          What does the above statement return?

6. Identify the error in given zero level DFD?
7. Create a unique index named

          ‘IndexNum’ on the ‘CustNum’ column to the table customer?

8. Draw basic ERD from the list of requirement provided
9. Analyze the below given statements and mark as correct or incorrect and also explain.

i)          After defining indexes are not adopted in any case

ii)         Index can only be define, when table have at least 100 rows

1. Analyze the below given statement and mark as correct or incorrect and also explain.

      In recovery procedure the transaction which have begin and rebort an entry are  redone?

            Best of luck to all