Quiz Discussion

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

Course Name: SQL -Structured Query Language

  • 1]

    Fixed, equal

  • 2]

    Equal, variable

  • 3]

    Fixed, variable

  • 4]

    Variable, equal

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
INSERT INTO instructor VALUES (10211, ’Smith’, ’Biology’, 66000);

What type of statement is this?

  • 1]

    Query

  • 2]

    DML

  • 3]

    Relational

  • 4]

    DDL

Solution
3
Discuss

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

  • 1]

    Delete

  • 2]

    Purge

  • 3]

    Remove

  • 4]

    Drop table

Solution
4
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
5
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
6
Discuss
SELECT * FROM employee

What type of statement is this?

  • 1]

    DML

  • 2]

    DDL

  • 3]

    View

  • 4]

    Integrity constraint

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