Back to Top

Quiz Discussion

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

Course Name: SQL -Structured Query Language

  • 1]

    Where, from
  • 2]

    From, select
  • 3]

    Select, from
  • 4]

    From, where
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 most commonly used operation in relational algebra for projecting a set of tuple from a relation is

  • 1]

    Join
  • 2]

    Projection
  • 3]

    Select
  • 4]

    Union
Solution
10
Discuss

Using which language can a user request information from a database?

  • 1]

    Query
  • 2]

    Relational
  • 3]

    Structural
  • 4]

    Compiler
Solution
2
Discuss
 
SELECT name ____ instructor name, course id
FROM instructor, teaches
WHERE instructor.ID= teaches.ID;

Which keyword must be used here to rename the field name?

  • 1]

    From
  • 2]

    Rename
  • 3]

    As
  • 4]

    Join
Solution
3
Discuss

The_____ operation allows the combining of two relations by merging pairs of tuples, one from each relation, into a single tuple.

  • 1]

    Select
  • 2]

    Join
  • 3]

    Union
  • 4]

    Intersection
Solution
4
Discuss

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

  • 1]

    Union
  • 2]

    Join
  • 3]

    Product
  • 4]

    Intersect
Solution
5
Discuss
 
SELECT instructor.*
FROM instructor, teaches
WHERE instructor.ID= teaches.ID;

This query does which of the following operation?

  • 1]

    All attributes of instructor and teaches are selected
  • 2]

    All attributes of instructor are selected on the given condition
  • 3]

    All attributes of teaches are selected on given condition
  • 4]

    Only the some attributes from instructed and teaches are selected
Solution
6
Discuss

Department (dept name, building, budget) and Employee (employee_id, name, dept name, salary)
Here the dept_name attribute appears in both the relations. Here using common attributes in relation schema is one way of relating ___________ relations.

  • 1]

    Attributes of common
  • 2]

    Tuple of common
  • 3]

    Tuple of distinct
  • 4]

    Attributes of distinct
Solution
7
Discuss

The term _______ is used to refer to a row.

  • 1]

    Attribute
  • 2]

    Tuple
  • 3]

    Field
  • 4]

    Instance
Solution
8
Discuss

The tuples of the relations can be of ________ order.

  • 1]

    Any
  • 2]

    Same
  • 3]

    Sorted
  • 4]

    Constant
Solution
9
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
#Quiz
Showing 1 to 10 of 10 entries

About Fresherbell

Best learning portal that provides you great learning experience of various technologies with modern compilation tools and technique

Important Links

Social Media

Copyright © 2020 Inovatik - All rights reserved