NewSQL — Learn free · DataAI Nexus

Self-check

Questions 1–10 of 10

1. What does the term NewSQL refer to?
Question 1A. A single database product sold by one vendorB. A class of modern relational database management systems designed to meet the performance and scalability needs of modern applicationsC. A new version of the SQL language that replaces SELECT statementsD. A category of document-oriented NoSQL databasesE. A file format for exchanging data between spreadsheets
2. What potential benefit is suggested if the NewSQL model materialises?
Question 2A. Eliminating the need for separate SQL and NoSQL datastores, saving significant effortB. Removing the need for any database administratorsC. Making all data publicly available by defaultD. Replacing cloud computing with on-premises serversE. Eliminating the need for data backups
3. What do the letters in ACID stand for?
Question 3A. Access, Control, Integration, DeploymentB. Availability, Capacity, Indexing, DistributionC. Atomicity, Consistency, Isolation, DurabilityD. Analysis, Compression, Iteration, DesignE. Authentication, Confidentiality, Integrity, Detection
4. How do NewSQL databases achieve scalability?
Question 4A. By buying a single much larger serverB. By reducing the amount of data storedC. By dropping SQL support entirelyD. By scaling horizontally, adding more nodes to a distributed systemE. By limiting the number of concurrent users
5. Why does SQL compatibility matter for NewSQL databases?
Question 5A. It prevents the database from running in the cloudB. It forces developers to learn a new query languageC. It makes the database slower but more secureD. It removes the need for ACID complianceE. It makes it easier for developers to transition from traditional relational databases
6. Which of these is given as an example of a NewSQL database?
Question 6A. Google SpannerB. Microsoft ExcelC. Apache KafkaD. MongoDB AtlasE. Oracle Forms
7. How is CockroachDB described?
Question 7A. A proprietary desktop spreadsheet toolB. An open-source, distributed SQL database designed to be scalable, resilient and strongly consistentC. A streaming platform for video deliveryD. A metadata registry standardE. A programming language for data science
8. Which architectural designs may NewSQL databases use to distribute data and workload across nodes?
Question 8A. Monolithic and single-server architecturesB. Mainframe and terminal architecturesC. Distributed and shared-nothing architecturesD. Peer-to-peer file-sharing architecturesE. Client-only architectures with no server
9. Which of the following is NOT a key characteristic attributed to NewSQL databases?
Question 9A. Horizontal scalabilityB. High performance for read and write operationsC. ACID complianceD. Abandoning structured query language in favour of key-value access onlyE. SQL compatibility
10. Is NewSQL tied to a specific product or technology?
Question 10A. Yes, it is the trademark of a single companyB. Yes, it refers only to Google SpannerC. Yes, it is a specific version of PostgreSQLD. Yes, it is a cloud service sold by one providerE. No, it represents a category of databases that share similar goals and characteristics