week 5 - Practice quiz Flashcards

1
Q

Which of the following database management systems implements NoSQL?

1) DB2
2) MariaDB
3) MongoDB
4) Oracle

A

3) MongoDB

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
2
Q

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.

A

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.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
3
Q

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

A

3) CAP Theorem

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
4
Q

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

A

3) Eventual consistency

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
5
Q

What kind of NoSQL data model does Google Big Table use?

1) Column-based
2) Graph-based
3) Key-value
4) Document-based

A

1) Column-based

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
6
Q

In which format does MongoDB store data?

1) C++
2) BSON
3) Java
4) JSON

A

2) BSON

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
7
Q

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.

A

2) There is no JOIN operation.

Not 1) Documents are taken as independent units.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
8
Q

Which of the following data operations is possible with NoSQL?

1) Group by
2) Data retrieval
3) Order by
4) Join

A

2) Data retrieval

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
9
Q

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

A

4) Minimize processing time

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
10
Q

Which of the following search algorithms gives the precise solution?

1) Simulated annealing
2) Heuristic algorithm
3) Genetic algorithm
4) Exhaustive search

A

4) Exhaustive search

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
11
Q

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

A

Nope 2) CPU cost + IO cost

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
12
Q

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

A

1) Query Processor

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
13
Q

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

A

1) When developing a search strategy

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
14
Q

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.

A

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.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
15
Q

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.

A

3) Applying data distribution information to algebraic operations such as Select, Project, and Join.

Not 4) Optimizing fragment queries with communication operations.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
16
Q

Which of the following operations is not part of query decomposition?

1) Algebraic rewriting
2) Local optimization
3) Normalization
4) Elimination of redundancy

A

2) Local optimization

17
Q

What does the I/O cost refer to?

1) The cost of local data processing using computer memory
2) The cost of retrieving data from a hard disk
3) The cost of transferring data across multiple sites
4) The cost of local data processing using CPU

A

2) The cost of retrieving data from a hard disk

18
Q

What kind of database management system is Apache Titan?

Column-based

Graph-based

Document-based

Key-value
Correct

A

Graph-based

19
Q

What is the syntax used by Amazon’s DynamoDB to insert data in to its database.

insert in to (key, context, object)

create (key, context, object)

insert (key, context, object)

put (key, context, object)

A

put (key, context, object)

20
Q

What kind of NoSQL data model does MongoDB use?

Document-based

Key-value

Column-based

Graph-based

A

Document-based