MCQOPTIONS
Saved Bookmarks
MCQOPTIONS
This section includes 14 Mcqs, each offering curated multiple-choice questions to sharpen your Rdbms knowledge and support exam preparation. Choose a topic below to get started.
| 1. |
What statement is used to define a new assertion in SQL? |
| A. | create check ; |
| B. | create assertion where ; |
| C. | create where ; |
| D. | create assertion check ;Answer: dExplanation: We use “create assertion check ;” statement to create a new assertion in a relation. advertisement/**/ var adpushup = adpushup || {}; adpushup.que = adpushup.que || []; adpushup.que.push(function() { adpushup.triggerAd("90f55663-effd-4105-b1e7-29d86b526544"); });/**/ Sanfoundry Global Education & Learning Series – RDBMS.To practice all areas of RDBMS, here is complete set of 1000+ Multiple Choice Questions and Answers.Participate in the Sanfoundry Certification contest to get free Certificate of Merit. Join our social networks below and stay updated with latest contests, videos, internships and jobs!Telegram | Youtube | LinkedIn | Instagram | Facebook | Twitter | PinterestYoutube | LinkedIn | Instagram | Facebook | Twitter | Pinterest« Prev - RDBMS Questions and Answers – Views and Transactions» Next - RDBMS Questions and Answers – SQL Data Types and Schemas |
| Answer» E. | |
| 2. |
State true or false: Oracle does not support complex check conditions |
| A. | True |
| B. | False |
| Answer» B. False | |
| 3. |
________ is a predicate that we expect the database to always satisfy |
| A. | Assertion |
| B. | Reason |
| C. | Mandate |
| D. | Verify |
| Answer» B. Reason | |
| 4. |
What does the following condition do?check( name in( ‘Ryan’, ‘Cristiano’, ‘Leo’)) |
| A. | The condition checks whether the name attribute includes the three mentioned names |
| B. | The condition allows the name attribute to possess only the three mentioned names |
| C. | The condition checks whether the given names are sub-strings in at least one of the values |
| D. | None of the mentioned |
| Answer» C. The condition checks whether the given names are sub-strings in at least one of the values | |
| 5. |
What is the function of the unique constraint? |
| A. | It ensures that no two values under an attribute are identical |
| B. | It ensures that all the attributes are perfectly unique in their data type |
| C. | It ensures that all the relations in the database have a unique set of attributes |
| D. | It does not have any function in SQL |
| Answer» B. It ensures that all the attributes are perfectly unique in their data type | |
| 6. |
Domain constraints, functional dependency and referential integrity are special forms of _________$ |
| A. | Foreign key |
| B. | Primary key |
| C. | Assertion |
| D. | Referential constraint |
| Answer» D. Referential constraint | |
| 7. |
State true or false: Oracle does not support complex check condition? |
| A. | True |
| B. | False |
| Answer» B. False | |
| 8. |
Foreign key is the one in which the ________ of one relation is referenced in another relation. |
| A. | Foreign key |
| B. | Primary key |
| C. | References |
| D. | Check constraint |
| Answer» D. Check constraint | |
| 9. |
________ is a predicate that we expect the database to always satisfy |
| A. | Assertion |
| B. | Reason |
| C. | Mandate |
| D. | Verify |
| Answer» B. Reason | |
| 10. |
Referential integrity constraints are also called as _________ |
| A. | Functional dependencies |
| B. | Subset dependencies |
| C. | Superset dependencies |
| D. | Primary dependencies |
| Answer» C. Superset dependencies | |
| 11. |
What does the following condition do? |
| A. | ) |
| B. | The condition checks whether the name attribute includes the three mentioned names |
| C. | The condition allows the name attribute to possess only the three mentioned names |
| D. | The condition checks whether the given names are sub-strings in at least one of the values |
| Answer» C. The condition allows the name attribute to possess only the three mentioned names | |
| 12. |
What is the functions of on delete cascade? |
| A. | It is used to delete a tuple in a table |
| B. | It is used to specify the precise attribute that needs to be deleted in a single relation. |
| C. | It is used to preserve referential integrity in a relation |
| D. | It is used to execute sub-queries in the from clause. |
| Answer» D. It is used to execute sub-queries in the from clause. | |
| 13. |
What is the function of the not null constraint? |
| A. | It prevents illegal data from being entered into the database |
| B. | It ensures that data is entered into the database |
| C. | It ensures that the data entered is unique |
| D. | None of the mentioned |
| Answer» C. It ensures that the data entered is unique | |
| 14. |
Which of the following is not an integrity constraint? |
| A. | not null |
| B. | unique |
| C. | identical |
| D. | check |
| Answer» D. check | |