MCQOPTIONS
Saved Bookmarks
MCQOPTIONS
This section includes 3 Mcqs, each offering curated multiple-choice questions to sharpen your Rdbms knowledge and support exam preparation. Choose a topic below to get started.
| 1. |
State true or false: Oracle does not support complex check conditions |
| A. | tTrue |
| B. | tFalse |
| Answer» B. tFalse | |
| 2. |
What does the following condition do?check( name in( Ryan , Cristiano , Leo )) |
| A. | tThe condition checks whether the name attribute includes the three mentioned names |
| B. | tThe condition allows the name attribute to possess only the three mentioned names |
| C. | tThe condition checks whether the given names are sub-strings in at least one of the values |
| D. | tNone of the mentioned |
| Answer» C. tThe condition checks whether the given names are sub-strings in at least one of the values | |
| 3. |
What is the function of the unique constraint? |
| A. | tIt ensures that no two values under an attribute are identical |
| B. | tIt ensures that all the attributes are perfectly unique in their data type |
| C. | tIt ensures that all the relations in the database have a unique set of attributes |
| D. | tIt does not have any function in SQL |
| Answer» B. tIt ensures that all the attributes are perfectly unique in their data type | |