Quiz Discussion

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

• 1]

  Union

• 2]

  Join

• 3]

  Product

• 4]

  Intersect

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

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

• 1]

  Where

• 2]

  Select

• 3]

  From

• 4]

  Distinct

The term _______ is used to refer to a row.

• 1]

  Attribute

• 2]

  Tuple

• 3]

  Field

• 4]

  Instance

Which one of the following is procedural language?

• 1]

  Domain relational calculus

• 2]

  Tuple relational calculus

• 3]

  Relational algebra

• 4]

  Query language

’_____’ matches any string of ______ three characters. ’_____%’ matches any string of at ______ three characters.

• 1]

  Atleast, Exactly

• 2]

  Exactly, Atleast

• 3]

  Atleast, All

• 4]

  All, Exactly

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

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

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 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