Quiz Discussion

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

• 1]

  Upper

• 2]

  String

• 3]

  Trim

• 4]

  Lower

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

The most commonly used operation in relational algebra for projecting a set of tuple from a relation is

• 1]

  Join

• 2]

  Projection

• 3]

  Select

• 4]

  Union

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

• 1]

  Where

• 2]

  Select

• 3]

  From

• 4]

  Distinct

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

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

• 1]

  Query

• 2]

  Relational

• 3]

  Structural

• 4]

  Compiler

The term attribute refers to a ___________ of a table.

• 1]

  Record

• 2]

  Column

• 3]

  Tuple

• 4]

  Key

The tuples of the relations can be of ________ order.

• 1]

  Any

• 2]

  Same

• 3]

  Sorted

• 4]

  Constant

SELECT * FROM employee WHERE dept_name="Comp Sci";

In the SQL given above there is an error . Identify the error.

• 1]

  Dept_name

• 2]

  Employee

• 3]

  “Comp Sci”

• 4]

  From

SELECT name
FROM instructor
WHERE salary <= 100000 AND salary >= 90000;

This query can be replaced by which of the following ?

• 1]

  SELECT name
  FROM instructor
  WHERE salary BETWEEN 90000 AND 100000;

   

• 2]

  SELECT name
  FROM employee
  WHERE salary <= 90000 AND salary>=100000;

   

• 3]

  SELECT name
  FROM employee
  WHERE salary BETWEEN 90000 AND 100000;

   

• 4]

  SELECT name
  FROM instructor
  WHERE salary BETWEEN 100000 AND 90000;