cs403 final term current paper spring July 2011

[Vuhelper]

full solve papers are in attachment


Question No: 1 ( Marks: 1 ) - Please choose one
Which feature of database provides conversion from inconsistent state of DB to a consistent state ensuring minimum data loss?
► User accessible catalog
► Data processing
► Authorization service
► Recovery service

Question No: 2 ( Marks: 1 ) - Please choose one
Which of the following statements is true about the views?
► view is always a complete set of all the tables in a database
► View can not be used for retrieving data
► The results of using a view are not permanently stored in the database.
► Rows can not be updated or deleted in the view

Question No: 3 ( Marks: 1 ) - Please choose one
Which of the following is true about TRUNCATE?
► Can be Rolled back.
► Activates Triggers.
► is DML Command.
► Resets identity of the table.
1. TRUNCATE is faster and uses fewer system and transaction log resources than DELETE.
2. TRUNCATE removes the data by deallocating the data pages used to store the table's data, and only the page deallocations are recorded in the transaction log.
3. TRUNCATE removes all rows from a table, but the table structure, its columns, constraints, indexes and so on, remains. The counter used by an identity for new rows is reset to the seed for the column.
4. You cannot use TRUNCATE TABLE on a table referenced by a FOREIGN KEY constraint. Because TRUNCATE TABLE is not logged, it cannot activate a trigger.
5. TRUNCATE cannot be rolled back.
6. TRUNCATE is DDL Command.
7. TRUNCATE Resets identity of the table
Question No: 4 ( Marks: 1 ) - Please choose one
Which of the following is the correct way to find out the size of cartesian product incase of CROSS JOIN?
► the number of columns in the first table multiplied by the number of columns in the second table.
► the number of columns in the first table multiplied by the number of rows in the second table.
► the number of rows in the first table multiplied by the number of columns in the first table.
► the number of rows in the first table multiplied by the number of rows in the second table.

Question No: 5 ( Marks: 1 ) - Please choose one
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

Question No: 6 ( Marks: 1 ) - Please choose one
Which of the following is not one of the properties of Transaction?
► atomicity
► consistency
► redundancy
► durability