08.02 - Database Management Systems (DBMSs)

Question 1

Database management system (DBMS)

Answer 1

Systems software for the definition, creation, and manipulation of a database

Question 2

Data management

Answer 2

The organisation and maintenance of data in a database to provide the information required

Question 3

Data dictionary

Answer 3

A set of data that contains metadata (data about other data) for a database

Question 4

Data modelling

Answer 4

The analysis and definition of the data structures required in a database and to produce a data model

Question 5

Logical schema

Answer 5

A data model for a specific database that is independent of the DBMS used to build that database

Question 6

Access rights (database)

Answer 6

The permissions given to database users to access, modify, or delete data

Question 7

Developer interface

Answer 7

Feature of a DBMS that provides developers with the commands required for definition, creation, and manipulation of a database

Question 8

Structured query language (SQL)

Answer 8

The standard query language used with relational databases for data definition and data modification

Question 9

Query processor

Answer 9

Feature of a DBMS that processes and executes queries written in structured query language (SQL)