# 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

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
2
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
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
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
5
Discuss

A Delete command operates on ______ relation.

• 1]

One

• 2]

Two

• 3]

Several

• 4]

Null

##### Solution
6
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
7
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
8
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
9
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
10
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

# Quiz