Loading, please wait ...
Open its course - Database Systems

Functions in SQL

Topic Questions:
26
MCQs T/F FiB SQ
7 10 7 2
Question Type Legends

Easy

Medium

Difficult
Open its course - Database Systems

Multiple Choice Questions for Functions in SQL

  • ×

    Hidden Questions!

    Some MCQs are not visible. Usually teachers hides their visibility if they are few in number. Subject Expert recommends them to have more than 70+ questions against the topic and make them public.

  • 1 if you want to delete a tuple from parent relation and all its child tuples in other relations, which option will you choose on DELETE command?
    1. NO ACTION
    2. CASCADE
    3. SET DEFAULT
    4. NO CHECK

  • 2 If the participation of the child relation in the relationship is mandatory, then nulls are
    1. Allowed
    2. not allowed
    3. Both a & b
    4. None

  • 3 In SQL function we specify which keyword is used to specify the returning data type?
    1. Return
    2. Returns
    3. Output
    4. Select

  • 4 The SQL function which returns a single value is called
    1. Scalar Function
    2. Table Valued Function
    3. Both a & b
    4. None

Contact Us

support@subexpert.com
Write to Us View Help
Subject Expert Logo

Subject Expert

Learn, Evaluate and Optimize

Follow Us
Facebook Switch Display Mode Enable Translation
© 2024 - Subject Expert