Quiz Discussion

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

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

• 1]

  Different

• 2]

  Indivisbile

• 3]

  Constant

• 4]

  Divisible

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

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

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

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

• 1]

  Query

• 2]

  Relational

• 3]

  Structural

• 4]

  Compiler

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

Which one of the following is procedural language?

• 1]

  Domain relational calculus

• 2]

  Tuple relational calculus

• 3]

  Relational algebra

• 4]

  Query language

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