MCQOPTIONS
Saved Bookmarks
MCQOPTIONS
This section includes 26 Mcqs, each offering curated multiple-choice questions to sharpen your Database knowledge and support exam preparation. Choose a topic below to get started.
| 1. |
Distributing the columns of a table into several separate physical records is known as horizontal partitioning.~! |
| A. | True |
| B. | False |
| Answer» C. | |
| 2. |
A bitmap index is an index on columns from two or more tables that come from the same domain of values.~! |
| A. | True |
| B. | False |
| Answer» C. | |
| 3. |
It is usually not very important to design the physical database to minimize the time required by users to interact with the information systems.~! |
| A. | True |
| B. | False |
| Answer» C. | |
| 4. |
A pointer is a detailed coding scheme recognized by system software for representing organizational data.%! |
| A. | True |
| B. | False |
| Answer» C. | |
| 5. |
The primary goal of physical database design is data processing efficiency.%! |
| A. | True |
| B. | False |
| Answer» B. False | |
| 6. |
In general, larger block sizes are used for online transaction processing applications and smaller block sizes are used for databases with a decision support or data warehousing system.%! |
| A. | True |
| B. | False |
| Answer» C. | |
| 7. |
Some advantages of partitioning include: efficiency, security, and load balancing.%! |
| A. | True |
| B. | False |
| Answer» B. False | |
| 8. |
Hashing algorithm converts a primary key value into a record address.%! |
| A. | True |
| B. | False |
| Answer» B. False | |
| 9. |
Data-volume and frequency-of-use statistics are not critical inputs to the physical database design process.%! |
| A. | True |
| B. | False |
| Answer» C. | |
| 10. |
A field represents each component of a composite attribute.%! |
| A. | True |
| B. | False |
| Answer» B. False | |
| 11. |
Denormalization and clustering can work well to minimize data access time for small records.%! |
| A. | True |
| B. | False |
| Answer» B. False | |
| 12. |
The three newest database architectures in use today are relational, multidimensional and hierarchical.%! |
| A. | True |
| B. | False |
| Answer» C. | |
| 13. |
When storage space is scarce and physical records cannot span pages, creating multiple physical records from one logical relation will minimize wasted storage space.%! |
| A. | True |
| B. | False |
| Answer» B. False | |
| 14. |
Two basic constructs to link one piece of data with another piece of data: sequential storage and pointers.%! |
| A. | True |
| B. | False |
| Answer» B. False | |
| 15. |
An extent is a contiguous section of disk storage space.%! |
| A. | True |
| B. | False |
| Answer» B. False | |
| 16. |
*$_A multidimensional database model is used most often in which of the following models?? |
| A. | Data warehouse |
| B. | Relational |
| C. | Hierarchical |
| D. | Network |
| Answer» B. Relational | |
| 17. |
*$_What is the best data type definition for Oracle when a field is alphanumeric and has a fixed length?? |
| A. | VARCHAR2 |
| B. | CHAR |
| C. | LONG |
| D. | NUMBER |
| Answer» C. LONG | |
| 18. |
*/*_Which of the following is an advantage of partitioning?? |
| A. | Complexity |
| B. | Inconsistent access speed |
| C. | Extra space |
| D. | Security |
| Answer» E. | |
| 19. |
%_Sequential retrieval on a primary key for sequential file storage has which of the following features?_% |
| A. | Very fast |
| B. | Moderately fast |
| C. | Slow |
| D. | Impractical |
| Answer» B. Moderately fast | |
| 20. |
%_Which of the following is not a factor to consider when switching from small to large block size?_% |
| A. | The length of all of the fields in a table row |
| B. | The number of columns |
| C. | Block contention |
| D. | Random row access speed |
| Answer» C. Block contention | |
| 21. |
_ If a denormalization situation exists with a many-to-many or associative binary relationship, which of the following is true?$? |
| A. | All fields are stored in one relation. |
| B. | All fields are stored in two relations. |
| C. | All fields are stored in three relations. |
| D. | All fields are stored in four relations. |
| Answer» C. All fields are stored in three relations. | |
| 22. |
_A rule of thumb for choosing indexes for a relational database includes which of the following?$? |
| A. | Indexes are more useful on smaller tables. |
| B. | Indexes are more useful for columns that do not appear frequently in the WHERE clause in queries. |
| C. | Do not specify a unique index for the primary key of each table. |
| D. | Be careful indexing attributes that have null values. |
| Answer» E. | |
| 23. |
_Which of the following are integrity controls that a DBMS may support?$? |
| A. | Assume a default value in a field unless a user enters a value for that field. |
| B. | Limit the set of permissible values that a field may assume. |
| C. | Limit the use of null values in some fields. |
| D. | All of the above. |
| Answer» E. | |
| 24. |
What is the best data type definition for Oracle when a field is alphanumeric and has a length that can vary?$? |
| A. | VARCHAR2 |
| B. | CHAR |
| C. | LONG |
| D. | NUMBER |
| Answer» B. CHAR | |
| 25. |
The fastest read/write time and most efficient data storage of any disk array type is:? |
| A. | RAID-0 |
| B. | RAID-1 |
| C. | RAID-2 |
| D. | RAID-3 |
| Answer» B. RAID-1 | |
| 26. |
Which of the following improves a query's processing time?? |
| A. | Write complex queries. |
| B. | Combine a table with itself. |
| C. | Query one query within another. |
| D. | Use compatible data types. |
| Answer» E. | |