Quiz Discussion

Which one of the following is procedural language?

• 1]

  Domain relational calculus

• 2]

  Tuple relational calculus

• 3]

  Relational algebra

• 4]

  Query language

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

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

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

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

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

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

• 1]

  Column

• 2]

  Key

• 3]

  Row

• 4]

  Entry

A relational database consists of a collection of

• 1]

  Tables

• 2]

  Fields

• 3]

  Records

• 4]

  Keys

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

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

• 1]

  Query

• 2]

  Relational

• 3]

  Structural

• 4]

  Compiler