Quiz Discussion

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 term _______ is used to refer to a row.

• 1]

  Attribute

• 2]

  Tuple

• 3]

  Field

• 4]

  Instance

A relational database consists of a collection of

• 1]

  Tables

• 2]

  Fields

• 3]

  Records

• 4]

  Keys

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

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

• 1]

  Upper

• 2]

  String

• 3]

  Trim

• 4]

  Lower

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 name
FROM instructor
WHERE dept name = ’Physics’
ORDER BY name;

By default, the order by clause lists items in ______ order.

• 1]

  Descending

• 2]

  Any

• 3]

  Same

• 4]

  Ascending

_____ operator is used for appending two strings.

• 1]

  &

• 2]

  %

• 3]

  ||

• 4]

  _

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

• 1]

  Column

• 2]

  Key

• 3]

  Row

• 4]

  Entry

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