Quiz Discussion

The _______operation performs a set union of two “similarly structured” tables

Course Name: SQL -Structured Query Language

  • 1]

    Union

  • 2]

    Join

  • 3]

    Product

  • 4]

    Intersect

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

The ______ clause allows us to select only those rows in the result relation of the ____ clause that satisfy a specified predicate.

  • 1]

    Where, from

  • 2]

    From, select

  • 3]

    Select, from

  • 4]

    From, where

Solution
2
Discuss

A relational database consists of a collection of

  • 1]

    Tables

  • 2]

    Fields

  • 3]

    Records

  • 4]

    Keys

Solution
3
Discuss

Student(ID, name, dept name, tot_cred)
In this query which attributes form the primary key?

  • 1]

    Name

  • 2]

    Dept

  • 3]

    Tot_cred

  • 4]

    ID

Solution
4
Discuss
SELECT emp_name
FROM department
WHERE dept_name LIKE ’ _____ Computer Science’;

Which one of the following has to be added into the blank to select the dept_name which has Computer Science as its ending string?

  • 1]

    %

  • 2]

    _

  • 3]

    ||

  • 4]

    $

Solution
5
Discuss
SELECT *
FROM instructor
ORDER BY salary ____, name ___;

To display the salary from greater to smaller and name in ascending order which of the following options should be used?

  • 1]

    Ascending, Descending

  • 2]

    Asc, Desc

  • 3]

    Desc, Asc

  • 4]

    Descending, Ascending

Solution
6
Discuss

The result which the operation contains all pairs of tuples from the two relations, regardless of whether their attribute values match.

  • 1]

    Join

  • 2]

    Cartesian product

  • 3]

    Intersection

  • 4]

    Set difference

Solution
7
Discuss

Database __________ which is the logical design of the database, and the database _______ which is a snapshot of the data in the database at a given instant in time.

  • 1]

    Instance, Schema

  • 2]

    Relation, Schema

  • 3]

    Relation, Domain

  • 4]

    Schema, Instance

Solution
8
Discuss

The term _______ is used to refer to a row.

  • 1]

    Attribute

  • 2]

    Tuple

  • 3]

    Field

  • 4]

    Instance

Solution
9
Discuss

A ________ in a table represents a relationship among a set of values.

  • 1]

    Column

  • 2]

    Key

  • 3]

    Row

  • 4]

    Entry

Solution
10
Discuss

The _________ provides a set of operations that take one or more relations as input and return a relation as an output.

  • 1]

    Schematic representation

  • 2]

    Relational algebra

  • 3]

    Scheme diagram

  • 4]

    Relation flow

Solution
# Quiz