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. |
What is the default format for “Datetime” data type? |
| A. | YYYY-MM-DD HH:MI:SS |
| B. | MM-YYYY-DD HH:MI:SS |
| C. | DD-YYYY-MM MI:HH:SS |
| D. | None of the mentioned |
| Answer» B. MM-YYYY-DD HH:MI:SS | |
| 2. |
Which of the following is the correct order of precedence (high to low)? |
| A. | !, ^, <<, XOR |
| B. | ^, !, <<, XOR |
| C. | !, <<, XOR, ^ |
| D. | !, ^, XOR, << |
| Answer» B. ^, !, <<, XOR | |
| 3. |
Which spatial datatype is used to store a curve? |
| A. | GEOMETRY |
| B. | POINT |
| C. | LINESTRING |
| D. | POLYGON |
| Answer» D. POLYGON | |
| 4. |
Which datatype is used for a fixed length binary string? |
| A. | VARCHAR |
| B. | BINARY |
| C. | VARBINARY |
| D. | BLOB |
| Answer» C. VARBINARY | |
| 5. |
The facility that allows nesting one select statement into another is ______________ |
| A. | nesting |
| B. | binding |
| C. | subquerying |
| D. | encapsulating |
| Answer» D. encapsulating | |
| 6. |
The NUL (‘\0’) is same as the SQL NULL value. |
| A. | True |
| B. | False |
| C. | May be True or False |
| D. | Can't say |
| Answer» C. May be True or False | |
| 7. |
Which character set variable indicates the character set used for storing identifiers? |
| A. | character_set_system |
| B. | character_set_server |
| C. | collation_server |
| D. | character_set_database |
| Answer» B. character_set_server | |
| 8. |
To measure the length of a string in bytes, the operator used is __________ |
| A. | CHAR_LENGTH() |
| B. | LENGTH() |
| C. | LEN() |
| D. | SIZE() |
| Answer» C. LEN() | |
| 9. |
What is used to produce a new string from an old string in the desired character set? |
| A. | Introducers |
| B. | CONVERT() |
| C. | CONVERTER() |
| D. | CONVERTS() |
| Answer» C. CONVERTER() | |
| 10. |
X’61626364′ and X’61626364′ are respectively __________ |
| A. | abcd and 1633837924 |
| B. | abcd and 4297383361 |
| C. | dcba and 1633837924 |
| D. | dcba and 4297383361 |
| Answer» B. abcd and 4297383361 | |
| 11. |
x’ffff’ in decimal is ___________ |
| A. | 65534 |
| B. | 66535 |
| C. | 65536 |
| D. | 65537 |
| Answer» D. 65537 | |
| 12. |
Which declaration represents that “character data will consume the same number of bytes as declared and is right padded”? |
| A. | Char |
| B. | Varchar |
| C. | Both Char and Varchar |
| D. | None of the mentioned |
| Answer» B. Varchar | |
| 13. |
Character data can be stored as ______________ |
| A. | Fixed length string |
| B. | Variable length string |
| C. | Either Fixed or Variable length string |
| D. | None of the mentioned |
| Answer» D. None of the mentioned | |
| 14. |
Which among the following have the maximum bytes? |
| A. | Varchar |
| B. | Char |
| C. | Text type |
| D. | Both Varchar and Char |
| Answer» D. Both Varchar and Char | |
| 15. |
In oracle database variable length column is declared by ____________ |
| A. | Varchar |
| B. | Varchar 3 |
| C. | Varchar2 |
| D. | None of the mentioned |
| Answer» D. None of the mentioned | |
| 16. |
Which “text type” has the maximum number of bytes? |
| A. | Tiny text |
| B. | Text |
| C. | Medium text |
| D. | Long text |
| Answer» E. | |
| 17. |
Mysql support different character sets, which command is used to display all character sets? |
| A. | SHOW CHARACTER SET; |
| B. | SHOW; |
| C. | CHARACTER SET; |
| D. | None of the mentioned |
| Answer» B. SHOW; | |
| 18. |
The maximum length of the varchar columns is ____________ |
| A. | Upto 65, 535 bytes |
| B. | Upto 256 bytes |
| C. | Upto 65, 567 bytes |
| D. | None of the mentioned |
| Answer» B. Upto 256 bytes | |
| 19. |
The maximum length of the char columns is ____________ |
| A. | 255 bytes |
| B. | 65, 535 bytes |
| C. | 256 bytes |
| D. | None of the mentioned |
| Answer» B. 65, 535 bytes | |
| 20. |
Which declaration doesn’t use the same number of bytes and consumption of bytes depends on the input data? |
| A. | Varchar |
| B. | Char |
| C. | Both Varchar and Char |
| D. | None of the mentioned |
| Answer» B. Char | |
| 21. |
Which of the following cannot be a variable? |
| A. | __init__ |
| B. | in |
| C. | it |
| D. | on |
| Answer» C. it | |
| 22. |
Which is the correct operator for power(x^y)? |
| A. | X^y |
| B. | X**y |
| C. | X^^y |
| D. | None of the mentioned |
| Answer» C. X^^y | |
| 23. |
A BIT value in a result set is displayed as a binary string. |
| A. | True |
| B. | False |
| C. | May be True or False |
| D. | Can't say |
| Answer» B. False | |
| 24. |
Numbers prefixed with ‘0x’ are in base __________ |
| A. | 8 |
| B. | 16 |
| C. | 32 |
| D. | 64 |
| Answer» C. 32 | |
| 25. |
If ANSI_QUOTES is enabled, MySQL treats the double quotes as ________________ |
| A. | identifier-quoting character |
| B. | string-quoting character |
| C. | hexadecimal |
| D. | string |
| Answer» B. string-quoting character | |
| 26. |
‘2341’ is a ____________ |
| A. | integer |
| B. | floating point |
| C. | hexadecimal |
| D. | string |
| Answer» E. | |
| 27. |
An ADT is defined to be a mathematical model of a user-defined type along with the collection of all ____________ operations on that model. |
| A. | Cardinality |
| B. | Assignment |
| C. | Primitive |
| D. | Structured |
| Answer» D. Structured | |
| 28. |
Type data abstraction which allows conceptual representation of data in database management system is considered as |
| A. | logical design model |
| B. | data model |
| C. | interface model |
| D. | user friendly model |
| Answer» C. interface model | |
| 29. |
Considering abstraction concepts, process of assigning similar entities to similar entity types systematically is called |
| A. | classification |
| B. | instantiation |
| C. | identification |
| D. | exception abstract |
| Answer» B. instantiation | |
| 30. |
Identification, aggregation and instantiation are abstraction concepts used in |
| A. | intension and extension models |
| B. | classes and nodes models |
| C. | concrete models |
| D. | semantic data models |
| Answer» E. | |
| 31. |
For implementation of PR quadtree data structure, design pattern to use is |
| A. | Visitor |
| B. | Flyweights |
| C. | Composite |
| D. | Compound |
| Answer» C. Composite | |
| 32. |
To deal with relationship between a collection of actions and a hierarchy of object types, approaches are of |
| A. | 2 types |
| B. | 3 types |
| C. | 4 types |
| D. | 5 types |
| Answer» B. 3 types | |
| 33. |
Generalization of important design concepts for a recurring problem is done through a |
| A. | Design Pattern |
| B. | Members |
| C. | Design component |
| D. | Software component |
| Answer» B. Members | |
| 34. |
A structure for a design solution is described by |
| A. | Classes |
| B. | Design patterns |
| C. | Parameters |
| D. | Design members |
| Answer» C. Parameters | |
| 35. |
Techniques that are used to combine various software components are referred to as |
| A. | Design members |
| B. | Design Patterns |
| C. | Physical design member |
| D. | Logical design member |
| Answer» C. Physical design member | |
| 36. |
Maintaining an efficient communication between programmers is job done by |
| A. | Programmers itself |
| B. | Integration team |
| C. | Communication team |
| D. | Design patterns |
| Answer» E. | |
| 37. |
Which if the following is/are the levels of implementation of data structure |
| A. | Abstract level |
| B. | Application level |
| C. | Implementation level |
| D. | All of the above |
| Answer» E. | |
| 38. |
Process of abstraction in which objects and classes are identified with some kind of identifier is classified as |
| A. | classification |
| B. | instantiation |
| C. | identification |
| D. | exception abstract |
| Answer» D. exception abstract | |
| 39. |
Data type is the classification of pieces of information in a____________. |
| A. | Linker |
| B. | Code |
| C. | Program |
| D. | None of the above |
| Answer» D. None of the above | |
| 40. |
Implementation of identical nodes of a PR quadtree can be done through pattern |
| A. | Flyweights |
| B. | Composite |
| C. | Compound |
| D. | Visitor |
| Answer» B. Composite | |
| 41. |
Theoretical computer science refers to the collection of such topics that focus onthe__________, as well as mathematical aspects of computing. |
| A. | Abstract |
| B. | Logical |
| C. | Both (a) and (b) |
| D. | None of the above |
| Answer» D. None of the above | |
| 42. |
A dynamic data structure is one in which the memory for elements is allocated dynamically at runtime. Is this statement True or False? |
| A. | True |
| B. | False |
| C. | May be |
| D. | Partially true and partially false |
| Answer» B. False | |
| 43. |
Identical nodes of a PR quadtree can be implemented by flyweight for |
| A. | Efficient execution |
| B. | Efficient implementation |
| C. | Efficient memory |
| D. | Efficient compile time |
| Answer» D. Efficient compile time | |
| 44. |
Representation of data structure in memory is known as: |
| A. | recursive |
| B. | abstract data type |
| C. | storage structure |
| D. | file structure |
| Answer» C. storage structure | |
| 45. |
Operations on a data structure may be ….. |
| A. | creation |
| B. | destruction |
| C. | selection |
| D. | all of the above |
| Answer» E. | |
| 46. |
Which of the following are the operations applicable an primitive data structures? |
| A. | create |
| B. | destroy |
| C. | update |
| D. | all of the above |
| Answer» E. | |
| 47. |
Which of the following data structure is non-linear type? |
| A. | Strings |
| B. | Lists |
| C. | Stacks |
| D. | Tree |
| Answer» E. | |
| 48. |
Which of the following is true about the characteristics of abstract data types?i) It exports a type.ii) It exports a set of operations. |
| A. | True, False |
| B. | False, True |
| C. | True, True |
| D. | False, False |
| Answer» D. False, False | |
| 49. |
Which of the following data structures are indexed structures? |
| A. | Linear arrays |
| B. | Linked lists |
| C. | Queue |
| D. | Stack |
| Answer» B. Linked lists | |
| 50. |
Which of the following data structure can't store the non-homogeneous data elements? |
| A. | Arrays |
| B. | Records |
| C. | Pointers |
| D. | None of the above |
| Answer» B. Records | |