Quiz Discussion

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

Course Name: SQL -Structured Query Language

  • 1]

    .txt

  • 2]

    .ora

  • 3]

    .pls

  • 4]

    .sql

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

Triggers __________ enabled or disabled.

  • 1]

    Cannot be

  • 2]

    Can be

  • 3]

    Ought to be

  • 4]

    Always

Solution
4
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
5
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
6
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
7
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
8
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
9
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
10
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
# Quiz