CS-403 Final Term Exams Preparation Virtual University With Answers

image
image
image

CS-403 Final Term Exams Preparation Virtual University

Sr. # Questions Answers Choice
1 Which of the following are the general activities, which are performed during the development of application programs? Data input programs Editing Display All of given
2 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
3 Which of the following serves as a milestone or reference point in the log file? Constraints Relations Check points Transactions identities
4 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
5 Which of the following is a correct way of selecting all the columns from a table called PERSONS? SELECT FROM * Persons SELECT * FROM Persons SELECT * WHERE Persons SELECT WHERE * Persons
6 Which of the following is used to add or drop columns in an existing table? ALTER HAVING SELECT THEN
7 Each course section is assigned a particular faculty member, and each course section corresponds to a particular course. Conceptually, what is the relationship between faculty and course (not course section). 1:1 1:M M:M Ternary
8 Which of the following is INCORRECT about VIEWS? It is not possible to left out the data which is not required for a specific view. A database view displays one or more database records on the same page. Views can be used as security mechanisms Views are generally used to focus the perception each user has of the database.
9 Which of the following is not one of the properties of Transaction? atomicity consistency redundancy durability
10 Suppose there are 8 rows and 4 columns in TABLE1 and 3 rows and 4 columns in TABLE2; what is the size of the cartesian product incase of CROSS JOIN between these two tables? 24 ( The number of rows in the first table multiplied by the number of rows in the second table ) 32 12 16
Download This Set
×