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. |
In MyISAM tables, when a table is emptied with the TRUNCATE TABLE, the counter begins at _____________ |
| A. | 0 |
| B. | 1 |
| C. | -1 |
| D. | arbitrary |
| Answer» C. -1 | |
| 2. |
In a MyISAM table, if the maximum value of an AUTO_INCREMENT increment column is 12 and that row is deleted, the next value generated is _____________ |
| A. | 12 |
| B. | 13 |
| C. | 1 |
| D. | 14 |
| Answer» C. 1 | |
| 3. |
The number of rows in the table is 10. Suppose all rows are deleted. The new row starts with sequence number _____________ |
| A. | 11 |
| B. | 1 |
| C. | 100 |
| D. | 101 |
| Answer» C. 100 | |
| 4. |
The ‘LAST_INSERT_ID()’ is tied only to the ‘AUTO_INCREMENT’ values generated during the current connection to the server. |
| A. | True |
| B. | False |
| Answer» B. False | |
| 5. |
IN_A_MYISAM_TABLE,_IF_THE_MAXIMUM_VALUE_OF_AN_AUTO_INCREMENT_INCREMENT_COLUMN_IS_12_AND_THAT_ROW_IS_DELETED,_THE_NEXT_VALUE_GENERATED_IS______________?$ |
| A. | 12 |
| B. | 13 |
| C. | 1 |
| D. | 14 |
| Answer» C. 1 | |
| 6. |
In MyISAM tables, when a table is emptied with the TRUNCATE TABLE, the counter begins at _____________$ |
| A. | 0 |
| B. | 1 |
| C. | -1 |
| D. | arbitrary |
| Answer» C. -1 | |
| 7. |
The number of rows in the table is 10. Suppose all rows are deleted. The new row starts with sequence number ____________? |
| A. | 11 |
| B. | 1 |
| C. | 100 |
| D. | 101 |
| Answer» C. 100 | |
| 8. |
Suppose the last row has the AUTO_INCREMENT column value 32. Suppose a new row is added by setting AUTO_INCREMENT value equal to 100. The next row added will have value _____________ |
| A. | 32 |
| B. | 33 |
| C. | 100 |
| D. | 101 |
| Answer» E. | |
| 9. |
The ‘LAST_INSERT_ID()’ is tied only to the ‘AUTO_INCREMENT’ values generated during the current connection to the server.$ |
| A. | True |
| B. | False |
| Answer» B. False | |
| 10. |
When no AUTO_INCREMENT value has been generated during the current connection, LAST_INSERT_ID() returns ____________ |
| A. | -1 |
| B. | 0 |
| C. | 1 |
| D. | 2 |
| Answer» C. 1 | |
| 11. |
The value of recently generated sequence number can be obtained by ____________ |
| A. | LAST_INSERT_ID() |
| B. | LATEST_INSERT_ID() |
| C. | INITIAL_INSERT_ID() |
| D. | INSERT_ID() |
| Answer» B. LATEST_INSERT_ID() | |
| 12. |
The AUTO_INCREMENT sequences normally begin at __________ |
| A. | 0 |
| B. | 1 |
| C. | -1 |
| D. | 2 |
| Answer» C. -1 | |
| 13. |
There can be only one column per table with the AUTO_INCREMENT attribute. |
| A. | True |
| B. | False |
| Answer» B. False | |
| 14. |
Which column attribute provides unique numbers for identification? |
| A. | AUTO_INCREMENT |
| B. | UNSIGNED |
| C. | IDENTIFY |
| D. | DESCRIBE |
| Answer» B. UNSIGNED | |