Quiz Discussion

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

Which of the following fields are displayed as output?

Course Name: SQL -Structured Query Language

  • 1]

    Salary, dept_id

  • 2]

    Employee

  • 3]

    Salary

  • 4]

    All the field of employee relation

Solution
No Solution Present Yet

Top 5 Similar Quiz - Based On AI&ML

Quiz Recommendation System API Link - https://fresherbell-quiz-api.herokuapp.com/fresherbell_quiz_api

# Quiz
1
Discuss

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

Solution
2
Discuss

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

Solution
3
Discuss

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

Solution
4
Discuss
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

Solution
5
Discuss

A Delete command operates on ______ relation.

  • 1]

    One

  • 2]

    Two

  • 3]

    Several

  • 4]

    Null

Solution
6
Discuss

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;

     

Solution
7
Discuss

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

Solution
8
Discuss
Employee_id Name Salary
1001 Annie 6000
1009 Ross 4500
1018 Zeith 7000

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

Solution
9
Discuss
Name
Annie
Bob
Callie
Derek

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

Solution
10
Discuss

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;

Solution
# Quiz