Back to Top

Quiz Discussion

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

Course Name: SQL -Structured Query Language

  • 1]

    Join
  • 2]

    Cartesian product
  • 3]

    Intersection
  • 4]

    Set difference
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
10
Discuss
 
SELECT name
FROM instructor
WHERE dept name = ’Physics’
ORDER BY name;

By default, the order by clause lists items in ______ order.

  • 1]

    Descending
  • 2]

    Any
  • 3]

    Same
  • 4]

    Ascending
Solution
2
Discuss

Course(course_id,sec_id,semester)

Here the course_id,sec_id and semester are __________ and course is a _________

  • 1]

    Relations, Attribute
  • 2]

    Attributes, Relation
  • 3]

    Tuple, Relation
  • 4]

    Tuple, Attributes
Solution
3
Discuss

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

  • 1]

    Column
  • 2]

    Key
  • 3]

    Row
  • 4]

    Entry
Solution
4
Discuss

The tuples of the relations can be of ________ order.

  • 1]

    Any
  • 2]

    Same
  • 3]

    Sorted
  • 4]

    Constant
Solution
5
Discuss

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

  • 1]

    Union
  • 2]

    Join
  • 3]

    Product
  • 4]

    Intersect
Solution
6
Discuss

The ________ clause is used to list the attributes desired in the result of a query.

  • 1]

    Where
  • 2]

    Select
  • 3]

    From
  • 4]

    Distinct
Solution
7
Discuss

A domain is atomic if elements of the domain are considered to be ____________ units.

  • 1]

    Different
  • 2]

    Indivisbile
  • 3]

    Constant
  • 4]

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

A ________ is a pictorial depiction of the schema of a database that shows the relations in the database, their attributes, and primary keys and foreign keys.

  • 1]

    Schema diagram
  • 2]

    Relational algebra
  • 3]

    Database diagram
  • 4]

    Schema flow
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