MC What does the following Cypher query express?
MATCH (bart:User {name:'Bart'})-[:KNOWS*2]->(f)
WHERE NOT((bart)-[:KNOWS]->(f))
RETURN f
Does not return Bart's friends, but returns their friends incorrect Returns Bart's friends who have exactly one other friend incorrect Does not return Bart's friends, but returns their friends if Bart does not know them correct Return all of Bart's friends, and their friends as well incorrect
MC Which of the following is not a property of a good hash function for use in key-value based storage structures? Two hashes from two inputs that differ little should also differ as little as possible. correct A good hash function should map its inputs as evenly as possible over the output range. incorrect A hash function should return an output of fixed size. incorrect A hash function should always return the same output for the same input. 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 of the following is not a property of a good hash function for use in key-value based storage structures? A good hash function should map its inputs as evenly as possible over the output range. incorrect A hash function should always return the same output for the same input. incorrect A hash function should return an output of fixed size. incorrect Two hashes from two inputs that differ little should also differ as little as possible. correct
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)
WHERE b.name = "Wilfried Lemahieu"
AND m.stars >=4
RETURN m incorrect MATCH (b:User)-[I:LIKES]-(m:Movie)
WHERE b.name = "Wilfried Lemahieu"
AND l.stars >= 4
RETURN m correct MATCH (b:User)--(m:Movie)
WHERE b.name = "Wilfried Lemahieu"
AND l.stars >= 4
RETURN m incorrect SELECT (b:User)--m:Movie)
WHERE b.name = "Wilfried Lemahieu"
AND m.starts >= 4 incorrect
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 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 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 do not support joins. incorrect NoSQL databases are not capable to deal with large datasets. incorrect NoSQL databases are non-relational. correct
MC Using Cypher, how do you get a list of all movies Wilfried Lemahieu has liked, when he has given at least four stars? SELECT (b:User)--m:Movie)
WHERE b.name = "Wilfried Lemahieu"
AND m.starts >= 4 incorrect MATCH (b:User)--(m:Movie)
WHERE b.name = "Wilfried Lemahieu"
AND l.stars >= 4
RETURN m incorrect MATCH (b:User)-[I:LIKES]-(m:Movie)
WHERE b.name = "Wilfried Lemahieu"
AND m.stars >=4
RETURN m incorrect MATCH (b:User)-[I:LIKES]-(m:Movie)
WHERE b.name = "Wilfried Lemahieu"
AND l.stars >= 4
RETURN m correct
MC Which of the following is not a property of a good hash function for use in key-value based storage structures? A hash function should return an output of fixed size. incorrect Two hashes from two inputs that differ little should also differ as little as possible. correct A good hash function should map its inputs as evenly as possible over the output range. incorrect A hash function should always return the same output for the same input. incorrect