MCQOPTIONS
Saved Bookmarks
MCQOPTIONS
This section includes 8 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_STATEMENT_IS_USED_TO_SELECT_A_DEFAULT_DATABASE??$ |
| A. | USE |
| B. | CREATE |
| C. | DROP |
| D. | SCHEMA |
| Answer» B. CREATE | |
| 2. |
Which variable is a handle to a database object? |
| A. | $dbh |
| B. | $sth |
| C. | $fh |
| D. | $h |
| Answer» B. $sth | |
| 3. |
The variable used as a handle to an open file is ______________ |
| A. | $dbh |
| B. | $sth |
| C. | $fh |
| D. | $h |
| Answer» D. $h | |
| 4. |
The functions in Perl DBI called? |
| A. | functions |
| B. | procedures |
| C. | methods |
| D. | programs |
| Answer» D. programs | |
| 5. |
MySQL automatically converts a date or time value to a number if the value is used in a numeric context. |
| A. | True |
| B. | False |
| Answer» B. False | |
| 6. |
The mode that does not remove trailing spaces when CHAR values are retrieved is _____________ |
| A. | PAD_CHAR_TO_FULL_LENGTH |
| B. | TO_FULL_LENGTH_CHAR_PAD |
| C. | CHAR_PAD_TO_FULL_LENGTH |
| D. | PAD_CHAR_TO_LENGTH |
| Answer» B. TO_FULL_LENGTH_CHAR_PAD | |
| 7. |
To disallow zero month or day parts in dates, the option used is _____________ |
| A. | NO_ZERO_IN_DATE |
| B. | NO_DATE_WITH_ZERO |
| C. | ZERO_IN_DATE |
| D. | DATE_WITH_ZERO |
| Answer» B. NO_DATE_WITH_ZERO | |
| 8. |
Which of these has special automatic update behavior? |
| A. | DATE |
| B. | TIME |
| C. | TIMESTAMP |
| D. | YEAR |
| Answer» D. YEAR | |