Which one of the following is used to define the structure of the relation, deleting relations and relating schemas?
DML(Data Manipulation Langauge)
DDL(Data Definition Langauge)
Query
Relational Schema
Quiz Recommendation System API Link - https://fresherbell-quiz-api.herokuapp.com/fresherbell_quiz_api
# | Quiz |
---|---|
1
Discuss
|
To remove a relation from an SQL database, we use the ______ command.
Solution |
2
Discuss
|
This command performs which of the following action?
Solution |
3
Discuss
|
Which of the following is used to avoid cascading of authorizations from the user?
Solution |
4
Discuss
|
Which of the following is used to provide delete authorization to instructor?
Solution |
5
Discuss
|
In the authorization graph, if DBA provides authorization to u1 which in turn gives to u2 which of the following is correct?
Solution |
6
Discuss
|
What type of statement is this?
Solution |
7
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 |
8
Discuss
|
Which of the following statement is used to remove the privilege from the user Amir?
Solution |
9
Discuss
|
What type of statement is this?
Solution |
10
Discuss
|
Updates that violate __________ are disallowed.
Solution |
# | Quiz |
Copyright © 2020 Inovatik - All rights reserved