week 5 - Practice quiz Flashcards
Which of the following database management systems implements NoSQL?
1) DB2
2) MariaDB
3) MongoDB
4) Oracle
3) MongoDB
Which of the following statements about NoSQL databases using key-value data model is correct?
1) It uses JSON to format data.
2) It uses a graph to store data.
3) Referential integrity is enforced.
4) Data is stored in a table-like structure.
4) Data is stored in a table-like structure.
Notp: 2) It uses a graph to store data. ??
Nope 1) It uses JSON to format data.
What is the name of the theorem that states “it is impossible for a distributed database to simultaneously provide more than two out of the three guarantees: consistency, availability, and partition-tolerance.”
1) Quality of Service Guarantee
2) Impossibility Theorem
3) CAP Theorem
4) Distributed Database Dilemma
3) CAP Theorem
What is the name of the distributed database state when all updates eventually propagate through the system and all the nodes become consistent?
1) Latent consistency
2) Slow consistency
3) Eventual consistency
4( Lagged consistency
3) Eventual consistency
What kind of NoSQL data model does Google Big Table use?
1) Column-based
2) Graph-based
3) Key-value
4) Document-based
1) Column-based
In which format does MongoDB store data?
1) C++
2) BSON
3) Java
4) JSON
2) BSON
Which of the following is a disadvantage of document-based NoSQL?
1) Documents are taken as independent units.
2) There is no JOIN operation.
3) Data does not need a structure.
4) No translation is required between data objects and queries.
2) There is no JOIN operation.
Not 1) Documents are taken as independent units.
Which of the following data operations is possible with NoSQL?
1) Group by
2) Data retrieval
3) Order by
4) Join
2) Data retrieval
Which of the following should be a goal in a query processing?
1) Minimize throughput
2) Maximize storage space
3) Maximize transfers among sites
4) Minimize processing time
4) Minimize processing time
Which of the following search algorithms gives the precise solution?
1) Simulated annealing
2) Heuristic algorithm
3) Genetic algorithm
4) Exhaustive search
4) Exhaustive search
Which of the following formulas must be minimized when executing a query?
1) IO cost + Communication cost
2) CPU cost + IO cost
3) CPU cost + IO cost + Communication cost
4) CPU cost + Communication cost
Nope 2) CPU cost + IO cost
What is the name of the database management system component that takes SQL commands and implements low-level data manipulation operations?
1) Query Processor
2) Central Processing Unit
3) Memory
4) Cache
1) Query Processor
In which step of the query optimization process should the cost model be considered?
1) When developing a search strategy
2) When generating search space
3) When developing equivalent query execution plans
4) When selecting the best query execution plan
1) When developing a search strategy
What does query decomposition mean?
1) Applying data distribution information to algebraic operations such as Select, Project, and Join.
2) Mapping of SQL commands to algebraic operations such as Select, Project, and Join.
3) Optimizing fragment queries with communication operations.
4) Globally optimizing queries by using stats on fragments.
2) Mapping of SQL commands to algebraic operations such as Select, Project, and Join.
Nope 1) Applying data distribution information to algebraic operations such as Select, Project, and Join.
Not 4) Globally optimizing queries by using stats on fragments.
What does data localization mean?
1) Mapping of SQL commands to algebraic operations such as Select, Project, and Join.
2) Globally optimizing queries by using stats on fragments.
3) Applying data distribution information to algebraic operations such as Select, Project, and Join.
4) Optimizing fragment queries with communication operations.
3) Applying data distribution information to algebraic operations such as Select, Project, and Join.
Not 4) Optimizing fragment queries with communication operations.