Project Controls PC 11 Rev 01

Data Manipulation is basically a process of changing Data to make it easier to read or better organized for traceability purposes.

• True

• False

What does the acronym "ERD" stand for in respect of Data Base creation and management.

• Electrical Radius Distribution

• Entity Relationship Diagrams

• Early Redemption Duration

• No Options Listed

In respect to Data bases what is the meaning of "SQL"

• Standard Query Language

• Structured Query Language

• Secure Query Language

• Safe Query Language

How many Data base management system types are available with different Functionality.

• 2

• 4

• 6

• 8

Which of the options listed is not a type of Data base management system.

• Hierarchical

• Network

• Charter

• Relational

• Object oriented

Which statement best describes a Hierarchical DBMS

• This Data Base allows each child to have multiple parents and helps address more complex relationships, this model is organised in a graph which can be accessed through several paths.

• This Data Base is organised in a tree like structure and Data is stored Hierarchically either top down or bottom up format.The Data is represented by a Parent -Child relationship. This particular model allows for parent to have many children but children only have one parent.

• This Data Base is modelled by being based on normalizing data in the rows and columns of tables. This Model is stored in fixed structures and manipulated using SQL.

• This Data Base is modelled on stored data being in the form of objects.The structure which is called classes which display data within it.This model defines a database as a collection of objects which stores both data members, values and operations.

The Relational Model is based on Normalizing data in rows and columns of a table.

• True

• False

The Network Model type DBMS is a very simple relationship based software which only has a single Path and is presented on a Bar chart.

• True

• False

DBMS can perform sophisticated calculations.

• True

• False

How many recognised Anomaly's exist in database Normalization.

• 1

• 2

• 3

• 4