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. |
                           express the number of entities to which another entity can be associated via a relationship set. |
| A. | mapping cardinality |
| B. | relational cardinality |
| C. | participation constraints |
| D. | none of the mentioned |
| Answer» B. relational cardinality | |
| 2. |
An entity in A is associated with at most one entity in B. An entity in B, however, can be associated with any number (zero or more) of entities in A. |
| A. | one-to-many |
| B. | one-to-one |
| C. | many-to-many |
| D. | many-to-one |
| Answer» E. | |
| 3. |
An entity in A is associated with at most one entity in B, and an entity in B is associated with at most one entity in A.This is called as |
| A. | one-to-many |
| B. | one-to-one |
| C. | many-to-many |
| D. | many-to-one |
| Answer» C. many-to-many | |
| 4. |
In a relation between the entities the type and condition of the relation should be speciï¬ed. That is called as            attribute. |
| A. | desciptive |
| B. | derived |
| C. | recursive |
| D. | relative |
| Answer» B. derived | |
| 5. |
Which of the following is a single valued attribute |
| A. | register_number |
| B. | address |
| C. | subject_taken |
| D. | reference |
| Answer» B. address | |
| 6. |
Which of the following can be a multivalued attribute? |
| A. | phone_number |
| B. | name |
| C. | date_of_birth |
| D. | all of the mentioned |
| Answer» B. name | |
| 7. |
Not applicable condition can be represented in relation entry as |
| A. | na |
| B. | 0 |
| C. | null |
| D. | blank space |
| Answer» D. blank space | |
| 8. |
The attribute AGE is calculated from DATE_OF_BIRTH. The attribute AGE is |
| A. | single valued |
| B. | multi valued |
| C. | composite |
| D. | derived |
| Answer» E. | |
| 9. |
The attribute name could be structured as an attribute consisting of ï¬rst name, middle initial, and last name. This type of attribute is called |
| A. | simple attribute |
| B. | composite attribute |
| C. | multivalued attribute |
| D. | derived attribute |
| Answer» C. multivalued attribute | |
| 10. |
Entity is a |
| A. | object of relation |
| B. | present working model |
| C. | thing in real world |
| D. | model of relation |
| Answer» D. model of relation | |
| 11. |
An                  is a set of entities of the same type that share the same properties, or attributes. |
| A. | entity set |
| B. | attribute set |
| C. | relation set |
| D. | entity model |
| Answer» B. attribute set | |
| 12. |
A set of possible data values is called |
| A. | attribute |
| B. | degree |
| C. | tuple |
| D. | domain |
| Answer» E. | |
| 13. |
In domain relaional calculus “there exist†|
| A. | (p1(x)) |
| B. | (p1(x)) Ð x |
| C. | v x (p1(x)) |
| D. | Ð x (p1(x)) |
| Answer» E. | |
| 14. |
Which of the following is the comparison operator in tuple relational calculus |
| A. | ⇒ |
| B. | = |
| C. | ε |
| D. | all of the mentioned |
| Answer» C. ε | |
| 15. |
Which of the following symbol is used in the place of except? |
| A. | ^ |
| B. | v |
| C. | ¬ |
| D. | ~ |
| Answer» D. ~ | |
| 16. |
The assignment operator is denoted by |
| A. | -> |
| B. | <- |
| C. | = |
| D. | == |
| Answer» C. = | |
| 17. |
Which of the following is not outer join? |
| A. | left outer join |
| B. | right outer join |
| C. | full outer join |
| D. | all of the mentioned |
| Answer» E. | |
| 18. |
Which is a join condition contains an equality operator: |
| A. | equijoins |
| B. | cartesian |
| C. | natural |
| D. | left |
| Answer» B. cartesian | |
| 19. |
Which is a unary operation: |
| A. | selection operation |
| B. | primitive operation |
| C. | projection operation |
| D. | generalized selection |
| Answer» E. | |
| 20. |
The                        operation, denoted by −, allows us to ï¬nd tuples that are in one relation but are not in another. |
| A. | union |
| B. | set-difference |
| C. | difference |
| D. | intersection |
| Answer» C. difference | |
| 21. |
For select operation the                  appear in the subscript and the                        argument appears in the paranthesis after the sigma. |
| A. | predicates, relation |
| B. | relation, predicates |
| C. | operation, predicates |
| D. | relation, operation |
| Answer» B. relation, predicates | |
| 22. |
Which of the following is used to denote the selection operation in relational algebra? |
| A. | pi (greek) |
| B. | sigma (greek) |
| C. | lambda (greek) |
| D. | omega (greek) |
| Answer» C. lambda (greek) | |
| 23. |
Which of the following is a fundamental operation in relational algebra? |
| A. | set intersection |
| B. | natural join |
| C. | assignment |
| D. | none of the mentioned |
| Answer» E. | |
| 24. |
Relational Algebra is a                      query language that takes two relations as input and produces another relation as an output of the query. |
| A. | relational |
| B. | structural |
| C. | procedural |
| D. | fundamental |
| Answer» D. fundamental | |
| 25. |
Which one of the following is the right syntax for DECODE? |
| A. | decode (search, expression, result [, search, result]… [, default]) |
| B. | decode (expression, result [, search, result]… [, default], search) |
| C. | decode (search, result [, search, result]… [, default], expression) |
| D. | decode (expression, search, result [, search, result]… [, default]) |
| Answer» E. | |
| 26. |
What do data warehouses support? |
| A. | olap |
| B. | oltp |
| C. | olap and oltp |
| D. | operational databases |
| Answer» B. oltp | |
| 27. |
In SQL the cross-tabs are created using |
| A. | slice |
| B. | dice |
| C. | pivot |
| D. | all of the mentioned |
| Answer» B. dice | |
| 28. |
The operation of moving from ï¬ner- granularity data to a coarser granularity (by means of aggregation) is called a |
| A. | rollup |
| B. | drill down |
| C. | dicing |
| D. | pivoting |
| Answer» B. drill down | |
| 29. |
The process of viewing the cross-tab (Single dimensional) with a ï¬xed value of one attribute is |
| A. | slicing |
| B. | dicing |
| C. | pivoting |
| D. | both slicing and dicing |
| Answer» B. dicing | |
| 30. |
OLAP stands for |
| A. | online analytical processing |
| B. | online analysis processing |
| C. | online transaction processing |
| D. | online aggregate processing |
| Answer» B. online analysis processing | |
| 31. |
The command                                  such tables are available only within the transaction executing the query and are dropped when the transaction ï¬nishes. |
| A. | create table |
| B. | create temporary table |
| C. | create view |
| D. | create label view |
| Answer» C. create view | |
| 32. |
If there are n tuples in the partition and the rank of the tuple is r, then its                  is deï¬ned as (r −1)/(n−1). |
| A. | ntil() |
| B. | cum_rank |
| C. | percent_rank |
| D. | rank() |
| Answer» D. rank() | |
| 33. |
Inorder to simplify the null value confusion in the rank function we can specify |
| A. | not null |
| B. | nulls last |
| C. | nulls ï¬rst |
| D. | either nulls last or ï¬rst |
| Answer» E. | |
| 34. |
The                      function that does not create gaps in the ordering. |
| A. | intense_rank() |
| B. | continue_rank() |
| C. | default_rank() |
| D. | dense_rank() |
| Answer» E. | |
| 35. |
Ranking of queries is done by which of the following? |
| A. | group by |
| B. | order by |
| C. | having |
| D. | both group by and order by |
| Answer» C. having | |
| 36. |
In rank() function if one value is shared by two tuples then |
| A. | the rank order continues as counting numbers |
| B. | the rank order continues by leaving one rank in the middle |
| C. | the user speciï¬es the order |
| D. | the order does not change |
| Answer» C. the user speciï¬es the order | |
| 37. |
Any recursive view must be deï¬ned as the union of two subqueries: a                query that is nonrecursive and a                      query. |
| A. | base, recursive |
| B. | recursive, base |
| C. | base, redundant |
| D. | view, base |
| Answer» B. recursive, base | |
| 38. |
Triggers                  enabled or disabled |
| A. | can be |
| B. | cannot be |
| C. | ought to be |
| D. | always |
| Answer» B. cannot be | |
| 39. |
Which preï¬xes are available to Oracle triggers? |
| A. | : new only |
| B. | : old only |
| C. | both :new and : old |
| D. | neither :new nor : old |
| Answer» D. neither :new nor : old | |
| 40. |
What are the different in triggers? |
| A. | deï¬ne, create |
| B. | drop, comment |
| C. | insert, update, delete |
| D. | all of the mentioned |
| Answer» D. all of the mentioned | |
| 41. |
Which of the following is NOT an Oracle- supported trigger? |
| A. | before |
| B. | during |
| C. | after |
| D. | instead of |
| Answer» C. after | |
| 42. |
The default extension for an Oracle SQL*Plus ï¬le is: |
| A. | .txt |
| B. | .pls |
| C. | .ora |
| D. | .sql |
| Answer» E. | |
| 43. |
The variables in the triggers are declared using |
| A. | – |
| B. | @ |
| C. | / |
| D. | /@ |
| Answer» C. / | |
| 44. |
What are the after triggers? |
| A. | triggers generated after a particular operation |
| B. | these triggers run after an insert, update or delete on a table |
| C. | these triggers run after an insert, views, update or delete on a table |
| D. | all of the mentioned |
| Answer» C. these triggers run after an insert, views, update or delete on a table | |
| 45. |
Triggers are supported in |
| A. | delete |
| B. | update |
| C. | views |
| D. | all of the mentioned |
| Answer» D. all of the mentioned | |
| 46. |
A Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â is a special kind of a store procedure that executes in response to certain action on the table like insertion, deletion or updation of data. |
| A. | procedures |
| B. | triggers |
| C. | functions |
| D. | none of the mentioned |
| Answer» C. functions | |
| 47. |
Which of the following is used to access large objects from a database ? |
| A. | setblob() |
| B. | getblob() |
| C. | getclob() |
| D. | all of the mentioned |
| Answer» E. | |
| 48. |
Which of the following is used as the embedded SQL in COBOL? |
| A. | exec sql <embedded sql statement >; |
| B. | exec sql <embedded sql statement > end-exec |
| C. | exec sql <embedded sql statement > |
| D. | exec sql <embedded sql statement > end exec; |
| Answer» C. exec sql <embedded sql statement > | |
| 49. |
Which of the following is used to distinguish the variables in SQL from the host language variables? |
| A. | . |
| B. | – |
| C. | : |
| D. | , |
| Answer» C. : | |
| 50. |
Which of the following function is used to ï¬nd the column count of the particular resultset? |
| A. | getmetadata() |
| B. | metadata() |
| C. | getcolumn() |
| D. | get count() |
| Answer» B. metadata() | |