DBMS
Notes and Test Papers covering DBMS and RDBMS concepts including Primary Key, Data, Information, Modeling language, Data structure, Database query language, Transaction mechanism, SQL, Normalization, and Database Design
Questions
Which of the following is not a logical data-base structure?
- Tree
- Relational Structure
- Network
- Chain
Which of the following is true of a network structure?
- It is a physical representation of the data.
- It allows a many-to-many relationship.
- It is conceptually simple.
- It will be dominant database of the future.
Embedded Pointer provides
- the secondary access path
- a physical record key
- an inverted index
- all of the above
A scheme describes
- data elements
- records and files
- records relationships
- all of the above
The highest level in the hierarchy of data organization is called
- data link
- data base
- data file
- data record
The function of a database is
- to check all input data
- to check all spellings
- to collect and organize input data
- to output data
A number of related records that are treated as a unit, are called
- file
- field
- data
- batch
Periodically adding, changing and deleting file records is called file
- updating
- upgrading
- restructuring
- renewing
The file organization technique which includes an index on every secondary field, is
- inverted organization
- multi-list organization
- regular organization
- hierarchical organization
The simplest file organization technique is
- inverted organization
- multi-list organization
- regular organization
- hierarchical organization
The file organization technique which provides a very fast direct access, is
- inverted organization
- regular organization
- multi-list organization
- hashed organization
Which of the following is not a relational database?
- dBASE 1V
- 4th dimension
- Fox Pro
- Reflex
The database environment has all of the following components, except
- users
- separate files
- database
- data-base administrator
Complete indexing is defined as an index existing for every distinct field combination in the indexed file. The number of indices necessary to provide complete indexing for a file defined on 4 fields, is
- 6
- 16
- 8
- 10