Which of the keys below are not supported by a relational database? a. Foreign keys b. Composite keys c. Dynamic keys d. Primary keys
-
Which of the keys below are not supported by a relational
database ?a. Foreign keys
b. Composite keys
c. Dynamic keys
d. Primary keys
In InfluxDB, it is advantageous to store data used in search queries using tags rather than fields. What is the advantage of storing data in tags over fields?
a. Tags are indexed which improves search speed.
b. Tags retain the datatype of the data whereas fields converting every data to string.
c. It is easier to write search query using tags rather than fields.
d. Data stored in tags can be easily exported to other formats.
Our Neo4j database consists of ‘Student’ and ‘Course’ nodes. A student node is connected to course node via a relationship ‘STUDIES_IN’. Write a query to retrieve all courses that the student ‘Peter Parker’ is enrolled in?
a. a) RETURN c WHERE (: Student { name: ‘Peter Parker’ }) –[:STUDIES_IN]-> (c:Course)
b. MATCH (: Student) –[:STUDIES_IN]-> (c:Course)
RETURN c
c. MATCH (: Student { name: ‘Peter Parker’ }) –[rel:STUDIES_IN]-> (c:Course)
RETURN rel
d. a) MATCH (: Student { name: ‘Peter Parker’ }) –[:STUDIES_IN]-> (c:Course)
RETURN c
Step by step
Solved in 3 steps