Quiz Discussion

_____ operator is used for appending two strings.

• 1]

  &

• 2]

  %

• 3]

  ||

• 4]

  _

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;

   

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

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

A domain is atomic if elements of the domain are considered to be ____________ units.

• 1]

  Different

• 2]

  Indivisbile

• 3]

  Constant

• 4]

  Divisible

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

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

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

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