Quiz Discussion

Views constructed from SQL SELECT statements that conform to the SQL-92 standard may not contain

Course Name: SQL -Structured Query Language

  • 1]

    GROUP BY

  • 2]

    WHERE

  • 3]

    ORDER BY

  • 4]

    FROM

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

What SQL structure is used to limit column values of a table?

  • 1]

    The LIMIT constraint

  • 2]

    The CHECK constraint

  • 3]

    The VALUE constraint

  • 4]

    None of the above

Solution
2
Discuss

‘AS’ clause is used in SQL for

  • 1]

    Selection operation

  • 2]

    Rename operation

  • 3]

    Join operation

  • 4]

    Projection operation

Solution
3
Discuss

Which one of the following is not true for a view

  • 1]

    View is derived from other tables

  • 2]

    View is a virtual table

  • 3]

    A view definition is permanently stored as part of the database

  • 4]

    View never contains derived columns

Solution
4
Discuss

What is an advantage of placing computations in SQL views

  • 1]

    To save users from having to write an expression

  • 2]

    To ensure that the results are consistent

  • 3]

    To accomplish both of the above

  • 4]

    None of the above

Solution
5
Discuss

Count function in SQL returns the number of

  • 1]

    Values

  • 2]

    Distinct values

  • 3]

    Groups

  • 4]

    Columns

Solution
6
Discuss

Which of the following is a legal expression in SQL?

  • 1]
    SELECT NULL FROM EMPLOYEE;

     

  • 2]
    SELECT NAME FROM EMPLOYEE;

     

  • 3]
    SELECT NAME FROM EMPLOYEE WHERE SALARY = NULL;

     

  • 4]
    None of the above

     

Solution
7
Discuss

Which of the following is a valid SQL type?

  • 1]

    CHARACTER

  • 2]

    NUMERIC

  • 3]

    FLOAT

  • 4]

    All of the above

Solution
8
Discuss

Which is NOT one of the most common types of SQL CHECK constraints?

  • 1]

    System date

  • 2]

    Range checks

  • 3]

    Lists of values

  • 4]

    Comparing one column value to another within the same table

Solution
9
Discuss

To delete a particular column in a relation the command used is

  • 1]

    UPDATE

  • 2]

    DROP

  • 3]

    ALTER

  • 4]

    DELETE

Solution
10
Discuss

A reason for using an SQL view to hide columns is

  • 1]

    to simplify a result only

  • 2]

    to prevent the display of sensitive data only

  • 3]

    to accomplish both of the above

  • 4]

    None of the above

Solution
# Quiz