SELECT instructor.*
FROM instructor, teaches
WHERE instructor.ID= teaches.ID;
This query does which of the following operation?
All attributes of instructor and teaches are selected
All attributes of instructor are selected on the given condition
All attributes of teaches are selected on given condition
Only the some attributes from instructed and teaches are selected
Quiz Recommendation System API Link - https://fresherbell-quiz-api.herokuapp.com/fresherbell_quiz_api
# | Quiz |
---|---|
1
Discuss
|
The tuples of the relations can be of ________ order.
Solution |
2
Discuss
|
The _______ operator takes the results of two queries and returns only rows that appear in both result sets.
Solution |
3
Discuss
|
The ______ clause allows us to select only those rows in the result relation of the ____ clause that satisfy a specified predicate.
Solution |
4
Discuss
|
The ________ clause is used to list the attributes desired in the result of a query.
Solution |
5
Discuss
|
To display the salary from greater to smaller and name in ascending order which of the following options should be used?
Solution |
6
Discuss
|
Student(ID, name, dept name, tot_cred)
Solution |
7
Discuss
|
Which keyword must be used here to rename the field name?
Solution |
8
Discuss
|
The _________ provides a set of operations that take one or more relations as input and return a relation as an output.
Solution |
9
Discuss
|
In the SQL given above there is an error . Identify the error.
Solution |
10
Discuss
|
The term attribute refers to a ___________ of a table.
Solution |
# | Quiz |
Copyright © 2020 Inovatik - All rights reserved