NEW
Font size
WorksheetsEngineering ACW Semester 2 - #2 Data
Total questions: 15
Worksheet time: 8mins
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
An ERD is...?
A document formatting standard like JSON.
A big data analytics tool
A type of SQL command
A structural diagram of a database
Which of the following is an example of a SQL command?
select name in lego_people
select name from lego_people
select name on lego_people
select name table_lego_people
How many bits are there in a byte?
2, just 0 or 1 as it's binary.
8 as it's octal.
16 as it's hexadecimal.
10 as it's decimal.
If you have data on two or more tables in a RDBMS you would need to tell SQL to...?
JOIN them.
MERGE them.
CONNECT them.
LINK them.
If we store the same data in two places, and they differ, they could said to be what?
continuous
contracted
contradictory
cooperative
