Quiz Discussion

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

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

The _________ provides a set of operations that take one or more relations as input and return a relation as an output.

• 1]

  Schematic representation

• 2]

  Relational algebra

• 3]

  Scheme diagram

• 4]

  Relation flow

The term attribute refers to a ___________ of a table.

• 1]

  Record

• 2]

  Column

• 3]

  Tuple

• 4]

  Key

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

Which one of the following is procedural language?

• 1]

  Domain relational calculus

• 2]

  Tuple relational calculus

• 3]

  Relational algebra

• 4]

  Query language

_____ operator is used for appending two strings.

• 1]

  &

• 2]

  %

• 3]

  ||

• 4]

  _

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

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

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