Back to Top

Quiz Discussion

In SQL the spaces at the end of the string are removed by _______ function.

Course Name: SQL -Structured Query Language

  • 1]

    Upper
  • 2]

    String
  • 3]

    Trim
  • 4]

    Lower
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

For each attribute of a relation, there is a set of permitted values, called the ________ of that attribute.

  • 1]

    Domain
  • 2]

    Relation
  • 3]

    Set
  • 4]

    Schema
Solution
10
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
2
Discuss

The term attribute refers to a ___________ of a table.

  • 1]

    Record
  • 2]

    Column
  • 3]

    Tuple
  • 4]

    Key
Solution
3
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
4
Discuss

The term _______ is used to refer to a row.

  • 1]

    Attribute
  • 2]

    Tuple
  • 3]

    Field
  • 4]

    Instance
Solution
5
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
6
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
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

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

  • 1]

    Where
  • 2]

    Select
  • 3]

    From
  • 4]

    Distinct
Solution
9
Discuss

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

  • 1]

    Column
  • 2]

    Key
  • 3]

    Row
  • 4]

    Entry
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