McqMate
These multiple-choice questions (MCQs) are designed to enhance your knowledge and understanding in the following areas: Master of Computer Applications (MCA) .
Chapters
| 151. |
Changing cardinalities in a database is: |
| A. | a common database design task. |
| B. | a rare database design task, but does occur. |
| C. | a database design task that never occurs. |
| D. | is impossible to do, so a new database must be constructed and the data moved into it. |
| Answer» A. a common database design task. | |
| 152. |
Which one of the following sorts rows in SQL? |
| A. | SORT BY |
| B. | ALIGN BY |
| C. | ORDER BY |
| D. | GROUP BY |
| Answer» C. ORDER BY | |
| 153. |
The SQL keyword(s) ________ is used with wildcards. |
| A. | LIKE only |
| B. | IN only |
| C. | NOT IN only |
| D. | IN and NOT IN |
| Answer» A. LIKE only | |
| 154. |
If a relationship has a cascade updates constraint, then if ________ in the parent table is changed, then the same change will automatically be made to any corresponding foreign key value. |
| A. | the primary key |
| B. | any alternate key |
| C. | a surrogate key |
| D. | a foreign key |
| Answer» A. the primary key | |
| 155. |
For every relationship, how many possible types of actions are there when enforcing minimum cardinalities? |
| A. | Two |
| B. | Three |
| C. | Four |
| D. | Six |
| Answer» D. Six | |
| 156. |
In creating a procedure, you may get a message if you have compile errors. Which of the following is true? |
| A. | The line numbers reported match the line numbers you see in your text editor. |
| B. | SQL*Plus will automatically show the errors to you. |
| C. | To see the errors, enter SHOW ERRORS in SQL*Plus. |
| D. | If there are no syntax errors, you will receive the message "NO ERRORS." |
| Answer» C. To see the errors, enter SHOW ERRORS in SQL*Plus. | |
| 157. |
Which of the following is not true about indexes? |
| A. | Indexes are created to enforce uniqueness on columns. |
| B. | Indexes are created to enable fast retrieval by column values. |
| C. | Columns that are frequently used with equal conditions in WHERE clauses are good candidates for indexes. |
| D. | Indexes are created with the ALTER TABLE command. |
| Answer» D. Indexes are created with the ALTER TABLE command. | |
Done Studing? Take A Test.
Great job completing your study session! Now it's time to put your knowledge to the test. Challenge yourself, see how much you've learned, and identify areas for improvement. Don’t worry, this is all part of the journey to mastery. Ready for the next step? Take a quiz to solidify what you've just studied.