Quiz Discussion

Which one of the following is procedural language?

• 1]

  Domain relational calculus

• 2]

  Tuple relational calculus

• 3]

  Relational algebra

• 4]

  Query language

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

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

• 1]

  Column

• 2]

  Key

• 3]

  Row

• 4]

  Entry

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

• 1]

  Where

• 2]

  Select

• 3]

  From

• 4]

  Distinct

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

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

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

• 1]

  Upper

• 2]

  String

• 3]

  Trim

• 4]

  Lower

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

_____ operator is used for appending two strings.

• 1]

  &

• 2]

  %

• 3]

  ||

• 4]

  _

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