MCQOPTIONS
Saved Bookmarks
MCQOPTIONS
This section includes 98 Mcqs, each offering curated multiple-choice questions to sharpen your Database Management System knowledge and support exam preparation. Choose a topic below to get started.
| 1. |
Dependency preservation is not guaranteed in |
| A. | BCNF |
| B. | 3NF |
| C. | PJNF |
| D. | DKNF |
| Answer» B. 3NF | |
| 2. |
Wait-for graph is used for |
| A. | detecting view serializability. |
| B. | detecting conflict serializability. |
| C. | C. |
| D. | |
| E. | deadlock detection |
| Answer» E. deadlock detection | |
| 3. |
Cascading rollback is avoided in all protocol except |
| A. | strict two-phase locking protocol. |
| B. | tree locking protocol |
| C. | two-phase locking protocol |
| D. | validation based protocol. |
| Answer» E. | |
| 4. |
Relationships among relationships can be represented in an-E-R model using |
| A. | Aggregation |
| B. | Association |
| C. | Weak entity sets |
| D. | Weak relationship sets |
| Answer» B. Association | |
| 5. |
The part of a database management system which ensures that the data remains in a consistent state is |
| A. | authorization and integrity manager |
| B. | buffer manager |
| C. | transaction manager |
| D. | file manager |
| Answer» D. file manager | |
| 6. |
Which of the following is not a consequence of non-normalized database? |
| A. | Update Anomaly |
| B. | Insertion Anomaly |
| C. | Redundancy |
| D. | Lost update problem |
| Answer» E. | |
| 7. |
Which among the following field type is used to store photograph of employees? |
| A. | Memo |
| B. | Picture |
| C. | OLE |
| D. | Photo |
| Answer» D. Photo | |
| 8. |
Which among the following field type can store maximum data? |
| A. | Yes/No fields |
| B. | Date/Time fields |
| C. | Text fields |
| D. | Memo fields |
| Answer» E. | |
| 9. |
Which among following relationship type is not possible to realize in Access Database directly? |
| A. | One to one |
| B. | One to many |
| C. | Many to many |
| D. | None of above |
| Answer» D. None of above | |
| 10. |
Which among the following filter method is not available in Access? |
| A. | Filter by selection |
| B. | Filter by form |
| C. | Advanced filter |
| D. | None of above |
| Answer» D. None of above | |
| 11. |
operator is used to compare a value to a list of literals values that have been specified. |
| A. | Like |
| B. | COMPARE |
| C. | BETWEEN |
| D. | IN |
| Answer» B. COMPARE | |
| 12. |
Which is the best file organization when data is frequently added or deleted from a file? |
| A. | Sequential |
| B. | Direct |
| C. | Index sequential |
| D. | D. |
| E. | |
| Answer» C. Index sequential | |
| 13. |
Which of the following constitutes a basic set of operations for manipulating relational data? |
| A. | Predicate calculus |
| B. | B. |
| C. | |
| D. | Relational algebra |
| E. | D. |
| Answer» D. Relational algebra | |
| 14. |
______ keyword is used to find the number of values in a column. |
| A. | TOTAL |
| B. | ADD |
| C. | COUNT |
| D. | SUM |
| Answer» D. SUM | |
| 15. |
______contains information that defines valid values that are stored in a column or data type. |
| A. | Default |
| B. | Index |
| C. | Rule |
| D. | View |
| Answer» C. Rule | |
| 16. |
SQL server stores index information in the _____system table |
| A. | system indexes |
| B. | B. |
| C. | |
| D. | sys indexes |
| E. | D. |
| Answer» D. sys indexes | |
| 17. |
______defines the structure of a relation which consists of a fixed set of attribute-domain pairs. |
| A. | Instance |
| B. | Program |
| C. | Schema |
| D. | Super Key |
| Answer» D. Super Key | |
| 18. |
____ table store information about database or about the system. |
| A. | SQL |
| B. | System |
| C. | Nested |
| D. | None of these |
| Answer» C. Nested | |
| 19. |
In an ER model,_____ is described in the database by storing its data. |
| A. | Entity |
| B. | Attribute |
| C. | Relationship |
| D. | Notation |
| Answer» B. Attribute | |
| 20. |
The relational model is based on the concept that data is organized and stored in two-dimensional tables called ______ |
| A. | Fields |
| B. | Records |
| C. | Relations |
| D. | Keys |
| Answer» D. Keys | |
| 21. |
______is a preferred method for enforcing data integrity |
| A. | Constraints |
| B. | Triggers |
| C. | Stored procedure |
| D. | D. |
| Answer» B. Triggers | |
| 22. |
Which of the following is not a logical database structure? |
| A. | Chain |
| B. | Network |
| C. | Tree |
| D. | Relational |
| Answer» B. Network | |
| 23. |
_____clause is an additional filter that is applied to the result. |
| A. | Select |
| B. | Order by |
| C. | C. |
| D. | D. |
| Answer» E. | |
| 24. |
Processed data is called _____ |
| A. | Raw data |
| B. | B. |
| C. | C. |
| D. | D. |
| E. | |
| Answer» D. D. | |
| 25. |
What will be the number of columns and rows respectively obtained for the operation, A- B, if A B are Base union compatible and all the rows of a are common to B? Assume A has 4 columns and 10 rows; and B has 4 columns and 15 rows |
| A. | 4,0 |
| B. | 0,0 |
| C. | 4,5 |
| D. | 8,5 |
| Answer» B. 0,0 | |
| 26. |
For correct behaviour during recovery, undo and redo operation must be |
| A. | Commutative |
| B. | Associative |
| C. | idempotent |
| D. | distributive |
| Answer» D. distributive | |
| 27. |
Which of the following ensures the atomicity of the transaction? |
| A. | Transaction management component of DBMS |
| B. | Application Programmer |
| C. | Concurrency control component of DBMS |
| D. | Recovery management component of DBMS |
| Answer» B. Application Programmer | |
| 28. |
Which of the following relational algebraic operations is not from set theory? |
| A. | Union |
| B. | Intersection |
| C. | Cartesian Product |
| D. | Select |
| Answer» E. | |
| 29. |
The values of the attribute describes a particular |
| A. | Entity set |
| B. | File |
| C. | Entity instance |
| D. | Organization |
| Answer» D. Organization | |
| 30. |
Which of the following addressing modes permits relocation without any change over in the code? |
| A. | Indirect addressing |
| B. | Indexed addressing |
| C. | PC relative addressing |
| D. | Base register addressing |
| Answer» C. PC relative addressing | |
| 31. |
In a multi-user database, if two users wish to update the same record at the same time, they are prevented from doing so by |
| A. | jamming |
| B. | password |
| C. | documentation |
| D. | record lock |
| Answer» E. | |
| 32. |
The graphical representation of a query is . |
| A. | B-Tree |
| B. | graph |
| C. | Query Tree |
| D. | D. |
| E. | |
| Answer» D. D. | |
| 33. |
Which of the following is not a characteristic of a relational database model? |
| A. | Table |
| B. | Tree like structure |
| C. | C. |
| D. | |
| E. | Records |
| Answer» C. C. | |
| 34. |
In E-R Diagram total participation is represented by |
| A. | Double lines |
| B. | B. |
| C. | |
| D. | Dashed lines |
| E. | D. |
| Answer» B. B. | |
| 35. |
Which normal form is considered adequate for normal relational database design? |
| A. | 2NF |
| B. | 5NF |
| C. | 4NF |
| D. | 3NF |
| Answer» E. | |
| 36. |
The drawback of shadow paging technique are |
| A. | Commit overhead |
| B. | Data fragmentation |
| C. | Garbage collection |
| D. | All of these |
| Answer» E. | |
| 37. |
As per equivalence rules for query transformation, selection operation distributes over |
| A. | Union. |
| B. | Set difference. |
| C. | C. |
| D. | D. |
| E. | |
| Answer» E. | |
| 38. |
It is an abstraction through which relationships are treated as higher level entities |
| A. | Generalization. |
| B. | Specialization. |
| C. | Aggregation. |
| D. | Inheritance. |
| Answer» D. Inheritance. | |
| 39. |
Which of the syntax is correct for insert statement? i) insert into values ii) insert into (column list) values |
| A. | i-only |
| B. | ii-only |
| C. | Both of them |
| D. | D. |
| E. | |
| Answer» D. D. | |
| 40. |
An outstanding functionality of SQL is its support for automatic_____ to the target data. |
| A. | programming |
| B. | navigation |
| C. | functioning |
| D. | notification |
| Answer» C. functioning | |
| 41. |
Which of the following is not comparison operator? |
| A. | <> |
| B. | < |
| C. | =< |
| D. | >= |
| Answer» D. >= | |
| 42. |
A _____ is used to define overall design of the database |
| A. | code |
| B. | data definition language |
| C. | C. |
| D. | |
| E. | schema |
| Answer» E. schema | |
| 43. |
The collection of information stored in a database at a particular moment is called as ...... |
| A. | schema |
| B. | instance of the database |
| C. | C. |
| D. | |
| E. | independence |
| Answer» C. C. | |
| 44. |
The set of all values that can be taken by the attribute is called as _______ of the attribute. |
| A. | Tuple |
| B. | Cardinality |
| C. | Degree |
| D. | Domain |
| Answer» E. | |
| 45. |
The ______ indexes are forced to store only record IDs in the data structure and require at least one additional I/O Operation to retrieve the actual record. |
| A. | Clustered |
| B. | Hashed |
| C. | Un-clustered |
| D. | Collision |
| Answer» D. Collision | |
| 46. |
The _______ is a set of programs to use and / or modify this data. |
| A. | DBMS |
| B. | System |
| C. | Program |
| D. | Software |
| Answer» B. System | |
| 47. |
DBMS helps achieve |
| A. | Centralized control of data |
| B. | Data independence |
| C. | Both A and B |
| D. | D. |
| E. | |
| Answer» D. D. | |
| 48. |
_____ command can be used to modify a column in a table |
| A. | alter |
| B. | update |
| C. | set |
| D. | create |
| Answer» B. update | |
| 49. |
A _____ is a logical unit of database processing that includes one or more data access operations that can include insertion, deletion, modification or retrieval operations. |
| A. | Database |
| B. | Data |
| C. | Transaction |
| D. | Record |
| Answer» D. Record | |
| 50. |
The ____ operator joins two or more conditions and displays rows only if that rows data satisfies all conditions specified. |
| A. | OR |
| B. | AND |
| C. | NOT |
| D. | ALL |
| Answer» C. NOT | |