Database Mock Test - 2
9 Questions
Settings
-
+
This is a simple quiz which is created for test your basic data base knowledge!
Questions and Answers
- 1.What does a positive value of SQL code mean?
- A.
Error
- B.
Successful execution
- C.
No rows found
- 2.. AUTOMATIC RECOMPILATION occurs when
- A.
A existing index is dropped.
- B.
A new index is created.
- C.
Both (A) and (B).
- 3.Collections are essentially just a means of giving a name to a logically related set of packages
- A.
True
- B.
False
- 4.Cartesian product ‘ is the result of a join that does not specify matching columns
- A.
True
- B.
False
- 5.13 Group By does not do any sorting .
- A.
True
- B.
False
- 6.. In EXIST operator when a match is found, the query ends processing for that row
- A.
True
- B.
False
- 7.. GRANT SELECT ON EMPTAB TO USER is a correct syntax
- A.
True
- B.
False
- 8.Performed for each row in the result table
- A.
Scalar function
- B.
Group by
- C.
Aggregate function
- 9.. What is single bound DBRM with optimized access path .
- A.
1) PLAN
- B.
2) PACKAGE
- C.
3) BIND
Back to top