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;

 

Course Name: SQL -Structured Query Language

  • 1]

    Salary*1.1

  • 2]

    ID

  • 3]

    Where

  • 4]

    Instructor

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

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

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

Solution
5
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
6
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
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
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
9
Discuss

A Delete command operates on ______ relation.

  • 1]

    One

  • 2]

    Two

  • 3]

    Several

  • 4]

    Null

Solution
10
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
# Quiz