-
1)
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
-
2)
Which of the following serves as a milestone or reference point in the log file?
- A) Constraints
- B) Relations
- C) Check points
- D) Transactions identities
-
3)
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
-
4)
Which of the following are the general activities, which are performed during the development of application programs?
- A) Data input programs
- B) Editing
- C) Display
- D) All of given
-
5)
Browser based forms are developed in the following tools EXCEPT
- A) HTML
- B) Scripting language
- C) Front Page
- D) Web-based Forms
-
6)
Which of the following is not a form of optical disk?
- A) CD ROM
- B) WORM
- C) Erasable Optical
- D) EEPROM
-
7)
Which of the following is the correct description of cache hit?
- A) When data is found in the cache
- B) When data is removed in the cache
- C) The number of times the cache is accessed directly by the processor
- D) When data is lost from the cache
-
8)
In which of the following situations, Clustering is suitable:
- A) Frequently updating
- B) Relatively static
- C) Relatively deletion
- D) Relatively dynamic
-
9)
Only one type of constraint can be enforced in any table by CREATE command
- A) True
- B) False
-
10)
Which of the following is disadvantage of chaining technique to handle the collisions?
- A) Unlimited Number of elements
- B) Fast re-hashing
- C) Overhead of multiple linked lists
- D) Maximum number of elements must be known
