MCQOPTIONS
Saved Bookmarks
MCQOPTIONS
This section includes 14 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. |
The datatype best suited to store currency values is ______________ |
| A. | INT |
| B. | FLOAT |
| C. | DOUBLE |
| D. | DECIMAL |
| Answer» E. | |
| 2. |
The AUTO_INCREMENT column attribute is best used with ______________ |
| A. | FLOAT |
| B. | INT |
| C. | CHARACTER |
| D. | DOUBLE |
| Answer» C. CHARACTER | |
| 3. |
What does ‘abc’ || ‘xyz’ result in if the PIPES_AS_CONCAT is disabled? |
| A. | 1 |
| B. | 0 |
| C. | error |
| D. | -1 |
| Answer» C. error | |
| 4. |
What does the expression ’12 DIV 5′ evaluate to? |
| A. | 2.4 |
| B. | 2 |
| C. | error |
| D. | 0 |
| Answer» C. error | |
| 5. |
THE_DATATYPE_BEST_SUITED_TO_STORE_CURRENCY_VALUES_IS_______________?$ |
| A. | INT |
| B. | FLOAT |
| C. | DOUBLE |
| D. | DECIMAL |
| Answer» E. | |
| 6. |
The AUTO_INCREMENT column attribute is best used with _____________? |
| A. | FLOAT |
| B. | INT |
| C. | CHARACTER |
| D. | DOUBLE |
| Answer» C. CHARACTER | |
| 7. |
What does ‘abc’ || ‘xyz’ result in if the PIPES_AS_CONCAT is disabled?# |
| A. | 1 |
| B. | 0 |
| C. | error |
| D. | -1 |
| Answer» C. error | |
| 8. |
What does the expression ’12 DIV 5′ evaluate to?$ |
| A. | 2.4 |
| B. | 2 |
| C. | error |
| D. | 0 |
| Answer» C. error | |
| 9. |
By default, the AUTO_INCREMENT sequences begin at __________ |
| A. | 0 |
| B. | 1 |
| C. | -1 |
| D. | 2 |
| Answer» C. -1 | |
| 10. |
There can be more than one column per table with the AUTO_INCREMENT attribute. |
| A. | True |
| B. | False |
| Answer» C. | |
| 11. |
CGI.pm also supports an object oriented style of use. |
| A. | True |
| B. | False |
| Answer» B. False | |
| 12. |
Which line is written at the top of the script to write a Perl script using CGI.pm? |
| A. | use this CGI |
| B. | put CGI |
| C. | use CGI |
| D. | include CGI |
| Answer» D. include CGI | |
| 13. |
CGI stands for ______________ |
| A. | Computer Gateway Interface |
| B. | Common Gateway Interface |
| C. | Computer Generated Interface |
| D. | Common Generated Interface |
| Answer» C. Computer Generated Interface | |
| 14. |
The module that links DBI to the web is ______________ |
| A. | CGI.pn |
| B. | CGI.pem |
| C. | CGI.pm |
| D. | CGI.po |
| Answer» D. CGI.po | |