Q1. Which one of the following statements is false forSQL?
(a) SQL supports logical data model concepts (e.g. tables, primarykey, foreign key)
(b) All versions of SQL are suitable for recursive queries (e.g.,shortest path)
(c) SQL has many brands (e.g. Oracle, IBM DB2, Sybase, MS SQLServer)
(d) SQL is a popular query language for relational databasemanagement system

Q2. Which one the the following is NOT a component of SQL?
(a) Data definition language
(b) Data manipulation language
(c) Data control language
(d) Data visualization language

Q3. Which of the following SQL statements adds a row to an existingtable?
(a) CREATE TABLE
(b) INSERT INTO
(c) UPDATE
(d) ALTER TABLE

Q4. Which geometry subclasses is not included in OGIS simplefeature types?
(a) Point
(b) LineString
(c) Polygon
(d) Raster

Q5. Which common operation is not included in OGIS simple featuretypes?
(a) shortest path
(b) distance
(c) overlap
(d) convex hull

Q6. Which OGIS operation is not topological ?
(a) Envelope
(b) Equal
(c) Within
(d) Contains

Q7. Which of the following queries returns different result thanothers?
(a) SELECT C.Name FROM City C, River R
WHERE Distance (C.Shape, R.Shape) <= 300
(b) SELECT C.Name FROM City C, River R
WHERE Within (C.Shape, Buffer (R.Shape, 300)) = 1
(c) SELECT C.Name FROM City C, River R
WHERE Contains (C.Shape, Buffer (R.Shape, 300)) = 1
(d) SELECT C.Name FROM City C, River R
WHERE Cross (R.Shape, Buffer (C.Shape, 300)) = 1

Q8. Which of the following queries returns different result thanothers?
(a) SELECT C1.Name, C2.Name FROM Country C1, Country C2
WHERE Intersects(C1.Shape, C2.Shape) = 1
(b) SELECT C1.Name, C2.Name FROM Country C1, Country C2
WHERE Overlaps(C1.Shape, C2.Shape) = 1
(c) SELECT C1.Name, C2.Name FROM Country C1, Country C2
WHERE Disjoint(C1.Shape, C2.Shape) <> 1
(d) SELECT C1.Name, C2.Name FROM Country C1, Country C2
WHERE ( Touches(C1.Shape,C2.Shape)= 1) OR(Overlaps(C1.Shape,C2.Shape)=1)

Q9. Which OGIS topological operation should be used in the WHEREclause of following SQL query to list countries with only oneneighbor country?
A country is a neighbor of another country if their land massesshare a boundary.
Island nation, e.g. Iceland, have no neighbors.

SELECT Co.Name

FROM Country Co, Country Co1

WHERE _______ (Co.Shape,Co1.Shape)

GROUP BY Co.Name

HAVING Count(*)=1

Q10. Please write the spatial SQL query to list the GDP of the country with the maximum number of neighbors. (Hint: use nested query)

The COUNTRY table has 6 columns: Name, Continent (Cont), population (Pop), Gross domestic product(GDP), Life-expectancy (Life-exp) and Shape, Shape is boundary

Answer rating: 100% (QA)

The detailed answer for the above question is provided below 1 b All versions of SQL are suitable for recursive queries eg shortest path is false Not all versions of SQL support recursive queries Recu... View the full answer