Quiz Discussion

A relational database consists of a collection of

• 1]

  Tables

• 2]

  Fields

• 3]

  Records

• 4]

  Keys

The tuples of the relations can be of ________ order.

• 1]

  Any

• 2]

  Same

• 3]

  Sorted

• 4]

  Constant

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

Using which language can a user request information from a database?

• 1]

  Query

• 2]

  Relational

• 3]

  Structural

• 4]

  Compiler

The term attribute refers to a ___________ of a table.

• 1]

  Record

• 2]

  Column

• 3]

  Tuple

• 4]

  Key

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

• 1]

  Upper

• 2]

  String

• 3]

  Trim

• 4]

  Lower

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

• 1]

  Where

• 2]

  Select

• 3]

  From

• 4]

  Distinct

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

_____ operator is used for appending two strings.

• 1]

  &

• 2]

  %

• 3]

  ||

• 4]

  _