FIle Structure and Organization Set 1

Computer Science Engineering (CSE),

Bachelor of Science in Computer Science FY (BSc CS),

Bachelor of Science in Computer Science SY (BSc CS),

Bachelor of Science in Information Technology SY (BSc IT),

Bachelor of Computer Applications (BCA),

Bachelor of Business Administration in Computer Applications (BBA [CA]),

Bachelor of Science in Information Technology (BSc IT),

Bachelor of Science in Computer Science (BSc CS),

Master of Business Administration (MBA)

Learning Mode Previous Next
On This Page

This set of DataBase Management System (DBMS) Multiple Choice Questions & Answers (MCQs) focuses on FIle Structure and Organization Set 1

Q1 | __________ is a contiguous group of blocks allocated for use as part of a table, index,and so forth.
Q2 | ________ is the smallest unit of allocation in an Oracle database.
Q3 | An Oracle __________ is a set of tables and views that are used as a read-onlyreference about the database.
Q4 | A data dictionary is created when a __________ created.
Q5 | An Oracle object type has two parts the _________ and__________
Q6 | A(n) _________ can be used to preserve the integrity of a document or a message.
Q7 | A hash function must meet ________ criteriA:)
Q8 | What is the main limitation of Hierarchical Databases?
Q9 | The property (or set of properties) that uniquely defines each row in a table is called the:
Q10 | The separation of the data definition from the program is known as:
Q11 | The traditional storage of data that is organized by customer, stored in separate foldersin filing cabinets is an example of what type of ‘database’ system?
Q12 | The database design that consists of multiple tables that are linked together throughmatching data stored in each table is called
Q13 | The association role defines:
Q14 | The purpose of an N-Ary association is:
Q15 | 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.
Q16 | Indices whose search key specifies an order different from the sequential order of thefile are called ___________ indices.
Q17 | An ____________ consists of a search-key value and pointers to one or more recordswith that value as their search-key value.
Q18 | In a _______ clustering index, the index record contains the search-key value and apointer to the first data record with that search-key value and the rest of the records will be inthe sequential pointers.
Q19 | In a __________ index, an index entry appears for only some of the search-key values.
Q20 | Incase the indices values are larger, index is created for these values of the index. Thisis called
Q21 | A search key containing more than one attribute is referred to as a _________ searchkey.
Q22 | Insertion of a large number of entries at a time into an index is referred to as__________ of the index.
Q23 | While inserting the record into the index, if the search-key value does not appear in theindex.
Q24 | A collection of data designed to be used by different people is called a/an
Q25 | Which of the following is the oldest database model?
Previous Next