MCQOPTIONS
Saved Bookmarks
MCQOPTIONS
This section includes 6 Mcqs, each offering curated multiple-choice questions to sharpen your Rdbms knowledge and support exam preparation. Choose a topic below to get started.
| 1. |
revoke select on takes from amit;What does the above query perform? |
| A. | tIt revokes all authorizations from amit |
| B. | tIt revokes select authorization from amit |
| C. | tIt revokes takes authorization from amit |
| D. | tIt gives an error |
| Answer» C. tIt revokes takes authorization from amit | |
| 2. |
The _________ statement is used in SQL to confer authorization. |
| A. | tgrant |
| B. | tconfer |
| C. | timplement |
| D. | tpermit |
| Answer» B. tconfer | |
| 3. |
What does the following statement do?create table temp_inst like institute |
| A. | tIt creates a new relation temp_inst with all the tuples and attributes of the institute relation |
| B. | tIt creates a new relation temp_inst with the same schema as that of the institute relation |
| C. | tIt creates a new relation named temp_inst with institute as its only attribute |
| D. | tIt does not create any relations and returns an error |
| Answer» C. tIt creates a new relation named temp_inst with institute as its only attribute | |
| 4. |
Which of the following is an illegal data type in SQL |
| A. | tnumber |
| B. | tclob |
| C. | tblob |
| D. | tlint |
| Answer» E. | |
| 5. |
What does p indicate in the following data type?time(p) |
| A. | tThe amount of delay that needs to be added to the time |
| B. | tThe number of fractional digits for the seconds |
| C. | tThe maximum number of allowed hours |
| D. | tNone of the mentioned |
| Answer» C. tThe maximum number of allowed hours | |
| 6. |
Which of the following is not a valid Date and Time data type? |
| A. | tdate |
| B. | ttime |
| C. | tdatestamp |
| D. | ttimestamp |
| Answer» D. ttimestamp | |