MC	Which statement is NOT CORRECT?	According to the dissemination protocol, each node sends out an "are you (still) there and part of my network?" request to all other members in a node's known network.	correct	The meaning of NoSQL shifted from 'not SQL' to 'not only SQL' or 'not relational'.	incorrect	Graphs are mathematical structures consisting of nodes and edges.	incorrect	Vertical scaling is limited by hardware performance.	incorrect	
MC	What does the following Cypher query express?<br><br>OPTIONAL MATCH (user;User)-[:FRIENDS_WITH]-(friend;User)<br>WHERE user.name = "Bart Baesens"<br>RETURN user, count(friend) AS NumberOfFriends	Get the node for Bart Baesens and all his friends.	incorrect	Get the node for Bart Baesens and a count of all his friends, but only if at least one FRIENDS_WITH relation exists.	correct	Get the node for Bart Baesens and a count of all his friends, even if no FRIENDS_WITH relation exists.	incorrect	This query will fail if Bart Baesens is FRIENDS_WITH himself.	incorrect	
MC	When are column oriented databases more efficient?	When inserts are performed where all of the row data is supplied at the same time.	incorrect	When aggregates need to be calculated over many or all rows in the dataset.	correct	When a lot of JOINs need to be performed in queries.	incorrect	When many columns of a single group need to be fetched at the same time.	incorrect	
MC	Using Cypher, how do you get a list of all movies Wilfried Lemahieu has liked, when he has given at least four stars?	MATCH (b:User)-[I:LIKES]-(m:Movie)<br>WHERE b.name = "Wilfried Lemahieu"<br>AND m.stars >=4<br>RETURN m	incorrect	MATCH (b:User)--(m:Movie)<br>WHERE b.name = "Wilfried Lemahieu"<br>AND l.stars >= 4<br>RETURN m	incorrect	MATCH (b:User)-[I:LIKES]-(m:Movie)<br>WHERE b.name = "Wilfried Lemahieu"<br>AND l.stars >= 4<br>RETURN m	correct	SELECT (b:User)--m:Movie)<br>WHERE b.name = "Wilfried Lemahieu"<br>AND m.starts >= 4	incorrect	
MC	Which statement is NOT CORRECT?	Graph models are not capable to model many-to-many relationships.	correct	Edges in graphs can be uni- or bidirectional.	incorrect	Graphs are mathematical structures consisting of nodes and edges.	incorrect	Graph databases work particularly well on tree-like structures.	incorrect	
MC	Which statement is CORRECT?	Some relational constructs, such as the many-to-many relationship, are harder to express using graph databases.	incorrect	Replicas in a distributed NoSQL environment relate to making periodic backups of the database to a second system.	incorrect	Stabilization relates to the waiting time between the start-up of a NoSQL system and when the system becomes usable to receive user queries.	incorrect	The fact that most NoSQL databases adopt an eventual consistency approach is due to the CAP theorem, which states that strong consistency cannot be obtained when availability and partitioning has to be ensured.	correct	
MC	Which of the following is not an example of a NoSQL database?	Graph based databases.	incorrect	XML based databases. 	incorrect	Document based databases.	incorrect	All three can be regarded as NoSQL databases.	correct	
MC	When are column oriented databases more efficient?	When aggregates need to be calculated over many or all rows in the dataset.	correct	When many columns of a single group need to be fetched at the same time.	incorrect	When a lot of JOINs need to be performed in queries.	incorrect	When inserts are performed where all of the row data is supplied at the same time.	incorrect	
MC	Which of the following statements describes NoSQL databases best?	A NoSQL database offers no support for SQL.	incorrect	NoSQL databases are non-relational.	correct	NoSQL databases are not capable to deal with large datasets.	incorrect	NoSQL databases do not support joins.	incorrect	
MC	Which statement is CORRECT?	Some relational constructs, such as the many-to-many relationship, are harder to express using graph databases.	incorrect	Stabilization relates to the waiting time between the start-up of a NoSQL system and when the system becomes usable to receive user queries.	incorrect	Replicas in a distributed NoSQL environment relate to making periodic backups of the database to a second system.	incorrect	The fact that most NoSQL databases adopt an eventual consistency approach is due to the CAP theorem, which states that strong consistency cannot be obtained when availability and partitioning has to be ensured.	correct