Back to Top

Quiz Discussion

Which of the following statement is used to remove the privilege from the user Amir?

Course Name: SQL -Structured Query Language

1]
Remove update on department from Amir
2]
Revoke update on employee from Amir
3]
Delete select on department from Raj
4]
Grant update on employee from Amir

Solution

No Solution Present Yet

Top 5 Similar Quiz - Based On AI&ML

Quiz Recommendation System API Link - https://fresherbell-quiz-api.herokuapp.com/fresherbell_quiz_api

Show entries

Search:

#	Quiz
1 Discuss	Which of the following is true regarding views? 1] The user who creates a view cannot be given update authorization on a view without having update authorization on the relations used to define the view 2] The user who creates a view cannot be given update authorization on a view without having update authorization on the relations used to define the view 3] If a user creates a view on which no authorization can be granted, the system will allow the view creation request 4] A user who creates a view receives all privileges on that view Solution
10 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. 1] With grant 2] Grant user 3] Grant pass privilege 4] With grant option Solution
2 Discuss	`SELECT * FROM employee` What type of statement is this? 1] DML 2] DDL 3] View 4] Integrity constraint Solution
3 Discuss	Which one of the following is used to define the structure of the relation, deleting relations and relating schemas? 1] DML(Data Manipulation Langauge) 2] DDL(Data Definition Langauge) 3] Query 4] Relational Schema Solution
4 Discuss	Which of the following is used to provide delete authorization to instructor? 1] `CREATE ROLE instructor ; GRANT DELETE TO instructor;` 2] `CREATE ROLE instructor; GRANT SELECT ON takes TO instructor;` 3] `CREATE ROLE instructor; GRANT DELETE ON takes TO instructor;` 4] All of the mentioned Solution
5 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? 1] DML(Data Manipulation Langauge) 2] DDL(Data Definition Langauge) 3] Query 4] Relational Schema Solution
6 Discuss	`INSERT INTO instructor VALUES (10211, ’Smith’, ’Biology’, 66000);` What type of statement is this? 1] Query 2] DML 3] Relational 4] DDL Solution
7 Discuss	In the authorization graph, if DBA provides authorization to u1 which in turn gives to u2 which of the following is correct? 1] If DBA revokes authorization from u1 then u2 authorization is also revoked 2] If u1 revokes authorization from u2 then u2 authorization is revoked 3] If DBA & u1 revokes authorization from u1 then u2 authorization is also revoked 4] If u2 revokes authorization then u1 authorization is revoked Solution
8 Discuss	An attribute A of datatype varchar(20) has the value “Avi”. The attribute B of datatype char(20) has value ”Reed”. Here attribute A has ____ spaces and attribute B has ____ spaces. 1] 3, 20 2] 20, 4 3] 20, 20 4] 3, 4 Solution
9 Discuss	To remove a relation from an SQL database, we use the ______ command. 1] Delete 2] Purge 3] Remove 4] Drop table Solution
#	Quiz

Showing 1 to 10 of 10 entries

Social Media

Copyright © 2020 Inovatik - All rights reserved