Database Management System (DBMS)

221. Which join refers to join records from the write table that have no matching key in the left table are include in the result set:

1. Left outer join
2. Right outer join
3. Full outer join
4. Half outer join

View answer

222. How many set operations supports the oracle SQL:

1. 2
2. 3
3. 4
4. 5

View answer

223. Which are the set operations supports the oracle SQL:

1. UNION
2. UNION ALL
3. INTERSECT
4. MINUS
5. All of these

View answer

224. ___________ operator merges the result sets of two component queries:

1. UNION
2. UNION ALL
3. INTERSECT
4. MINUS

View answer

225. How many component queries are combined using the set operators:

1. 1
2. 2
3. 3
4. 4

View answer

226. In precedence of set operators the expression is evaluated from ___________:

1. Left to Left
2. Right to Right
3. Left to Right
4. Right to Left

View answer

227. View in SQL a view may be defined as a:

1. Stored query
2. Virtual table
3. Both
4. None

View answer

228. Which views is using in several advantages:

1. Simplicity
2. Security
3. User reports
4. Data integrity
5. All of these

View answer

229. How many types of views in SQL:

1. 1
2. 2
3. 3
4. 4

View answer

230. Which are the types of views in SQL:

1. Inline view
2. Database view
3. Materialized view
4. All of these

View answer