SQL -Structured Query Language - SQL Table - Alter - Rename Table Quiz

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

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

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

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;

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

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

A Delete command operates on ______ relation.

• 1]

  One

• 2]

  Two

• 3]

  Several

• 4]

  Null

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;