Quiz Discussion

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

Course Name: SQL -Structured Query Language

  • 1]

    trigger

  • 2]

    stored procedure

  • 3]

    pseudofile

  • 4]

    None 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

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
2
Discuss

When using the SQL INSERT statement

  • 1]

    rows can be modified according to criteria only

  • 2]

    rows cannot be copied in mass from one table to another only

  • 3]

    rows can be inserted into a table only one at a time only

  • 4]

    rows can either be inserted into a table one at a time or in groups

Solution
3
Discuss

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

  • 1]

    PRIMARY KEY

  • 2]

    ALTERNATE KEY

  • 3]

    UNIQUE

  • 4]

    FOREIGN KEY

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

The DROP TABLE statement:

  • 1]

    deletes the table structure only

  • 2]

    deletes the table structure along with the table data

  • 3]

    works whether or not referential integrity constraints would be violated

  • 4]

    is not an SQL statement

Solution
7
Discuss

The SQL statement to create a view is

  • 1]

    CREATE VIEW

  • 2]

    MAKE VIEW

  • 3]

    SELECT VIEW

  • 4]

    INSERT VIEW

Solution
8
Discuss

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

  • 1]

    .txt

  • 2]

    .ora

  • 3]

    .pls

  • 4]

    .sql

Solution
9
Discuss

For what purposes are views used?

  • 1]

    To hide columns only

  • 2]

    To hide rows only

  • 3]

    To hide complicated SQL statements only

  • 4]

    All of the above

Solution
10
Discuss

Triggers __________ enabled or disabled.

  • 1]

    Cannot be

  • 2]

    Can be

  • 3]

    Ought to be

  • 4]

    Always

Solution
# Quiz