# Quiz Discussion

In the given query which of the keyword has to be inserted?

INSERT INTO employee _____ (1002,Joey,2000);

Course Name: SQL -Structured Query Language

• 1]
Table
• 2]

Values

• 3]

Relation

• 4]

Field

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

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
6
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
7
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
8
Discuss

A Delete command operates on ______ relation.

• 1]

One

• 2]

Two

• 3]

Several

• 4]

Null

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

# Quiz