Quiz Discussion

Which of the following is used to provide privilege to only a particular attribute?

Course Name: SQL -Structured Query Language

  • 1]

    Grant update(budget,salary,Rate) on department to Raj

  • 2]

    Grant update(budget) on department to Raj

  • 3]

    Grant select on employee to Amit

  • 4]

    Grant delete to Amit

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

# Quiz
1
Discuss
DELETE FROM r;   /* r - relation  */

This command performs which of the following action?

  • 1]

    Remove relation

  • 2]

    Clear relation entries

  • 3]

    Delete fields

  • 4]

    Delete rows

Solution
2
Discuss

Which of the following is used to avoid cascading of authorizations from the user?

  • 1]

    Granted by the current role

  • 2]

    Revoke select on the department from Amit, Satoshi restrict;

  • 3]

    Revoke grant option for select on the department from Amit;

  • 4]

    Revoke select on the department from Amit, Satoshi cascade;

Solution
3
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
4
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
5
Discuss

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

  • 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
6
Discuss

To remove a relation from an SQL database, we use the ______ command.

  • 1]

    Delete

  • 2]

    Purge

  • 3]

    Remove

  • 4]

    Drop table

Solution
7
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
8
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
9
Discuss

The basic datatype char (n) is a _______ length character string and varchar (n) is _______ length character.

  • 1]

    Fixed, equal

  • 2]

    Equal, variable

  • 3]

    Fixed, variable

  • 4]

    Variable, equal

Solution
10
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
# Quiz