MCQOPTIONS
Saved Bookmarks
MCQOPTIONS
This section includes 6 Mcqs, each offering curated multiple-choice questions to sharpen your Database knowledge and support exam preparation. Choose a topic below to get started.
| 1. |
Which_of_the_following_closely_resembles_Create_view?$ |
| A. | Create table . . .like |
| B. | Create table . . . as |
| C. | With data |
| D. | Create view as |
| Answer» C. With data | |
| 2. |
Values of one type can be converted to another domain using which of the following? |
| A. | Cast |
| B. | Drop type |
| C. | Alter type |
| D. | Convert |
| Answer» D. Convert | |
| 3. |
The user defined data type can be created using |
| A. | Create datatype |
| B. | Create data |
| C. | Create definetype |
| D. | Create type |
| Answer» B. Create data | |
| 4. |
Which of the following is used to store movie and image files? |
| A. | Clob |
| B. | Blob |
| C. | Binary |
| D. | Image |
| Answer» E. | |
| 5. |
A ________ on an attribute of a relation is a data structure that allows the database system to find those tuples in the relation that have a specified value for that attribute efficiently, without scanning through all the tuples of the relation. |
| A. | Index |
| B. | Reference |
| C. | Assertion |
| D. | Timestamp |
| Answer» B. Reference | |
| 6. |
Dates must be specified in the format |
| A. | mm/dd/yy |
| B. | yyyy/mm/dd |
| C. | dd/mm/yy |
| D. | yy/dd/mm |
| Answer» C. dd/mm/yy | |