MCQOPTIONS
Saved Bookmarks
MCQOPTIONS
This section includes 10 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_KEY_DECLARES_THAT_AN_INDEX_IN_ONE_TABLE_IS_RELATED_TO_THAT_IN_ANOTHER_IS_CALLED______________?$ |
| A. | primary |
| B. | secondary |
| C. | foreign |
| D. | cross |
| Answer» D. cross | |
| 2. |
Foreign_keys_can_handle_deletes_and_updates.$ |
| A. | True |
| B. | False |
| Answer» B. False | |
| 3. |
Which of these operators does not perform relative value comparisons? |
| A. | = |
| B. | == |
| C. | <= |
| D. | >= |
| Answer» C. <= | |
| 4. |
The operator that does not perform relative-value comparisons is ______________ |
| A. | = |
| B. | == |
| C. | <= |
| D. | >= |
| Answer» C. <= | |
| 5. |
What allows nesting one select statement into another? |
| A. | nesting |
| B. | binding |
| C. | subquerying |
| D. | encapsulating |
| Answer» D. encapsulating | |
| 6. |
The statement to remove indexes on tables is ______________ |
| A. | DROP INDEX |
| B. | DELETE INDEX |
| C. | REMOVE INDEX |
| D. | FLUSH INDEX |
| Answer» B. DELETE INDEX | |
| 7. |
Which variable returns code from operations that return true or false? |
| A. | $rc |
| B. | $rv |
| C. | $rows |
| D. | $ary |
| Answer» B. $rv | |
| 8. |
The variable that is a handle to a database object is ______________ |
| A. | $dbh |
| B. | $sth |
| C. | $fh |
| D. | $h |
| Answer» B. $sth | |
| 9. |
Which variable is used as a handle to an open file? |
| A. | $dbh |
| B. | $sth |
| C. | $fh |
| D. | $h |
| Answer» D. $h | |
| 10. |
In Perl DBI, functions are called ______________ |
| A. | functions |
| B. | procedures |
| C. | methods |
| D. | programs |
| Answer» D. programs | |