Quiz Discussion

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?

Course Name: SQL -Structured Query Language

  • 1]

    DML(Data Manipulation Langauge)

  • 2]

    DDL(Data Definition Langauge)

  • 3]

    Query

  • 4]

    Relational Schema

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
CREATE TABLE employee (name VARCHAR, id INTEGER)

What type of statement is this?

  • 1]

    DML

  • 2]

    DDL

  • 3]

    View

  • 4]

    Integrity constraint

Solution
2
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
3
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
4
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
5
Discuss
INSERT INTO instructor VALUES (10211, ’Smith’, ’Biology’, 66000);

What type of statement is this?

  • 1]

    Query

  • 2]

    DML

  • 3]

    Relational

  • 4]

    DDL

Solution
6
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
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.

  • 1]

    With grant

  • 2]

    Grant user

  • 3]

    Grant pass privilege

  • 4]

    With grant option

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?

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

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

  • 1]

    Delete

  • 2]

    Purge

  • 3]

    Remove

  • 4]

    Drop table

Solution
# Quiz