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 term _______ is used to refer to a row.
Solution |
2
Discuss
|
A relational database consists of a collection of
Solution |
3
Discuss
|
Department (dept name, building, budget) and Employee (employee_id, name, dept name, salary)
Solution |
4
Discuss
|
Which keyword must be used here to rename the field name?
Solution |
5
Discuss
|
The tuples of the relations can be of ________ order.
Solution |
6
Discuss
|
The _______ operator takes the results of two queries and returns only rows that appear in both result sets.
Solution |
7
Discuss
|
The result which the operation contains all pairs of tuples from the two relations, regardless of whether their attribute values match.
Solution |
8
Discuss
|
The _______operation performs a set union of two “similarly structured” tables
Solution |
9
Discuss
|
The ______ clause allows us to select only those rows in the result relation of the ____ clause that satisfy a specified predicate.
Solution |
10
Discuss
|
To display the salary from greater to smaller and name in ascending order which of the following options should be used?
Solution |
# | Quiz |
Copyright © 2020 Inovatik - All rights reserved