BCS Programming - 5 Data Storage

What type of data can be stored on a database?

• Just text and numbers

• Text, number, drawings and pictures

• Text, numbers, videos and music

• Anything that can be digitised

What type of database has data that logically exists in tables of rows and columns?

• Relational

• Network

• Hierarchical

• NoSQL

The column or columns of a table that uniquely identify a record are know as the?

• Primary key

• Foreign key

• Index

• Unique key

The family of SQL statements that CREATE, ALTER and DROP database objects are known as?

• Data Definition Language (DDL)

• Data Manipulation Language (DML)

• Date Control Language (DCL)

• Programming Interface

The SQL keyword to make a table is?

• CREATE

• CONSTRUCT

• COIN

• CRAFT

Data stored in a structured format should follow which set of principles?

• ACID

• ALKALI

• SOLVENT

• SOLUTION

Which is NOT an advantage of using a database is?

• Security better than alternatives

• Easy to retrieve and update data

• Easy to search and store data

• Only one person can access data at a time

An Orders database will keep record of which customers?

• Past

• Present

• Potential

• It depends

Which is TRUE of a NoSQL database?

• Uses a declarative query language

• Predefined schema

• Suitable for structured and predictable data

• High performance and availability

A Graph type of NoSQL database is designed for?

• Networks of connected entities

• Applications with frequent small reads / simple data model

• Flexibility

• Large volumes of data, high performance and availability