Quiz Discussion

A type of query that is placed within a WHERE or HAVING clause of another query is called

Course Name: SQL -Structured Query Language

  • 1]

    Super query

  • 2]

    Multi-query

  • 3]

    Subquery

  • 4]

    Master query

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

An ________ on an attribute of a relation is a data structure that allows the database system to find those tuples in the relation that have a specified value for that attribute efficiently, without scanning through all the tuples of the relation.

  • 1]

    Index

  • 2]

    Reference

  • 3]

    Assertion

  • 4]

    Timestamp

Solution
2
Discuss

In order to ensure that an instructor’s salary domain allows only values greater than a specified value use:

CREATE DOMAIN YearlySalary NUMERIC(8,2)
CONSTRAINT salary VALUE test __________;

 

  • 1]

    Value>=30000.00

  • 2]

    Not null;

  • 3]

    Check(value >= 29000.00);

  • 4]

    Check(value)

Solution
3
Discuss

The SQL database language includes statements for:

  • 1]

    Database definition

  • 2]

    Database manipulation

  • 3]

    Database control

  • 4]

    All of the above

Solution
4
Discuss

Values of one type can be converted to another domain using which of the following?

  • 1]

    Cast

  • 2]

    Drop type

  • 3]

    Alter type

  • 4]

    Convert

Solution
5
Discuss

Which of the following is used to store movie and image files?

  • 1]

    Clob

  • 2]

    Blob

  • 3]

    Binary

  • 4]

    Image

Solution
6
Discuss

Which of the following statements creates a new table temp instructor that has the same schema as an instructor?

  • 1]
    Create table temp_instructor;

     

  • 2]
    Create table temp_instructor like instructor;

     

  • 3]
    Create Table as temp_instructor;

     

  • 4]
    Create table like temp_instructor;

     

Solution
7
Discuss

Dates must be specified in the format

  • 1]

    mm/dd/yy

  • 2]

    yyyy/mm/dd

  • 3]

    dd/mm/yy

  • 4]

    yy/dd/mm

Solution
8
Discuss

Which SQL Query is used to remove a table and all its data from the database?

  • 1]

    Create Table

  • 2]

    Alter Table

  • 3]

    Drop Table

  • 4]

    None of these

Solution
9
Discuss

The user-defined data type can be created using

  • 1]

    Create datatype

  • 2]

    Create data

  • 3]

    Create definetype

  • 4]

    Create type

Solution
10
Discuss

Here which one denotes the relation for which index is created?

Create index studentID_index on student(ID);

 

  • 1]

    StudentID_index

  • 2]

    ID

  • 3]

    StudentID

  • 4]

    Student

Solution
# Quiz