MCQOPTIONS
Saved Bookmarks
MCQOPTIONS
This section includes 657 Mcqs, each offering curated multiple-choice questions to sharpen your Testing Subject knowledge and support exam preparation. Choose a topic below to get started.
| 1. |
Consider two tuples B and C, operation whose result includes tuples that are included in both relations or either in B or C is classified as |
| A. | Square of relation B and C |
| B. | Union of relation B and C |
| C. | Intersection of relation B and C |
| D. | Difference of relation B and C |
| Answer» C. Intersection of relation B and C | |
| 2. |
In relational operations, SELECT operation is written as |
| A. | &Sigma < selection condition > ( S ) |
| B. | &sigma < selection condition > ( R ) |
| C. | &omega < selection condition > ( R ) |
| D. | < selection condition > ( R ) |
| Answer» C. &omega < selection condition > ( R ) | |
| 3. |
Nodes which represents queries in relations are classified as |
| A. | Relation nodes |
| B. | Query nodes |
| C. | Truth nodes |
| D. | Local nodes |
| Answer» B. Query nodes | |
| 4. |
In unary relational operations, symbol is used to represent operation called |
| A. | OR operation |
| B. | AND operation |
| C. | TABLE operation |
| D. | PROJECT operation |
| Answer» E. | |
| 5. |
Relational calculus is classified as |
| A. | High level language |
| B. | Low level language |
| C. | Query specifying language |
| D. | Query identifying language |
| Answer» B. Low level language | |
| 6. |
Kind of operation which is used to extend traditional projection operation by including projection attributes in projection list is called |
| A. | Relational projection |
| B. | Generalized projection |
| C. | Analyzed projection |
| D. | Multiple projection |
| Answer» C. Analyzed projection | |
| 7. |
Expression of generalized projection can be written as |
| A. | F1, F2, Fn ( R ) |
| B. | F1, F2, Fn ( R ) |
| C. | F1, F2, Fn ( R ) |
| D. | F1, F2, Fn ( R ) |
| Answer» B. F1, F2, Fn ( R ) | |
| 8. |
Expression which specifies procedure to retrieve rather than retrieval content is classified as |
| A. | Procedural expression |
| B. | Structural expression |
| C. | Functional expression |
| D. | Calculus expression |
| Answer» E. | |
| 9. |
In a query tree, input relations of query are classified as |
| A. | Attribute nodes |
| B. | Leaf nodes |
| C. | Stem nodes |
| D. | Root nodes |
| Answer» C. Stem nodes | |
| 10. |
With help of selection condition, fraction of selected tuples is classified as |
| A. | Insertion of condition |
| B. | Functionality of condition |
| C. | Selectivity of the condition |
| D. | Interactivity of condition |
| Answer» D. Interactivity of condition | |
| 11. |
Most convenient operation which is used for queries having universal quantification is classified as |
| A. | Division operation |
| B. | Multiply operation |
| C. | Add operation |
| D. | Subtracted operation |
| Answer» B. Multiply operation | |