Quiz Discussion

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

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

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

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

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

The term attribute refers to a ___________ of a table.

• 1]

  Record

• 2]

  Column

• 3]

  Tuple

• 4]

  Key

_____ operator is used for appending two strings.

• 1]

  &

• 2]

  %

• 3]

  ||

• 4]

  _

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

• 1]

  Where

• 2]

  Select

• 3]

  From

• 4]

  Distinct

The term _______ is used to refer to a row.

• 1]

  Attribute

• 2]

  Tuple

• 3]

  Field

• 4]

  Instance

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

• 1]

  Column

• 2]

  Key

• 3]

  Row

• 4]

  Entry