1. | If a piece of data is stored in two places in the database, then |
A. | Storage space is wasted |
B. | Changing the data in one spot will cause data inconsistency |
C. | In can be more easily accessed |
D. | Storage space is wasted & Changing the data in one spot will cause data inconsistency |
Answer» D. Storage space is wasted & Changing the data in one spot will cause data inconsistency |
2. | An audit trail ___________ |
A. | Is used to make backup copies |
B. | Is the recorded history of operations performed on a file |
C. | Can be used to restore lost information |
D. | None of the mentioned |
Answer» B. Is the recorded history of operations performed on a file |
3. | Large collection of files are called ____________ |
A. | Fields |
B. | Records |
C. | Database |
D. | Sectors |
Answer» C. Database |
4. | Which of the following hardware component is the most important to the operation of a database management system? |
A. | High resolution video display |
B. | Printer |
C. | High speed, large capacity disk |
D. | Mouse |
Answer» C. High speed, large capacity disk |
5. | Which of the following is not true of the traditional approach to information processing |
A. | There is common sharing of data among the various applications |
B. | It is file oriented |
C. | Programs are dependent on the file |
D. | It is inflexible |
Answer» A. There is common sharing of data among the various applications |
6. | The information about data in a database is called _______ |
A. | Metadata |
B. | Hyper data |
C. | Tera data |
D. | None of the mentioned |
Answer» A. Metadata |
7. | A data dictionary is a special file that contains? |
A. | The names of all fields in all files |
B. | The data types of all fields in all files |
C. | The widths of all fields in all files |
D. | All of the mentioned |
Answer» D. All of the mentioned |
8. | A relational database system needs to maintain data about the relations, such as the schema of the relations. This is called |
A. | Metadata |
B. | Catalog |
C. | Log |
D. | Dictionary |
Answer» A. Metadata |
9. | Relational schemas and other metadata about relations are stored in a structure called the ____________ |
A. | Metadata |
B. | Catalog |
C. | Log |
D. | Data Dictionary |
Answer» D. Data Dictionary |
10. | ___________ is the collection of memory structures and Oracle background processes that operates against an Oracle database. |
A. | Database |
B. | Instance |
C. | Tablespace |
D. | Segment |
Answer» B. Instance |
11. | A ________ is a logical grouping of database objects, usually to facilitate security, performance, or the availability of database objects such as tables and indexes. |
A. | Tablespace |
B. | Segments |
C. | Extents |
D. | Blocks |
Answer» A. Tablespace |
12. | A tablespace is further broken down into ________ |
A. | Tablespace |
B. | Segments |
C. | Extents |
D. | Blocks |
Answer» B. Segments |
13. | __________ is a contiguous group of blocks allocated for use as part of a table, index, and so forth. |
A. | Tablespace |
B. | Segment |
C. | Extent |
D. | Block |
Answer» C. Extent |
14. | ________ is the smallest unit of allocation in an Oracle database. |
A. | Database |
B. | Instance |
C. | Tablespace |
D. | Database Block |
Answer» D. Database Block |
15. | An Oracle __________ is a set of tables and views that are used as a read-only reference about the database. |
A. | Database dictionary |
B. | Dictionary table |
C. | Data dictionary |
D. | Dictionary |
Answer» C. Data dictionary |
16. | A data dictionary is created when a __________ created. |
A. | Instance |
B. | Segment |
C. | Database |
D. | Dictionary |
Answer» C. Database |
17. | An Oracle object type has two parts the _________ and__________ |
A. | Instance and body |
B. | Segment and blocks |
C. | Specification and body |
D. | Body and segment |
Answer» C. Specification and body |
18. | A(n) _________ can be used to preserve the integrity of a document or a message. |
A. | Message digest |
B. | Message summary |
C. | Encrypted message |
D. | None of the mentioned |
Answer» A. Message digest |
19. | A hash function must meet ________ criteriA:) |
A. | Two |
B. | Three |
C. | Four |
D. | None of the mentioned |
Answer» B. Three |
20. | What is the main limitation of Hierarchical Databases? |
A. | Limited capacity (unable to hold much datA:) |
B. | Limited flexibility in accessing data |
C. | Overhead associated with maintaining indexes |
D. | The performance of the database is poor |
Answer» B. Limited flexibility in accessing data |
21. | The property (or set of properties) that uniquely defines each row in a table is called the: |
A. | Identifier |
B. | Index |
C. | Primary key |
D. | Symmetric key |
Answer» C. Primary key |
22. | The separation of the data definition from the program is known as: |
A. | Data dictionary |
B. | Data independence |
C. | Data integrity |
D. | Referential integrity |
Answer» B. Data independence |
23. | The traditional storage of data that is organized by customer, stored in separate folders in filing cabinets is an example of what type of ‘database’ system? |
A. | Hierarchical |
B. | Network |
C. | Object oriented |
D. | Relational |
Answer» A. Hierarchical |
24. | The database design that consists of multiple tables that are linked together through matching data stored in each table is called |
A. | Hierarchical database |
B. | Network database |
C. | Object oriented database |
D. | Relational database |
Answer» D. Relational database |
26. | The purpose of an N-Ary association is: | |
A. | To capture a parent-child relationship | |
B. | To deal with one to many relationships | |
C. | To deal with relationships that involve more than two tables | |
D. | To represent an inheritance relationship | |
Answer» C. To deal with relationships that involve more than two tables | ||
27. | In ordered indices the file containing the records is sequentially ordered, a ___________ is an index whose search key also defines the sequential order of the file. |
A. | Clustered index |
B. | Structured index |
C. | Unstructured index |
D. | Nonclustered index |
Answer» A. Clustered index |
28. | Indices whose search key specifies an order different from the sequential order of the file are called ___________ indices. |
A. | Nonclustered |
B. | Secondary |
C. | All of the mentioned |
D. | None of the mentioned |
Answer» C. All of the mentioned |
29. | An ____________ consists of a search-key value and pointers to one or more records with that value as their search-key value. |
A. | Index entry |
B. | Index hash |
C. | Index cluster |
D. | Index map |
Answer» A. Index entry |
30. | In a _______ clustering index, the index record contains the search-key value and a pointer to the first data record with that search-key value and the rest of the records will be in the sequential pointers. |
A. | Dense |
B. | Sparse |
C. | Straight |
D. | Continuous |
Answer» A. Dense |
31. | In a __________ index, an index entry appears for only some of the search-key values. |
A. | Dense |
B. | Sparse |
C. | Straight |
D. | Continuous |
Answer» A. Dense |
32. | Incase the indices values are larger, index is created for these values of the index. This is called |
A. | Pointed index |
B. | Sequential index |
C. | Multilevel index |
D. | Multiple index |
Answer» C. Multilevel index |
33. | A search key containing more than one attribute is referred to as a _________ search key. |
A. | Simple |
B. | Composite |
C. | Compound |
D. | Secondary |
Answer» B. Composite |
34. | Insertion of a large number of entries at a time into an index is referred to as __________ of the index. |
A. | Loading |
B. | Bulk insertion |
C. | Bulk loading |
D. | Increase insertion |
Answer» C. Bulk loading |
35. | While inserting the record into the index, if the search-key value does not appear in the index. |
A. | The system adds a pointer to the new record in the index entry |
B. | The system places the record being inserted after the other records with the same searchkey values |
C. | The system inserts an index entry with the search-key value in the index at the appropriate position |
D. | None of the mentioned |
Answer» C. The system inserts an index entry with the search-key value in the index at the appropriate position |
36. | A collection of data designed to be used by different people is called a/an |
A. | Organization |
B. | Database |
C. | Relationship |
D. | Schema |
Answer» B. Database |
37. | Which of the following is the oldest database model? |
A. | Relational |
B. | Deductive |
C. | Physical |
D. | Network |
Answer» D. Network |
38. | Which of the following schemas does define a view or views of the database for particular users? |
A. | Internal schema |
B. | Conceptual schema |
C. | Physical schema |
D. | External schema |
Answer» D. External schema |
39. | Which of the following are the process of selecting the data storage and data access characteristics of the database? |
A. | Logical database design |
B. | Physical database design |
C. | Testing and performance tuning |
D. | Evaluation and selecting |
Answer» B. Physical database design |
40. | Which of the following terms does refer to the correctness and completeness of the data in a database? |
A. | Data security |
B. | Data constraint |
C. | Data independence |
D. | Data integrity |
Answer» D. Data integrity |
41. | A table can be logically connected to another table by defining a |
A. | Super key |
B. | Candidate key |
C. | Primary key |
D. | Unique key |
Answer» C. Primary key |
42. | If the state of the database no longer reflects a real state of the world that the database is supposed to capture, then such a state is called |
A. | Consistent state |
B. | Parallel state |
C. | Durable state |
D. | Inconsistent state |
Answer» D. Inconsistent state |
43. | Ensuring isolation property is the responsibility of the |
A. | Recovery-management component of the DBMS |
B. | Concurrency-control component of the DBMS |
C. | Transaction-management component of the DBMS |
D. | Buffer management component in DBMS |
Answer» B. Concurrency-control component of the DBMS |
Tags
Question and answers in FIle Structure and Organization,
FIle Structure and Organization Multiple choice questions and answers,
FIle Structure and Organization Important MCQs,
Solved MCQs for FIle Structure and Organization,
FIle Structure and Organization MCQs with answers PDF download