Study

MCQ1 Database Environment

  •   0%
  •  0     0     0

      Back   Restart
  • What is a SCHEMA in relation to databases?
    it defines how data is stored, accessed and managed by the organisation
  • What is the role of a database designer?
    identify which data needs to be stored in a database and to create and update Data Models
  • 1970 EF Codd published his paper on which type of database?
    relational database
  • What is a record in relation to Databases?
    Each row in a table is known as a record
  • What is the role of a Database Designer ?
    identify which data needs to be stored in a database and to create and update Data Models
  • What are the components of a DBMS Environment?
    hardware, software, data, procedures and people
  • Who could be an End User in relation to DBMS?
    They could be employees of the organisation, external customers or partners of the organisation.
  • What does a database environment consist of?
    it consists of software, hardware, people, database handling techniques and the actual data.
  • How would an End User use a DBMS?
    They use the DBMS to access and retrieve data
  • What is the role of the Database Administrator?
    They develop and implement data policies and standards to ensure the data is accurate, complete and consistent across the organisation.
  • What is the role of the application programmer?
    they develop the application programs that provide the required visual layout for the the end-users.
    • Your experience on this site will be improved by allowing cookies.