Quiz Discussion

For what purposes are views used?

Course Name: SQL -Structured Query Language

  • 1]

    To hide columns only

  • 2]

    To hide rows only

  • 3]

    To hide complicated SQL statements only

  • 4]

    All of the above

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

SQL views can be used to hide

  • 1]

    columns and rows only

  • 2]

    complicated SQL syntax only

  • 3]

    both of the above can be hidden by an SQL view

  • 4]

    None of the above is correct

Solution
2
Discuss

A _________ is a program that performs some common action on database data and that is stored in the database

  • 1]

    trigger

  • 2]

    stored procedure

  • 3]

    pseudofile

  • 4]

    None of the above

Solution
3
Discuss

To update an SQL view, the DBMS must be able to associate the column(s) to be updated with

  • 1]

    a particular column in a particular underlying table

  • 2]

    a particular column in a particular row

  • 3]

    a particular row in a particular underlying table

  • 4]

    None of the above is correct

Solution
4
Discuss

The SQL statement to create a view is

  • 1]

    CREATE VIEW

  • 2]

    MAKE VIEW

  • 3]

    SELECT VIEW

  • 4]

    INSERT VIEW

Solution
5
Discuss

Triggers __________ enabled or disabled.

  • 1]

    Cannot be

  • 2]

    Can be

  • 3]

    Ought to be

  • 4]

    Always

Solution
6
Discuss

The default extension for an Oracle SQL*Plus file is:

  • 1]

    .txt

  • 2]

    .ora

  • 3]

    .pls

  • 4]

    .sql

Solution
7
Discuss

To include integrity constraint in a existing relation use :

  • 1]

    Create table

  • 2]

    Alter table

  • 3]

    Modify table

  • 4]

    Any of the above

Solution
8
Discuss

Which of the following is NOT a type of SQL constraint?

  • 1]

    PRIMARY KEY

  • 2]

    ALTERNATE KEY

  • 3]

    UNIQUE

  • 4]

    FOREIGN KEY

Solution
9
Discuss

A _________ is a stored program that is attached to a table or a view.

  • 1]

    pseudofile

  • 2]

    trigger

  • 3]

    embedded SELECT statement

  • 4]

    None of the above is correct.

Solution
10
Discuss

What is an SQL virtual table that is constructed from other tables?

  • 1]

    Just another table

  • 2]

    View

  • 3]

    Relation

  • 4]

    Query results

Solution
# Quiz