McqMate
Chapters
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 |
25. |
The association role defines: |
A. | How tables are related in the database |
B. | The relationship between the class diagram and the tables in the database |
C. | The tables that each attribute is contained |
D. | Which attribute is the table’s primary key |
Answer» A. How tables are related in the 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
|
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 |
Done Reading?