This Query can be replaced by which one of the following? ...

This Query can be replaced by which one of the following?

SELECT name, course_id
FROM instructor, teaches
WHERE instructor_ID= teaches_ID;

Course Name: SQL -Structured Query Language

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

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

Discuss

Which one of the following deletes all the entries but keeps the structure of the relation.

1]
```
Delete from r where P;
```

Delete from instructor where dept name= ’Finance’;

Delete from instructor where salary between 13000 and 15000;

4]
```
Delete from instructor;
```

Solution

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

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

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

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

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

Discuss

A Delete command operates on ______ relation.

1]
One
2]
Two
3]
Several
4]
Null

Solution

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

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

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

# Quiz

Quiz Discussion

Solution

Top 5 Similar Quiz - Based On AI&ML

Solution

Solution

Solution

Solution

Solution

Solution

Solution

Solution

Solution

Solution

About Fresherbell

Important Links

Social Media