Engineering ACW Semester 2 - #2 Data

Which of the following is true?

• DML is used to define the database schema whereas DDL is used to retrieve, add, remove, retrieve or update data.

• DDL is used to define the database schema whereas DML is used to retrieve, add, remove, retrieve or update data.

In what format is data saved on an RDBMS?

• In CSV format.

• In flat files or indexed files.

• In human readable form using JSON.

• In tables with rows and columns.

According to the video, 'big data' is defined as anything larger than what?

• 1 terabyte or more...

• 1 gigabyte or more...

• 1 petabyte or more...

• 1 kilobyte or more...

Which database uses the JSON format to store data?

• Every RDBMS

• MongoDB

• Oracle RDBMS

• MySQL RDBMS

What can you can use SQL to do with a database?

• Only retrieve data.

• Create, replace, update or delete data but NOT change the structure of the database itself.

• Modify the structure of a database but not retrieve data from it.

• Create, replace, update or delete data AND change the structure of the database itself.

Metadata is?

• Data about data.

• A type of NoSQL database

• A query language.

• A type of RDBMS.

Database tables usually contain what?

• Cells and identifiers.

• Cells and indexes.

• Columns and rows.

• Rows and objects.

Which of the following is NOT an example of structured data?

• Addresses

• Documents

• Names

• Dates

The 3 'V's' of 'big data' are...

• Volume, Variety and Velocity

• Vocation, Variety and Velocity

• Volume, Viscosity and Velocity

• Volume, Viscosity and Validity

Data Analytics is useful for...

• Updating big data

• Understanding big data

• Creating big data

• Preventing big data