Quiz Discussion

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

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

SELECT instructor.*
FROM instructor, teaches
WHERE instructor.ID= teaches.ID;

This query does which of the following operation?

• 1]

  All attributes of instructor and teaches are selected

• 2]

  All attributes of instructor are selected on the given condition

• 3]

  All attributes of teaches are selected on given condition

• 4]

  Only the some attributes from instructed and teaches are selected

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

• 1]

  Where

• 2]

  Select

• 3]

  From

• 4]

  Distinct

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]

  $

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

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

The term attribute refers to a ___________ of a table.

• 1]

  Record

• 2]

  Column

• 3]

  Tuple

• 4]

  Key

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