Quiz Discussion

The tuples of the relations can be of ________ order.

• 1]

  Any

• 2]

  Same

• 3]

  Sorted

• 4]

  Constant

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

• 1]

  Query

• 2]

  Relational

• 3]

  Structural

• 4]

  Compiler

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

For each attribute of a relation, there is a set of permitted values, called the ________ of that attribute.

• 1]

  Domain

• 2]

  Relation

• 3]

  Set

• 4]

  Schema

SELECT name
FROM instructor
WHERE salary <= 100000 AND salary >= 90000;

This query can be replaced by which of the following ?

• 1]

  SELECT name
  FROM instructor
  WHERE salary BETWEEN 90000 AND 100000;

   

• 2]

  SELECT name
  FROM employee
  WHERE salary <= 90000 AND salary>=100000;

   

• 3]

  SELECT name
  FROM employee
  WHERE salary BETWEEN 90000 AND 100000;

   

• 4]

  SELECT name
  FROM instructor
  WHERE salary BETWEEN 100000 AND 90000;

   

Database __________ which is the logical design of the database, and the database _______ which is a snapshot of the data in the database at a given instant in time.

• 1]

  Instance, Schema

• 2]

  Relation, Schema

• 3]

  Relation, Domain

• 4]

  Schema, Instance

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

SELECT * FROM employee WHERE dept_name="Comp Sci";

In the SQL given above there is an error . Identify the error.

• 1]

  Dept_name

• 2]

  Employee

• 3]

  “Comp Sci”

• 4]

  From

Which one of the following is procedural language?

• 1]

  Domain relational calculus

• 2]

  Tuple relational calculus

• 3]

  Relational algebra

• 4]

  Query language

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