SQL and NoSQL Databases — Learn free

Self-check

Questions 1–10 of 10

1. What does the term NoSQL actually mean?
Question 1A. Not-Only-SQLB. No SQL is permittedC. Non-Structured Query LanguageD. Network-Oriented SQLE. Normalised SQL
2. Which four types of NoSQL database came onto the surface with the introduction of Big Data?
Question 2A. Relational, Hierarchical, Network and ObjectB. Key-Value, Columnar, Document and GraphC. Hive, HDFS, Oracle and TeradataD. In-memory, Time-series, Spatial and LedgerE. Star, Snowflake, Vault and Anchor
3. Which of the following is NOT given as an example of a SQL/RDBMS database?
Question 3A. OracleB. DB2C. HiveD. TeradataE. MySQL
4. What storage can NoSQL databases use in addition to server OS file systems such as EXT and FAT?
Question 4A. Oracle tablespacesB. Spreadsheet filesC. Relational tablesD. HDFS, the Hadoop file storageE. Cloud object storage only
5. Among the five data stores in Hadoop (Hive, Key-Value, Columnar, Document and Graph DB), which one uses only HDFS as its storage?
Question 5A. Key-Value DBB. Columnar DBC. Document DBD. Graph DBE. Hive
6. What is Hive?
Question 6A. A wrapper on top of files sitting in HDFS that shows the files in the shape of tables for ease of useB. A relational database that replaces Oracle in HadoopC. A graph database that stores entities as nodes and relationships as edgesD. A file system used by SQL ServerE. A key-value cache for HDFS metadata
7. How does a Key-Value database store data?
Question 7A. As tables with rows, columns and schemasB. As a collection of key-value pairs in which the key normally serves as a unique identifierC. As documents with data type descriptions and valuesD. As nodes and edges with unique identifiersE. As columns rather than rows for analytical processing
8. Why is a Columnar database suitable for analytical query processing and data warehouses?
Question 8A. Because it stores entities as nodes and relationships as edgesB. Because it requires no SQL and no tablesC. Because it stores data by columns rather than by rowsD. Because it uses only HDFS as its storageE. Because it stores each record as a document
9. What do NoSQL Document databases use instead of the tables, columns, rows, schemas and tabular relations of relational databases?
Question 9A. Key-value pairs with compound objectsB. Nodes and edgesC. Flat files in HDFS shown as tablesD. Documents with data type descriptions and valuesE. Star schemas with fact and dimension tables
10. How is a Graph database characterised in comparison with a relational database?
Question 10A. It stores data by columns and is best for data warehousesB. It uses documents rather than tablesC. It has no unique identifiers on its entitiesD. It can only use OS file systems, never HDFSE. It is multi-relational in nature, whereas relational tables are loosely connected