Homechevron_rightEngineeringchevron_rightRPSC Programmerchevron_rightProgrammer DBMSchevron_rightRelational Algebra is a ________ language.

Relational Algebra is a ________ language.

  • Q. Relational Algebra is a ________ language.
  • filter_dramaExplanation
    Answer is : B

    The correct answer is option 2.

    Concept:

    Relational algebra is a procedural query language, which takes instances of relations as input and yields instances of relations as output.

    It uses operators to perform queries. An operator can be either unary or binary. They accept relations as their input and yield relations as their output. Relational algebra is performed recursively on relation and intermediate results are also considered relations.

    The fundamental operations of relational algebra are as follows:

    • Select (σ)
    • Project (∏)
    • Union (∪)
    • Set different (−)
    • Cartesian product (Χ)
    • Rename (ρ)

    Hence the correct answer is procedural.

Discussion

    No one started the discussion yet. Break the ice and start the conversation.
    Please Login to be part of the discussion.

Similar Questions

  • 1.

    Match the following:

    i. PSTN     a. Virtual Switching
    ii. X.25        b. Message Switching
    iii. Internet   c. Circuit Switching
    iv. Frame Relay    d. Datagram Switching

     Match for  i , ii , iii, iv respectively is:

  • filter_dramaExplanation
    Answer is : B

    The most common forms of Virtual Circuit networks are X.25 and Frame Relay, which are commonly used for public data networks (PDN).

    The main implementation of Datagram Switching network is the Internet, which uses the IP network protocol.
  • 2. Which of the following provides a mechanism for retrieving emails from a remote server for a mail recipient?
  • filter_dramaExplanation
    Answer is : A

    The correct answer is option 1.

    Key Points POP stands for Post Office Protocol. It provides a standard mechanism for retrieving emails from a remote server for a mail recipient.  In simple terms, a user who wants to receive emails but does not have a permanent connection to the internet uses a POP client to pull emails from the POP server.

    Hence the correct answer is POP server.

    Additional Information

    • SMTP stands for Simple Mail Transfer Protocol, and SMTP server is an application used by mail servers to send, receive, and/or relay outgoing mail between email senders and receivers.
    • Database servers are networked computers on a network dedicated to database storage and data retrieval from the database. The database server is a key component in a client/server computing environment. It holds the database management system (DBMS) and the databases.
  • 3. The situation where no transaction can proceed with normal execution is known as ________
  • filter_dramaExplanation
    Answer is : B
    The situation where no transaction can proceed with normal execution is known as a deadlock.
  • 4.

    What is the number of rows returned for the given Relation R if query passed is “∏Name(R)”?

    Name

    X

    X

    X

    Y

    Z

  • filter_dramaExplanation
    Answer is : C

    Symbol

    Name

    Example

    Projection

    B(R) → Output the column B and no duplicate are allowed

     

    Output:

    Name

    X

    Y

    Z


    Output contain 3 rows
  • 5. Which of the following is not type of SQL?
  • filter_dramaExplanation
    Answer is : D

    SQL is only categorized in three languages: DDL, DML, and Data Control Language

    The set of relations in a database must be specified to the system by means of a data-definition language (DDL).

    DML (Data Manipulation Language) – is used for manipulating the database. Manipulation means insert, modify, delete or query the data in the database. It enables users to access or manipulate the data as organised by the appropriate data model.

    DCL (Data Control Language) which includes commands that are mostly concerned with rights, permissions and other controls of the database system.

Programmer DBMSTopics

leaderboardLeaderboard
  • Rahul Kumar

    191 Points

  • VIKRAM JEET

    54 Points

  • GEETHIKA CHOWDARY

    53 Points

  • sunita saini

    52 Points

  • Zain

    49 Points