Quiz Discussion

Which of the following is true regarding views?

Course Name: SQL -Structured Query Language

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

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
2
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
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
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
5
Discuss
SELECT * FROM employee

What type of statement is this?

  • 1]

    DML

  • 2]

    DDL

  • 3]

    View

  • 4]

    Integrity constraint

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

Updates that violate __________ are disallowed.

  • 1]

    Integrity constraints

  • 2]

    Transaction control

  • 3]

    Authorization

  • 4]

    DDL constraints

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