DBMS MCQ Question and Answer
DBMS MCQ Question and Answer
161. An abstract model of the database from a business perspective best defines:
- physical design
- object design
- organizational view
- conceptual design
162. The process of creating small, stable data structures from complex groups of data when designing a relational database defines:
- data decomposition
- data structuring
- data transcribing
- normalization
163. Which of the following best describes a special organizational function for managing the organization
- database administration
- information management
- data analysis
- data administration
164. Data administration:
- establishes specific policies and procedures through which data can be managed as an organizational resource.
- establishes access rules and procedures.
- defines and organizes database structure and content.
- maintains the database
165. A collection of operations that performs a single logic function is called
- schedule
- transaction
- DBA
- none of the above
166. A table
- does not define logical order of records
- orders record by key field in a record
- orders records by the first field of a record
- imposes a logical order on record
167. Atomicity means
1 .complete commit
2. complete rollback
3. partial commit
4. partial roll back
- 1 only
- 2 only
- 1 and 2
- 3 and 4
168. Which of the following property ensures that the state of database is same when it ends as it was began
- Atomicity
- Consistency
- Isolation
- Durability
169. What is isolation
- The operation of one transaction does not affect the operation of other transaction
- Once a transaction is completed the results will persist
- The state of database is the same when it ends as it begins
- none