Top 50+ Solved FIle Structure and Organization MCQ Questions Answer
Q. Incase the indices values are larger, index is created for these values of the index. Thisis called
a. Pointed index
b. Sequential index
c. Multilevel index
d. Multiple index
Q. A search key containing more than one attribute is referred to as a _________ searchkey.
a. Simple
b. Composite
c. Compound
d. Secondary
Q. 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
Q. While inserting the record into the index, if the search-key value does not appear in theindex.
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
Q. A collection of data designed to be used by different people is called a/an
a. Organization
b. Database
c. Relationship
d. Schema
Q. Which of the following is the oldest database model?
a. Relational
b. Deductive
c. Physical
d. Network
Q. Which of the following schemas does define a view or views of the database forparticular users?
a. Internal schema
b. Conceptual schema
c. Physical schema
d. External schema
Q. Which of the following are the process of selecting the data storage and data accesscharacteristics of the database?
a. Logical database design
b. Physical database design
c. Testing and performance tuning
d. Evaluation and selecting
Q. Which of the following terms does refer to the correctness and completeness of the datain a database?
a. Data security
b. Data constraint
c. Data independence
d. Data integrity
Q. A table can be logically connected to another table by defining a
a. Super key
b. Candidate key
c. Primary key
d. Unique key
Q. If the state of the database no longer reflects a real state of the world that the databaseis supposed to capture, then such a state is called
a. Consistent state
b. Parallel state
c. Durable state
d. Inconsistent state
Q. 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