Unit 26 - Develop Databases

Relational Databases save information as...

• text files

• Separate Documents

• Structured tables without relations

• Structured tables with relations

Many to many relation means..

• One table record relates to another record in another table

• One table record relates to many records in another table.

• More than one table record relates to another table record

• More than one table record relates to more than one record in another table

Some examples of relational databases include

• Microsoft SQL Server

• MySQL

• Oracle

• All of the above

A labeled element of a tuple, e.g. "Address" or "Date of birth" is called

• Row

• Tuple

• Attribute

• Record

A data report from the RDBMS in response to a query is called

• Column

• Result Set

• Base Relation

• Field

A constraint can restrict a given integer attribute to values between 1 and 10. This is called...

• Primary Key Constraint

• Foreign Key Constraint

• Domain Constraint

• Syntax Constraint

DDL stands for

• Data Define Language

• Define Data Language

• Data Definition Language

• Definition Data Language

DML includes

• SELECT query

• INSERT query

• DELETE query

• All of the above

A language consisting of diagrams that help developers to program (code) an application is known as

• Structure Query Language

• Unified Modeling Language

• Hypertext Markup Language

• eXtensible Markup Language

DBMS is...

• a software used to create, update and delete user profiles in a computer system

• a software used to only update a database in a computer system

• a software that handles the storage, retrieval, and updating of data in a computer system.

• a software used to alter the memory cache in a computer system