Quiz Discussion

Delete from r where P;

The above command

• 1]

  Deletes a particular tuple from the relation

• 2]

  Deletes the relation

• 3]

  Clears all entries from the relation

• 4]

  All of the mentioned

Which one of the following deletes all the entries but keeps the structure of the relation.

• 1]

  Delete from r where P;

   

• 2]

  Delete from instructor where dept name= ’Finance’;

   

• 3]

  Delete from instructor where salary between 13000 and 15000;

   

• 4]

  Delete from instructor;

   

In the given query which of the keyword has to be inserted?

INSERT INTO employee _____ (1002,Joey,2000);

• 1]

  Table

• 2]

  Values

• 3]

  Relation

• 4]

  Field

Which of these queries will display the table given above?

• 1]

  Select employee from name

• 2]

  Select name

• 3]

  Select name from employee

• 4]

  Select employee

The query given below will not give an error. Which one of the following has to be replaced to get the desired output?

SELECT ID, name, dept name, salary * 1.1
WHERE instructor;

• 1]

  Salary*1.1

• 2]

  ID

• 3]

  Where

• 4]

  Instructor

Which of the following statements contains an error?

• 1]

  Select * from emp where empid = 10003;

• 2]

  Select empid from emp where empid = 10006;

• 3]

  Select empid from emp;

• 4]

  Select empid where empid = 1009 and lastname = ‘GELLER’;

Here which of the following displays the unique values of the column?

SELECT ________ dept_name 
FROM instructor;

• 1]

  All

• 2]

  From

• 3]

  Distinct

• 4]

  Name

A Delete command operates on ______ relation.

• 1]

  One

• 2]

  Two

• 3]

  Several

• 4]

  Null

SELECT * FROM employee WHERE salary>10000 AND dept_id=101;

Which of the following fields are displayed as output?

• 1]

  Salary, dept_id

• 2]

  Employee

• 3]

  Salary

• 4]

  All the field of employee relation

This Query can be replaced by which one of the following?

SELECT name, course_id
FROM instructor, teaches
WHERE instructor_ID= teaches_ID;

• 1]

  Select name,course_id from teaches,instructor where instructor_id=course_id;

• 2]

  Select name, course_id from instructor natural join teaches;

• 3]

  Select name, course_id from instructor;

• 4]

  Select course_id from instructor join teaches;