Test Your Data Base 2 Query Knowledge
20 Questions
| Attempts: 3139
In this quiz you will get to learn about queries of data base. Play this quiz and test your knowledge on this!
Questions and Answers
- 1.A concurrency control mechanisms is required to isolate the users from one another is called
- 2.In referential integrity each foreign key value have a matching ___________ Value.
- A.
Primary key
- B.
Secondary key
- C.
Both
- 3.Write a query that will return the list of all employees whose names starts with ‘s’.
- 4.One student (parent or root) can have multiple course( child) records. Identify the model.
- A.
A. Network model
- B.
B. Relational model
- C.
C. Hierarchical model
- D.
D. Rotational model
- 5.SELECT ename , grade , sal FROM emp, salgrade . WHERE sal BETWEEN losal AND hisal ORDER BY grade, job. Above is an example of :
- A.
Self join
- B.
Inner join
- C.
Outer join
- D.
Non-equi join
- 6.__________ command is used to modify an existing column .
- 7.Collections are essentially just a means of giving a name to a logically related set of packages.
- A.
True
- B.
False
- 8.NULL indicates:
- A.
Unknown
- B.
Zero
- C.
Space
- D.
None of the above
- 9.A mechanism that ensures data integrity between tables related by Primary & Foreign Keys
- A.
Pre-compilation
- B.
Referential Integrity
- C.
A and b
- D.
All the above
- 10.DB2 employs TSO as interactive and ____________.
- 11.Maximum number of tables that can be joined :
- A.
16
- B.
12
- C.
15
- D.
10
- 12.Cartesian product ‘ is the result of a join that does not specify matching columns. (T\F).
- A.
True
- B.
False
- 13.Group By does not do any sorting . (T\F).
- A.
True
- B.
False
- 14.The DBRM stands for______________________
- 15.Which subquery operator compares a single value to every member of set of value.
- A.
IN
- B.
ANY
- C.
ALL
- D.
BETWEEN..AND
- 16.. In EXIST operator when a match is found, the query ends processing for that row. (T/F)
- A.
True
- B.
False
- 17.GRANT SELECT ON EMPTAB TO USER is a correct syntax (T/F)
- A.
True
- B.
False
- 18.Performed for each row in the result table
- A.
Aggregate function
- B.
Scalar function
- C.
Group by
- D.
None of the above
- 19.What is single bound DBRM with optimized access path .
- A.
PLAN
- B.
PACKAGE
- C.
BIND
- D.
NONE
- 20.A DB2 storage group is a set of volume on a _______.
Featured Quizzes
Popular Topics
Back to top