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

14 Questions Published

Questions

Question 1 Multiple Choice (Single Answer)

Which of the following is not a logical data-base structure?

  1. Tree
  2. Relational Structure
  3. Network
  4. Chain
Question 2 Multiple Choice (Single Answer)

Which of the following is true of a network structure?

  1. It is a physical representation of the data.
  2. It allows a many-to-many relationship.
  3. It is conceptually simple.
  4. It will be dominant database of the future.
Question 3 Multiple Choice (Single Answer)

Embedded Pointer provides

  1. the secondary access path
  2. a physical record key
  3. an inverted index
  4. all of the above
Question 4 Multiple Choice (Single Answer)

A scheme describes

  1. data elements
  2. records and files
  3. records relationships
  4. all of the above
Question 5 Multiple Choice (Single Answer)

The highest level in the hierarchy of data organization is called

  1. data link
  2. data base
  3. data file
  4. data record
Question 6 Multiple Choice (Single Answer)

The function of a database is

  1. to check all input data
  2. to check all spellings
  3. to collect and organize input data
  4. to output data
Question 7 Multiple Choice (Single Answer)

A number of related records that are treated as a unit, are called

  1. file
  2. field
  3. data
  4. batch
Question 8 Multiple Choice (Single Answer)

Periodically adding, changing and deleting file records is called file

  1. updating
  2. upgrading
  3. restructuring
  4. renewing
Question 9 Multiple Choice (Single Answer)

The file organization technique which includes an index on every secondary field, is

  1. inverted organization
  2. multi-list organization
  3. regular organization
  4. hierarchical organization
Question 10 Multiple Choice (Single Answer)

The simplest file organization technique is

  1. inverted organization
  2. multi-list organization
  3. regular organization
  4. hierarchical organization
Question 11 Multiple Choice (Single Answer)

The file organization technique which provides a very fast direct access, is

  1. inverted organization
  2. regular organization
  3. multi-list organization
  4. hashed organization
Question 12 Multiple Choice (Single Answer)

Which of the following is not a relational database?

  1. dBASE 1V
  2. 4th dimension
  3. Fox Pro
  4. Reflex
Question 13 Multiple Choice (Single Answer)

The database environment has all of the following components, except

  1. users
  2. separate files
  3. database
  4. data-base administrator
Question 14 Multiple Choice (Single Answer)

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

  1. 6
  2. 16
  3. 8
  4. 10