Quiz Discussion

The_____ operation allows the combining of two relations by merging pairs of tuples, one from each relation, into a single tuple.

• 1]

  Select

• 2]

  Join

• 3]

  Union

• 4]

  Intersection

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

SELECT emp_name
FROM department
WHERE dept_name LIKE ’ _____ Computer Science’;

Which one of the following has to be added into the blank to select the dept_name which has Computer Science as its ending string?

• 1]

  %

• 2]

  _

• 3]

  ||

• 4]

  $

The _______ operator takes the results of two queries and returns only rows that appear in both result sets.

• 1]

  Union

• 2]

  Intersect

• 3]

  Difference

• 4]

  Projection

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

• 1]

  Union

• 2]

  Join

• 3]

  Product

• 4]

  Intersect

Department (dept name, building, budget) and Employee (employee_id, name, dept name, salary)
Here the dept_name attribute appears in both the relations. Here using common attributes in relation schema is one way of relating ___________ relations.

• 1]

  Attributes of common

• 2]

  Tuple of common

• 3]

  Tuple of distinct

• 4]

  Attributes of distinct

A relational database consists of a collection of

• 1]

  Tables

• 2]

  Fields

• 3]

  Records

• 4]

  Keys

The tuples of the relations can be of ________ order.

• 1]

  Any

• 2]

  Same

• 3]

  Sorted

• 4]

  Constant

The term _______ is used to refer to a row.

• 1]

  Attribute

• 2]

  Tuple

• 3]

  Field

• 4]

  Instance

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