MCQOPTIONS
Saved Bookmarks
MCQOPTIONS
This section includes 7 Mcqs, each offering curated multiple-choice questions to sharpen your Structured Query Language (SQL) knowledge and support exam preparation. Choose a topic below to get started.
| 1. |
WHICH_AMONG_THE_FOLLOWING_IS_THE_CORRECT_REPRESENTATION_OF_‚ÄÖ√Ñ√∂‚ÀÖ√Ë‚ÀÖ‚À´FLOAT(1,1)‚ÄÖ√Ñ√∂‚ÀÖ√Ë‚ÀÖŒÄ??$# |
| A. | Total of 1 digit |
| B. | Total of 2 digit |
| C. | Total of 2 digit, one digit at right of the decimal, one digit at left of the decimal |
| D. | None of the mentioned |
| Answer» B. Total of 2 digit | |
| 2. |
Which among the following are the correct representation of “float(4,2)”?$ |
| A. | 24.33 |
| B. | 124.4 |
| C. | 12.123 |
| D. | Both 24.33 and 124.4 |
| Answer» E. | |
| 3. |
What will be the storage pattern for “float(4,2)” in Mysql?$ |
| A. | Total of four digits, two to the left of decimal and two to the right of decimal |
| B. | Total of six digits |
| C. | Total of four digits, not distributed uniformly |
| D. | None of the mentioned |
| Answer» B. Total of six digits | |
| 4. |
Which Numeric Data type has the largest range? |
| A. | Mediumint |
| B. | Smallint |
| C. | Int |
| D. | Tinyint |
| Answer» D. Tinyint | |
| 5. |
“Numeric Data” is used to store$ |
| A. | Whole numbers |
| B. | Natural numbers |
| C. | Rational numbers |
| D. | Both Whole and Natural numbers |
| Answer» E. | |
| 6. |
Which data type is more suitable for storing “small notes” in Mysql?$ |
| A. | Char |
| B. | Varchar |
| C. | Mediumtext |
| D. | Longtext |
| Answer» D. Longtext | |
| 7. |
What will happen if the data being loaded into a text column exceeds the maximum size of that type? |
| A. | Extra memory will be allocated |
| B. | Process terminate |
| C. | Data will be truncated |
| D. | Depend on the system |
| Answer» D. Depend on the system | |