Quiz Discussion

The tuples of the relations can be of ________ order.

• 1]

  Any

• 2]

  Same

• 3]

  Sorted

• 4]

  Constant

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

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

A relational database consists of a collection of

• 1]

  Tables

• 2]

  Fields

• 3]

  Records

• 4]

  Keys

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 ________ clause is used to list the attributes desired in the result of a query.

• 1]

  Where

• 2]

  Select

• 3]

  From

• 4]

  Distinct

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

• 1]

  Different

• 2]

  Indivisbile

• 3]

  Constant

• 4]

  Divisible

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

• 1]

  Column

• 2]

  Key

• 3]

  Row

• 4]

  Entry

Student(ID, name, dept name, tot_cred)
In this query which attributes form the primary key?

• 1]

  Name

• 2]

  Dept

• 3]

  Tot_cred

• 4]

  ID

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