To remove a relation from an SQL database, we use the ______ command.
Delete
Purge
Remove
Drop table
Quiz Recommendation System API Link - https://fresherbell-quiz-api.herokuapp.com/fresherbell_quiz_api
# | Quiz |
---|---|
1
Discuss
|
This command performs which of the following action?
Solution |
2
Discuss
|
If we wish to grant a privilege and to allow the recipient to pass the privilege on to other users, we append the __________ clause to the appropriate grant command.
Solution |
3
Discuss
|
The database administrator who authorizes all the new users, modifies the database and takes grants privilege is
Solution |
4
Discuss
|
What type of statement is this?
Solution |
5
Discuss
|
Updates that violate __________ are disallowed.
Solution |
6
Discuss
|
Which one of the following provides the ability to query information from the database and to insert tuples into, delete tuples from, and modify tuples in the database?
Solution |
7
Discuss
|
Which one of the following is used to define the structure of the relation, deleting relations and relating schemas?
Solution |
8
Discuss
|
In the authorization graph, if DBA provides authorization to u1 which in turn gives to u2 which of the following is correct?
Solution |
9
Discuss
|
What type of statement is this?
Solution |
10
Discuss
|
Which of the following is used to avoid cascading of authorizations from the user?
Solution |
# | Quiz |
Copyright © 2020 Inovatik - All rights reserved