Quiz Discussion

_____ operator is used for appending two strings.

• 1]

  &

• 2]

  %

• 3]

  ||

• 4]

  _

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

• 1]

  Union

• 2]

  Join

• 3]

  Product

• 4]

  Intersect

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

Which one of the following is procedural language?

• 1]

  Domain relational calculus

• 2]

  Tuple relational calculus

• 3]

  Relational algebra

• 4]

  Query language

The tuples of the relations can be of ________ order.

• 1]

  Any

• 2]

  Same

• 3]

  Sorted

• 4]

  Constant

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;

   

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

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

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

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