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 _______operation performs a set union of two “similarly structured” tables
Solution |
10
Discuss
|
A domain is atomic if elements of the domain are considered to be ____________ units.
Solution |
2
Discuss
|
The term _______ is used to refer to a row.
Solution |
3
Discuss
|
’_____’ matches any string of ______ three characters. ’_____%’ matches any string of at ______ three characters.
Solution |
4
Discuss
|
The tuples of the relations can be of ________ order.
Solution |
5
Discuss
|
A ________ is a pictorial depiction of the schema of a database that shows the relations in the database, their attributes, and primary keys and foreign keys.
Solution |
6
Discuss
|
In the SQL given above there is an error . Identify the error.
Solution |
7
Discuss
|
The _______ operator takes the results of two queries and returns only rows that appear in both result sets.
Solution |
8
Discuss
|
For each attribute of a relation, there is a set of permitted values, called the ________ of that attribute.
Solution |
9
Discuss
|
Which one of the following has to be added into the blank to select the dept_name which has Computer Science as its ending string?
Solution |
# | Quiz |
Copyright © 2020 Inovatik - All rights reserved