Database Basic - Quiz

Which of these is not a representational data model?

  • A Entity-relationship model
  • B Network data model
  • C Hierarchical data model
  • D Relational data model

The

  • A Object-oriented data model
  • B Object-relational data model
  • C Semistructured data model
  • D None of these

Which of these individuals plays an important role in defining and maintaining a database for an organization?

  • A Application programmer
  • B System analyst
  • C Database administrator
  • D Both (a) and (b)

Which of these is an advantage of database systems?
  • A Data abstraction
  • B Program-data independence
  • C Centralized data management
  • D All of these

Which of the following levels of abstraction deals with the user's view of the database?

  • A External level
  • B Conceptual level
  • C Physical level
  • D None of these

The

  • A Data dictionary
  • B Data table
  • C Data record
  • D None of these

The users who query and update the database by invoking some already-written application programs are known as
  • A System analysts
  • B Na
  • C Special users
  • D Sophisticated users

What is the correct sequence of these phases of database design and implementation process?

(i) Conceptual database design

(ii) Requirement collection and analysis

(iii) Physical database design

(iv) Testing and evaluation
  • A ii, i, iii and iv
  • B i, ii, iii and iv
  • C ii, iii, i and iv
  • D i, ii, iv and iii

The process of transforming the requests and results between various levels of DBMS architecture is known as

  • A Mapping
  • B Scheming
  • C Viewing
  • D None of these

The ability to change the conceptual schema without affecting the external schemas or application programs is known as

  • A Program-data independence
  • B Logical data independence
  • C Physical data independence
  • D Data abstraction