(A) Data input programs
(B) Editing
(C) Display
(D) All of the above
Author:
Which of the following is not true regarding DB transactions?
(A) A set of database operations that are processed partly
(B) A database transaction is a logical unit of database operations
(C) A database transaction must be atomic
(D) A database transaction must contains the ACID property
Which of the following serves as a milestone or reference point in the log file?
(A) Constraints
(B) Check points
(C) Relations
(D) Transactions identities
Which of the following is NOT a feature of Indexed sequential files?
(A) Records are stored in sequence and index is maintained
(B) Dense and nondense types of indexes are maintained
(C) Track overflows and file overflow areas can not be ensured
(D) Cylinder index increases the efficiency
Which of the following is used to add or drop columns in an existing table?
(A) HAVING
(B) ALTER
(C) SELECT
(D) THEN
Which of the following is INCORRECT about VIEWS?
(A) It is not possible to left out the data which is not required for a specific view
(B) A database view displays one or more database records on the same page
(C) Views can be used as security mechanisms
(D) Views are generally used to focus the perception each user has of the database
Which of the following is not one of the properties of Transaction?
(A) Atomicity
(B) Consistency
(C) Redundancy
(D) Durability
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?
(A) 12
(B) 16
(C) 24
(D) 32