Quiz Discussion

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

A Delete command operates on ______ relation.

• 1]

  One

• 2]

  Two

• 3]

  Several

• 4]

  Null

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

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

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;

   

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

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

This is the Employee table.
Which of the following employee_id will be displayed for the given query?

SELECT * FROM employee WHERE employee_id>1009;

• 1]

  1009, 1001, 1018

• 2]

  1009, 1018

• 3]

  1001

• 4]

  1018

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

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;