Quiz Discussion

SELECT * FROM employee

What type of statement is this?

Course Name: SQL -Structured Query Language

  • 1]

    DML

  • 2]

    DDL

  • 3]

    View

  • 4]

    Integrity constraint

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

Updates that violate __________ are disallowed.

  • 1]

    Integrity constraints

  • 2]

    Transaction control

  • 3]

    Authorization

  • 4]

    DDL constraints

Solution
2
Discuss

The database administrator who authorizes all the new users, modifies the database and takes grants privilege is

  • 1]

    Operator of operating system

  • 2]

    Administrator

  • 3]

    Super user

  • 4]

    All of the mentioned

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

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

  • 1]

    Delete

  • 2]

    Purge

  • 3]

    Remove

  • 4]

    Drop table

Solution
9
Discuss

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

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