CompTIA Tech+ FC0-U71 TTT Session 2:

What does NoSQL stand for?

New SQL
No SQL Allowed
Incorrect answer:
Non-Structured Query Language
Correct Answer:
Not Only SQL

Explanation​

NoSQL stands for "Not Only SQL." It refers to a class of database management systems that are designed to handle unstructured or semi-structured data and can scale easily with large datasets. NoSQL databases do not rely solely on the traditional relational database structure, which uses tables and rows, but can support various data models such as document, key-value, graph, and columnar formats. This makes them ideal for handling big data, real-time web applications, and distributed architectures.
 
What is a relational database?
A database that stores data in a single table.
A database that only stores text data
A database that keeps data in several connected tables.
A database that does not use tables at all.

Explanation​

A relational database is a database that keeps data in several connected tables. These tables are structured with rows and columns, and they use relationships (often through keys, such as primary keys and foreign keys) to connect data across different tables. This structure allows for efficient organization, retrieval, and manipulation of data, and it supports complex queries involving multiple tables
 
What does NoSQL stand for?

New SQL
No SQL Allowed
Incorrect answer:
Non-Structured Query Language
Correct Answer:
Not Only SQL

Explanation​

A foreign key is a primary key from another table. It is a column or set of columns in a relational database table that creates a link between data in two tables. The foreign key in one table refers to the primary key in another table, establishing a relationship between the tables and enforcing referential integrity. This ensures that the data in the foreign key column must match a value in the related table's primary key.
 
What data formats are commonly used in document databases?
CSV and TXT
HTML and CSS
JSON and XML
DOC and PDF

Explanation​

In document databases, the commonly used data formats are JSON and XML. These formats allow for flexible and semi-structured data storage, making them ideal for handling complex, hierarchical data structures. Document databases, like MongoDB and CouchDB, often store and retrieve data in these formats due to their compatibility with web applications and ease of parsing.
 
How does a document database store data?
In rows and columns
In word documents
In spreadsheets
In flexible documents

Explanation​

A document database stores data in flexible documents. These documents are typically in formats like JSON, BSON, or XML, and can hold complex, nested data structures. Unlike relational databases that use rows and columns, document databases store data as key-value pairs within documents, allowing each document to have a unique structure. This flexibility makes document databases suitable for handling unstructured or semi-structured data.