Quiz Discussion

Count function in SQL returns the number of

Course Name: SQL -Structured Query Language

  • 1]

    Values

  • 2]

    Distinct values

  • 3]

    Groups

  • 4]

    Columns

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

Which of the following is an SQL trigger supported by Oracle?

  • 1]

    BEFORE

  • 2]

    AFTER

  • 3]

    INSTEAD OF

  • 4]

    All of the above

Solution
2
Discuss

Which of the following is an advantage of view?

  • 1]

    Data security

  • 2]

    Derived columns

  • 3]

    Hiding of complex queries

  • 4]

    All of the above

Solution
3
Discuss

What is not an advantage of stored procedures?

  • 1]

    Greater security

  • 2]

    SQL can be optimized

  • 3]

    Code sharing

  • 4]

    Increased network traffic

Solution
4
Discuss

The SQL ALTER statement can be used to

  • 1]

    Change the table structure

  • 2]

    Change the table data

  • 3]

    Add rows to the table

  • 4]

    Delete rows from the table

Solution
5
Discuss

Which of the following is a valid SQL type?

  • 1]

    CHARACTER

  • 2]

    NUMERIC

  • 3]

    FLOAT

  • 4]

    All of the above

Solution
6
Discuss

The statement in SQL which allows changing the definition of a table is

  • 1]

    Alter

  • 2]

    Update

  • 3]

    Create

  • 4]

    Select

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

‘AS’ clause is used in SQL for

  • 1]

    Selection operation

  • 2]

    Rename operation

  • 3]

    Join operation

  • 4]

    Projection operation

Solution
9
Discuss

A report generator is used to

  • 1]

    update files

  • 2]

    print files on paper

  • 3]

    data entry

  • 4]

    delete files

Solution
10
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
# Quiz